public void SaveFolderListToDb() { using (var db = new Models.DatabaseContext()) { var folders = db.Folders.ToList(); foreach (var folder in folders) { if (!_parentForm.FolderList.ContainsKey(folder.FolderName)) { db.Folders.Remove(folder); } } db.SaveChanges(); foreach (var folder in _parentForm.FolderList.Values) { db.Folders.AddOrUpdate(folder); } db.SaveChanges(); } }
public void SaveCollectionToDb() { using (var db = new Models.DatabaseContext()) { var emails = db.Emails.ToList(); foreach (var email in emails) { if (!_parentForm.FolderList.ContainsKey(email.Id)) { db.Emails.Remove(email); } } db.SaveChanges(); foreach (var email in _parentForm.EmailCollection.Values) { db.Emails.AddOrUpdate(email); } db.SaveChanges(); } }