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
};
}));
}
