public void ExcelWriteWithSortingByAverageMarkAverageMarkBySpecification()
        {
            //arrange
            AverageMarkBySpecificationGetter  getter  = new AverageMarkBySpecificationGetter(connectionString);
            List <AverageMarkBySpecification> results = getter.GetAverageMark(1, i => i.AverageMark, SortType.Ascending).ToList();
            //act
            bool flag = ExcelWorker.Write(@"AverageMarkBySpecificationWithSorting.xlsx", results);

            //assert
            Assert.IsTrue(flag);
        }
        public void ExcelWriteAverageMarkBySpecification()
        {
            //arrange
            AverageMarkBySpecificationGetter  getter  = new AverageMarkBySpecificationGetter(connectionString);
            List <AverageMarkBySpecification> results = getter.GetAverageMark(1).ToList();
            //act
            bool flag = ExcelWorker.Write(@"AverageMarkBySpecification.xlsx", results);

            //assert
            Assert.IsTrue(flag);
        }