private void getNotesFromDb() { DaysDBEntities ctx = new DaysDBEntities(); var results = (from d in ctx.Days select d); List <Days> days = results.ToList(); foreach (Days dbDay in days) { foreach (Day calendarDay in Calendar.Days) { if (calendarDay.Date == dbDay.date) { calendarDay.Notes = dbDay.notes; } } } }
private void Calendar_DayChanged(object sender, DayChangedEventArgs e) { DaysDBEntities ctx = new DaysDBEntities(); var results = (from d in ctx.Days where d.date == e.Day.Date select d); if (results.Count() <= 0) { Days newDay = new Days(); newDay.date = e.Day.Date; newDay.notes = e.Day.Notes; ctx.Days.Add(newDay); ctx.SaveChanges(); } else { Days oldDay = results.FirstOrDefault(); oldDay.notes = e.Day.Notes; ctx.SaveChanges(); } }