public List <ProductViewModel> ListProduct(ObjectProduct objectProduct)
{
try
{
return(_db.ProductViewModel.FromSqlRaw("SP_GetProductsByFilter @p0, @p1, @p2, @p3, @p4, @p5",
objectProduct.Keyword, objectProduct.Top, objectProduct.Page, objectProduct.Status, objectProduct.FirstDate, objectProduct.LastDate).ToList());
}
catch (Exception ex)
{
throw (ex);
}
}
public PartialViewResult _ListProduct(ObjectProduct objectProduct)
{
// khi load Keyword = null
if (objectProduct.Keyword == null)
{
objectProduct.Keyword = string.Empty;
}
var product = _productService.ListProduct(objectProduct);
var totalRow = 0;
var totalPage = 0;
if (product.Any())
{
totalRow = product.FirstOrDefault().TotalRow;
totalPage = (int)Math.Ceiling((float)totalRow / objectProduct.Top);
}
ViewBag.page = objectProduct.Page;
ViewBag.totalPage = totalPage;
ViewBag.totalRow = totalRow;
return(PartialView(product));
}
