public static void AddCustomer(LocalDBExample.DTO.Customer newCustomer) { ACMEEntities db = new ACMEEntities(); var dbCustomers = db.Customers; var customer = new Customer(); // checking if if (newCustomer.Name.Trim().Length == 0) { throw new Exception("Name is a required field"); } // other validation here. 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); // won't actually save to database unless you call SaveChanges() db.SaveChanges(); } catch (Exception ex) { // Log the exception throw ex; } }
public static List <LocalDBExample.DTO.Customer> GetCustomers() { ACMEEntities db = new ACMEEntities(); var dbCustomers = db.Customers.OrderBy(p => p.Name).ToList(); var dtoCustomers = new List <LocalDBExample.DTO.Customer>(); foreach (var dbCustomer in dbCustomers) { var dtoCustomer = new LocalDBExample.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); }