/// <summary> /// Adds new contact in database /// </summary> /// <param name="inputContact"></param> public void AddNewContact(Contact inputContact) { using (var ctx = new AppContacts()) { ctx.Contacts.Add(inputContact); ctx.SaveChanges(); } }
/// <summary> /// Deletes contact from database /// </summary> /// <param name="id"></param> public void DeleteContact(int id) { using (var ctx = new AppContacts()) { var contact = ctx.Contacts .Where(s => s.ContactId == id) .FirstOrDefault(); ctx.Contacts.Remove(contact); ctx.SaveChanges(); } }
/// <summary> /// Updates contact information in database /// </summary> /// <param name="inputContact"></param> /// <returns>integer indicating whether the operation was successful</returns> public int UpdateContact(Contact inputContact) { using (var ctx = new AppContacts()) { var existingContact = ctx.Contacts.Where(s => s.ContactId == inputContact.ContactId) .FirstOrDefault <Contact>(); if (existingContact != null) { existingContact.FirstName = inputContact.FirstName; existingContact.LastName = inputContact.LastName; existingContact.Email = inputContact.Email; existingContact.PhoneNumber = inputContact.PhoneNumber; existingContact.ContactStatus = inputContact.ContactStatus; ctx.SaveChanges(); return(1); } else { return(0); } } }