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