private void InsertProduct() { using (cnViragkereskedes context = new cnViragkereskedes()) { foreach (var x in Prod) { var CategoryId = context.enCategories.First(a => a.category_name == x.CategoryName); var NewProduct = new enProduct() { product_name = x.Name, product_price_net = x.NetPrice, product_fees = x.Fees, product_sale = x.Sale, product_description = x.Description, product_icon = x.Icon, product_active = x.Active, enCategory = CategoryId, product_price_gross = x.GrossPrice }; if (Bouquet) { foreach (var UsedAccessories in AccessoryAmount) { var AccessoryName = context.enAccessories.First(a => a.accessory_name == UsedAccessories.Key); NewProduct.enAccessory_vs_product.Add(new enAccessory_vs_product() { enAccessory = AccessoryName, accessory_amount = UsedAccessories.Value }); } foreach (var UsedProducts in ProdAmount) { var ProductName = context.enProducts.Where(a => a.product_name == UsedProducts.Key).ToList(); NewProduct.enBouquets.Add(new enBouquet() { enProducts = ProductName, product_amount = UsedProducts.Value }); } } context.enProducts.Add(NewProduct); } context.SaveChanges(); } }
public bool ModifyProduct(List <ProductsList> CProd) { using (cnViragkereskedes context = new cnViragkereskedes()) { var ProductToChange = new enProduct(); foreach (var prod in CProd) { ProductToChange = context.enProducts.Where(x => x.product_name == prod.Name).First(); ProductToChange.product_name = prod.Name; ProductToChange.product_price_net = prod.NetPrice; ProductToChange.product_fees = prod.Fees; ProductToChange.product_sale = prod.Sale; ProductToChange.product_description = prod.Description; ProductToChange.product_icon = prod.Icon; ProductToChange.product_active = prod.Active; ProductToChange.product_price_gross = prod.GrossPrice; } context.Entry(ProductToChange).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(true); } }