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;
//}
}
static void Main(string[] args)
{
//string provider = ConfigurationManager.AppSettings["provider"];
//string connectionString = ConfigurationManager.AppSettings["connectionString"];
//DbProviderFactory factory = DbProviderFactories.GetFactory(provider);
//using (DbConnection connection = factory.CreateConnection())
//{
// if (connection == null)
// {
// Console.WriteLine("Connection Error");
// Console.ReadLine();
// return;
// }
// connection.ConnectionString = connectionString;
// connection.Open();
// DbCommand command1 = factory.CreateCommand();
// if (command1 == null)
// {
// Console.WriteLine("Command Error");
// Console.ReadLine();
// return;
// }
// command1.Connection = connection;
// command1.CommandText = "Select * From SubjectEnrollments";
// using (DbDataReader dataReader = command1.ExecuteReader())
// {
// while (dataReader.Read())
// {
// Console.WriteLine($"{dataReader["CourseCode"]} " + $"{dataReader["StudentID"]}");
// }
// }
//}
Console.WriteLine(@"Welcome to Jess' pathway generator. This is still in dev, so if it breaks let me know.
Commands:
mp ------ make pathway table from enrollmentdata file
prepfd ------ prepare data for force directed diagram from pathway table
getdata ------ get data from NuStar");
string command;
while ((command = Console.ReadLine()) != "q")
{
if (command.Equals("mp"))
{
var pathwayMaker = new PathwayMakerTool();
pathwayMaker.MakePathways(new ConsoleReader());
}
if (command.Equals("prepfd"))
{
var forceDirectedTableMaker = new ForceDirectedTableMakerTool();
forceDirectedTableMaker.CreateForceDirectedTable(new ConsoleReader());
}
if (command.Equals("getdata"))
{
var nuStarDataScraper = new NuStarDataScraper();
nuStarDataScraper.GetDataFromNuStarWebsite(new ConsoleReader(), new SaveFilePathMaker());
}
}
}