public async Task<Detail> GetDataAsync(int ticketId)
    {
        using (var dbConn = new OleDbConnection(AS400ConnectionString))
        {

            string query = "LIBRARY.PROCNAME";

            var p = new DynamicParameters();
            p.Add("TICKET", ticketId, direction: ParameterDirection.Input);
            var detail = await dbConn.QueryAsync<Detail>(query, p, commandType: CommandType.StoredProcedure, commandTimeout: Constants.AS400CommandTimeout);

            return detail.FirstOrDefault();
        }
    }