public void AddExam(Exam exam)
{
using (var context = new SessionContext(ConnectionString))
{
exam.ExamId = 0;
context.Exams.Add(exam);
context.SaveChanges();
}
}
public void AddExamsRange(IEnumerable<Exam> examList)
{
using (var context = new SessionContext(ConnectionString))
{
foreach (var exam in examList)
{
exam.ExamId = 0;
context.Exams.Add(exam);
}
context.SaveChanges();
}
}
public void BackupDB(string filename)
{
using (var context = new SessionContext(ConnectionString))
{
var dbName = ExtractDBName(context.Database.Connection.ConnectionString);
if (dbName == "")
{
return;
}
var backupSQL = "BACKUP DATABASE " + dbName + " TO DISK = '" + filename + "' WITH FORMAT, MEDIANAME='" + dbName + "'";
ExecuteQuery(backupSQL);
}
}
public void UpdateExamWOLog(Exam exam)
{
using (var context = new SessionContext(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 SessionContext(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();
}
}
public void SaveChanges()
{
using (var context = new SessionContext(ConnectionString))
{
context.SaveChanges();
}
}
public void CreateDB()
{
using (var context = new SessionContext(ConnectionString))
{
if (!context.Database.Exists())
{
((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
}
}
}
private void RemoveLogEvent(int logEventId)
{
using (var context = new SessionContext(ConnectionString))
{
var logEvent = context.EventLog.FirstOrDefault(le => le.LogEventId == logEventId);
context.EventLog.Remove(logEvent);
context.SaveChanges();
}
}
public Exam GetFirstFiltredExam(Func<Exam, bool> condition)
{
using (var context = new SessionContext(ConnectionString))
{
return context.Exams.ToList().FirstOrDefault(condition);
}
}
public List<Exam> GetFiltredExams(Func<Exam, bool> condition)
{
using (var context = new SessionContext(ConnectionString))
{
return context.Exams.ToList().Where(condition).ToList();
}
}
public Exam GetExam(int examId)
{
using (var context = new SessionContext(ConnectionString))
{
return context.Exams.FirstOrDefault(a => a.ExamId == examId);
}
}
public List<LogEvent> GetAllLogEvents()
{
using (var context = new SessionContext(ConnectionString))
{
return context
.EventLog
.Include(e => e.OldExam)
.Include(e => e.NewExam)
.ToList();
}
}
public List<Exam> GetAllExams()
{
using (var context = new SessionContext(ConnectionString))
{
return context
.Exams
.Where(e => e.IsActive)
.ToList();
}
}
public List<Exam> GetAllExamRecords()
{
using (var context = new SessionContext(ConnectionString))
{
return context
.Exams
.ToList();
}
}
private void Dispose(bool b)
{
using (var context = new SessionContext(ConnectionString))
{
context.Dispose();
}
}
private LogEvent GetLogEvent(int logEventId)
{
using (var context = new SessionContext(ConnectionString))
{
return context
.EventLog
.Include(e => e.OldExam)
.Include(e => e.NewExam)
.FirstOrDefault(le => le.LogEventId == logEventId);
}
}
public int GetTotalExamsCount()
{
using (var context = new SessionContext(ConnectionString))
{
return context
.Exams
.Count(e => e.IsActive);
}
}
public void RecreateDB()
{
using (var context = new SessionContext(ConnectionString))
{
context.Database.Delete();
context.Database.CreateIfNotExists();
}
}
public void RemoveExam(int examId)
{
using (var context = new SessionContext(ConnectionString))
{
var exam = context.Exams.FirstOrDefault(e => e.ExamId == examId);
context.Exams.Remove(exam);
try
{
context.SaveChanges();
}
catch (Exception e)
{
throw;
}
}
}
public void ClearAllExams()
{
using (var context = new SessionContext(ConnectionString))
{
var examIds = context.Exams.Select(e => e.ExamId).ToList();
foreach (var examId in examIds)
{
RemoveExam(examId);
}
}
}
public void ClearExamLogs()
{
using (var context = new SessionContext(ConnectionString))
{
var logIds = context.EventLog.Select(le => le.LogEventId).ToList();
foreach (var logId in logIds)
{
RemoveLogEvent(logId);
}
}
}