public void ExcelWriteWithSortingDescendingAverageMarkBySubject()
        {
            //arrange
            AverageMarksBySubjectsGetter           getter  = new AverageMarksBySubjectsGetter(connectionString);
            List <AverageMarksBySubjectsInOneYear> results = getter.GetAverageMarks(r => r.AverageMark, SortType.Descending).ToList();

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

            //assert
            Assert.IsTrue(flag);
        }
        public void ExcelWriteAverageMarkBySubject()
        {
            //arrange
            AverageMarksBySubjectsGetter           getter  = new AverageMarksBySubjectsGetter(connectionString);
            List <AverageMarksBySubjectsInOneYear> results = getter.GetAverageMarks().ToList();

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

            //assert
            Assert.IsTrue(flag);
        }