public void ExcelWriteSessionResultsWithSortingByDateAscending()
        {
            //arrange
            SessionResultGetter getter  = new SessionResultGetter(connectionString);
            List <GroupResult>  results = getter.GetSessionResult(1, (i) => i.StudentName, SortType.Ascending).ToList <GroupResult>();
            //act
            bool flag = ExcelWorker.Write(@"SessionResultsWithSorting.xlsx", results);

            //assert
            Assert.IsTrue(flag);
        }
        public void ExcelWriteSessionResults()
        {
            //arrange
            SessionResultGetter getter  = new SessionResultGetter(connectionString);
            List <GroupResult>  results = getter.GetSessionResult(1).ToList <GroupResult>();
            //act
            bool flag = ExcelWorker.Write(@"SessionResults.xlsx", results);

            //assert
            Assert.IsTrue(flag);
        }