private void AddScrollBarContent()
{
EventInfo lastEventWithScores = DatabaseFunctions.GetMostRecentEventWithScoresPosted(leagueID.ToString());
if (lastEventWithScores.EventID == 0)
{
return;
}
Scoring.EventStats eventStats = Scoring.GetEventResults(leagueID, lastEventWithScores.EventID, null);
Dictionary <int, Golfer> golfers = DatabaseFunctions.GetGolfersInfo(leagueID.ToString());
Dictionary <int, string> teams = DatabaseFunctions.GetTeamNames(leagueID);
ScrollLabel1.Text += "Last Event: " + lastEventWithScores.EventName + " (" + lastEventWithScores.Date + "): ";
var items = from pair in eventStats.grossScores
orderby pair.Value ascending
select pair;
ScrollLabel1.Text += " Scores: ";
foreach (KeyValuePair <int, int> pair in items)
{
ScrollLabel1.Text += golfers[pair.Key].firstName + " " + golfers[pair.Key].lastName + " - " + pair.Value.ToString() + " |";
//AddTableRowLeaderboard(Table_GrossScoreLeaderboard, DatabaseFunctions.GetGolferName(pair.Key), (decimal)pair.Value);
}
items = from pair in eventStats.netScores
orderby pair.Value ascending
select pair;
ScrollLabel1.Text += "|^|Net Scores: ";
foreach (KeyValuePair <int, int> pair in items)
{
ScrollLabel1.Text += golfers[pair.Key].firstName + " " + golfers[pair.Key].lastName + " - " + pair.Value.ToString() + " |";
//AddTableRowLeaderboard(Table_NetScoreLeaderboard, DatabaseFunctions.GetGolferName(pair.Key), (decimal)pair.Value);
}
var items2 = from pair in eventStats.teamPts
orderby pair.Value descending
select pair;
ScrollLabel1.Text += "|^|Team Scores: ";
foreach (KeyValuePair <int, decimal> pair in items2)
{
ScrollLabel1.Text += teams[pair.Key] + " " + pair.Value.ToString() + " |";
//AddTableRowLeaderboard(Table_TeamPts, teamNames[pair.Key], pair.Value);
}
}
private void DisplayWeeklyLeaderboard()
{
int selectedEventID = int.Parse(Dropdown_LeagueEvent.SelectedValue);
if (selectedEventID != 0)
{
Scoring.EventStats eventStats = Scoring.GetEventResults(leagueID, selectedEventID, null);
Dictionary <int, string> teamNames = DatabaseFunctions.GetTeamNames(leagueID);
//Clear Tables and Add Title Rows
Table_GrossScoreLeaderboard.Rows.Clear();
Table_NetScoreLeaderboard.Rows.Clear();
Table_TeamPts.Rows.Clear();
AddLeaderboardTitleRow(Table_GrossScoreLeaderboard, "Gross Score");
AddLeaderboardTitleRow(Table_NetScoreLeaderboard, "Net Score");
AddLeaderboardTitleRow(Table_TeamPts, "Team Points");
var items = from pair in eventStats.grossScores
orderby pair.Value ascending
select pair;
foreach (KeyValuePair <int, int> pair in items)
{
AddTableRowLeaderboard(Table_GrossScoreLeaderboard, DatabaseFunctions.GetGolferName(pair.Key), (decimal)pair.Value);
}
items = from pair in eventStats.netScores
orderby pair.Value ascending
select pair;
foreach (KeyValuePair <int, int> pair in items)
{
AddTableRowLeaderboard(Table_NetScoreLeaderboard, DatabaseFunctions.GetGolferName(pair.Key), (decimal)pair.Value);
}
var items2 = from pair in eventStats.teamPts
orderby pair.Value descending
select pair;
foreach (KeyValuePair <int, decimal> pair in items2)
{
AddTableRowLeaderboard(Table_TeamPts, teamNames[pair.Key], pair.Value);
}
}
}