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