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