public ActionResult Latest(int PageCount, int PageNo) { System.Threading.Thread.Sleep(1000); ViewModelProductList objViewModelProductList = new ViewModelProductList(); objViewModelProductList.PageCount = PageCount; objViewModelProductList.PageNo = PageNo; objViewModelProductList.Products = db.Products.OrderByDescending(m=>m.DateAdded).ToPagedList(Convert.ToInt32(PageNo), Convert.ToInt32(PageCount)); return PartialView("PartialListProducts", objViewModelProductList); }
public ActionResult ListProducts(int? CategoryID,string Brand,int? page,string search) { ViewModelProductList objViewModelProductList = new ViewModelProductList(); int pagesize = 3; int pagenumber = (page ?? 1); objViewModelProductList.PageCount = pagesize; objViewModelProductList.PageNo = pagenumber; if (CategoryID != null) { } if (CategoryID != null&& Brand !=null) { objViewModelProductList.Products= db.Products.Where(m => m.CategoryID == CategoryID && m.Brand == Brand).OrderBy(m=>m.ID).ToPagedList(pagenumber,pagesize); objViewModelProductList.TotalProducts = objViewModelProductList.Products.Count; objViewModelProductList.ProductCategory = db.Category.Where(m => m.ID == CategoryID).Single().CategoryName; return View(objViewModelProductList); } else if (CategoryID != null && Brand == null) { objViewModelProductList.Products = db.Products.Where(m => m.CategoryID == CategoryID).OrderBy(m=>m.ID).ToPagedList(pagenumber, pagesize); objViewModelProductList.ProductCategory = db.Category.Where(m => m.ID == CategoryID).Single().CategoryName; objViewModelProductList.TotalProducts = objViewModelProductList.Products.Count; return View(objViewModelProductList); } else if (!String.IsNullOrEmpty(search)) { objViewModelProductList.Products = db.Products.Where(m=>m.ProductName.Contains(search)||m.ProductCategory.Contains(search)).OrderBy(m => m.ID).ToPagedList(pagenumber, pagesize); objViewModelProductList.TotalProducts = objViewModelProductList.Products.Count; return View(objViewModelProductList); } else { objViewModelProductList.Products = db.Products.OrderBy(m=>m.ID).ToPagedList(pagenumber, pagesize); objViewModelProductList.TotalProducts = objViewModelProductList.Products.Count; return View(objViewModelProductList); } }