public ActionResult commandTag()
{
var listProduct = db.tblProducts.ToList();
for (int i = 0; i < listProduct.Count; i++)
{
int id = listProduct[i].id;
try
{
if (listProduct[i].Tabs != null && listProduct[i].Tabs != "")
{
string[] tabs = listProduct[i].Tabs.Split(',');
for (int j = 0; j < tabs.Length; j++)
{
tblProductTag productTag = new tblProductTag();
if (tabs[j] != null && tabs[j] != "")
{
productTag.Name = tabs[j];
productTag.Tag = StringClass.NameToTag(tabs[j]);
productTag.idp = id;
db.tblProductTags.Add(productTag);
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
}
}
return(View());
}
public ActionResult Edit(tblProduct tblproduct, FormCollection collection, int?id, List <HttpPostedFileBase> uploadFile)
{
if (ModelState.IsValid)
{
if (collection["drMenu"] != "" || collection["drMenu"] != null)
{
if (id == null)
{
id = int.Parse(collection["idProduct"]);
tblproduct = db.tblProducts.Find(id);
}
else
{
tblproduct = db.tblProducts.Find(id);
}
ViewBag.id = id;
int idCate = int.Parse(collection["drMenu"]);
tblproduct.idCate = idCate;
tblproduct.DateCreate = DateTime.Now;
string tag = tblproduct.Tag;
string Name = collection["Name"];
string Code = collection["Code"];
string Size = collection["Size"];
string Description = collection["Description"];
string Info = collection["Info"];
string Content = collection["Content"];
string Parameter = collection["Parameter"];
string ImageLinkDetail = collection["ImageLinkDetail"];
string[] listarray = ImageLinkDetail.Split('/');
string imagethum = listarray[listarray.Length - 1];
tblproduct.ImageLinkThumb = "/Images/_thumbs/Images/" + imagethum;
string ImageSale = collection["ImageSale"];
if (collection["Price"] != null)
{
float Price = float.Parse(collection["Price"]);
tblproduct.Price = Price;
}
if (collection["PriceSale"] != null)
{
float PriceSale = float.Parse(collection["PriceSale"]);
tblproduct.PriceSale = PriceSale;
}
string Warranty = collection["Warranty"];
string Address = collection["Address"];
string Sale = collection["Sale"];
int Ord = 0;
if (collection["Ord"] != null)
{
Ord = int.Parse(collection["Ord"]);
tblproduct.Ord = Ord;
}
bool URL = (collection["URL"] == "false") ? false : true; //
bool ProductSale = (collection["ProductSale"] == "false") ? false : true; //
bool Vat = (collection["Vat"] == "false") ? false : true; //
bool Status = (collection["Status"] == "false") ? false : true; //
bool Active = (collection["Active"] == "false") ? false : true;
bool New = (collection["New"] == "false") ? false : true; //
bool ViewHomes = (collection["ViewHomes"] == "false") ? false : true; //
bool Priority = (collection["Priority"] == "false") ? false : true; //
string Title = collection["Title"];
string Keyword = collection["Keyword"];
if (tblproduct.Visit != null)
{
tblproduct.Visit = tblproduct.Visit;
}
tblproduct.PriceNote = collection["PriceNote"];
tblproduct.Time = collection["Time"];
tblproduct.id = int.Parse(tblproduct.id.ToString());
tblproduct.Name = Name;
tblproduct.Code = Code;
tblproduct.ImageSale = ImageSale;
tblproduct.Description = Description;
tblproduct.ProductSale = ProductSale;
tblproduct.Content = Content;
tblproduct.Info = Info;
tblproduct.Size = Size;
tblproduct.Parameter = Parameter;
tblproduct.ImageLinkDetail = ImageLinkDetail;
tblproduct.Vat = Vat;
tblproduct.Warranty = Warranty;
tblproduct.Sale = Sale;
tblproduct.Active = Active;
tblproduct.New = New;
tblproduct.Priority = Priority;
tblproduct.Status = Status;
tblproduct.DateCreate = DateTime.Now;
tblproduct.ViewHomes = ViewHomes;
tblproduct.Title = Title;
tblproduct.Keyword = Keyword;
string urls = db.tblGroupProducts.Find(idCate).Tag;
if (URL == true)
{
tblproduct.Tag = StringClass.NameToTag(tblproduct.Name);
var GroupProduct = db.tblGroupProducts.Find(idCate);
clsSitemap.UpdateSitemap("san-pham/" + StringClass.NameToTag(tblproduct.Name), id.ToString(), "Product");
}
else
{
tblproduct.Tag = collection["NameURL"];
var GroupProduct = db.tblGroupProducts.Find(idCate);
clsSitemap.UpdateSitemap("san-pham/" + StringClass.NameToTag(tblproduct.Name), id.ToString(), "Product");
}
if (Session["Price"] == "1")
{
var getHtmlWeb = new HtmlWeb();
var listconnectweb = db.tblConnectWebs.Where(p => p.idCate == idCate).ToList();
List <int> Mang = new List <int>();
for (int i = 0; i < listconnectweb.Count; i++)
{
Mang.Add(int.Parse(listconnectweb[i].idWeb.ToString()));
}
var listweb = db.tblWebs.Where(p => Mang.Contains(p.id)).ToList();
for (int i = 0; i < listweb.Count; i++)
{
getHtmlWeb.Load("" + listweb[i].Url + "/Productad/UpdateProduct?Code=" + tblproduct.Code + "&Price=" + tblproduct.Price + "&PriceSale=" + tblproduct.PriceSale + "&Active=" + tblproduct.Active + "&Status=" + tblproduct.Status + "");
}
}
var Kiemtra = db.tblProducts.Where(p => p.Ord == Ord && p.idCate == idCate && p.id != id).ToList();
if (Kiemtra.Count > 0)
{
var listProduct = db.tblProducts.Where(p => p.Ord >= Ord && p.idCate == idCate).ToList();
for (int i = 0; i < listProduct.Count; i++)
{
int idp = int.Parse(listProduct[i].id.ToString());
var productUpdate = db.tblProducts.Find(idp);
productUpdate.Ord = productUpdate.Ord + 1;
db.SaveChanges();
}
}
db.SaveChanges();
//thêm tabs
var listProductTag = db.tblProductTags.Where(p => p.idp == id).ToList();
for (int i = 0; i < listProductTag.Count; i++)
{
int ids = listProductTag[i].id;
tblProductTag tblproducttag = db.tblProductTags.Find(ids);
db.tblProductTags.Remove(tblproducttag);
db.SaveChanges();
}
string nkeyword = collection["Tabs"];;
string[] mangKeyword = nkeyword.Split(',');
for (int i = 0; i < mangKeyword.Length; i++)
{
if (mangKeyword[i] != null && mangKeyword[i] != "")
{
tblProductTag tblproductTag = new tblProductTag();
tblproductTag.idp = id;
tblproductTag.Name = mangKeyword[i];
tblproductTag.Tag = StringClass.NameToTag(mangKeyword[i]);
db.tblProductTags.Add(tblproductTag);
db.SaveChanges();
}
}
foreach (string key in Request.Form.Cast <string>().Where(key => key.StartsWith("chek-")))
{
var checkbox = "";
checkbox = Request.Form["" + key];
if (checkbox != "false")
{
Int32 idchk = Convert.ToInt32(key.Remove(0, 5));
tblImageProduct image = db.tblImageProducts.Find(idchk);
db.tblImageProducts.Remove(image);
db.SaveChanges();
}
}
TempData["Msg"] = "";
string abc = "";
string def = "";
if (uploadFile != null)
{
foreach (var item in uploadFile)
{
if (item != null)
{
string filename = item.FileName;
string path = System.IO.Path.Combine(Server.MapPath("~/Images/ImagesList"), System.IO.Path.GetFileName(item.FileName));
item.SaveAs(path);
abc = string.Format("Upload {0} file thành công", uploadFile.Count);
def += item.FileName + "; ";
tblImageProduct imgp = new tblImageProduct();
imgp.idProduct = id;
imgp.Images = "/Images/ImagesList/" + System.IO.Path.GetFileName(item.FileName);
db.tblImageProducts.Add(imgp);
db.SaveChanges();
}
}
TempData["Msg"] = abc + "</br>" + def;
}
//Thêm các thuộc tính
var listconnectCre = db.tblConnectCriterias.Where(p => p.idpd == id).ToList();
for (int i = 0; i < listconnectCre.Count; i++)
{
db.tblConnectCriterias.Remove(listconnectCre[i]);
db.SaveChanges();
}
foreach (string key in Request.Form.Keys)
{
var checkbox = "";
if (key.StartsWith("chkCre_"))
{
checkbox = Request.Form["" + key];
if (checkbox != "false")
{
int idCri = Convert.ToInt32(key.Remove(0, 7));
tblConnectCriteria tblconnectcre = new tblConnectCriteria();
tblconnectcre.idCre = idCri;
tblconnectcre.idpd = id;
db.tblConnectCriterias.Add(tblconnectcre);
db.SaveChanges();
}
}
}
}
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa sản phẩm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Productad/Index?idCate=" + int.Parse(collection["drMenu"])));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm sản phẩm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Productad/Create?id=" + +int.Parse(collection["drMenu"]) + ""));
}
#region [Updatehistory]
Updatehistoty.UpdateHistory("Update Product", Request.Cookies["Username"].Values["Username"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
}
return(View(tblproduct));
}
public ActionResult Create(tblProduct tblproduct, FormCollection Collection, string id, List <HttpPostedFileBase> uploadFile)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
string nidCate = Collection["drMenu"];
if (nidCate != "")
{
tblproduct.idCate = int.Parse(nidCate);
int idcate = int.Parse(nidCate);
tblproduct.DateCreate = DateTime.Now;
tblproduct.Tag = StringClass.NameToTag(tblproduct.Name);
tblproduct.DateCreate = DateTime.Now;
tblproduct.Visit = 0;
string capacity = Collection["Capacity"];
string[] listarray = tblproduct.ImageLinkDetail.Split('/');
string ImageLinkDetail = Collection["ImageLinkDetail"];
string imagethum = listarray[listarray.Length - 1];
tblproduct.ImageLinkThumb = "/Images/_thumbs/Images/" + imagethum;
db.tblProducts.Add(tblproduct);
db.SaveChanges();
var listprro = db.tblProducts.OrderByDescending(p => p.id).Take(1).ToList();
clsSitemap.CreateSitemap("san-pham/" + tblproduct.Tag, listprro[0].id.ToString(), "Product");
#region [Updatehistory]
Updatehistoty.UpdateHistory("Create Product", Request.Cookies["Username"].Values["Username"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
var listproduct = db.tblProducts.OrderByDescending(p => p.id).Take(1).ToList();
int idp = 0;
if (listproduct.Count > 0)
{
idp = int.Parse(listproduct[0].id.ToString());
}
TempData["Msg"] = "";
string abc = "";
string def = "";
if (uploadFile != null)
{
foreach (var item in uploadFile)
{
if (item != null)
{
string filename = item.FileName;
string path = System.IO.Path.Combine(Server.MapPath("~/Images/ImagesList"), System.IO.Path.GetFileName(item.FileName));
item.SaveAs(path);
abc = string.Format("Upload {0} file thành công", uploadFile.Count);
def += item.FileName + "; ";
tblImageProduct imgp = new tblImageProduct();
imgp.idProduct = idp;
imgp.Images = "/Images/ImagesList/" + System.IO.Path.GetFileName(item.FileName);
db.tblImageProducts.Add(imgp);
db.SaveChanges();
}
}
TempData["Msg"] = abc + "</br>" + def;
}
//Thêm thuộc tính
foreach (string key in Request.Form.Keys)
{
var checkbox = "";
if (key.StartsWith("chkCre_"))
{
checkbox = Request.Form["" + key];
if (checkbox != "false")
{
int idCri = Convert.ToInt32(key.Remove(0, 7));
tblConnectCriteria tblconnectcre = new tblConnectCriteria();
tblconnectcre.idCre = idCri;
tblconnectcre.idpd = idp;
db.tblConnectCriterias.Add(tblconnectcre);
db.SaveChanges();
}
}
}
//thêm mới tabs
string nkeyword = tblproduct.Tabs;
string[] mangKeyword = nkeyword.Split(',');
for (int i = 0; i < mangKeyword.Length; i++)
{
if (mangKeyword[i] != null && mangKeyword[i] != "")
{
tblProductTag tblproductTag = new tblProductTag();
tblproductTag.idp = idp;
tblproductTag.Name = mangKeyword[i];
tblproductTag.Tag = StringClass.NameToTag(mangKeyword[i]);
db.tblProductTags.Add(tblproductTag);
db.SaveChanges();
}
}
if (Collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm sản phẩm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Productad/index?idCate=" + nidCate + ""));
}
if (Collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm sản phẩm thành công, mời bạn thêm sản phẩm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Productad/Create?id=" + nidCate + ""));
}
}
return(View());
}
