public void TestDaoSessionExamsCRUD() { DaoSessionExams daoExams = new DaoSessionExams(connectionString); var allExams = daoExams.GetAllRecords(); int count = allExams.Count; SessionExam exam = new SessionExam(2, 8, "exam", 1, new DateTime(2020, 12, 21)); daoExams.Create(exam); allExams = daoExams.GetAllRecords(); Assert.AreEqual(count + 1, allExams.Count); exam.ID = allExams.Last().ID; exam.GroupID = 3; exam.SubjectID = 3; daoExams.Update(exam); SessionExam updExam = daoExams.GetById(exam.ID); Assert.AreEqual(exam, updExam); daoExams.Delete(exam); Assert.AreEqual(count, daoExams.GetAllRecords().Count); }
/// <summary> /// Initializes a new instance of the Report class /// </summary> /// <param name="daoFactory"> Dao factory</param> public Reports(DaoFactory daoFactory) { daoGroup = daoFactory.GetDaoGroups(); daoSubject = daoFactory.GetDaoSubjects(); daoStudent = daoFactory.GetDaoStudents(); daoExams = daoFactory.GetDaoSessExams(); daoResults = daoFactory.GetDaoSessResults(); }
/// <summary> /// Create DaoSessionExams instance /// </summary> /// <returns></returns> public DaoSessionExams GetDaoSessExams() { if (daoSessionExams == null) { daoSessionExams = new DaoSessionExams(ConnectionString); } return(daoSessionExams); }