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 AddProduct()
        {
            CategoryDataStore     ObjDal       = new CategoryDataStore();
            SA_ProductViewModel   obj          = new SA_ProductViewModel();
            List <SelectListItem> CategoryList = ObjDal.CategoryList();

            obj.CategoryList = CategoryList;
            return(View("add-Product", obj));
        }
        public ActionResult EditProduct(int id)
        {
            ProductDataStore Obj = new ProductDataStore();
            SA_Product       obj = Obj.GetProductByid(id);

            CategoryDataStore     Objcat       = new CategoryDataStore();
            List <SelectListItem> CategoryList = Objcat.CategoryList();
            SA_ProductViewModel   objSaCatV    = new SA_ProductViewModel();

            objSaCatV.id                 = obj.id;
            objSaCatV.ProductName        = obj.ProductName;
            objSaCatV.ProductDiscription = obj.ProductDiscription;
            objSaCatV.Meta               = obj.Meta;
            objSaCatV.MetaDiscription    = obj.MetaDiscription;
            objSaCatV.CategoryList       = CategoryList;
            objSaCatV.Category           = obj.Category.ToString();

            return(View("add-Product", objSaCatV));
        }
        public ActionResult ProductList()
        {
            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();
            List <SA_Product> ProductList = p.GetProductList();

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

            ViewBag.category = c.CategoryList();
            return(View("~/Views/ChemAnalyst/products.cshtml", model));
        }
        public ActionResult Reportsection()
        {
            string cate    = Request.Form["categoryname"] != null ? Request.Form["categoryname"].ToString() : "";
            string country = Request.Form["countryname"] != null ? Request.Form["countryname"].ToString() : "";

            ViewBag.Cat = cate;
            ViewBag.Cou = country;
            CategoryDataStore  d            = new CategoryDataStore();
            IndustryViewModel  model        = new IndustryViewModel();
            List <SA_Industry> IndustryList = Obj.GetIndustryList().Where(x => (cate == "" || cate.Contains(x.CategoryID.ToString() + ",")) && (country == "" || country.Contains(x.CountryID.ToString() + ","))).OrderBy(w => w.id).OrderByDescending(w => w.id).ToList();

            model.Industry = IndustryList;
            List <SelectListItem> lstCategory = d.CategoryList();

            model.lstCategory = lstCategory;

            List <SelectListItem> lstCountry = d.CountryList();

            model.lstCountry = lstCountry;

            return(View("report-section", model));
        }