public Customer InsertCustomer(Customer customer)
{
using (var dbContext = new Entities.AdventureWorks2017Context())
{
// Omvormen 'domein' object naar 'entity' object(en).
// Een customer aanmaken komt neer op het opvullen van 3 tabellen!
Entities.Customer customerEntity = new Entities.Customer();
customerEntity.Person = new Entities.Person()
{
PersonType = "IN", // https://www.sqldatadictionary.com/AdventureWorks2014/Person.Person.html
FirstName = customer.FirstName,
LastName = customer.LastName
};
customerEntity.Person.BusinessEntity = new Entities.BusinessEntity()
{
};
customerEntity.Person.EmailAddress.Add(new Entities.EmailAddress()
{
EmailAddress1 = customer.Email
});
// Toevoegen aan DbContext
dbContext.Add(customerEntity);
// Wegschrijven naar database
dbContext.SaveChanges();
// Toegekende ID (door database) in domein object kopiëren.
customer.Id = customerEntity.CustomerId;
return(customer);
}
}
public Customer GetCustomer(int id)
{
using (var dbContext = new Entities.AdventureWorks2017Context())
{
Entities.Customer customer = dbContext.Customer
.Include(c => c.Person)
.Include(c => c.Person.EmailAddress)
.Where(c => c.CustomerId == id && c.Person != null)
.FirstOrDefault();
if (customer != null)
{
return(new Customer()
{
Id = customer.CustomerId,
FirstName = customer.Person.FirstName,
LastName = customer.Person.LastName,
Email = customer.Person.EmailAddress
.Select(ea => ea.EmailAddress1)
.FirstOrDefault()
});
}
}
return(null);
}