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