public void UpdateLogEvent(LogEvent logEvent)
{
using (var context = new ScheduleContext(ConnectionString))
{
var curLogEvent = context.EventLog.FirstOrDefault(le => le.LogEventId == logEvent.LogEventId);
curLogEvent.DateTime = logEvent.DateTime;
curLogEvent.OldExam = context.Exams.FirstOrDefault(e => e.ExamId == logEvent.OldExam.ExamId);
curLogEvent.NewExam = context.Exams.FirstOrDefault(e => e.ExamId == logEvent.NewExam.ExamId);
context.SaveChanges();
}
}
public LogEvent AddLogEvent(LogEvent logEvent)
{
using (var context = new ScheduleContext(ConnectionString))
{
logEvent.OldExam = context.Exams.FirstOrDefault(e => e.ExamId == logEvent.OldExam.ExamId);
logEvent.NewExam = context.Exams.FirstOrDefault(e => e.ExamId == logEvent.NewExam.ExamId);
context.EventLog.Add(logEvent);
context.SaveChanges();
return logEvent;
}
}
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();
}
}