//Edit a person public void EditPerson(int personId, string lastName, string firstName, string companyName, string email, string phone, string altPhone, string address1, string address2, string state, string city, string zipcode) { RoladexContext db = new RoladexContext(); Person p = db.Persons.Find(personId); if (p != null) { p.PersonID = personId; p.LastName = lastName; p.FirstName = firstName; p.CompanyName = companyName; p.Email = email; p.Phone = phone; p.AltPhone = altPhone; p.Address1 = address1; p.Address2 = address2; p.State = state; p.City = city; p.Zipcode = zipcode; db.SaveChanges(); } else { throw new ApplicationException("Can not find person to update."); } }
public List <Person> CheckForContact(string email, string phone, string altPhone) { RoladexContext db = new RoladexContext(); List <Person> list = db.Persons.Where(p => p.Email == email || p.Phone == phone || p.AltPhone == altPhone).ToList(); return(list); }
//Add a person public void CreatePerson(string lastName, string firstName, string companyName, string email, string phone, string altPhone, string address1, string address2, string state, string city, string zipcode) { RoladexContext db = new RoladexContext(); db.Persons.Add(new Person() { LastName = lastName, FirstName = firstName, CompanyName = companyName, Email = email, Phone = phone, AltPhone = altPhone, Address1 = address1, Address2 = address2, State = state, City = city, Zipcode = zipcode }); db.SaveChanges(); }
//Delete a person public void DeletePerson(int personId) { RoladexContext db = new RoladexContext(); Person p = db.Persons.Find(personId); if (p != null) { db.Persons.Remove(p); db.SaveChanges(); } else { throw new ApplicationException("Can not find person to delete."); } }
//Select All public List <Person> GetAllPersons() { RoladexContext db = new RoladexContext(); return(db.Persons.ToList <Person>()); }