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); }