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); } } }