public void ExcelWriteWithSortingBySurnameAscendingDropOutStudents()
{
//arrange
DropoutStudentsGetter getter = new DropoutStudentsGetter(connectionString);
List <DropOutStudentsByGroup> results = getter.GetExpelStudents((res) => res.Surname, SortType.Ascending).ToList <DropOutStudentsByGroup>();
//act
bool flag = ExcelWorker.Write(@"DropoutStudentsAscendingWithSorting.xlsx", results);
//assert
Assert.IsTrue(flag);
}
public void ExcelWriteGroupAvgMinMaxWithSortingByMaxDescending()
{
//arrange
AllGroupsAvgMaxMinGetter getter = new AllGroupsAvgMaxMinGetter(connectionString);
List <GroupsAvgMinMax> results = getter.GetGroupsAvgMinMax((i) => i.Max, SortType.Descending).ToList <GroupsAvgMinMax>();
//act
bool flag = ExcelWorker.Write(@"GroupAvgMinMaxWithSorting.xlsx", results);
//assert
Assert.IsTrue(flag);
}
public void ExcelWriteDropOutStudents()
{
//arrange
DropoutStudentsGetter getter = new DropoutStudentsGetter(connectionString);
List <DropOutStudentsByGroup> results = getter.GetExpelStudents().ToList <DropOutStudentsByGroup>();
//act
bool flag = ExcelWorker.Write(@"DropoutStudents.xlsx", results);
//assert
Assert.IsTrue(flag);
}
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 ExcelWriteGroupAvgMinMax()
{
//arrange
AllGroupsAvgMaxMinGetter getter = new AllGroupsAvgMaxMinGetter(connectionString);
List <GroupsAvgMinMax> results = getter.GetGroupsAvgMinMax().ToList <GroupsAvgMinMax>();
//act
bool flag = ExcelWorker.Write(@"GroupAvgMinMax.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);
}
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);
}
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);
}
