public async Task OnGetAsync(int?pageIndex) { var qury = _context.Grantee.AsQueryable(); if (!string.IsNullOrEmpty(GranteeName)) { qury = qury.Where(g => g.Name.ToLower().Contains(GranteeName.ToLower())); } if (!string.IsNullOrEmpty(GranteeNationalId)) { qury = qury.Where(g => g.NationalId.Contains(GranteeNationalId)); } Grantee = await PaginatedList <Grantee> .CreateAsync(qury.Include(g => g.City).AsNoTracking(), pageIndex ?? 1, _PageSize); }
public async Task OnGetAsync(int?pageIndex) { var queryable = _context.GranteeService.AsQueryable(); if (!string.IsNullOrEmpty(ServiceName)) { queryable = queryable.Where(s => s.ServiceName.ToLower().Contains(ServiceName.ToLower())); } if (!string.IsNullOrEmpty(GranteeName)) { queryable = queryable.Where(s => s.Grantee.Name.ToLower().Contains(GranteeName.ToLower())); } if (!string.IsNullOrEmpty(GranteeNationalId)) { queryable = queryable.Where(s => s.Grantee.NationalId.Contains(GranteeNationalId)); } GranteeService = await PaginatedList <GranteeService> .CreateAsync(queryable .Include(g => g.Grantee) .Include(g => g.Organization).AsNoTracking(), pageIndex ?? 1, _PageSize); }