public void ChangePrice(string productName, double price)
{
using (var db = new Context())
{
var storeproduct = db.FindStoreProduct(Store.StoreName, productName);
storeproduct.Price = price;
db.SaveChanges();
}
}
public int AddProduct(string productName, double price)
{
using (var db = new Context())
{
if (db.FindStoreProduct(Store.StoreName, productName) != null)
{
return(-1);
}
Product product;
if ((product = db.FindProduct(productName)) == null)
{
product = new Product()
{
ProductName = productName
};
db.Products.Add(product);
}
var store = db.Stores.Find(Store.StoreId);
var storprod = new StoreProduct()
{
Price = price,
Product = product,
ProductId = product.ProductId,
Store = store,
StoreId = store.StoreId
};
db.StoreProducts.Add(storprod);
db.SaveChanges();
return(0);
}
}