public ActionResult Edit([Bind(Include = "id_product,name,id_manufacturer,id_category_default,type,on_sale,quantity,price,additional_shipping_cost,reference,width,height,depth,weight,quantity_discount,available_date,date_add,date_upd,description_short,description")] Product product)
{
if (ModelState.IsValid)
{
//if (!String.IsNullOrEmpty(id_category_selected))
{
var d = db.Categories.Where(x => x.name == id_category_selected).Select(x => x.id_category).SingleOrDefault();
// (from x in db.Categories
// where x.name == id_category_selected
// select x.id_category);
product.id_category_default = d;
}
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
var g = db.Categories_Products.Where(x => x.id_product == product.id_product).AsEnumerable().ToList();
db.Categories_Products.RemoveRange(g);
db.SaveChanges();
if (list.Count() != 0)
{
foreach (var item in list)
{
if (!String.IsNullOrEmpty(item.ToString()))
{
Category_Product cp = new Category_Product();
cp.id_product = product.id_product;
cp.id_category = (int)(from c in db.Categories
where c.name == item.ToString()
select c.id_category)
.Single();
int jj = (from c in db.Categories_Products
where c.id_category == cp.id_category && c.id_product == cp.id_product
select new { c.id_category, c.id_product }).ToList().Count();
if (jj == 0)
{
db.Categories_Products.Add(cp);
db.SaveChanges();
}
else
{
TempData["msg"] = "<script>alert('Error: Category already added');</script>";
//list = null;
//return RedirectToAction("Edit", "Products", new { id = product.id_product });
}
//dt.Tables.Rows.Add(cp);
//dt.Rows.Add(cp);
}
}
list = null;
}
return(RedirectToAction("Index"));
}
return(View(product));
}
public ActionResult ThemDanhMuc(FormCollection collection, HttpPostedFileBase imageCategory)
{
if (Session["idAccount"] == null)
{
return(RedirectToAction("DangNhap", "Login"));
}
if (!Equals(Session["idRole"], 5))
{
return(HttpNotFound());
}
var ma = collection["id"];
var ten = collection["name"];
var icon = collection["icon"];
var csdt = from lg in db.Category_Product
select lg;
foreach (var checksdt in csdt)
{
if (checksdt.idCategory_Product == Int32.Parse(ma.ToString()))
{
ViewData["Err55"] = "Mã này đã tồn tại trong hệ thống!";
return(View());
}
else if (checksdt.nameCategory == ten)
{
ViewData["Err55"] = "Tên này đã tồn tại trong hệ thống!";
return(View());
}
}
if (String.IsNullOrEmpty(ten))
{
ViewData["Err5"] = "Vui lòng nhập Tên danh mục!";
}
else if (String.IsNullOrEmpty(ma))
{
ViewData["Err5"] = "VUi lòng chọn Mã danh mục!";
}
else if (String.IsNullOrEmpty(icon))
{
ViewData["Err5"] = "Vui lòng nhập Icon danh mục!";
}
else
{
Category_Product info = new Category_Product();
if (ModelState.IsValid)
{
string extension1 = System.IO.Path.GetExtension(imageCategory.FileName);
if (Equals(extension1, ".png") || Equals(extension1, ".jpg"))
{
var filename1 = DateTime.Now.ToString("ddMMyyyyHHmmss-") + Guid.NewGuid().ToString() + ".jpg";
var path1 = Path.Combine(Server.MapPath("~/Assets/ImageCategory"), filename1);
if (System.IO.File.Exists(path1))
{
ViewData["Err55"] = "(*) Hình ảnh đã tồn tại !";
}
else
{
imageCategory.SaveAs(path1);
info.imageCategory = filename1;
info.idCategory_Product = Int32.Parse(ma.ToString());
info.iconCategory = icon;
info.nameCategory = ten;
info.iconCategory = icon;
db.Category_Product.Add(info);
}
db.SaveChanges();
}
}
;
}
return(RedirectToAction("DanhMucSanPham", "Manager"));
}