public void TestSessionReSult_Sort()
        {
            string           Path          = @"E:\Epam\.Net_EpamTraining\6";
            int              sessionNumber = 5;
            StatisticSession ss            = new StatisticSession();

            List <object[]>[] objss = ss.GetSessionReSult(sessionNumber);

            objss[0] = Sort.sortBy(3, false, objss[0]);

            int result = 0;

            for (int i = 0; i < objss.Count(); i++)
            {
                //export data
                result += ExcelExport.Export(objss[i],
                                             Path,
                                             @"Exported_Session_" + sessionNumber +
                                             "_results_" + objss[i][1][0].ToString())
                ? 1 : 0;
            }

            bool actual = result > 0 ? true : false;

            bool expected = true;

            Assert.AreEqual(actual, expected);
        }
        public void TestExportMiddleGroupResults()
        {
            string           Path = @"E:\Epam\.Net_EpamTraining\6";
            StatisticSession ss   = new StatisticSession();
            List <object[]>  obj  = ss.GetMiddleGroupResults();

            bool actual = ExcelExport.Export(obj, Path, "Middle_groups_results");

            bool expected = true;

            Assert.AreEqual(actual, expected);
        }
        public void TestGetYearsDinamicSubjectsMarks()
        {
            string           Path = @"E:\Epam\.Net_EpamTraining\6";
            StatisticSession ss   = new StatisticSession();
            List <object[]>  obj  = ss.GetYearsDinamicSubjectsMarks();

            bool actual = ExcelExport.Export(obj, Path,
                                             "_Task7__Middle_Subject_marks_for_years");

            bool expected = true;

            Assert.AreEqual(actual, expected);
        }
        public void TestGetTeachersMiddleMarks()
        {
            int              SessionNumber = 5;
            string           Path          = @"E:\Epam\.Net_EpamTraining\6";
            StatisticSession ss            = new StatisticSession();
            List <object[]>  obj           = ss.GetTeachersMiddleMarks(SessionNumber);

            bool actual = ExcelExport.Export(obj, Path,
                                             "_Task7__Middle_Teachers_marks_sessionNumber" + SessionNumber);

            bool expected = true;

            Assert.AreEqual(actual, expected);
        }
        public void TestExportExpelledStudents()
        {
            string           Path          = @"E:\Epam\.Net_EpamTraining\6";
            int              sessionNumber = 5;
            StatisticSession ss            = new StatisticSession();

            List <object[]> obj = ss.GetExpelledStudents(sessionNumber);

            bool expected = true;
            bool actual   = ExcelExport.Export(obj, Path,
                                               "ExpelledStudents_sessionNumber=" + sessionNumber);

            Assert.AreEqual(actual, expected);
        }