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; entity.CategoryID = product.CategoryID; if (entity.CategoryID == null) { entity.CategoryID = 1; } if (product.Category != null) { entity.CategoryID = product.Category.CategoryID; } entities.Products.Add(entity); entities.SaveChanges(); product.ProductID = (int)entity.ProductID; }
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; entity.CategoryID = product.CategoryID; if (product.Category != null) { entity.CategoryID = product.Category.CategoryID; } entities.Products.Attach(entity); entities.Entry(entity).State = EntityState.Modified; entities.SaveChanges(); }
public void Destroy(ProductViewModel product) { var entity = new Product(); entity.ProductID = product.ProductID; entities.Products.Attach(entity); entities.Products.Remove(entity); var orderDetails = entities.OrderDetails.Where(pd => pd.ProductID == entity.ProductID); foreach (var orderDetail in orderDetails) { entities.OrderDetails.Remove(orderDetail); } entities.SaveChanges(); }
partial void DeleteProduct(Product instance);
partial void UpdateProduct(Product instance);
partial void InsertProduct(Product instance);
private void detach_Products(Product entity) { this.SendPropertyChanging(); entity.Category = null; }
private void attach_Products(Product entity) { this.SendPropertyChanging(); entity.Category = this; }