// DELETE
public void Deletea_PurchaseOrder(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder a_PurchaseOrder = db.a_PurchaseOrder.Find(id);
db.a_PurchaseOrder.Remove(a_PurchaseOrder);
db.SaveChanges();
}
}
// INSERT INTO
public void CreateNewa_PurchaseOrder(a_PurchaseOrderViewModel a_PurchaseOrder)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder Model = new a_PurchaseOrder();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
db.a_PurchaseOrder.Add(Model);
db.SaveChanges();
}
}
// UPDATE
public void Updatea_PurchaseOrder(a_PurchaseOrderViewModel a_PurchaseOrder)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder Model = new a_PurchaseOrder();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
db.Entry(Model).State = EntityState.Modified;
db.SaveChanges();
}
}
// SELECT *
public a_PurchaseOrderViewModel Geta_PurchaseOrderById(int id)
{
using (ShopDBEntities db = new ShopDBEntities())
{
a_PurchaseOrder a_PurchaseOrder = db.a_PurchaseOrder.Find(id);
a_PurchaseOrderViewModel Model = new a_PurchaseOrderViewModel();
Model.ID = a_PurchaseOrder.ID;
Model.Code = a_PurchaseOrder.Code;
//Model.PurchaseDate = a_PurchaseOrder.PurchaseDate;
Model.SupplierID = a_PurchaseOrder.SupplierID;
Model.Remarks = a_PurchaseOrder.Remarks;
return(Model);
}
}
