public void Verify_SqlCosmetologyGradeBookRepository_GetStudentCosmetologyGradeBookTestReport_Returns_Data_Against_Valid_Db_Student()
        {
            ICosmetologyGradeBookRepository gradeBookRepository = new SqlCosmetologyGradeBookRepository();
            var studentGradeBookTest = gradeBookRepository.GetStudentCosmetologyGradeBookTestReport(TestConstants.DbStudentUserId);

            Assert.IsNotNull(studentGradeBookTest);
            Assert.IsNotNull(studentGradeBookTest.StudentName);
            Assert.IsNotNull(studentGradeBookTest.CosmetologyGradeBookTests);
            Assert.IsTrue(studentGradeBookTest.CosmetologyGradeBookTests.Count > 0);
        }
        public void Verify_SqlCosmetologyGradeBookRepository_GetStudentCosmetologyGradeBookSummaryReport_Returns_Empty_Data_Against_Invalid_Db_Student()
        {
            ICosmetologyGradeBookRepository gradeBookRepository = new SqlCosmetologyGradeBookRepository();
            var studentGradeBookSummary = gradeBookRepository.GetStudentCosmetologyGradeBookSummaryReport(TestConstants.InvalidUserId);

            Assert.IsNotNull(studentGradeBookSummary);
            Assert.IsNull(studentGradeBookSummary.StudentName);
            Assert.IsNotNull(studentGradeBookSummary.CosmetologyGradeBookSummaries);
            Assert.IsTrue(studentGradeBookSummary.CosmetologyGradeBookSummaries.Count == 0);
        }