public void TestDaoStudentsCRUD() { DaoStudents daoStudents = new DaoStudents(connectionString); var allStudents = daoStudents.GetAllRecords(); int count = allStudents.Count; Student student1 = new Student("Sinatra", "Frank", "Petrovich", 2, "male", new DateTime(1915, 4, 17)); daoStudents.Create(student1); allStudents = daoStudents.GetAllRecords(); Assert.AreEqual(count + 1, allStudents.Count); student1.ID = allStudents.Last().ID; student1.LastName = "Eliseev"; student1.FirstName = "Igor"; student1.MiddleName = "Andreevich"; student1.BirthDate = new DateTime(1998, 3, 5); daoStudents.Update(student1); Student updStudent = daoStudents.GetById(student1.ID); Assert.AreEqual(student1, updStudent); daoStudents.Delete(student1); Assert.AreEqual(count, daoStudents.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 DaoStudents instance /// </summary> /// <returns></returns> public DaoStudents GetDaoStudents() { if (daoStudents == null) { daoStudents = new DaoStudents(ConnectionString); } return(daoStudents); }