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