// DELETE public void Deletea_Product(int id) { using (ShopDBEntities db = new ShopDBEntities()) { a_Product a_Product = db.a_Product.Find(id); db.a_Product.Remove(a_Product); db.SaveChanges(); } }
// SELECT * FROM a_Product WHERE Id = Id public a_ProductViewModel Geta_ProductById(int id) { using (ShopDBEntities db = new ShopDBEntities()) { a_Product a_Product = db.a_Product.Find(id); Xsis_Shop_ViewModels.a_ProductViewModel Model = new Xsis_Shop_ViewModels.a_ProductViewModel(); Model.ID = a_Product.ID; Model.Code = a_Product.Code; Model.Name = a_Product.Name; return(Model); } }