/// <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(); } }
public StoredContactViewModel() { _appContacts = new AppContacts(); SaveCommand = new RelayCommand(Save); UpdateCommand = new RelayCommand(Update); RemoveCommand = new RelayCommand(Remove); Messenger.Default.Register <string>(this, "LoadContactByEmailMessage", LoadContactByEmail); }
/// <summary> /// Gets contact by ID from database /// </summary> /// <param name="id"></param> /// <returns>single contact</returns> public Contact GetContactById(int id) { Contact contact = null; using (var ctx = new AppContacts()) { contact = ctx.Contacts.Where(s => s.ContactId == id).FirstOrDefault(); } return(contact); }
/// <summary> /// Gets full contact list from database /// </summary> /// <returns>List of contacts</returns> public List <Contact> GetAllContacts() { List <Contact> contacts = null; using (var ctx = new AppContacts()) { contacts = ctx.Contacts.ToList(); } return(contacts); }
/// <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(); } }
public StoredContactViewModelCollection() { if (IsInDesignMode) { return; } _appContacts = new AppContacts(); LoadContacts(); LoadContactsCommand = new RelayCommand(LoadContacts); NavigateToEditContactPageCommand = new RelayCommand <StoredContactViewModel>(NavigateToEditContactPage); }
/// <summary> /// Checks if email address already exists in database /// </summary> /// <param name="email"></param> /// <returns></returns> public bool CheckIfEmailExists(String email, int contactId) { bool result; using (var ctx = new AppContacts()) { //Update existing contact if (contactId > 0) { result = ctx.Contacts.Any(x => x.Email == email && x.ContactId != contactId); } //New contact else { result = ctx.Contacts.Any(x => x.Email == email); } return(result); } }
/// <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); } } }
private void MainPage_Loaded(object sender, System.Windows.RoutedEventArgs e) { _appContacts = new AppContacts(); }