////THis function show the product whose quantity is less 15 public ActionResult FilterStock(string search, string toDate, string fromDate, int?categoryID, int?pageNo) { PurchaseStockViewModel model = new PurchaseStockViewModel(); ProductHandler handler = new ProductHandler(); model.SearchItem = search; model.toDate = toDate; model.frmDate = fromDate; model.CategoryId = categoryID.Value > 0 ? categoryID.Value : 0; pageNo = pageNo.HasValue ? pageNo.Value > 0 ? pageNo.Value : 1 : 1; //model.productList = handler.GetAllStockProduct(search,toDate,fromDate,pageNo.Value); var totalRecord = handler.GetAllStockProductCount(search, toDate, fromDate, categoryID.Value); model.productList = handler.GetAllStockProduct1(search, toDate, fromDate, categoryID.Value, pageNo.Value); if (model.productList != null) { model.Pager = new Pager(totalRecord, pageNo, 6); return(PartialView("_FilterStock", model)); } return(PartialView("_FilterStock", model)); }