public async Task <List <BookedTripsDto> > BookedTrips(BookedTripsQueryDto queryDto)
{
if (queryDto.StartDate == null)
{
queryDto.StartDate = Clock.Now.Date;
}
if (queryDto.EndDate == null)
{
queryDto.EndDate = Clock.Now;
}
queryDto.PhysicalBusRegisterationNumber = string.IsNullOrEmpty(queryDto.PhysicalBusRegisterationNumber) ? null : queryDto.PhysicalBusRegisterationNumber;
var reports = await _unitOfWork
.GetDbContext <ApplicationDbContext>()
.Database.ExecuteSqlToObject <BookedTripsDto>(@"Exec Sp_BookedBusesReports", queryDto.BookingType,
queryDto.PhysicalBusRegisterationNumber, queryDto.StartDate, queryDto.EndDate);
return(reports.ToList());
}
public async Task <IServiceResponse <List <BookedTripsDto> > > AllBookedTrips(BookedTripsQueryDto queryDto)
{
return(await HandleApiOperationAsync(async() =>
{
var reports = await _bookingReportService.BookedTrips(queryDto);
return new ServiceResponse <List <BookedTripsDto> >
{
Object = reports.OrderByDescending(p => p.DepartureDate).ToList()
};
}));
}
