public void Create(ProductDto newProd)
{
var newProdEntity = new Product
{
ProductID = newProd.ProductID,
Name = newProd.Name,
ProductNumber = newProd.ProductNumber,
MakeFlag = newProd.MakeFlag,
FinishedGoodsFlag = newProd.FinishedGoodsFlag,
Color = newProd.Color,
SellStartDate = newProd.SellStartDate,
rowguid = System.Guid.NewGuid(),
ModifiedDate = DateTime.Now,
SafetyStockLevel = newProd.SafetyStockLevel,
ReorderPoint = newProd.ReorderPoint,
StandardCost = newProd.StandardCost,
ListPrice = newProd.ListPrice,
DaysToManufacture = 2
};
using (var ctx = new AdventureWorks.DbModel.Entities())
{
ctx.Products.Add(newProdEntity);
ctx.SaveChanges();
}
}
public void Remove(int id)
{
using (var ctx = new AdventureWorks.DbModel.Entities())
{
var updItem = ctx.Products.FirstOrDefault(o => o.ProductID == id);
if (updItem != null)
{
ctx.Products.Remove(updItem);
ctx.SaveChanges();
}
}
}
public void Update(ProductDto updProd)
{
using (var ctx = new AdventureWorks.DbModel.Entities())
{
var updItem = ctx.Products.FirstOrDefault(o => o.ProductID == updProd.ProductID);
if (updItem != null)
{
updItem.Name = updProd.Name;
updItem.ProductNumber = updProd.ProductNumber;
updItem.MakeFlag = updProd.MakeFlag;
updItem.FinishedGoodsFlag = updProd.FinishedGoodsFlag;
updItem.Color = updProd.Color;
updItem.SellStartDate = updProd.SellStartDate;
updItem.ModifiedDate = DateTime.Now;
updItem.SafetyStockLevel = updProd.SafetyStockLevel;
updItem.ReorderPoint = updProd.ReorderPoint;
updItem.StandardCost = updProd.StandardCost;
updItem.ListPrice = updProd.ListPrice;
updItem.DaysToManufacture = 2;
}
ctx.SaveChanges();
}
}