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