public void Delete(AppointmentDeletedEventArgs e) { var appointment = (Appointment)(e.Appointment); using (var db = new AppointmentContext()) { var findAppInDB = db.AppointmentModels.FirstOrDefault(applic => applic.Id == appointment.UniqueId); db.AppointmentModels.Remove(findAppInDB); db.SaveChanges(); } }
public void Edit(AppointmentEditedEventArgs e) { var appointment = (Appointment)(e.Appointment); using (var db = new AppointmentContext()) { var findAppInDB = db.AppointmentModels.FirstOrDefault(applic => applic.Id == appointment.UniqueId); findAppInDB.StartTime = appointment.Start; findAppInDB.EndTime = appointment.End; findAppInDB.Subject = appointment.Subject; findAppInDB.Body = appointment.Body; db.SaveChanges(); } }
public void Save(AppointmentCreatedEventArgs e) { using (var db = new AppointmentContext()) { var appointment = (Appointment)(e.CreatedAppointment); var newAppointment = new AppointmentModel() { Id = appointment.UniqueId, StartTime = appointment.Start, EndTime = appointment.End, Subject = appointment.Subject, Body = appointment.Body }; db.AppointmentModels.Add(newAppointment); db.SaveChanges(); } }
private ObservableCollection<Appointment> Load() { using (var db = new AppointmentContext()) { var collection = new ObservableCollection<Appointment>(); try { var findApps = db.AppointmentModels.Select(app => app); if (findApps.Count() > 0) { foreach (var app in findApps) { var appoint = new Appointment(); appoint.UniqueId = app.Id; appoint.Start = app.StartTime; appoint.End = app.EndTime; appoint.Subject = app.Subject; appoint.Body = app.Body; collection.Add(appoint); } } } catch { } return collection; } }