// GET: Attestation public async Task <IActionResult> Index(int?region, string dateFrom, string dateTo, int page = 1) { int pageSize = 5; // количество элементов на странице IQueryable <Attestation> attestations = _context.Attestations.Include(s => s.Region).Include(s => s.Comission).Include(s => s.AttestationUserBelts).OrderByDescending(a => a.IssueDate); ViewBag.Regions = _regionsList; if (region != null && region != 0) { attestations = attestations.Where(p => p.RegionId == region); ViewBag.Regions = _regionsHandler.GetSelectedListRegionsWithSelection((int)region); } if (!string.IsNullOrEmpty(dateFrom) || !string.IsNullOrEmpty(dateTo)) { var _dateFrom = string.IsNullOrEmpty(dateFrom) ? DateTime.MinValue : DateTime.Parse(dateFrom); var _dateTo = string.IsNullOrEmpty(dateTo) ? DateTime.MaxValue : DateTime.Parse(dateTo); attestations = attestations.Where(p => p.IssueDate >= _dateFrom && p.IssueDate <= _dateTo); } var count = await attestations.CountAsync(); var items = await attestations.Skip((page - 1) *pageSize).Take(pageSize).ToListAsync(); PageViewModel pageViewModel = new PageViewModel(count, page, pageSize); AttestationsViewModel viewModel = new AttestationsViewModel { PageViewModel = pageViewModel, Attestations = items }; return(View(viewModel)); }
// GET: Comissions public async Task <IActionResult> Index(int?region, string title) { IQueryable <Comission> comissions = _context.Comissions.Include(s => s.Region) .Include(s => s.SportmanComissions).ThenInclude(a => a.Sportman); ViewBag.Regions = _regionsList; if (region != null && region != 0) { comissions = comissions.Where(p => p.RegionId == region); ViewBag.Regions = _regionsHandler.GetSelectedListRegionsWithSelection((int)region); } if (!string.IsNullOrEmpty(title)) { comissions = comissions.Where(p => p.Name.Contains(title)); } return(View(await comissions.ToListAsync())); }