public void AddEventToStackPanel()
{
DataBaseEventDbContext db = new DataBaseEventDbContext();
var r = from d in db.DataBaseEvents1
where d.Year == Current_calendar_data.Date.Year && d.Month == Current_calendar_data.Date.Month
select d;
foreach (var item in r)
{
Image_list_of_day[item.Day - 1].Visibility = Visibility.Visible;
}
}
public void RemoveEventToStackPanel(int id)
{
DataBaseEventDbContext db = new DataBaseEventDbContext();
var r = from d in db.DataBaseEvents1
where d.Id == id
select d;
foreach (var item in r)
{
Image_list_of_day[item.Day - 1].Visibility = Visibility.Hidden;
}
}
// Updates the current reminder time
/// <summary>
/// Updates the current reminder time
/// </summary>
private void UpdateReminderTime(object sender, EventArgs e)
{
DataBaseEventDbContext db = new DataBaseEventDbContext();
var r = from d in db.DataBaseEvents1
where d.RemindTime.Year == Current_data.Year && d.RemindTime.Month == Current_data.Month && d.RemindTime.Day == Current_data.Day && d.RemindTime.Hour == Current_data.Hour && d.RemindTime.Minute == Current_data.Minute
select d;
foreach (var item in r)
{
string eventReminder = "Event " + item.Name.ToString() + " starts at " + item.StartTime.ToString();
AlertWindow alertWindow = new AlertWindow(eventReminder, "Reminder");
alertWindow.ShowDialog();
}
}
// Method to update the DataGrid
/// <summary>
/// Method to update the DataGrid
/// </summary>
private void UpdateGrid()
{
DataBaseEventDbContext db = new DataBaseEventDbContext();
var docs = from d in db.DataBaseEvents1
select new
{
Nr = d.Id,
Name = d.Name,
Localization = d.Localization,
Year = d.Year,
Month = d.Month,
Day = d.Day,
From = d.StartTime,
To = d.StopTime,
Remind = d.RemindTime,
};
this.EventGrid.ItemsSource = docs.ToList();
}
// The metod displays a selected DataGrid section in other TextBoxs
/// <summary>
/// The metod displays a selected DataGrid section in other TextBoxs
/// </summary>
/// <param name="sender"> Contains a reference to the object that triggered the event </param>
/// <param name="e"> Contains state information and event data associated with a routed event </param>
private void EventGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.EventGrid.SelectedIndex >= 0)
{
if (this.EventGrid.SelectedItems.Count >= 0)
{
var row = this.EventGrid.SelectedItems[0];
string arg1 = row.ToString();
string arg2 = "Nr = ";
string arg3 = ",";
string Idstring = Between(arg1, arg2, arg3);
updatingEventID = int.Parse(Idstring);
DataBaseEventDbContext db = new DataBaseEventDbContext();
var r = from d in db.DataBaseEvents1
where d.Id == updatingEventID
select d;
foreach (var item in r)
{
SetBlackForeground(item.Name, item.Localization, item.StartTime, item.StopTime, item.RemindTime);
}
}
}
}
