public async Task <IActionResult> Index(string keyword, int pageIndex = 1, int pageSize = 5)
{
var paging = new GetPagingRequestHeSoLuongTheoQuanHam()
{
keyword = keyword,
pageIndex = pageIndex,
pageSize = pageSize
};
if (TempData["result"] != null)
{
ViewBag.Success = true;
ViewBag.SuccessMessage = TempData["result"];
}
var pageresult = await _heSoLuongTheoQuanHamApiClient.GetAllWithPaging(paging);
return(View(pageresult.ResultObj));
}
public async Task <IActionResult> GetAllWithPaging([FromQuery] GetPagingRequestHeSoLuongTheoQuanHam request)
{
var result = await _heSoLuongTheoQuanHamServices.GetAllWithPaging(request);
return(Ok(result));
}
public async Task <APIResult <PageResult <HeSoLuongTheoQuanHamViewModel> > > GetAllWithPaging(GetPagingRequestHeSoLuongTheoQuanHam request)
{
var client = _httpClientFactory.CreateClient();
client.BaseAddress = new Uri(_configuration["BaseAddress"]);
var session = _httpContextAccessor.HttpContext.Session.GetString("Token");
client.DefaultRequestHeaders.Authorization = new System.Net.Http.Headers.AuthenticationHeaderValue("Bearer", session);
var reponse = await client.GetAsync($"/api/HeSoLuongTheoQuanHams/paging?pageIndex={request.pageIndex}&pageSize={request.pageSize}&keyword={request.keyword}");
var body = await reponse.Content.ReadAsStringAsync();
var user = JsonConvert.DeserializeObject <APISuccessedResult <PageResult <HeSoLuongTheoQuanHamViewModel> > >(body);
return(user);
}
public async Task<APIResult<PageResult<HeSoLuongTheoQuanHamViewModel>>> GetAllWithPaging(GetPagingRequestHeSoLuongTheoQuanHam request)
{
var query = (from qh in _context.QuanHams
join hsltqh in _context.HeSoLuongTheoQuanHams
on qh.IDQH equals hsltqh.IDQH
select new HeSoLuongTheoQuanHamViewModel()
{
IDHeSoLuongQH = hsltqh.IDHeSoLuongQH,
IDQH = hsltqh.IDQH,
TenQH = qh.TenQH,
TenHeSoLuongQH = hsltqh.TenHeSoLuongQH,
HeSoLuong = hsltqh.HeSoLuong
});
if (!string.IsNullOrEmpty(request.keyword))
{
query = query.Where(x => x.IDQH.ToString().Contains(request.keyword) || x.TenQH.Contains(request.keyword));
}
var totalrow = await query.CountAsync();
var data = await query.Skip((request.pageIndex - 1) * request.pageSize)
.Take(request.pageSize)
.Select(x => new HeSoLuongTheoQuanHamViewModel()
{
IDHeSoLuongQH = x.IDHeSoLuongQH,
IDQH = x.IDQH,
TenQH = x.TenQH,
TenHeSoLuongQH = x.TenHeSoLuongQH,
HeSoLuong = x.HeSoLuong
}).ToListAsync();
var pageresult = new PageResult<HeSoLuongTheoQuanHamViewModel>()
{
TotalRecord = totalrow,
PageIndex = request.pageIndex,
PageSize = request.pageSize,
Items = data
};
return new APISuccessedResult<PageResult<HeSoLuongTheoQuanHamViewModel>>(pageresult);
}
