public async Task <IActionResult> GetAllWithPaging([FromQuery] GetSiQuanImagePagingRequest request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var result = await _siQuanImageServices.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 sqImagePagingRequest = new GetSiQuanImagePagingRequest() { keyword = keyword, pageIndex = pageIndex, pageSize = pageSize }; var result = await _siQuanImageApiClient.GetAllWithPaging(sqImagePagingRequest); 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 <SiQuanImageViewModel> > > GetAllWithPaging(GetSiQuanImagePagingRequest request) { var query = from sqimage in _context.SiQuanImages join sq in _context.SiQuans on sqimage.IDSQ equals sq.IDSQ select new SiQuanImageViewModel() { IDImage = sqimage.IDImage, IDSQ = sqimage.IDSQ, HoTenSQ = sq.HoTen, ImagePath = sqimage.ImagePath, Caption = sqimage.Caption, IsDefault = sqimage.IsDefault, DateCreated = sqimage.DateCreated, FileSize = sqimage.FileSize }; if (!string.IsNullOrEmpty(request.keyword)) { query = query.Where(x => x.HoTenSQ.Contains(request.keyword) || x.Caption.Contains(request.keyword)); } var totalRow = await query.CountAsync(); var data = await query.Skip((request.pageIndex - 1) *request.pageSize) .Take(request.pageSize) .Select(x => new SiQuanImageViewModel() { IDImage = x.IDImage, IDSQ = x.IDSQ, HoTenSQ = x.HoTenSQ, ImagePath = x.ImagePath, Caption = x.Caption, IsDefault = x.IsDefault, DateCreated = x.DateCreated, FileSize = x.FileSize }).ToListAsync(); var pageResult = new PageResult <SiQuanImageViewModel>() { TotalRecord = totalRow, PageIndex = request.pageIndex, PageSize = request.pageSize, Items = data }; return(new APISuccessedResult <PageResult <SiQuanImageViewModel> >(pageResult)); }
public async Task <APIResult <PageResult <SiQuanImageViewModel> > > GetAllWithPaging(GetSiQuanImagePagingRequest 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/SiQuanImages/paging?pageIndex={request.pageIndex}&pageSize={request.pageSize}&keyword={request.keyword}"); var body = await response.Content.ReadAsStringAsync(); if (response.IsSuccessStatusCode) { return(JsonConvert.DeserializeObject <APISuccessedResult <PageResult <SiQuanImageViewModel> > >(body)); } return(JsonConvert.DeserializeObject <APIErrorResult <PageResult <SiQuanImageViewModel> > >(body)); }