private void LstBxTags_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (LstBxTags.SelectedItem != null) { string tmp = LstBxTags.SelectedItem.ToString(); if (userTags.Contains(tmp)) { //delete from database using (var db = new CVDBContext()) { var i = from tag in db.Tags where tag.Tag_Name == tmp select tag.Tag_ID; int id = i.FirstOrDefault(); var query = from rel in db.User_Tag_REL where rel.User_ID == selectedUID && rel.Tag_ID == id select rel; User_Tag_REL toDelete = query.FirstOrDefault(); db.User_Tag_REL.Remove(toDelete); db.SaveChanges(); } LblTags.Content = FillLabelTags(selectedUID); txtbxtest.Text = "deleted from database: " + tmp; } else { //save to database using (var db = new CVDBContext()) { var i = from tag in db.Tags where tag.Tag_Name == tmp select tag.Tag_ID; int id = i.FirstOrDefault(); User_Tag_REL toAdd = new User_Tag_REL { User_ID = selectedUID, Tag_ID = id }; db.User_Tag_REL.Add(toAdd); db.Entry(toAdd).State = EntityState.Added; db.SaveChanges(); } LblTags.Content = FillLabelTags(selectedUID); txtbxtest.Text = "saved to database: " + tmp; } Unselect(); } }
private void BtnAddTag_Click(object sender, RoutedEventArgs e) { using (var db = new CVDBContext()) { Tags t = new Tags { Tag_Name = TxtbxTagFilter.Text }; db.Tags.Add(t); db.Entry(t).State = EntityState.Added; db.SaveChanges(); } FillTags(); }
private void BtnJournalSave_Click(object sender, RoutedEventArgs e) { using (var db = new CVDBContext()) { if (DGJournals.SelectedIndex < 0) { Journals j = new Journals { Created = DateTime.Now, User_ID = selectedUID, Notes = TxtBxJournalEntry.Text, Lexicon_Handle_ID = 1 }; db.Journals.Add(j); db.Entry(j).State = EntityState.Added; } else { Journals j = db.Journals.Find(JournalID); j.Notes = TxtBxJournalEntry.Text; db.Entry(j).State = EntityState.Modified; } db.SaveChanges(); } PopupEditJournal.IsOpen = false; PopupJournal.IsOpen = true; BtnNewJournal.Content = "New Entry"; FillJournals(); }
private void BtnLogSave_Click(object sender, RoutedEventArgs e) { using (var db = new CVDBContext()) { if (LogID < 1) { Logs newLog = new Logs { Event_ID = getEventID(CBLogEvents.SelectedValue.ToString()), Lexicon_Handle_ID = 1, Created = DateTime.Now, User_ID = selectedUID, Notes = TxtBxLogEntry.Text }; db.Logs.Add(newLog); db.Entry(newLog).State = EntityState.Added; } else { Logs logToUpdate = db.Logs.Find(LogID); logToUpdate.Notes = TxtBxLogEntry.Text; db.Entry(logToUpdate).State = EntityState.Modified; } db.SaveChanges(); } PopupEditLog.IsOpen = false; BtnNewLog.Content = "New Log"; FillLogs(); }
private void BtnSaveDetails_Click(object sender, RoutedEventArgs e) { using (var db = new CVDBContext()) { User_Details ud = db.User_Details.Find(selectedUID); ud.User_ID = selectedUID; ud.Modified = DateTime.Now; ud.Active = (bool)ChkActive.IsChecked; ud.Available = (bool)ChkAvailable.IsChecked; if ((bool)ChkAvailable.IsChecked) { DPDetails.SelectedDate = null; } ud.Available_Date = DPDetails.SelectedDate; ud.Salary = GetNumber(TxtDetailsSalary.Text); db.Entry(ud).State = EntityState.Modified; txtbxtest.Text = ud.ToString(); db.SaveChanges(); } PopupDetails.IsOpen = false; dgContentList.UpdateGrid(); }