public decimal SellProduct(int productNo, int quantity)
{
using (ShopEntities shop = new ShopEntities())
{
Product product = shop.Products.Find(productNo);
product.Stock -= quantity;
shop.SaveChanges();
return(quantity * product.Price);
}
}
public decimal SellProduct(int productNo, int quantity)
{
using (ShopEntities db = new ShopEntities())
{
Product entry = db.Products.Find(productNo);
entry.Stock -= quantity;
db.SaveChanges();
return(quantity * entry.Price);
}
}
public int PlaceOrder(string customerId, int productNo, int quantity)
{
using (ShopEntities db = new ShopEntities())
{
Counter ctr = db.Counters.Find("order");
OrderDetail entry = new OrderDetail
{
OrderNo = ++ctr.CurrentValue + 1000,
OrderDate = DateTime.Today,
CustomerId = customerId,
ProductNo = productNo,
Quantity = quantity
};
db.OrderDetails.Add(entry);
db.SaveChanges();
return(entry.OrderNo);
}
}