/// <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;
}
