public void UpdateCustAccount(CustomerModel CUST) { using (CustomersDBEntities db = new CustomersDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { customer c = db.customers.Find(CUST.customerNumber); c.email = CUST.email; c.address = CUST.address; c.city = CUST.city; c.state = CUST.state; c.country = CUST.country; c.postalCode = CUST.postalCode; c.customerName = CUST.customerName; db.SaveChanges(); dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void AddCustomer(CustomerModel Cust) { using (CustomersDBEntities db = new CustomersDBEntities()) { customer c = new customer(); c.customerName = Cust.customerName; c.address = Cust.address; c.city = Cust.city; c.email = Cust.email; c.state = Cust.state; c.country = Cust.country; c.postalCode = Cust.postalCode; db.customers.Add(c); db.SaveChanges(); } }
public void DeleteCustomer(int CustNo) { using (CustomersDBEntities db = new CustomersDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var SUR = db.customers.Where(o => o.customerNumber == CustNo); if (SUR.Any()) { db.customers.Remove(SUR.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }