public ActionResult ProductList(string id, string search)
        {
            NewsDataStore        Obj      = new NewsDataStore();
            DealsDataStore       d        = new DealsDataStore();
            ProductListViewModel model    = new ProductListViewModel();
            List <SA_News>       NewsList = Obj.GetNewsList();

            model.NewsList = NewsList;
            List <SA_Deals> DealList = d.GetDealsList();

            model.DealsList = DealList;
            ProductDataStore        p           = new ProductDataStore();
            IQueryable <SA_Product> ProductList = p.GetProductListBySearch(id, search);

            model.ProductList = ProductList;
            CategoryDataStore c = new CategoryDataStore();

            if (id != "")
            {
                var categoryName = c.GetCategoryByid(Convert.ToInt32(id));
                ViewBag.CategoryName = categoryName.CategoryName;
            }
            else
            {
                ViewBag.CategoryName = "";
            }

            ViewBag.category = c.CategoryList();
            return(View("~/Views/ChemAnalyst/products.cshtml", model));
        }
        public ActionResult EditCategory(int id)
        {
            CategoryDataStore Obj = new CategoryDataStore();
            SA_Category       obj = Obj.GetCategoryByid(id);
            // List<SelectListItem> productList = Obj.GetProductList();
            SA_Category objSaCatV = new SA_Category();

            objSaCatV.id                  = obj.id;
            objSaCatV.CategoryName        = obj.CategoryName;
            objSaCatV.CategoryDiscription = obj.CategoryDiscription;
            objSaCatV.Meta                = obj.Meta;
            objSaCatV.MetaDiscription     = obj.MetaDiscription;
            objSaCatV.CategoryImg         = obj.CategoryImg;
            //   objSaCatV.ProductList = productList;



            return(View("add-Category", objSaCatV));
        }