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);
}