public void AddCustomer(Customer customer) { using (var _db = new CRUDEFEntities()) { _db.Customers.Add(customer); _db.SaveChanges(); } }
public void UpdateCustomer(Customer customer) { using (var _db = new CRUDEFEntities()) { var customer_temp = _db.Customers.SingleOrDefault(c => c.CustomerID == customer.CustomerID); _db.Entry(customer_temp).CurrentValues.SetValues(customer); _db.SaveChanges(); } }
public void DeleteCustomer(int idCustomer) { using (var _db = new CRUDEFEntities()) { var currentCustomer = _db.Customers.SingleOrDefault(c => c.CustomerID == idCustomer); _db.Entry(currentCustomer).State = System.Data.Entity.EntityState.Deleted; _db.SaveChanges(); } }