public async Task <IServiceResponse <List <SalesPerBusDTO> > > SalesByBus(SalesByBusQueryDto queryDto)
{
return(await HandleApiOperationAsync(async() =>
{
var reports = await _bookingReportService.SalesByBus(queryDto);
return new ServiceResponse <List <SalesPerBusDTO> >
{
Object = reports
};
}));
}
public async Task <List <SalesPerBusDTO> > SalesByBus(SalesByBusQueryDto 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 <SalesPerBusDTO>(@"Exec Sp_SalesByBus",
queryDto.StartDate, queryDto.EndDate);
return(reports.ToList());
}
