public HttpResponseMessage GetCustomers(int?id)
{
using (var db = new InsuranceDBEntities())
{
var entity = db.Customers.FirstOrDefault(ev => ev.CustomerID == id);
db.Entry(entity).Reference(policy => policy.Autos).Load();
db.Entry(entity).Reference(policy => policy.Addresses).Load();
db.Entry(entity).Reference(policy => policy.Contacts).Load();
if (entity != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The customer with id = " + id + " is not found"));
}
}
}
public HttpResponseMessage Delete(int?id)
{
using (var db = new InsuranceDBEntities())
{
var customer = db.Customers.FirstOrDefault(c => c.CustomerID == id);
var auto = db.Autos.FirstOrDefault(c => c.AutoID == customer.AutoID);
var address = db.Addresses.FirstOrDefault(c => c.AddressID == customer.AddressID);
var contact = db.Contacts.FirstOrDefault(c => c.ContactID == customer.ContactID);
customer.Autos = auto;
customer.Addresses = address;
customer.Contacts = contact;
if (customer != null)
{
db.Entry(customer).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, customer));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "The customer with id = " + id + " is not found"));
}
}
}