private void AddNoteToDate(DateTime dateTime, string note) { using var _nat02Context = new NAT02Context(); try { // Exists if (_nat02Context.EoiCalendar.Any(c => c.Year == dateTime.Year && c.Month == dateTime.Month && c.Day == dateTime.Day)) { EoiCalendar eoiCalendar = _nat02Context.EoiCalendar.First(c => c.Year == dateTime.Year && c.Month == dateTime.Month && c.Day == dateTime.Day); eoiCalendar.Notes += System.Environment.NewLine + note; eoiCalendar.DomainName = user.DomainName; _nat02Context.SaveChanges(); } else { EoiCalendar eoiCalendar = new EoiCalendar { Year = (Int16)dateTime.Year, Month = (byte)dateTime.Month, Day = (byte)dateTime.Day, DomainName = user.DomainName, Notes = note }; _nat02Context.EoiCalendar.Add(eoiCalendar); _nat02Context.SaveChanges(); } } catch (Exception ex) { MessageBox.Show("There was an error processing your request. It may have been parially processed" + System.Environment.NewLine + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error); IMethods.WriteToErrorLog("RecurringEventWindow => AddNoteToDate => Date: " + dateTime.ToLongDateString() + " => Note: " + note, ex.Message, user); } _nat02Context.Dispose(); }
private void Calendar_DayChanged(object sender, Jarloo.Calendar.DayChangedEventArgs e) { DateTime d = e.Day.Date; using var _nat02Context = new NAT02Context(); // Delete from table if (string.IsNullOrEmpty(e.Day.Notes) || string.IsNullOrWhiteSpace(e.Day.Notes)) { // Exists if (_nat02Context.EoiCalendar.Any(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day)) { if (_nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day).ActionDateTime < timeEnteredCalendar || _nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day).DomainName == user.DomainName) { // Remove EoiCalendar eoiCalendar = _nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day); _nat02Context.EoiCalendar.Remove(eoiCalendar); _nat02Context.SaveChanges(); _nat02Context.Dispose(); } else { MessageBox.Show("There appears to have been a change made by '" + _nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day).DomainName + "' to this date before you deleted the note. Please re-open the calendar to load the information.", "Prevoiusly changed", MessageBoxButton.OK, MessageBoxImage.Information); _nat02Context.Dispose(); } } } // Insert or Update else { // Exists if (_nat02Context.EoiCalendar.Any(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day)) { if (_nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day).ActionDateTime < timeEnteredCalendar || _nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day).DomainName == user.DomainName) { EoiCalendar eoiCalendar = _nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day); eoiCalendar.Notes = e.Day.Notes; eoiCalendar.DomainName = user.DomainName; _nat02Context.SaveChanges(); _nat02Context.Dispose(); } else { MessageBox.Show("There appears to have been a change made by '" + _nat02Context.EoiCalendar.First(c => c.Year == (short)d.Year && c.Month == (byte)d.Month && c.Day == (byte)d.Day).DomainName + "' to this date before you altered the note. Please re-open the calendar to load the information.", "Prevoiusly changed", MessageBoxButton.OK, MessageBoxImage.Information); _nat02Context.Dispose(); } } // New else { EoiCalendar eoiCalendar = new EoiCalendar { Day = (byte)d.Day, Month = (byte)d.Month, Year = (Int16)d.Year, DomainName = user.DomainName, Notes = e.Day.Notes }; _nat02Context.EoiCalendar.Add(eoiCalendar); _nat02Context.SaveChanges(); _nat02Context.Dispose(); } } }