public void Update(ProductViewModel product)
{
var entity = new Product();
entity.ProductID = product.ProductID;
entity.ProductName = product.ProductName;
entity.UnitPrice = product.UnitPrice;
entity.UnitsInStock = (short)product.UnitsInStock;
entity.Discontinued = product.Discontinued;
entities.Products.Attach(entity);
entities.Entry(entity).State = EntityState.Modified;
entities.SaveChanges();
}
public void Create(ProductViewModel product)
{
var entity = new Product();
entity.ProductName = product.ProductName;
entity.UnitPrice = product.UnitPrice;
entity.UnitsInStock = (short)product.UnitsInStock;
entity.Discontinued = product.Discontinued;
entities.Products.Add(entity);
entities.SaveChanges();
product.ProductID = entity.ProductID;
}
public void Destroy(ProductViewModel product)
{
var entity = new Product();
entity.ProductID = product.ProductID;
entities.Products.Attach(entity);
entities.Products.Remove(entity);
var orderDetails = entities.Order_Details.Where(pd => pd.ProductID == entity.ProductID);
foreach (var orderDetail in orderDetails)
{
entities.Order_Details.Remove(orderDetail);
}
entities.SaveChanges();
}
