private static void populateNamesTable()
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.EventNames);
DataTable computedScoresTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.EventComputedScores);
DataTable existingTable = m_dataSet.Tables["Names"];
foreach (DataRow existingRow in existingTable.Rows)
{
DataRow dRow = table.NewRow();
dRow["Team_Number"] = AccessDatabaseUtilities.getIntValue(existingRow, "Number");
dRow["Team_Name"] = getStringValue(existingRow, "Team Name");
dRow["Member_Names"] = getStringValue(existingRow, "Member 1 Name") + ", " +
getStringValue(existingRow, "Member 2 Name") + ", " +
getStringValue(existingRow, "Member 3 Name") + ", " +
getStringValue(existingRow, "Member 4 Name") + ", " +
getStringValue(existingRow, "Member 5 Name") + ", " +
getStringValue(existingRow, "Member 6 Name");
table.Rows.Add(dRow);
dRow = computedScoresTable.NewRow();
dRow["Team_Number"] = AccessDatabaseUtilities.getIntValue(existingRow, "Number");
computedScoresTable.Rows.Add(dRow);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.EventNames);
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.EventComputedScores);
}
private void setUpMatches(int roundNumber)
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
// Overwrite existing team numbers to avoid unique value errors
int count = -1;
foreach (DataRow dRow in table.Rows)
{
dRow["Team_Number"] = count--;
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
DataTable previousTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + (roundNumber + 1));
int matchNumber = 1;
foreach (DataRow dRow in table.Rows)
{
DataRow[] dRows = previousTable.Select("Match_Number = " + matchNumber);
DataRow winnerRow = findWinner(dRows);
dRow["Team_Number"] = AccessDatabaseUtilities.getIntValue(winnerRow, "Team_Number");
dRow["Team_Name"] = AccessDatabaseUtilities.getStringValue(winnerRow, "Team_Name");
matchNumber++;
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
knockoutRoundsCombobox.SelectedIndex = roundNumber - 1;
}
private void populateKnockoutTables()
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutTeams);
int count = 0;
foreach (string eventName in m_selectedEventNames)
{
for (int i = 0; i < m_dataViews[eventName].Count; ++i)
{
if (m_selectedTeams[m_currentTabNumber][eventName][i])
{
DataRow dRow = m_dataViews[eventName][i].Row;
int originalTeamNumber = AccessDatabaseUtilities.getIntValue(dRow, "Team_Number");
string teamName = AccessDatabaseUtilities.getStringValue(dRow, "Team_Name");
string memberNames = AccessDatabaseUtilities.getStringValue(dRow, "Member_Names");
int teamNumber = count + 1;
DataRow newRow = table.Rows[count];
newRow["Team_Number"] = teamNumber;
newRow["Team_Name"] = teamName;
newRow["Member_Names"] = memberNames;
newRow["Original_Team_Number"] = originalTeamNumber;
newRow["Original_Event_Name"] = eventName;
count++;
}
}
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutTeams);
}
public void updateSessions()
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutSessions);
foreach (DataRow dRow in table.Rows)
{
List <string> removeColumns = null;
int roundNumber = (int)dRow["Round_Number"];
int numberOfSessions = (int)dRow["Number_Of_Sessions"];
if (numberOfSessions > m_oldNumberOfSessions[roundNumber])
{
List <DatabaseField> fields = new List <DatabaseField>();
for (int i = m_oldNumberOfSessions[roundNumber] + 1; i <= numberOfSessions; ++i)
{
fields.Add(new DatabaseField("Session_" + i + "_Score", "NUMBER"));
}
AccessDatabaseUtilities.addColumn(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber, fields);
}
else if (m_oldNumberOfSessions[roundNumber] > numberOfSessions)
{
removeColumns = new List <string>();
List <DatabaseField> fields = new List <DatabaseField>();
for (int i = numberOfSessions + 1; i <= m_oldNumberOfSessions[roundNumber]; ++i)
{
fields.Add(new DatabaseField("Session_" + i + "_Score", "NUMBER"));
removeColumns.Add("Session_" + i + "_Score");
}
AccessDatabaseUtilities.dropColumn(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber, fields);
}
m_oldNumberOfSessions[roundNumber] = numberOfSessions;
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber, "", removeColumns);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutSessions);
}
private void saveKnockoutScoresButton_Click(object sender, EventArgs e)
{
int roundNumber = knockoutRoundsCombobox.SelectedIndex + 1;
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
DataTable sessionsTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutSessions);
DataRow dRow = sessionsTable.Rows.Find(roundNumber);
int numberOfSessions = (int)dRow["Number_Of_Sessions"];
checkRoundCompletion(roundNumber, numberOfSessions);
}
private void saveScoresButton_Click(object sender, EventArgs e)
{
int roundNumber = knockoutRoundsCombobox.SelectedIndex + 1;
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
Utilities.showBalloonNotification("Saved " + Constants.KnockoutScoresFileName + " to database successfully", "Save Done");
KnockoutTeamsDatabaseToWebpages ktdw = new KnockoutTeamsDatabaseToWebpages(m_eventName, m_databaseFileName, Constants.getEventWebpagesFolder(m_eventName));
ktdw.createWebpages_();
showUrl();
}
private void populateSwissLeagueTables(int numberOfRounds, int numberOfTeams)
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.EventNames);
int count = 1;
DataTable computedScoresTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.EventComputedScores);
foreach (string eventName in m_selectedEventNames)
{
for (int i = 0; i < m_dataViews[eventName].Count; ++i)
{
if (m_selectedTeams[m_currentTabNumber][eventName][i])
{
DataRow dRow = m_dataViews[eventName][i].Row;
int originalTeamNumber = AccessDatabaseUtilities.getIntValue(dRow, "Team_Number");
string teamName = AccessDatabaseUtilities.getStringValue(dRow, "Team_Name");
string memberNames = AccessDatabaseUtilities.getStringValue(dRow, "Member_Names");
double totalScore = AccessDatabaseUtilities.getDoubleValue(dRow, "Total_Score");
int teamNumber = count;
DataRow newRow = table.NewRow();
newRow["Team_Number"] = keepOriginalTeamNumbersCheckbox.Checked?originalTeamNumber:teamNumber;
newRow["Team_Name"] = teamName;
newRow["Member_Names"] = memberNames;
newRow["Carryover"] = carryoverTotalCheckbox.Checked ? totalScore : 0;
newRow["Original_Team_Number"] = originalTeamNumber;
newRow["Original_Event_Name"] = eventName;
newRow["Total_Score"] = 0;
newRow["Tiebreaker_Score"] = 0;
newRow["Rank"] = 1;
table.Rows.Add(newRow);
newRow = computedScoresTable.NewRow();
newRow["Team_Number"] = keepOriginalTeamNumbersCheckbox.Checked ? originalTeamNumber : teamNumber;
computedScoresTable.Rows.Add(newRow);
count++;
}
}
DataTable scoresTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.EventScores);
int numberOfMatches = (numberOfTeams / 2) + numberOfTeams % 2;
for (int i = 1; i <= numberOfRounds; ++i)
{
for (int j = 1; j <= numberOfMatches; ++j)
{
DataRow dRow = scoresTable.NewRow();
dRow["Table_Number"] = j;
dRow["Round_Number"] = i;
scoresTable.Rows.Add(dRow);
}
}
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.EventNames);
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.EventScores);
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.EventComputedScores);
}
public void update()
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutSessions);
DataTable teamsTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutTeams);
if (numberOfRounds > oldNumberOfRounds)
{
for (int i = oldNumberOfRounds + 1; i <= numberOfRounds; ++i)
{
DataRow dRow = table.NewRow();
string sessionName = (Constants.KnockoutSessionNames.Length >= i ? Constants.KnockoutSessionNames[i - 1] : "Round_of_" + Math.Pow(2, i));
dRow["Round_Number"] = i;
dRow["Round_Name"] = sessionName;
dRow["Number_Of_Sessions"] = 3;
table.Rows.Add(dRow);
createRoundScoresTable(i);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutSessions);
for (int i = oldNumberOfTeams + 1; i <= numberOfTeams; ++i)
{
DataRow dRow = teamsTable.NewRow();
string sessionName = (Constants.KnockoutSessionNames.Length >= i ? Constants.KnockoutSessionNames[i - 1] : "Round_of_" + Math.Pow(2, i));
dRow["Team_Number"] = i;
dRow["Team_Name"] = "Team " + i;
teamsTable.Rows.Add(dRow);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutTeams);
}
else if (numberOfRounds < oldNumberOfRounds)
{
for (int i = numberOfRounds + 1; i <= oldNumberOfRounds; ++i)
{
table.Rows.Find(i).Delete();
AccessDatabaseUtilities.dropTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + i);
m_oldNumberOfSessions.Remove(i);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutSessions);
for (int i = numberOfTeams + 1; i <= oldNumberOfTeams; ++i)
{
teamsTable.Rows.Find(i).Delete();
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutTeams);
}
oldNumberOfRounds = numberOfRounds;
oldNumberOfTeams = numberOfTeams;
}
private void createRoundScoresTable(int roundNumber)
{
List <DatabaseField> fields = new List <DatabaseField>();
fields.Add(new DatabaseField("Match_Number", "INTEGER"));
fields.Add(new DatabaseField("Team_Number", "INTEGER"));
fields.Add(new DatabaseField("Team_Name", "TEXT", 255));
fields.Add(new DatabaseField("Carryover", "NUMBER"));
fields.Add(new DatabaseField("Total", "NUMBER"));
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutSessions);
DataRow dRow = table.Rows.Find(roundNumber);
int numberOfSessions = (int)dRow["Number_Of_Sessions"];
m_oldNumberOfSessions[roundNumber] = numberOfSessions;
for (int i = 1; i <= numberOfSessions; ++i)
{
fields.Add(new DatabaseField("Session_" + i + "_Score", "NUMBER"));
}
List <string> primaryKeys = new List <string>();
primaryKeys.Add("Match_Number");
primaryKeys.Add("Team_Number");
DataTable scoresTable = AccessDatabaseUtilities.createTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber, fields, primaryKeys);
int numberOfMatches = Convert.ToInt32(Math.Pow(2, roundNumber - 1));
for (int i = 1; i <= numberOfMatches; ++i)
{
DataRow dScoresRow = scoresTable.NewRow();
dScoresRow["Match_Number"] = i;
int teamNumber = i;
dScoresRow["Team_Number"] = i;
dScoresRow["Team_Name"] = LocalUtilities.getTeamName(m_databaseFileName, Constants.TableName.KnockoutTeams, i);
scoresTable.Rows.Add(dScoresRow);
dScoresRow = scoresTable.NewRow();
dScoresRow["Match_Number"] = i;
teamNumber = 2 * numberOfMatches - (i - 1);
dScoresRow["Team_Number"] = teamNumber;
dScoresRow["Team_Name"] = LocalUtilities.getTeamName(m_databaseFileName, Constants.TableName.KnockoutTeams, teamNumber);
scoresTable.Rows.Add(dScoresRow);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
}
private static void populateScoresTable()
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.EventScores);
DataTable existingTable = m_dataSet.Tables["Scores"];
foreach (DataRow existingRow in existingTable.Rows)
{
DataRow dRow = table.NewRow();
dRow["Round_Number"] = AccessDatabaseUtilities.getIntValue(existingRow, "Round Number");
dRow["Table_Number"] = AccessDatabaseUtilities.getIntValue(existingRow, "Table Number");
dRow["Team_1_Number"] = AccessDatabaseUtilities.getIntValue(existingRow, "Team 1 Number");
dRow["Team_2_Number"] = AccessDatabaseUtilities.getIntValue(existingRow, "Team 2 Number");
dRow["Team_1_VPs"] = AccessDatabaseUtilities.getDoubleValue(existingRow, "Team 1 VPs");
dRow["Team_2_VPs"] = AccessDatabaseUtilities.getDoubleValue(existingRow, "Team 2 VPs");
dRow["Team_1_VP_Adjustment"] = -1 * AccessDatabaseUtilities.getDoubleValue(existingRow, "Team 1 Adjustment");
dRow["Team_2_VP_Adjustment"] = -1 * AccessDatabaseUtilities.getDoubleValue(existingRow, "Team 2 Adjustment");
table.Rows.Add(dRow);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.EventScores);
}
public void deleteEvent(string eventName)
{
DialogResult result = MessageBox.Show("Are you sure?" + Environment.NewLine + "All information for this event will be deleted", "Confirm Delete", MessageBoxButtons.YesNo);
if (result == DialogResult.No)
{
return;
}
//DataTable table = AccessDatabaseUtilities.getDataTable(m_tourneyEventsFileName, Constants.TableName.TourneyEvents);
DataRow dRow = m_eventsTable.Rows.Find(eventName);
dRow.Delete();
AccessDatabaseUtilities.saveTableToDatabase(m_tourneyEventsFileName, Constants.TableName.TourneyEvents);
if (m_scorers.ContainsKey(eventName) && m_scorers[eventName] != null && !m_scorers[eventName].IsDisposed)
{
m_scorers[eventName].Close();
}
m_scorers[eventName] = null;
m_scorers.Remove(eventName);
Directory.Delete(Constants.getEventDatabasesFolder(eventName), true);
Directory.Delete(Constants.getEventWebpagesFolder(eventName), true);
}
private bool addEvent(string eventName, string eventType)
{
if (string.IsNullOrWhiteSpace(eventName))
{
MessageBox.Show("Event Name cannot be empty!", "Empty Event Name!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
DataTable table = AccessDatabaseUtilities.getDataTable(Constants.getCurrentTourneyEventsFileName(), Constants.TableName.TourneyEvents);
DataRow dRow = table.Rows.Find(eventName);
if (dRow != null)
{
MessageBox.Show("Another event with same name (" + eventName + ") already exists!" + Environment.NewLine + "Either delete the other event first or provide a different event name!", "Duplicate Event Name!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
dRow = table.NewRow();
dRow["Event_Name"] = eventName;
dRow["Event_Type"] = eventType;
table.Rows.Add(dRow);
AccessDatabaseUtilities.saveTableToDatabase(Constants.getCurrentTourneyEventsFileName(), Constants.TableName.TourneyEvents);
return(true);
}
public void initializeMatches()
{
DataTable teamsTable = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutTeams);
for (int i = 1; i <= numberOfRounds; ++i)
{
DataTable table = AccessDatabaseUtilities.getDataTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + i);
int totalTeams = Convert.ToInt32(Math.Pow(2, i));
int numberOfMatches = totalTeams / 2;
for (int j = 1; j <= numberOfMatches; ++j)
{
DataRow team1Row = teamsTable.Rows[j - 1];
DataRow team2Row = teamsTable.Rows[totalTeams - j];
DataRow[] dRows = table.Select("Match_Number = " + j);
Debug.Assert(dRows.Length == 2);
dRows[0]["Team_Number"] = AccessDatabaseUtilities.getIntValue(team1Row, "Team_Number");
dRows[0]["Team_Name"] = AccessDatabaseUtilities.getStringValue(team1Row, "Team_Name");
dRows[1]["Team_Number"] = AccessDatabaseUtilities.getIntValue(team2Row, "Team_Number");
dRows[1]["Team_Name"] = AccessDatabaseUtilities.getStringValue(team2Row, "Team_Name");
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + i);
}
}
private string addEvent(string eventType, string message = "What is the name of the event?")
{
string eventName = Microsoft.VisualBasic.Interaction.InputBox("What is the name of the event?", "Event Name");
if (string.IsNullOrWhiteSpace(eventName))
{
MessageBox.Show("Event Name cannot be empty!", "Empty Event Name!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return("");
}
//DataTable table = AccessDatabaseUtilities.getDataTable(m_tourneyEventsFileName, Constants.TableName.TourneyEvents);
DataRow dRow = m_eventsTable.Rows.Find(eventName);
if (dRow != null)
{
MessageBox.Show("Another event with same name (" + eventName + ") already exists!" + Environment.NewLine + "Either delete the other event first or provide a different event name!", "Duplicate Event Name!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return("");
}
dRow = m_eventsTable.NewRow();
dRow["Event_Name"] = eventName;
dRow["Event_Type"] = eventType;
m_eventsTable.Rows.Add(dRow);
AccessDatabaseUtilities.saveTableToDatabase(m_tourneyEventsFileName, Constants.TableName.TourneyEvents);
return(eventName);
}
private void createSessionsTable()
{
List <DatabaseField> fields = new List <DatabaseField>();
fields.Add(new DatabaseField("Round_Number", "INTEGER"));
fields.Add(new DatabaseField("Round_Name", "TEXT", 255));
fields.Add(new DatabaseField("Number_Of_Sessions", "INTEGER"));
List <string> primaryKeys = new List <string>();
primaryKeys.Add("Round_Number");
DataTable table = AccessDatabaseUtilities.createTable(m_databaseFileName, Constants.TableName.KnockoutSessions, fields, primaryKeys);
for (int i = 1; i <= numberOfRounds; i++)
{
DataRow dRow = table.NewRow();
string sessionName = (Constants.KnockoutSessionNames.Length >= i ? Constants.KnockoutSessionNames[i - 1] : "Round_of_" + Convert.ToInt32(Math.Pow(2, i)));
dRow["Round_Number"] = i;
dRow["Round_Name"] = sessionName;
dRow["Number_Of_Sessions"] = 3;
table.Rows.Add(dRow);
createRoundScoresTable(i);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutSessions);
}
private void createTeamsTable()
{
List <DatabaseField> fields = new List <DatabaseField>();
fields.Add(new DatabaseField("Team_Number", "INTEGER"));
fields.Add(new DatabaseField("Team_Name", "TEXT", 255));
fields.Add(new DatabaseField("Member_Names", "TEXT", 255));
fields.Add(new DatabaseField("Original_Team_Number", "INTEGER"));
fields.Add(new DatabaseField("Original_Event_Name", "TEXT", 255));
List <string> primaryKeys = new List <string>();
primaryKeys.Add("Team_Number");
DataTable table = AccessDatabaseUtilities.createTable(m_databaseFileName, Constants.TableName.KnockoutTeams, fields, primaryKeys);
for (int i = 1; i <= numberOfTeams; i++)
{
DataRow dRow = table.NewRow();
string sessionName = (Constants.KnockoutSessionNames.Length >= i ? Constants.KnockoutSessionNames[i - 1] : "Round_of_" + Math.Pow(2, i));
dRow["Team_Number"] = i;
dRow["Team_Name"] = "Team " + i;
table.Rows.Add(dRow);
}
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutTeams);
}
private void saveTable(string tableName)
{
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, tableName);
}
private void saveNamesButton_Click(object sender, EventArgs e)
{
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, Constants.TableName.KnockoutTeams);
Utilities.showBalloonNotification("Save Completed", Constants.TableName.KnockoutTeams + " saved to Database successfully");
}
private void saveWithdrawTeamsToDatabase_Click(object sender, EventArgs e)
{
AccessDatabaseUtilities.saveTableToDatabase(m_databaseFileName, m_tableName);
Utilities.showBalloonNotification("Save Completed", m_tableName + " saved to Database successfully");
}