public Product Get(int id)
{
var _Product = _db.Product.FirstOrDefault(p => p.PID.Equals(id));
return _Product;
}
public int Insert(Product _Product)
{
_db.Product.InsertOnSubmit(_Product);
_db.SubmitChanges();
return _Product.PID;
}
public void Update(int id, Product _Product)
{
var item = _db.Product.FirstOrDefault(p => p.PID.Equals(id));
item.ProductName = _Product.ProductName;
_db.SubmitChanges();
}
public void Delete(int id)
{
var item = _db.Product.FirstOrDefault(p => p.PID.Equals(id));
_db.Product.DeleteOnSubmit(item);
_db.SubmitChanges();
}