CategoryListByIdView(ProductPaginationByCategoryIdListSerializer request)
{
// SELECT JOIN
var query = from p in _context.Products
join pt in _context.ProductTranslations
on p.id equals pt.productId
join pic in _context.ProductInCategories
on p.id equals pic.productId
join c in _context.Categories on pic.categoryId equals c.id
select new { p, pt, pic };
// Fillter
if (request.categoryId.HasValue && request.categoryId.Value > 0)
{
query = query.Where(x => x.pic.categoryId == request.categoryId);
}
// Pagination
int totalRow = await query.CountAsync();
var data = await query.Skip((request.pageIndex - 1) *request.pageSize)
.Take(request.pageSize)
.Select(x => new ProductSerializer()
{
id = x.p.id,
name = x.pt.name,
brief = x.pt.brief,
title = x.pt.title,
price = x.p.price,
originalPrice = x.p.originalPrice,
languageId = x.pt.languageId,
slug = x.pt.slug,
inventory = x.p.inventory,
viewCount = x.p.viewCount,
}).ToListAsync();
// Select and projection
var pageResult = new PaginationSerializer <ProductSerializer>()
{
Items = data,
totalRecord = totalRow,
};
return(pageResult);
}
public async Task <IActionResult> Get([FromQuery] ProductPaginationByCategoryIdListSerializer request)
{
var products = await _publicProductServices.CategoryListByIdView(request);
return(Ok(products));
}
