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