private void UpdateLastGameToolStripMenuItem_Click(object sender, EventArgs e)
{
List <List <string> > lastGameData;
string location;
FrmStatistics Statistics = new FrmStatistics(frmSettings);
lastGameData = Statistics.GetLastGameData();
while (lastGameData.Count < 14)
{
lastGameData.Add(new List <string>()
{
"", "", "", "", "", "", ""
});
}
location = lastGameData[0][1];
UpdateGoogleSpreadsheetCell("1pgtVGwY1ba3BxL5p5HwS_aYpDj1Go_Y1UPgam9S57Ac", "'" + location.ToUpper() + " Last Game'!C3", lastGameData[0][0]);
lastGameData.Remove(lastGameData.First());
UpdateGoogleSpreadsheetCellRange("1pgtVGwY1ba3BxL5p5HwS_aYpDj1Go_Y1UPgam9S57Ac", "'" + location.ToUpper() + " Last Game'!C7:I20", lastGameData);
MessageBox.Show("Last Game stats have been updated.");
}
private void UpdateSeasonStats()
{
List <List <string> > leagueData;
FrmStatistics Statistics = new FrmStatistics(frmSettings);
leagueData = Statistics.GetLeagueData();
//MessageBox.Show(settings[Settings.Default.IniSection]["GameLocation"].ToUpper());
UpdateGoogleSpreadsheetCellRange("1pgtVGwY1ba3BxL5p5HwS_aYpDj1Go_Y1UPgam9S57Ac", "'" + settings[Settings.Default.IniSection]["GameLocation"].ToUpper() + " Seasons'!C5:P8", leagueData);
}
private void StatsToolStripMenuItem_Click(object sender, EventArgs e)
{
string resultsPath = Environment.ExpandEnvironmentVariables(settings[Settings.Default.IniSection]["ResultsFolder"]);
if (!Directory.Exists(resultsPath))
{
MessageBox.Show("Please go to settings and set a results folder location.");
}
else if (IsDirectoryEmpty(resultsPath))
{
MessageBox.Show("Chosen results folder is empty. Go to settings and select a different results folder.");
}
else
{
FrmStatistics Statistics = new FrmStatistics(frmSettings);
Statistics.Show();
}
}
