public void Delete(int id) { try { CustomerContactManagerContext cx = new CustomerContactManagerContext(); Customer cust = cx.Customers.Find(id); List <CustomerContact> contactToDelete = cust.CustomerContacts.ToList(); if (contactToDelete.Count == 0) { cx.Customers.Remove(cust); } else { foreach (CustomerContact cont in contactToDelete) { cx.CustomerContacts.Remove(cont); } cx.Customers.Remove(cust); } cx.SaveChanges(); } catch (Exception e) { string test = ""; } }
public void Post([FromBody] CustomerContact Contact) { CustomerContactManagerContext cx = new CustomerContactManagerContext(); var contacts = cx.CustomerContacts; CustomerContact cont = contacts.Where(x => x.ID == Contact.ID).FirstOrDefault(); if (cont == null) { Contact.DateCreated = DateTime.Now; Contact.DateModified = DateTime.Now; cx.CustomerContacts.Add(Contact); cx.SaveChanges(); } else { cont.DateModified = DateTime.Now; cont.Name = Contact.Name; cont.Email = Contact.Email; cont.ContactNumber = Contact.ContactNumber; cx.SaveChanges(); } }
public void Post([FromBody] Customer customer) { try { CustomerContactManagerContext cx = new CustomerContactManagerContext(); var customers = cx.Customers; Customer cust = customers.Where(x => x.ID == customer.ID).FirstOrDefault(); if (cust == null) { customer.DateCreated = DateTime.Now; customer.DateModified = DateTime.Now; cx.Customers.Add(customer); cx.SaveChanges(); } else { cust.DateModified = DateTime.Now; cust.Name = customer.Name; cust.Longitude = customer.Longitude; cust.Latitude = customer.Latitude; cx.SaveChanges(); } } catch (Exception e) { string test = ""; } }
public List <CustomerContact> GetCustomerContact() { CustomerContactManagerContext cx = new CustomerContactManagerContext(); var customerContacts = cx.CustomerContacts; List <CustomerContact> contacts = customerContacts.ToList(); return(contacts); }
public Customer GetCustomer(int id) { CustomerContactManagerContext cx = new CustomerContactManagerContext(); var customers = cx.Customers; Customer cust = customers.Where(x => x.ID == id).FirstOrDefault(); if (cust == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } return(cust); }
public List <Customer> GetCusomters() { CustomerContactManagerContext cx = new CustomerContactManagerContext(); var customers = cx.Customers; List <Customer> custs = customers.ToList(); if (custs == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } return(custs); }
public void Delete(int id) { CustomerContactManagerContext cx = new CustomerContactManagerContext(); CustomerContact DelCont = cx.CustomerContacts.Find(id); if (DelCont == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } cx.CustomerContacts.Remove(DelCont); cx.SaveChanges(); }
public CustomerContact GetCustomerContact(int id) { CustomerContactManagerContext cx = new CustomerContactManagerContext(); var customerContacts = cx.CustomerContacts; var contact = (from v in customerContacts where v.ID == id select v).FirstOrDefault(); if (contact == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } return(contact); }