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