/// <summary> /// Summons the OpenFileDialog to open the excel spreadsheet and loads the latest data entry date /// </summary> private void GetSpreadsheetFileAndMetadata(Object stateInfo) { _spreadsheetFilePath = OpenSpreadsheetFileDialogue(); if (_spreadsheetFilePath == "Please select the WHO Coronavirus Spreadsheet File") { return; } else { _canGetDataFromFile = true; } _parser = new ExcelFileParsingService(_spreadsheetFilePath); LatestDataEntryDate = "Loading Latest Data Entry Date..."; TotalCumulativeCases = "Calculating Total Cases To Date..."; GetLatestDateOnFile_CSV(); GetTotalCasesOnFile_CSV(); _totalDatafileEntries = _parser.GetTotalDataEntriesOnFile(); }
public ModifyDatabase_InputValues(SqlConnectionService sqlService, ExcelFileParsingService parser) { _sqlService = sqlService; _parser = parser; }