public void CreateProduct()
{
Product product = new Product();
product.CreatedOn = DateTime.Now;
product.Measurement = Measurement.SquareFeet;
product.ModifiedOn = DateTime.Now;
product.Name = "Siding";
using (var mm = new MaterialsManager())
{
product = mm.CreateProduct(product);
Assert.IsTrue(product.ID > 0);
}
}
public ActionResult EditProduct(Product product)
{
using (var mm = new MaterialsManager())
{
product = mm.EditProduct(product);
}
return RedirectToAction("Products");
}
partial void DeleteProduct(Product instance);
partial void UpdateProduct(Product instance);
partial void InsertProduct(Product instance);
public Product EditProduct(Product product)
{
product.ModifiedOn = DateTime.Now;
Product dbProduct = SingleProduct(product.ID);
// get the database columns which need to be updated
var databaseMembers =
db.Mapping.MappingSource.GetModel(typeof(BizzyQuoteDataContext)).GetMetaType(typeof(Product)).DataMembers
.Where(d => d.IsAssociation == false && d.IsDbGenerated == false && d.IsPersistent == true);
// reflect to get instances of the entity preoprties
var editProperties =
from p in dbProduct.GetType().GetProperties()
join m in databaseMembers on p.Name equals m.Name
select p;
// copy the values
PropertyInfo[] editProps = editProperties.ToArray();
foreach (PropertyInfo propertyInfo in editProps)
{
propertyInfo.SetValue(dbProduct, propertyInfo.GetValue(product, null), null);
}
db.SubmitChanges();
return dbProduct;
}
public Product CreateProduct(Product product)
{
product.CreatedOn = DateTime.Now;
product.ModifiedOn = DateTime.Now;
db.Products.InsertOnSubmit(product);
db.SubmitChanges();
return product;
}
