public void ExcelWriteWithSortingByAverageMarkAverageMarkByExaminer()
        {
            //arrange
            AverageMarkByExaminerGetter  getter  = new AverageMarkByExaminerGetter(connectionString);
            List <AverageMarkByExaminer> results = getter.GetAverageMark(1, i => i.AverageMark, SortType.Descending).ToList();

            //act
            bool flag = ExcelWorker.Write(@"AverageMarkByExaminerWithSorting.xlsx", results);

            //assert
            Assert.IsTrue(flag);
        }
        public void ExcelWriteAverageMarkByExaminer()
        {
            //arrange
            AverageMarkByExaminerGetter  getter  = new AverageMarkByExaminerGetter(connectionString);
            List <AverageMarkByExaminer> results = getter.GetAverageMark(1).ToList();

            //act
            bool flag = ExcelWorker.Write(@"AverageMarkByExaminer.xlsx", results);

            //assert
            Assert.IsTrue(flag);
        }