List <DataScraperInput> GetInputFromUser(IConsoleReader consoleReader)
{
Console.WriteLine("Info For Search Result...");
var subjectArea = consoleReader.GetSubjectArea();
var startYear = consoleReader.GetStartYear();
var endYear = consoleReader.GetEndYear();
var dataScraperInput = new List <DataScraperInput>();
while (startYear <= endYear)
{
dataScraperInput.Add(new DataScraperInput(startYear, subjectArea, 1));
dataScraperInput.Add(new DataScraperInput(startYear, subjectArea, 2));
startYear++;
}
return(dataScraperInput);
}
public void MakePathways(IConsoleReader consoleReader)
{
var dataFilePath = consoleReader.GetInputFilePath();
var startYear = consoleReader.GetStartYear();
var endYear = consoleReader.GetEndYear();
var campus = consoleReader.GetWorksheetName();
var pathwayFilePath = consoleReader.GetNewSaveFilePath();
var excelHandler = new ExcelHandler(dataFilePath, campus, pathwayFilePath);
excelHandler.SetUpPathwayFile(startYear, endYear);
excelHandler.SearchSpreadsheetForStudentEnrollments();
excelHandler.GeneratePathwaysFromStudentData(endYear - startYear + 1);
Console.WriteLine("Saving {0}", pathwayFilePath);
excelHandler.SavePathwayFile();
excelHandler.QuitApp();
Console.WriteLine("COMPLETE");
}
