public static void AddCustomer(DTO.Customer newCustomer) { ACMEEntities db = new ACMEEntities(); var dbCustomers = db.Customers; var customer = new Customer(); if (newCustomer.Name.Trim().Length == 0) { throw new Exception("Name is a required field."); } customer.CustomerId = newCustomer.CustomerId; customer.Name = newCustomer.Name; customer.Address = newCustomer.Address; customer.City = newCustomer.City; customer.State = newCustomer.State; customer.PostalCode = newCustomer.PostalCode; customer.Notes = newCustomer.Notes; try { dbCustomers.Add(customer); db.SaveChanges(); } catch (Exception ex) { //Log the exception. throw ex; } }
public static List <DTO.Customer> GetCustomers() { ACMEEntities db = new ACMEEntities(); var dbCustomers = db.Customers.OrderBy(p => p.Name).ToList(); var dtoCustomers = new List <DTO.Customer>(); foreach (var dbCustomer in dbCustomers) { var dtoCustomer = new DTO.Customer(); dtoCustomer.CustomerId = dbCustomer.CustomerId; dtoCustomer.Name = dbCustomer.Name; dtoCustomer.Address = dbCustomer.Address; dtoCustomer.City = dbCustomer.City; dtoCustomer.State = dbCustomer.State; dtoCustomer.PostalCode = dbCustomer.PostalCode; dtoCustomer.Notes = dbCustomer.Notes; dtoCustomers.Add(dtoCustomer); } return(dtoCustomers); }