private async void button1_Click(object sender, EventArgs e) { OpenFileDialog opf = new OpenFileDialog(); opf.ShowDialog(); if (string.IsNullOrWhiteSpace(opf.FileName)) { return; } IExcelAlgo dataList = new StudentDataList(opf.FileName); dataGridView1.DataSource = await dataList.Load(); }
protected StudentDataList GetStudentDataList() { var list = new StudentDataList(); list.AddRange(allStudentUSIs.Select(studentUSI => new StudentData {StudentUSI = studentUSI, Filler = providedFiller1})); list.Filler = providedFiller2; return list; }
protected override void ExecuteTest() { var testService = windsorContainer.Resolve<ITestService>(); actualNoStudentData = testService.GetNoStudentData(providedFiller1); actualNoStudentDataEnumerable = testService.GetNoStudentDataEnumerable(GetNoStudentDataEnumerable()); actualNoStudentDataQueryable = testService.GetNoStudentDataQueryable(GetNoStudentDataEnumerable().AsQueryable()); actualNoStudentDataList = testService.GetNoStudentDataList(GetNoStudentDataEnumerable()); actualStudentData = testService.GetStudentData(student1_1, providedFiller1); actualStudentDataEnumerable = testService.GetStudentDataEnumerable(GetStudentDataEnumerable()); actualStudentDataQueryable = testService.GetStudentDataQueryable(GetStudentDataEnumerable().AsQueryable()); actualStudentDataList = testService.GetStudentDataList(GetStudentDataEnumerable()); actualNestedStudentData = testService.GetNestedStudentData(student1_1, providedFiller1, providedFiller2); actualNestedStudentDataEnumerable = testService.GetNestedStudentDataEnumerable(GetNestedStudentDataEnumerable()); actualNestedStudentDataQueryable = testService.GetNestedStudentDataQueryable(GetNestedStudentDataEnumerable().AsQueryable()); actualNestedStudentDataList = testService.GetNestedStudentDataList(GetNestedStudentDataEnumerable()); actualNestedStudentDataCollection = testService.GetNestedStudentDataCollection(GetStudentDataEnumerable().ToList(), providedFiller1); actualNestedStudentDataCollectionEnumerable = testService.GetNestedStudentDataCollectionEnumerable(GetNestedStudentDataCollectionEnumerable()); actualNestedStudentDataCollectionQueryable = testService.GetNestedStudentDataCollectionQueryable(GetNestedStudentDataCollectionEnumerable().AsQueryable()); actualNestedStudentDataCollectionList = testService.GetNestedStudentDataCollectionList(GetNestedStudentDataCollectionEnumerable()); actualStudentDataTypedList = testService.GetStudentDataList(GetStudentDataList()); }