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 BtnSearch_Click(object sender, RoutedEventArgs e)
{
using (var db = new CVDBContext())
{
var query = from user in db.Users
join ud in db.User_Details on user.User_ID equals ud.User_ID
where user.First_Name.Contains(TxtBoxSearch.Text) ||
user.Last_Name.Contains(TxtBoxSearch.Text)
orderby user.Last_Name, user.First_Name, ud.Available, ud.Available_Date
select new { user.User_ID, user.First_Name, user.Last_Name, ud.Available, ud.Available_Date };
dgContentList.ItemsSource = query.ToList();
}
}
private void FillTags()
{
BtnAddTag.IsEnabled = false;
TxtbxTagFilter.Text = "";
using (var db = new CVDBContext())
{
var query = from tag in db.Tags
orderby tag.Tag_Name ascending
select tag.Tag_Name;
LstBxTags.ItemsSource = query.ToList();
}
}
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 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();
}
private void DGLogs_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DGLogs.SelectedIndex >= 0)
{
var obj = DGLogs.SelectedItem;
System.Type type = obj.GetType();
LogID = (int)type.GetProperty("Log_ID").GetValue(obj, null);
PopupEditLog.IsOpen = true;
BtnNewLog.Content = "Close";
using (var db = new CVDBContext())
{
Logs log = db.Logs.Find(LogID);
var query = from ev in db.Log_Events
where ev.Event_ID == log.Event_ID
select ev.Event_Name;
string tmp = query.FirstOrDefault();
LblLogDate.Content = log.Created;
LblLogWho.Content = log.GetLexiconHandle();
CBLogEvents.SelectedItem = tmp;
TxtBxLogEntry.Text = log.Notes;
}
BtnLogDelete.IsEnabled = true;
}
}
public void FillJournals()
{
using (var db = new CVDBContext())
{
var query = from j in db.Journals
where j.User_ID == selectedUID
select new { Journal_ID = j.Journal_ID, Created = j.Created, Notes = j.Notes };
var tmp = query.ToList();
DGJournals.ItemsSource = tmp;
}
}
public void FillLogs()
{
using (var db = new CVDBContext())
{
var query = from l in db.Logs
join e in db.Log_Events on l.Event_ID equals e.Event_ID
where l.User_ID == selectedUID
select new { Log_ID = l.Log_ID, Created = l.Created, Event = e.Event_Name };
var tmp = query.ToList();
DGLogs.ItemsSource = tmp;
}
}
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 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 BtnNewJournal_Click(object sender, RoutedEventArgs e)
{
PopupEditJournal.IsOpen = PopupEditJournal.IsOpen == true ? false : true;
BtnNewJournal.Content = PopupEditJournal.IsOpen == true ? "Close" : "New Entry";
DGJournals.SelectedIndex = -1;
DGJournals.SelectedItem = null;
LblJournalDate.Content = DateTime.Now;
string lhName = "";
using (var db = new CVDBContext())
{
var query = from lh in db.Lexicon_Handles
where lh.Lexicon_Handle_ID == 1
select lh.First_Name + " " + lh.Last_Name;
lhName = query.FirstOrDefault();
}
LblJournalWho.Content = lhName;
TxtBxJournalEntry.Text = "";
BtnJournalDelete.IsEnabled = false;
}
private void DGJournals_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (DGJournals.SelectedIndex >= 0)
{
var obj = DGJournals.SelectedItem;
System.Type type = obj.GetType();
JournalID = (int)type.GetProperty("Journal_ID").GetValue(obj, null);
using (var db = new CVDBContext())
{
Journals journal = db.Journals.Find(JournalID);
LblJournalDate.Content = journal.Created;
LblJournalWho.Content = journal.GetLexiconHandle();
TxtBxJournalEntry.Text = journal.Notes;
}
BtnNewJournal.Content = "Close";
PopupEditJournal.IsOpen = true;
}
}
private void FillDetails(int id)
{
using (var db = new CVDBContext())
{
var ud = from u_d in db.User_Details
where u_d.User_ID == selectedUID
select u_d;
ChkActive.IsChecked = ud.FirstOrDefault().Active;
if ((bool)ChkAvailable.IsChecked)
{
ChkAvailable.IsChecked = ud.FirstOrDefault().Available;
DPDetails.SelectedDate = null;
}
DPDetails.SelectedDate = ud.FirstOrDefault().Available_Date;
TxtDetailsSalary.Text = AddSEK(ud.FirstOrDefault().Salary.ToString());
}
}
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 BtnNewLog_Click(object sender, RoutedEventArgs e)
{
PopupEditLog.IsOpen = PopupEditLog.IsOpen == true ? false : true;
BtnNewLog.Content = PopupEditLog.IsOpen == true ? "Close" : "New Log";
LblLogDate.Content = DateTime.Now;
string lhName = "";
using (var db = new CVDBContext())
{
var query = from lh in db.Lexicon_Handles
where lh.Lexicon_Handle_ID == 1
select lh.First_Name + " " + lh.Last_Name;
lhName = query.FirstOrDefault();
}
LblLogWho.Content = lhName;
TxtBxLogEntry.Text = "";
BtnLogDelete.IsEnabled = false;
using (var db = new CVDBContext())
{
var query = from le in db.Log_Events
select le;
foreach (Log_Events le in query)
{
if (!CBLogEvents.Items.Contains(le.Event_Name))
CBLogEvents.Items.Add(le.Event_Name);
if (!eventlist.ContainsKey(le.Event_ID))
{
eventlist.Add(le.Event_ID, le.Event_Name);
}
}
}
}
private string FillLabelTags(int uid)
{
LblTags.Content = "";
using (var db = new CVDBContext())
{
var query = from rel in db.User_Tag_REL
join tag in db.Tags on rel.Tag_ID equals tag.Tag_ID
where rel.User_ID == uid
orderby tag.Tag_Name
select tag.Tag_Name;
userTags = query.ToList();
}
if (userTags.Count > 0)
{
return string.Join(",", userTags).CapitalizeFirst();
}
else
{
return "";
}
}
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);
}