public int InsertProduct(string NameProduct, string FullNameProduct, int?Qty, int?Price, bool?News, bool?Sale, int?PriceSale, string Color, string Size, string Maker, string Description, string Note, bool?Active, int?CreateByUserID, string[] list_Category, string UrlImage) { Product p = new Product(); p.NameProduct = NameProduct; p.FullNameProduct = FullNameProduct; p.Qty = Qty; p.Price = Price; p.News = News; p.Sale = Sale; p.PriceSale = PriceSale; p.Color = Color; p.Size = Size; p.Maker = Maker; p.Description = Description; p.NumberView = 0; p.NumberBuy = 0; p.Note = Note; p.Actives = Active; p.CreateByEmployeeID = CreateByUserID; p.CreateDate = DateTime.Now; db.Products.Add(p); foreach (string category in list_Category) { int int_categoryid = Int32.Parse(category); CF_Products_Categories pc = new CF_Products_Categories(); pc.ProductID = p.ID; pc.CategoriesID = int_categoryid; db.CF_Products_Categories.Add(pc); } db.SaveChanges(); string[] urlImageDD = UrlImage.Split(','); foreach (string s in urlImageDD) { ProductImage proImage = new ProductImage(); proImage.ProdutsID = p.ID; proImage.URLImage = s; db.ProductImages.Add(proImage); } db.SaveChanges(); return(p.ID); }
public void UpdateProduct(Product p, string[] list_Category, string UrlImage) { Product product = db.Products.Find(p.ID); if (product != null) { product.NameProduct = p.NameProduct; product.FullNameProduct = p.FullNameProduct; product.Price = p.Price; product.News = p.News; product.Sale = p.Sale; product.PriceSale = p.PriceSale; product.Color = p.Color; product.Size = p.Size; product.Maker = p.Maker; product.Description = p.Description; product.Note = p.Note; product.Actives = p.Actives; db.SaveChanges(); db.Database.ExecuteSqlCommand("DeleteCF_Products_Categories @ProductID", new SqlParameter("@ProductID", p.ID)); db.Database.ExecuteSqlCommand("exec DeleteProductImages @ProductID", new SqlParameter("@ProductID", p.ID)); foreach (string category in list_Category) { int int_categoryid = Int32.Parse(category); CF_Products_Categories pc = new CF_Products_Categories(); pc.ProductID = p.ID; pc.CategoriesID = int_categoryid; db.CF_Products_Categories.Add(pc); } string[] urlImageDD = UrlImage.Split(','); foreach (string s in urlImageDD) { ProductImage proImage = new ProductImage(); proImage.ProdutsID = p.ID; proImage.URLImage = s; db.ProductImages.Add(proImage); } db.SaveChanges(); } }