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