public List <CustomerModel> GetAllUserProfiles() { List <CustomerModel> profiles = new List <CustomerModel>(); using (CustomersDBEntities db = new CustomersDBEntities()) { CustomerModel UPV; var cust = db.customers.ToList(); foreach (customer u in db.customers) { UPV = new CustomerModel(); UPV.customerName = u.customerName; UPV.email = u.email; UPV.address = u.address; UPV.city = u.city; UPV.state = u.state; UPV.country = u.country; UPV.postalCode = u.postalCode; UPV.customerNumber = u.customerNumber; profiles.Add(UPV); } } return(profiles); }
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 CustomerModel GetCustomerProfile(int custN) { CustomerModel UPV = new CustomerModel(); using (CustomersDBEntities db = new CustomersDBEntities()) { var c = db.customers.Find(custN); if (c != null) { UPV.customerName = c.customerName; UPV.email = c.email; UPV.address = c.address; UPV.city = c.city; UPV.state = c.state; UPV.country = c.country; UPV.postalCode = c.postalCode; UPV.customerNumber = c.customerNumber; } } return(UPV); }
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(); } } } }