public async Task <int> Count(PagedLotsForm form) { return(await _dc.Lots .Where(u => u.CreationDate > form.Start && u.CreationDate < form.End) .Where(u => !u.IsDeleted) .CountAsync()); }
public async Task <IActionResult> List(PagedLotsForm form) { form.Year = CurrenYear; var page = await _lots.GetList(form); form.Total = await _lots.Count(form); return(View(new PagedViewModel <HbLot, PagedLotsForm>(page, form))); }
public async Task <IEnumerable <HbLot> > GetList(PagedLotsForm form) { var lots = await _dc.Lots .Where(u => u.Year == form.Year) .Where(u => !u.IsDeleted) .OrderByDescending(u => u.Id) .Skip(form.Offset) .Take(form.Count) .ToArrayAsync(); return(lots.Select(_mapper.Map <HbLot>).ToArray()); }