public async Task <IActionResult> AgencyGetAllAsync() { var req = new ReportADPMainRequest(); var result = await _adpMainManager.GetAllAsync(req); return(Ok(result)); }
public async Task<ReportADPMainResponse> GetAllAsync(ReportADPMainRequest req) { using (var conn = new SqlConnection(_connectionSettings.DefaultConnection)) { var result = new ReportADPMainResponse(); const string storeproc = @"[dbo].[uspADPMainGetList_New]"; await conn.OpenAsync(); var rawResult = await conn.QueryAsync<ReportMainDTO>(storeproc, null, null, null, CommandType.StoredProcedure); result.Data = rawResult.ToList(); return result; } }
public async Task <ReportADPMainResponse> GetAllAsync(ReportADPMainRequest req) { var result = await _repos.GetAllAsync(req); if (result != null && result.Data.Any()) { result.Data.ToList().ForEach(x => { if (x.EffectiveDate != null && x.EffectiveDate > DateTime.MinValue && x.EffectiveDate < DateTime.MaxValue) { x.EffectiveDateStr = x.EffectiveDate.ToString("MM/dd/yyyy"); } }); } return(result); }