public async Task <IHttpActionResult> DocMotTrangHangHoa([FromBody] PagedInput input, int CLID) { try { int n = (input.PageIndex - 1) * input.PageSize; int totalItems = await db.HangHoas.CountAsync(p => p.Loai.ChungLoaiID == CLID); var hangHoaItems = await db.HangHoas .Where(p => p.Loai.ChungLoaiID == CLID) .OrderBy(p => p.ID) .Skip(n) .Take(input.PageSize) .Include(p => p.Loai) .Select(p => new HangHoaOutput { hangHoaEntity = p, loaiEntity = p.Loai }) .ToListAsync(); var onePageOfData = new PagedOutput <HangHoaOutput> { Items = hangHoaItems, TotalItemCount = totalItems }; return(Ok(onePageOfData)); } catch (Exception ex) { return(BadRequest($"Lỗi không truy cập được dữ liệu. Lý do: {ex.Message}")); } }
public async Task <IHttpActionResult> DocMotTrang([FromBody] PagedInput input) { try { int n = (input.PageIndex - 1) * input.PageSize; int totalItems = await db.HangHoas.CountAsync(); var hangHoaItems = await db.HangHoas .OrderByDescending(p => p.ID) .Skip(n) .Take(input.PageSize) .Include(p => p.ChungLoai) .Select(p => new HangHoaOutput { hangHoaEntity = p, chungLoaiEntity = p.ChungLoai }) .ToListAsync(); var onePageOfData = new PagedOutPut <HangHoaOutput> { Items = hangHoaItems, TotalItemCout = totalItems }; return(Ok(onePageOfData)); } catch (Exception ex) { return(BadRequest($"Loi khong truy cap duoc du lieu. Ly do : {ex.Message}")); } }
public async Task <PagedOutput <HangHoaOutput> > GetOnePage(PagedInput input) { try { int n = (input.PageIndex - 1) * input.PageSize; int totalItems = await _db.HangHoas.CountAsync(); var hangHoaItems = await _db.HangHoas .OrderByDescending(p => p.ID) .Skip(n) .Take(input.PageSize) .Include(p => p.ChungLoai) .Select(p => new HangHoaOutput { hangHoaEntity = p, chungLoaiEntity = p.ChungLoai }) .ToListAsync(); var onePageOfData = new PagedOutput <HangHoaOutput> { Items = hangHoaItems, TotalItemCount = totalItems }; return(onePageOfData); } catch (Exception ex) { throw new Exception($"Loi khong truy cap duoc du lieu. Ly do : {ex.Message}"); } }
public async Task <PagedResponse <UserViewModel> > GetAsync([FromQuery] PagedInput input, string filter) { var pagedList = await _userProvider.FindUsers(input, filter); return(new PagedResponse <UserViewModel>() { Data = pagedList, Page = pagedList.Page, PageSize = pagedList.PageSize, Pages = pagedList.Pages, RecordCount = pagedList.RecordCount }); }
public static PagedList <T> ToPagedList <T>(this IQueryable <T> query, PagedInput input) where T : class { var count = query.Count(); var list = query.Skip((input.Page - 1) * input.PageSize) .Take(input.PageSize).ToList <T>(); var pagedList = new PagedList <T>(list); pagedList.Page = input.Page; pagedList.PageSize = input.PageSize; pagedList.RecordCount = count; pagedList.Pages = (count + input.PageSize - 1) / input.PageSize; return(pagedList); }
public Task <PagedList <UserViewModel> > FindUsers(PagedInput input, string filter = "") { var query = _userManager.Users.AsQueryable(); if (!string.IsNullOrEmpty(filter)) { var username = filter?.Trim().ToUpper(); var displayName = filter?.Trim(); query = query.Where(q => q.NormalizedUserName.Contains(username) || q.DisplayName.Contains(displayName) || q.NormalizedEmail.Contains(username) || q.PhoneNumber.Contains(username)); } var users = query.ToPagedList <AppUser, UserViewModel>(_mapper, input); return(Task.FromResult(users)); }
public async Task <IHttpActionResult> DocMotTrangTheoLoai([FromBody] PagedInput input, int id) { try { var LoaiItem = await db.Loais .SingleOrDefaultAsync(p => p.ID == id); if (LoaiItem == null) { throw new Exception($"Loại ID={id} không tồn tại."); } ; int n = (input.PageIndex - 1) * input.PageSize; int totalItems = await db.HangHoas.CountAsync(p => p.LoaiID == id); var hangHoaItems = await db.HangHoas .Where(p => p.LoaiID == id) .OrderBy(p => p.ID) .Skip(n) .Take(input.PageSize) .Select(p => new HangHoaOutput { hangHoaEntity = p, loaiEntity = p.Loai }) .ToListAsync(); var onePageOfData = new PagedOutput <HangHoaOutput> { Items = hangHoaItems, TotalItemCount = totalItems }; return(Ok(onePageOfData)); } catch (Exception ex) { return(BadRequest($"Lỗi không truy cập được dữ liệu. lý do: {ex.Message}")); } }
public async Task <ActionResult> ShopAjax(int?page) { try { string url = "hang-hoa/doc-mot-trang"; int pageNumber = (page == null || page < 1) ? 1 : page.Value; var input = new PagedInput { PageIndex = pageNumber, PageSize = 12 }; HangHoaPagedOutput result = await ApiHelper <HangHoaPagedOutput> .RunPostAsync(url, input); ViewBag.OnePageOfData = new StaticPagedList <HangHoaOutput>(result.Items, input.PageIndex, input.PageSize, result.TotalItemCount); if (Request.IsAjaxRequest()) { return(PartialView("_ShopAjaxPartial")); } return(View()); } catch (Exception ex) { return(View("Error", model: ex.Message)); } }
public Task <IPagedList <PhoneEntry> > GetPagedListAsync(PagedInput input) { return(_phoneEntryRepository.GetPagedListAsync(input)); }
public Task <IPagedList <PhoneEntry> > GetPagedListAsync(PagedInput input) { return(_phones.AsQueryable().ToPagedListAsync(input.PageIndex ?? 1, input.PageSize)); }
public Task <IPagedList <PhoneEntry> > GetPagedListAsync(PagedInput input) { return(_dbContext.PhoneEntries.ToPagedListAsync(input.PageIndex ?? 1, input.PageSize)); }
public static PagedList <TDestination> ToPagedList <TSource, TDestination>(this IQueryable <TSource> query, IMapper mapper, PagedInput input) where TSource : class where TDestination : class { var source = query.ToPagedList <TSource>(input); var destination = mapper.Map <PagedList <TDestination> >(source); destination.Page = source.Page; destination.Pages = source.Pages; destination.PageSize = source.PageSize; destination.RecordCount = source.RecordCount; return(destination); }
public Task <IPagedList <PhoneEntry> > GetAllAsync(PagedInput input) { _logger.LogInformation("Get all phone entries"); return(_phonebookManager.GetPagedListAsync(input)); }