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); } } } }