public ActionResult Product_Detail(int Id) { if (HttpContext.Request.Cookies[StaticLicense.LicName + "Factor"] != null) { string SSSession = ""; HttpCookie cookie = HttpContext.Request.Cookies.Get(StaticLicense.LicName + "Factor"); if (cookie != null) { Encryption ENC = new Encryption(); SSSession = ENC.DecryptText(cookie.Value, "OMD_FACTOR"); MiniFactorModel minif = JsonConvert.DeserializeObject <MiniFactorModel>(SSSession); D_APIModelFiller dmf = new D_APIModelFiller(); FactorPopUpModel FPM = dmf.shoppingCart(minif.Id); FactorMasterModel modell = new FactorMasterModel() { ListOfProducts = FPM, Totality = minif }; ViewBag.factorMasterModel = modell; } else { ViewBag.factorMasterModel = null; } } else { ViewBag.factorMasterModel = null; } D_APIModelFiller DMF = new D_APIModelFiller(); var model = new ProductDetail_ModelView() { ProductModel = DMF.SingleProduct(Id, "Ago"), Company = DMF.CompanyCustomers() }; model.RelatedProducts = DMF.ProductList(15, "گروه اصلی", model.ProductModel.SubCatId, 1, "", "Ago"); return(View(model)); }
public ActionResult Product_List(string Type, int Id = 0, int Page = 1, string Search = "", int CustomerId = 0) { if (HttpContext.Request.Cookies[StaticLicense.LicName + "Factor"] != null) { string SSSession = ""; HttpCookie cookie = HttpContext.Request.Cookies.Get(StaticLicense.LicName + "Factor"); if (cookie != null) { Encryption ENC = new Encryption(); SSSession = ENC.DecryptText(cookie.Value, "OMD_FACTOR"); MiniFactorModel minif = JsonConvert.DeserializeObject <MiniFactorModel>(SSSession); D_APIModelFiller dmf = new D_APIModelFiller(); FactorPopUpModel FPM = dmf.shoppingCart(minif.Id); FactorMasterModel modell = new FactorMasterModel() { ListOfProducts = FPM, Totality = minif }; ViewBag.factorMasterModel = modell; } else { ViewBag.factorMasterModel = null; } } else { ViewBag.factorMasterModel = null; } D_APIModelFiller DMF = new D_APIModelFiller(4); D_APIModelFiller DMF2 = new D_APIModelFiller(); var model = new D_ProductList_ModelView() { Cateqories = DMF.CategoriesAsTree_OneSub("MainCat", 1), NewProducts = DMF.ChosenProducts("New", 3, "Ago"), Sale_Products = DMF.ChosenProducts("Sale", 3, "Ago"), ProductsG3 = DMF.ChosenProducts("MainTag", 3, "Ago", 1), thisPage = Page, Cat = Type, Search = Search, CatId = Id }; if (Type == "پرفروش ها") { model.Products = DMF.ChosenProducts("Sale", 15, "Ago"); model.Pages = 1; } else if (Type == "جدیدترین") { model.Products = DMF.ChosenProducts("New", 15, "Ago"); model.Pages = 1; } else if (Type == "فروش ویژه") { model.Products = DMF.ChosenProducts("MainTag", 15, "Ago", 1); model.Pages = 1; } else if (Type == "علاقه مندی ها") { model.Products = DMF2.FavoriteProducts(15, Type, Id, Page, Search, "Date", CustomerId); model.Pages = DMF2.ProList_Pages(Type, 15, Id, Search, CustomerId); } else { model.Products = DMF2.ProductList(15, Type, Id, Page, Search, "Date"); model.Pages = DMF2.ProList_Pages(Type, 15, Id, Search); } if (Type == "گروه اصلی") { model.tags = DMF2.ProductTags("Sub", Id); } else { model.tags = DMF2.ProductTags("min", 0); } return(View(model)); }
public ActionResult Add_ShoppingCart(int proId, int CustomerId, int number, int FactorId) { PDBC db = new PDBC("PandaMarketCMS", true); Encryption ENC = new Encryption(); if (FactorId == 0) { List <ExcParameters> parss = new List <ExcParameters>(); ExcParameters par = new ExcParameters() { _KEY = "@CustomerId", _VALUE = CustomerId }; parss.Add(par); db.Connect(); var FactorId_ = Convert.ToInt32(db.Script("INSERT INTO [tbl_FACTOR_Main] output inserted.Factor_Id VALUES(@CustomerId,0,GetDate(),'',NULL,0,0,0,0,0,0,0,'','')", parss)); par = new ExcParameters() { _KEY = "@Number", _VALUE = number }; parss.Add(par); par = new ExcParameters() { _KEY = "@FactorId", _VALUE = FactorId_ }; parss.Add(par); par = new ExcParameters() { _KEY = "@ProId", _VALUE = proId }; parss.Add(par); DataTable dt = db.Select("SELECT top 1 [id_PPH] ,PriceOff FROM [tbl_Product_PastProductHistory] where id_MPC=@ProId order by([ChangedDate])DESC", parss); int DateId = 0; long price = 0; if (dt.Rows.Count != 0) { DateId = Convert.ToInt32(dt.Rows[0]["id_PPH"]); price = long.Parse(dt.Rows[0]["PriceOff"].ToString()); } par = new ExcParameters() { _KEY = "@DateId", _VALUE = DateId }; parss.Add(par); db.Script("INSERT INTO [tbl_FACTOR_Items]VALUES(@ProId,@Number,@DateId,@FactorId)", parss); var Factor = new MiniFactorModel() { CustomerId = CustomerId, Id = FactorId_ }; parss = new List <ExcParameters>(); par = new ExcParameters() { _KEY = "@price", _VALUE = price * number }; parss.Add(par); par = new ExcParameters() { _KEY = "@FactorId", _VALUE = FactorId_ }; parss.Add(par); if (price != 0) { db.Script("UPDATE [tbl_FACTOR_Main] SET [toality] =@price WHERE Factor_Id=@FactorId", parss); } Factor.Items = Convert.ToInt32(db.Select("SELECT COUNT(*) FROM [tbl_FACTOR_Items] where FactorId=@FactorId", parss).Rows[0][0]); Factor.totality = price; db.DC(); return(Content(ENC.EncryptText(Newtonsoft.Json.JsonConvert.SerializeObject(Factor), "OMD_FACTOR"))); } else { List <ExcParameters> parss = new List <ExcParameters>(); ExcParameters par = new ExcParameters() { _KEY = "@CustomerId", _VALUE = CustomerId }; parss.Add(par); par = new ExcParameters() { _KEY = "@Number", _VALUE = number }; parss.Add(par); par = new ExcParameters() { _KEY = "@FactorId", _VALUE = FactorId }; parss.Add(par); par = new ExcParameters() { _KEY = "@ProId", _VALUE = proId }; parss.Add(par); db.Connect(); DataTable dt = db.Select("SELECT top 1 [id_PPH] ,PriceOff FROM [tbl_Product_PastProductHistory] where id_MPC=@ProId order by([ChangedDate])DESC", parss); int DateId = 0; long price = 0; if (dt.Rows.Count != 0) { DateId = Convert.ToInt32(dt.Rows[0]["id_PPH"]); price = long.Parse(dt.Rows[0]["PriceOff"].ToString()); } par = new ExcParameters() { _KEY = "@DateId", _VALUE = DateId }; parss.Add(par); db.Script("INSERT INTO [tbl_FACTOR_Items]VALUES(@ProId,@Number,@DateId,@FactorId)", parss); var Factor = new MiniFactorModel() { CustomerId = CustomerId, Id = FactorId }; parss = new List <ExcParameters>(); par = new ExcParameters() { _KEY = "@FactorId", _VALUE = FactorId }; parss.Add(par); DataTable Price = db.Select("SELECT [toality] FROM [tbl_FACTOR_Main]where Factor_Id=@FactorId", parss); long totality = 0; if (Price.Rows.Count != 0) { totality = long.Parse(Price.Rows[0][0].ToString()); } if (price != 0) { par = new ExcParameters() { _KEY = "@price", _VALUE = (price * number) + totality }; parss.Add(par); db.Script("UPDATE [tbl_FACTOR_Main] SET [toality] =@price WHERE Factor_Id=@FactorId", parss); } Factor.Items = Convert.ToInt32(db.Select("SELECT COUNT(*) FROM [tbl_FACTOR_Items] where FactorId=@FactorId", parss).Rows[0][0]); Factor.totality = ((price * number) + totality); db.DC(); return(Content(ENC.EncryptText(Newtonsoft.Json.JsonConvert.SerializeObject(Factor), "OMD_FACTOR"))); } }