public async Task <PagedResult <BrandVm> > GetSizesPagings(GetBrandPagingRequest request)
{
//1. Select join
var query = from p in _context.productBrand
select new { p };
//2. filter
if (!string.IsNullOrEmpty(request.Keyword))
{
query = query.Where(x => x.p.brandName.Contains(request.Keyword));
}
//3. Paging
int totalRow = await query.CountAsync();
var data = await query.Skip((request.PageIndex - 1) *request.PageSize)
.Take(request.PageSize)
.Select(x => new BrandVm()
{
IdBrand = x.p.idBrand,
Name = x.p.brandName,
Details = x.p.brandDetail,
}).ToListAsync();
//4. Select and projection
var pagedResult = new PagedResult <BrandVm>()
{
TotalRecords = totalRow,
PageSize = request.PageSize,
PageIndex = request.PageIndex,
Items = data
};
return(pagedResult);
}
public async Task <PagedResult <BrandVm> > GetBrandsPagings(GetBrandPagingRequest request)
{
var data = await GetAsync <PagedResult <BrandVm> >(
$"/api/brands/paging?pageIndex={request.PageIndex}" +
$"&pageSize={request.PageSize}" +
$"&keyword={request.Keyword}&categoryId={request.BrandId}");
return(data);
}
public async Task <PagedResult <BrandViewModel> > GetBrandPagings(GetBrandPagingRequest request)
{
var client = _httpClientFactory.CreateClient();
client.BaseAddress = new Uri(_configuration["BaseAddress"]);
var respone = await client.GetAsync($"/api/brand/paging?Keyword={request.Keyword}&pageIndex=" +
$"{request.PageIndex}&pageSize={request.PageSize}");
var body = await respone.Content.ReadAsStringAsync();
var brand = JsonConvert.DeserializeObject <PagedResult <BrandViewModel> >(body);
return(brand);
}
public async Task <IActionResult> Index(string keyword, int pageIndex = 1, int pageSize = 15)
{
var request = new GetBrandPagingRequest()
{
Keyword = keyword,
PageIndex = pageIndex,
PageSize = pageSize,
};
var data = await _brandApiClient.GetBrandPagings(request);
ViewBag.Keyword = keyword;
if (TempData["result"] != null)
{
ViewBag.SuccessMsg = TempData["result"];
}
if (TempData["error"] != null)
{
ViewBag.ErrorMsg = TempData["error"];
}
return(View(data));
}
public async Task <IActionResult> Index(string keyword, int pageIndex = 1, int pageSize = 10)
{
var languageId = HttpContext.Session.GetString(SystemConstants.AppSettings.DefaultLanguageId);
var sessions = HttpContext.Session.GetString("Token");
var request = new GetBrandPagingRequest()
{
Keyword = keyword,
PageIndex = pageIndex,
PageSize = pageSize,
LanguageId = languageId
};
var data = await _brandApiClient.GetBrandsPagings(request);
ViewBag.Keyword = keyword;
if (TempData["result"] != null)
{
ViewBag.SuccessMsg = TempData["result"];
}
return(View(data));
}
public async Task <PagedResult <BrandViewModel> > GetAllPaging(GetBrandPagingRequest request)
{
var query = from brand in _context.Brands
where brand.isDelete == false
select brand;
if (!String.IsNullOrEmpty(request.Keyword))
{
query = query.Where(x => x.brand_name.Contains(request.Keyword));
}
int totalRow = await query.CountAsync();
var data = query.OrderByDescending(m => m.create_at)
.Skip((request.PageIndex - 1) * request.PageSize)
.Take(request.PageSize)
.Select(a => new BrandViewModel()
{
id = a.id,
brand_name = a.brand_name,
brand_slug = a.brand_slug,
meta_descriptions = a.meta_descriptions,
meta_keywords = a.meta_keywords,
meta_title = a.meta_title,
isActive = a.isActive,
}).ToListAsync();
var pageResult = new PagedResult <BrandViewModel>()
{
TotalRecords = totalRow,
PageIndex = request.PageIndex,
PageSize = request.PageSize,
Items = await data,
};
return(pageResult);
}
public async Task <IActionResult> GetAllPaging([FromQuery] GetBrandPagingRequest requet)
{
var customer = await _brandService.GetAllPaging(requet);
return(Ok(customer));
}
public async Task <IActionResult> GetAllPaging([FromQuery] GetBrandPagingRequest request)
{
var brands = await _brandService.GetSizesPagings(request);
return(Ok(brands));
}
