// DELETE
public void Deletea_PurchaseOrderDetail(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail a_PurchaseOrderDetail = db.a_PurchaseOrderDetail.Find(id);
db.a_PurchaseOrderDetail.Remove(a_PurchaseOrderDetail);
db.SaveChanges();
}
}
// INSERT INTO
public void CreateNewa_PurchaseOrderDetail(a_PurchaseOrderDetailViewModel a_PurchaseOrderDetail)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail Model = new a_PurchaseOrderDetail();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
Model.Quantity = a_PurchaseOrderDetail.Quantity;
Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
db.a_PurchaseOrderDetail.Add(Model);
db.SaveChanges();
}
}
// UPDATE
public void Updatea_PurchaseOrderDetail(a_PurchaseOrderDetailViewModel a_PurchaseOrderDetail)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail Model = new a_PurchaseOrderDetail();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
Model.Quantity = a_PurchaseOrderDetail.Quantity;
Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
db.Entry(Model).State = EntityState.Modified;
db.SaveChanges();
}
}
// SELECT *
public a_PurchaseOrderDetailViewModel Geta_PurchaseOrderDetailById(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrderDetail a_PurchaseOrderDetail = db.a_PurchaseOrderDetail.Find(id);
a_PurchaseOrderDetailViewModel Model = new a_PurchaseOrderDetailViewModel();
Model.ID = a_PurchaseOrderDetail.ID;
Model.PurchaseOrderID = a_PurchaseOrderDetail.PurchaseOrderID;
Model.ProductID = a_PurchaseOrderDetail.ProductID;
//Model.Quantity = a_PurchaseOrderDetail.Quantity;
//Model.UnitPrice = a_PurchaseOrderDetail.UnitPrice;
return(Model);
}
}
