public async Task <IActionResult> GetAllWithPaging([FromQuery] GetQLQuaTrinhDaoTaoPagingRequest request)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var result = await _qLQuaTrinhDaoTaoServices.GetAllWithPaging(request);
if (result.ResultObj != null)
{
return(Ok(result));
}
return(BadRequest(result));
}
public async Task <IActionResult> Index(string keyword, int pageIndex = 1, int pageSize = 5)
{
var qlqtdtPagingRequest = new GetQLQuaTrinhDaoTaoPagingRequest()
{
keyword = keyword,
pageIndex = pageIndex,
pageSize = pageSize
};
var result = await _qLQuaTrinhDaoTaoApiClient.GetAllWithPaging(qlqtdtPagingRequest);
if (result.ResultObj != null)
{
if (TempData["result"] != null)
{
ViewBag.Success = true;
ViewBag.SuccessMessage = TempData["result"];
}
return(View(result.ResultObj));
}
return(View(result));
}
public async Task <APIResult <PageResult <QLQuaTrinhDaoTaoViewModel> > > GetAllWithPaging(GetQLQuaTrinhDaoTaoPagingRequest 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 resonse = await client.GetAsync($"/api/QLQuaTrinhDaoTaos/paging?pageIndex={request.pageIndex}&pageSize={request.pageSize}&keyword={request.keyword}");
var body = await resonse.Content.ReadAsStringAsync();
if (resonse.IsSuccessStatusCode)
{
return(JsonConvert.DeserializeObject <APISuccessedResult <PageResult <QLQuaTrinhDaoTaoViewModel> > >(body));
}
return(JsonConvert.DeserializeObject <APIErrorResult <PageResult <QLQuaTrinhDaoTaoViewModel> > >(body));
}
public async Task <APIResult <PageResult <QLQuaTrinhDaoTaoViewModel> > > GetAllWithPaging(GetQLQuaTrinhDaoTaoPagingRequest request)
{
var query = from qlqtdt in _context.QLQuaTrinhDaoTaos
join sq in _context.SiQuans
on qlqtdt.IDSQ equals sq.IDSQ
select new QLQuaTrinhDaoTaoViewModel()
{
IDQLQTDT = qlqtdt.IDQLQTDT,
IDSQ = qlqtdt.IDSQ,
HoTen = sq.HoTen,
TenTruong = qlqtdt.TenTruong,
NganhHoc = qlqtdt.NganhHoc,
ThoiGianBDDT = qlqtdt.ThoiGianBDDT,
ThoiGianKTDT = qlqtdt.ThoiGianKTDT,
HinhThucDT = qlqtdt.HinhThucDT,
VanBang = qlqtdt.VanBang
};
if (!string.IsNullOrEmpty(request.keyword))
{
query = query.Where(x => x.HoTen.Contains(request.keyword) || x.TenTruong.Contains(request.keyword) ||
x.NganhHoc.Contains(request.keyword) || x.HinhThucDT.Contains(request.keyword) || x.VanBang.Contains(request.keyword));
}
var totalRow = await query.CountAsync();
var data = await query.Skip((request.pageIndex - 1) *request.pageSize)
.Take(request.pageSize)
.Select(x => new QLQuaTrinhDaoTaoViewModel()
{
IDQLQTDT = x.IDQLQTDT,
IDSQ = x.IDSQ,
HoTen = x.HoTen,
TenTruong = x.TenTruong,
NganhHoc = x.NganhHoc,
ThoiGianBDDT = x.ThoiGianBDDT,
ThoiGianKTDT = x.ThoiGianKTDT,
HinhThucDT = x.HinhThucDT,
VanBang = x.VanBang
}).ToListAsync();
var pageResult = new PageResult <QLQuaTrinhDaoTaoViewModel>()
{
TotalRecord = totalRow,
PageIndex = request.pageIndex,
PageSize = request.pageSize,
Items = data
};
return(new APISuccessedResult <PageResult <QLQuaTrinhDaoTaoViewModel> >(pageResult));
}
