public ActionResult SaveProductsCategory(string Data)
        {
            PLog.Info("BEGIN::Controller > Home, Method > SaveProductsCategory(string Data)");
            long flg = 0;

            try
            {
                ProductsCategoryModel  obj       = JsonConvert.DeserializeObject <ProductsCategoryModel>(Data);
                IProductsCategoryImple oProducts = new ProductsCategoryImple();
                flg = oProducts.SaveProductCategory(obj);
            }
            catch (Exception ex)
            {
                PLog.Error("Error::Controller > Home, Method > SaveProductsCategory(string Data)", ex);
            }
            PLog.Info("END::Controller > Home, Method > SaveProductsCategory(string Data)");
            return(Content(flg.ToString()));
        }
        public long SaveProductCategory(ProductsCategoryModel _ProductsCategoryModel)
        {
            long flg = 0;

            try
            {
                ArrayList al = new ArrayList();

                al.Add(_ProductsCategoryModel.ProductCategoryID);
                al.Add(_ProductsCategoryModel.Name);
                _General.Set(al, "sp_InsertUpdateProductsCategory", out flg);
                // flg = DAL.ExecuteSP("sp_InsertUpdateProductsCategory", Params, al);
            }
            catch (Exception ex)
            {
                PLog.Error("Error::Class > ProductsCategory, Method >SaveProductCategory()", ex);
            }
            return(flg);
        }
        public ActionResult UpdateProductsCategory(string ID)
        {
            PLog.Info("BEGIN::Controller > Home, Method > UpdateProductsCategory(string ID");
            ProductsCategoryModel  objModel  = null;
            IProductsCategoryImple oProducts = new ProductsCategoryImple();

            try
            {
                if (!string.IsNullOrEmpty(ID))
                {
                    objModel = oProducts.EditProdcutCategory(Convert.ToInt32(ID));
                }
            }
            catch (Exception ex)
            {
                PLog.Error("Error::Controller > Home, Method > UpdateProductsCategory(string ID)", ex);
            }
            PLog.Info("END::Controller > Home, Method > UpdateProductsCategory(string ID)");
            return(View($"ProductsCategory", objModel));
        }
        public ProductsCategoryModel EditProdcutCategory(int ID)
        {
            ProductsCategoryModel _ProductsCategoryModel = new ProductsCategoryModel();

            try
            {
                DataTable dt = GetGridData(ID);

                if (dt != null && dt.Rows.Count > 0)
                {
                    _ProductsCategoryModel.ProductCategoryID = Convert.ToInt32(dt.Rows[0]["id"].ToString());
                    _ProductsCategoryModel.Name = dt.Rows[0]["Name"].ToString();
                }
            }
            catch (Exception ex)
            {
                PLog.Error("Error::Class > Products, Method >EditProdcut(int ID)", ex);
            }

            return(_ProductsCategoryModel);
        }