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