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