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 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 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 BtnLogDelete_Click(object sender, RoutedEventArgs e)
{
using (var db = new CVDBContext())
{
Logs LogToDelete = db.Logs.Find(LogID);
db.Logs.Remove(LogToDelete);
db.SaveChanges();
}
PopupEditLog.IsOpen = false;
BtnNewLog.Content = "New Log";
FillLogs();
}
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 BtnJournalDelete_Click(object sender, RoutedEventArgs e)
{
using (var db = new CVDBContext())
{
Journals JournalToDelete = db.Journals.Find(JournalID);
db.Journals.Remove(JournalToDelete);
db.SaveChanges();
}
PopupEditJournal.IsOpen = false;
BtnNewJournal.Content = "New Entry";
FillJournals();
}
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();
}
private void BtnYes_Click(object sender, RoutedEventArgs e)
{
using (CVDBContext db = new CVDBContext())
{
Users userToDelete = db.Users.Find(selectedUID);
db.Users.Remove(userToDelete);
db.SaveChanges();
}
//delete user, never to return!
txtbxtest.Text = "Användare med id: " + selectedUID + " borttagen.";
PopupDelete.IsOpen = false;
dgContentList.SelectedIndex = -1;
ShowHide();
dgContentList.UpdateGrid();
Page_default p = new Page_default();
FrmContent.Navigate(p);
}
