// 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); } }