public IList <Supplement> GetSupplements(SearchSupplementModel searchSupplement) { if (!searchSupplement.Validate()) { throw new ArgumentException("SearchSupplementModel didn't pass validation"); } return(_context.Query <Supplement>($@" SELECT SupplementId ,SupplementName ,SupplementDescription ,SupplementPrice ,SupplementWeight FROM Supplements {CreateQuery(searchSupplement)} ORDER BY {searchSupplement.OrderBy}{(searchSupplement.IsDesc ? " DESC" : string.Empty)} OFFSET @skip ROWS FETCH NEXT @take ROWS ONLY ", new { skip = searchSupplement.Skip, take = searchSupplement.Take } ).ToList()); }
public ActionResult ShowPager(SearchSupplementModel searchSupplement) { searchSupplement.Count = _supplementRepository.Count(searchSupplement); return(PartialView("_Pager", searchSupplement)); }
public ActionResult PagesData(SearchSupplementModel searchSupplement) { return(PartialView("SupplementsData", _supplementRepository.GetSupplements(searchSupplement))); }