public ExamProperties(ScheduleRepository repo, int examToUpdateId, ExamPropertiesMode mode) { InitializeComponent(); _repo = repo; _mode = mode; if (_mode == ExamPropertiesMode.Edit) { _exam = _repo.Exams.GetExam(examToUpdateId); } if (_mode == ExamPropertiesMode.New) { _exam = new Exam(); } }
public Exam AddExam(Exam exam) { using (var context = new ScheduleContext(ConnectionString)) { exam.ExamId = 0; context.Exams.Add(exam); context.SaveChanges(); return exam; } }
public void UpdateExamWOLog(Exam exam) { using (var context = new ScheduleContext(ConnectionString)) { var curExam = GetExam(exam.ExamId); curExam.ConsultationAuditoriumId = exam.ConsultationAuditoriumId; curExam.ConsultationDateTime = exam.ConsultationDateTime; curExam.DisciplineId = exam.DisciplineId; curExam.ExamAuditoriumId = exam.ExamAuditoriumId; curExam.ExamDateTime = exam.ExamDateTime; curExam.ExamId = exam.ExamId; curExam.IsActive = exam.IsActive; context.SaveChanges(); } }
public void UpdateExam(Exam exam) { using (var context = new ScheduleContext(ConnectionString)) { var oldExam = context.Exams.FirstOrDefault(e => e.ExamId == exam.ExamId); oldExam.IsActive = false; exam.ExamId = 0; context.Exams.Add(exam); context.SaveChanges(); var logEntry = new LogEvent() { OldExam = oldExam, NewExam = exam, DateTime = DateTime.Now }; context.EventLog.Add(logEntry); context.SaveChanges(); } }
private void Save_Click(object sender, EventArgs e) { var newExam = new Exam { ExamId = _exam.ExamId, DisciplineId = _exam.DisciplineId, IsActive = true, ConsultationDateTime = ConsDate.Value }; var consAud = _repo.Auditoriums.Find(ConsAudBox.Text); if (consAud != null) { newExam.ConsultationAuditoriumId = consAud.AuditoriumId; } newExam.ExamDateTime = ExamDate.Value; var examAud = _repo.Auditoriums.Find(ExamAudBox.Text); if (examAud != null) { newExam.ExamAuditoriumId = examAud.AuditoriumId; } _repo.Exams.UpdateExam(newExam); Close(); }