Esempio n. 1
0
 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());
 }
Esempio n. 2
0
        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)));
        }
Esempio n. 3
0
        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());
        }