public async Task OnGetAsync(string sortOrder,
string currentFilter, string searchString, int?pageIndex)
{
CurrentSort = sortOrder;
NameSort = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (searchString != null)
{
pageIndex = 1;
}
else
{
searchString = currentFilter;
}
CurrentFilter = searchString;
int endRange = 7000;
IQueryable <ProductCategory> PrimeListIQ = from pc in _context.ProductCategory
where pc.ProductCategoryID >= endRange
select pc;
IQueryable <ProductCategory> ProductCategoryRemainderIQ = from pc in _context.ProductCategory
where pc.ProductCategoryID < endRange
select pc;
if (!String.IsNullOrEmpty(searchString))
{
//if (PrimeListIQ.Any(pc => pc.Name.Contains(searchString)))
//{
// PrimeListIQ = PrimeListIQ.Where(pc => pc.Name.Contains(searchString));
//}
PrimeListIQ = PrimeListIQ.Where(pc => pc.Name.Contains(searchString));
ProductCategoryRemainderIQ = ProductCategoryRemainderIQ.Where(pc => pc.Name.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
PrimeListIQ = PrimeListIQ.OrderByDescending(pc => pc.Name);
ProductCategoryRemainderIQ = ProductCategoryRemainderIQ.OrderByDescending(pc => pc.Name);
break;
default:
PrimeListIQ = PrimeListIQ.OrderBy(pc => pc.Name);
ProductCategoryRemainderIQ = ProductCategoryRemainderIQ.OrderBy(pc => pc.Name);
break;
}
int pageSize = 20;
ProductCategory = await PaginatedList <ProductCategory> .CreateFromManyAsync(PrimeListIQ,
ProductCategoryRemainderIQ, pageIndex ?? 1, pageSize);
}