public async Task <IActionResult> GetAllWithPaging([FromQuery] GetQLGiaDinhSQPagingRequest request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var result = await _qLGiaDinhSQServices.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 qlgdsqPagingRequest = new GetQLGiaDinhSQPagingRequest() { keyword = keyword, pageIndex = pageIndex, pageSize = pageSize }; var result = await _qLGiaDinhApiClient.GetAllWithPaging(qlgdsqPagingRequest); if (result.IsSuccessed) { if (TempData["result"] != null) { ViewBag.Success = true; ViewBag.SuccessMessage = TempData["result"]; } return(View(result.ResultObj)); } return(View(result)); }
public async Task <APIResult <PageResult <QLGiaDinhSQViewModel> > > GetAllWithPaging(GetQLGiaDinhSQPagingRequest 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 response = await client.GetAsync($"/api/QLGiaDinhSQs/paging?pageIndex={request.pageIndex}&pageSize={request.pageSize}&keyword={request.keyword}"); var body = await response.Content.ReadAsStringAsync(); if (response.IsSuccessStatusCode) { return(JsonConvert.DeserializeObject <APISuccessedResult <PageResult <QLGiaDinhSQViewModel> > >(body)); } return(JsonConvert.DeserializeObject <APIErrorResult <PageResult <QLGiaDinhSQViewModel> > >(body)); }
public async Task <APIResult <PageResult <QLGiaDinhSQViewModel> > > GetAllWithPaging(GetQLGiaDinhSQPagingRequest request) { var query = from qlgdsq in _context.QLGiaDinhSQs join sq in _context.SiQuans on qlgdsq.IDSQ equals sq.IDSQ select new QLGiaDinhSQViewModel() { IDQLGDSQ = qlgdsq.IDQLGDSQ, IDSQ = qlgdsq.IDSQ, HoTenSQ = sq.HoTen, QuanHe = qlgdsq.QuanHe, HoTen = qlgdsq.HoTen, NgaySinh = qlgdsq.NgaySinh, GhiChu = qlgdsq.GhiChu }; if (!string.IsNullOrEmpty(request.keyword)) { query = query.Where(x => x.HoTenSQ.Contains(request.keyword) || x.QuanHe.Contains(request.keyword)); } var totalRow = await query.CountAsync(); var data = await query.Skip((request.pageIndex - 1) *request.pageSize) .Take(request.pageSize) .Select(x => new QLGiaDinhSQViewModel() { IDQLGDSQ = x.IDQLGDSQ, IDSQ = x.IDSQ, HoTenSQ = x.HoTenSQ, QuanHe = x.QuanHe, HoTen = x.HoTen, NgaySinh = x.NgaySinh, GhiChu = x.GhiChu }).ToListAsync(); var pageResult = new PageResult <QLGiaDinhSQViewModel>() { TotalRecord = totalRow, PageIndex = request.pageIndex, PageSize = request.pageSize, Items = data }; return(new APISuccessedResult <PageResult <QLGiaDinhSQViewModel> >(pageResult)); }