public async Task <APIResult <PageResult <QLDangVienViewModel> > > GetAllQLDangVien(GetQLDangVienPagingRequest 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/QLDangViens/paging?pageIndex={request.pageIndex}&pageSize={request.pageSize}&keyword={request.keyword}");
var body = await reponse.Content.ReadAsStringAsync();
var user = JsonConvert.DeserializeObject <APISuccessedResult <PageResult <QLDangVienViewModel> > >(body);
return(user);
}
public async Task <IActionResult> GetAllQLDangVien([FromQuery] GetQLDangVienPagingRequest request)
{
var qldv = await _qLDangVienServices.GetAllQLDangVien(request);
return(Ok(qldv));
}
public async Task <APIResult <PageResult <QLDangVienViewModel> > > GetAllQLDangVien(GetQLDangVienPagingRequest request)
{
var query = (from sq in _context.SiQuans
join qldv in _context.QLDangViens
on sq.IDSQ equals qldv.IDSQ
select new QLDangVienViewModel()
{
IDQLDV = qldv.IDQLDV,
IDSQ = qldv.IDSQ,
HoTen = sq.HoTen,
NgayVaoDang = qldv.NgayVaoDang,
NoiVaoDang = qldv.NoiVaoDang
});
if (!string.IsNullOrEmpty(request.keyword))
{
query = query.Where(p => p.HoTen.Contains(request.keyword) || p.IDSQ.Equals(request.keyword));
}
int totalRow = await query.CountAsync();
var data = await query.Skip((request.pageIndex - 1) *request.pageSize)
.Take(request.pageSize)
.Select(x => new QLDangVienViewModel()
{
IDQLDV = x.IDQLDV,
IDSQ = x.IDSQ,
HoTen = x.HoTen,
NgayVaoDang = x.NgayVaoDang,
NoiVaoDang = x.NoiVaoDang
}).ToListAsync();
var pageResult = new PageResult <QLDangVienViewModel>()
{
TotalRecord = totalRow,
PageIndex = request.pageIndex,
PageSize = request.pageSize,
Items = data
};
return(new APISuccessedResult <PageResult <QLDangVienViewModel> >(pageResult));
}
