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")));
}
}
