public async Task <PagenatedList <CommodityRequestCheckoutViewModel> > GetList(CommodityRequestCheckoutQuery query)
{
var dbquery = DbContext.CommodityRequestCheckouts.AsQueryable();
if (query.StartDate.HasValue)
{
dbquery = dbquery.Where(x => x.CreatedOn > query.StartDate);
}
if (query.EndDate.HasValue)
{
dbquery = dbquery.Where(x => x.CreatedOn < query.EndDate);
}
if (query.ResturantId.HasValue)
{
dbquery = dbquery.Where(x => x.RequestForm.ResturantId == query.ResturantId);
}
return(new PagenatedList <CommodityRequestCheckoutViewModel>
{
//to has error while retriving
Items = dbquery.Pagenate(query).ProjectTo <CommodityRequestCheckoutViewModel>(_mapper.ConfigurationProvider).ToList(),
Total = dbquery.Count()
});
}
public async Task <PagenatedList <CommodityRequestCheckoutViewModel> > GetList(CommodityRequestCheckoutQuery query)
{
return(await _repository.GetList(query));
}
public async Task <ActionResult <PagenatedList <CommodityRequestCheckoutViewModel> > > GetList([FromQuery] CommodityRequestCheckoutQuery query)
{
return(Ok(await _commodityRequestCheckoutService.GetList(query)));
}
