public void TestOurimbahMNGT30072018S1Pathways_OurimbahAndNCLData() { var consoleReader = new ConsoleReaderForTests("AllCampusACFIData2016-2019", 2016, 2019, "AllCampus", "AllCampusACFI10012016S1TESTFILE"); GeneratePathwaysForListOfStudentsFromEnrollmentData(consoleReader); }
public void TestOurimbahMNGT30072018S1Pathways_OnlyOurimbahData() { var consoleReader = new ConsoleReaderForTests("OurimbahOnlyMNGTData2017-2019", 2017, 2019, "Ourimbah", "OurimbahMNGT30072018S1TESTFILE"); GeneratePathwaysForListOfStudentsFromEnrollmentData(consoleReader); }
public void CreateForceDirectedTable_OurimbahMNGT20062018S2() { var consoleReader = new ConsoleReaderForTests("OurimbahMNGT20062018S2PATHWAY", "OurimbahMNGT20062018S2OUTPUT", "OurimbahMNGT20062018S1TESTFILE1"); var forceDirectedTableMaker = new ForceDirectedTableMakerTool(); forceDirectedTableMaker.CreateForceDirectedTable(consoleReader); var worksheetTableComparer = new WorksheetTableComparerForTests(consoleReader.GetTestFilePath(), consoleReader.GetNewSaveFilePath(), "ForceDirectedTable"); worksheetTableComparer.Compare(); }
public void GetDataFromNuStarWebsiteTest_MNGTS12019() { var consoleReader = new ConsoleReaderForTests("MNGT", "1", 2019, "5940"); var nuStarDataScraper = new NuStarDataScraper(); nuStarDataScraper.GetDataFromNuStarWebsite(consoleReader, new SaveFilePathMakerForTests()); var filePathConstructor = new FilePathConstructorForTests(); var tableComparer = new WorksheetTableComparerForTests( filePathConstructor.ConstructExcelFilePath("TestExcelFiles", "GetDataFromNuStarWebsiteTest_MNGTS12019"), filePathConstructor.ConstructExcelFilePath("OUTPUTFORTEST", "2019-1-5940-MNGT"), "2019-1-5940-MNGT"); tableComparer.Compare(); }
public void GeneratePathwaysForListOfStudentsFromEnrollmentData(ConsoleReaderForTests consoleReader) { var pathwayMakerTool = new PathwayMakerTool(); pathwayMakerTool.MakePathways(consoleReader); var tableComparer = new WorksheetTableComparerForTests(consoleReader.GetTestFilePath(), consoleReader.GetNewSaveFilePath(), consoleReader.GetWorksheetName()); tableComparer.Compare(); //var rowCount = 2; //while (rowCount <= (testFile as Worksheet).UsedRange.Rows.Count) //{ // var colCount = 2; // while (colCount <= (testFile as Worksheet).UsedRange.Columns.Count) // { // Assert.AreEqual((((testFile as Worksheet).Cells[rowCount, colCount] as Range).Value as string)?.Trim(), // (((outputFile as Worksheet).Cells[rowCount, colCount] as Range).Value as string)?.Trim(), // String.Format("Pathways didn't match. Student: {0} Semester {1}, {2}", // ((testFile as Worksheet).Cells[rowCount, 1] as Range).Value.ToString(), // ((testFile as Worksheet).Cells[2, colCount] as Range).Value.ToString(), // ((testFile as Worksheet).Cells[1, colCount] as Range).Value.ToString())); // colCount++; // } // rowCount++; //} //} //catch (Exception ex) //{ // outputWorkbook.Close(); // app.Quit(); // System.Runtime.InteropServices.Marshal.ReleaseComObject(outputFile); // System.Runtime.InteropServices.Marshal.ReleaseComObject(outputWorkbook); // System.IO.File.Delete(consoleReader.GetNewSaveFilePath()); // throw; //} }