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(); }