public async Task <List <JourneyDetailDisplayDTO> > JourneyChartForTerminals(JourneyChartQueryDto details) { var reports = await _unitOfWork .GetDbContext <ApplicationDbContext>() .Database.ExecuteSqlToObject <JourneyDetailDisplayDTO>(@"Exec Sp_JourneyChartsByTerminalDetails", details.StartDate, details.EndDate, details.DepartureTerminalId, details.DestinationTerminalId, details.JourneyStatus, details.JourneyType); return(reports.ToList()); }
public async Task <List <JourneyChartDto> > JourneyChartForStateTerminals(JourneyChartQueryDto queryDto) { if (queryDto.StartDate == null) { queryDto.StartDate = Clock.Now.Date; } if (queryDto.EndDate == null) { queryDto.EndDate = Clock.Now; } var reports = await _unitOfWork .GetDbContext <ApplicationDbContext>() .Database.ExecuteSqlToObject <JourneyChartDto>(@"Exec Sp_JourneyChartsByState", queryDto.StartDate, queryDto.EndDate, queryDto.StateId ); return(reports.ToList()); }
public async Task <IServiceResponse <List <JourneyDetailDisplayDTO> > > JourneyChartsForTerminal(JourneyChartQueryDto requestDto) { return(await HandleApiOperationAsync(async() => { var reports = await _bookingReportService.JourneyChartForTerminals(requestDto); return new ServiceResponse <List <JourneyDetailDisplayDTO> > { Object = reports }; })); }
public async Task <IServiceResponse <List <JourneyChartDto> > > JourneyCharts(JourneyChartQueryDto requestDto) { return(await HandleApiOperationAsync(async() => { var reports = await _bookingReportService.JourneyChartReport(requestDto); return new ServiceResponse <List <JourneyChartDto> > { Object = reports }; })); }