private void Schedule_AppointmentEditorClosed(object sender, AppointmentEditorClosedEventArgs e) { MeetingsDBDataContext scheduleMeetings = new MeetingsDBDataContext(); Meeting_Table meeting; if (e.Action == EditorClosedAction.Save) { var editedAppointment = (e.EditedAppointment as ScheduleMeeting); var appointmentID = Convert.ToInt32(editedAppointment.AppointmentID); if (!e.IsNew) { meeting = (from data in scheduleMeetings.Meeting_Tables where data.ID == appointmentID select data).First() as Meeting_Table; meeting.Subject = editedAppointment.MappedSubject; meeting.StartTime = editedAppointment.MappedStartTime.ToString(); meeting.EndTime = editedAppointment.MappedEndTime.ToString(); meeting.Color = editedAppointment.MappedColor.ToString(); meeting.IsAllDay = editedAppointment.MappedIsAllDay.ToString(); meeting.ID = appointmentID; } else { meeting = new Meeting_Table(); meeting.Subject = editedAppointment.MappedSubject; meeting.StartTime = editedAppointment.MappedStartTime.ToString(); meeting.EndTime = editedAppointment.MappedEndTime.ToString(); meeting.Color = editedAppointment.MappedColor.ToString(); meeting.IsAllDay = editedAppointment.MappedIsAllDay.ToString(); meeting.ID = appointmentID; scheduleMeetings.Meeting_Tables.InsertOnSubmit(meeting); } scheduleMeetings.SubmitChanges(); } if (e.Action == EditorClosedAction.Delete) { var editedAppointment = (e.OriginalAppointment as ScheduleMeeting); var appointmentID = Convert.ToInt32(editedAppointment.AppointmentID); meeting = (from data in scheduleMeetings.Meeting_Tables where data.ID == appointmentID select data).First() as Meeting_Table; scheduleMeetings.Meeting_Tables.DeleteOnSubmit(meeting); scheduleMeetings.SubmitChanges(); } }
public ScheduleViewModel() { Meetings = new ObservableCollection <ScheduleMeeting>(); MeetingsDBDataContext = new MeetingsDBDataContext(); var MeetingsList = (from data in MeetingsDBDataContext.Meeting_Tables select data).ToList(); for (int i = 0; i < MeetingsList.Count; i++) { Meetings.Add(new ScheduleMeeting() { MappedSubject = MeetingsList[i].Subject, MappedStartTime = Convert.ToDateTime(MeetingsList[i].StartTime), MappedEndTime = Convert.ToDateTime(MeetingsList[i].EndTime), MappedColor = new SolidColorBrush((Color)ColorConverter.ConvertFromString(MeetingsList[i].Color)), MappedIsAllDay = Convert.ToBoolean(MeetingsList[i].IsAllDay), AppointmentID = MeetingsList[i].ID.ToString() }); } }