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 void ChangePassword(string uName, string newPassword)
{
using (cnViragkereskedes context = new cnViragkereskedes())
{
var oldPassword = context.enUsers.SingleOrDefault(x => x.user_name == uName);
oldPassword.user_password = newPassword;
oldPassword.user_name = uName;
context.Entry(oldPassword).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
private void Insert_User(string uname, string pw, bool admin = false)
{
//enUser newUser = new enUser() { user_name = uname, user_password = pw, user_admin = admin };
using (cnViragkereskedes context = new cnViragkereskedes())
{
context.enUsers.Add(new enUser()
{
user_name = uname, user_password = pw, user_admin = admin
});
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);
}
}
