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