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)); }