private void createSwissLeagueComputedScoresTable(int numberOfRounds) { List <DatabaseField> fields = new List <DatabaseField>(); List <string> primaryKeys = new List <string>(); fields.Add(new DatabaseField("Team_Number", "INTEGER")); primaryKeys.Add("Team_Number"); for (int i = 1; i <= numberOfRounds; ++i) { fields.Add(new DatabaseField("Score_After_Round_" + i, "NUMBER")); fields.Add(new DatabaseField("Rank_After_Round_" + i, "NUMBER")); fields.Add(new DatabaseField("Tiebreaker_After_Round_" + i, "NUMBER")); } AccessDatabaseUtilities.createTable(m_databaseFileName, Constants.TableName.EventComputedScores, fields, primaryKeys); }
private static void createTourneyDatabases() { TourneyInfo m_tourneyInfo = new TourneyInfo(Constants.getCurrentTourneyInformationFileName(), true); m_tourneyInfo.TourneyName = m_tourneyName; string databaseFileName = Constants.getCurrentTourneyEventsFileName(); AccessDatabaseUtilities.createDatabase(databaseFileName); List <DatabaseField> fields = new List <DatabaseField>(); fields.Add(new DatabaseField("Event_Name", "TEXT", 255)); fields.Add(new DatabaseField("Event_Type", "TEXT", 255)); List <string> primaryKeyFields = new List <string>(); primaryKeyFields.Add("Event_Name"); AccessDatabaseUtilities.createTable(databaseFileName, Constants.TableName.TourneyEvents, fields, primaryKeyFields); }
private void createSwissLeagueTeamsTable() { 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("Carryover", "NUMBER")); fields.Add(new DatabaseField("Original_Team_Number", "INTEGER")); fields.Add(new DatabaseField("Original_Event_Name", "TEXT", 255)); fields.Add(new DatabaseField("Total_Score", "NUMBER")); fields.Add(new DatabaseField("Tiebreaker_Score", "NUMBER")); fields.Add(new DatabaseField("Rank", "INTEGER")); List <string> primaryKeys = new List <string>(); primaryKeys.Add("Team_Number"); AccessDatabaseUtilities.createTable(m_databaseFileName, Constants.TableName.EventNames, fields, primaryKeys); }
private void loadTourneyEvents() { string databaseFileName = Constants.getCurrentTourneyEventsFileName(); if (!File.Exists(databaseFileName)) { AccessDatabaseUtilities.createDatabase(databaseFileName); List <DatabaseField> fields = new List <DatabaseField>(); fields.Add(new DatabaseField("Event_Name", "TEXT", 255)); fields.Add(new DatabaseField("Event_Type", "TEXT", 255)); List <string> primaryKeyFields = new List <string>(); primaryKeyFields.Add("Event_Name"); AccessDatabaseUtilities.createTable(databaseFileName, Constants.TableName.TourneyEvents, fields, primaryKeyFields); } else { AccessDatabaseUtilities.loadDatabaseToTable(databaseFileName, Constants.TableName.TourneyEvents); } }
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 void createSwissLeagueScoresTable() { List <DatabaseField> fields = new List <DatabaseField>(); fields.Add(new DatabaseField("Round_Number", "INTEGER")); fields.Add(new DatabaseField("Table_Number", "INTEGER")); fields.Add(new DatabaseField("Team_1_Number", "INTEGER")); fields.Add(new DatabaseField("Team_2_Number", "INTEGER")); fields.Add(new DatabaseField("Team_1_IMPs", "NUMBER")); fields.Add(new DatabaseField("Team_2_IMPs", "NUMBER")); fields.Add(new DatabaseField("Team_1_VPs", "NUMBER")); fields.Add(new DatabaseField("Team_2_VPs", "NUMBER")); fields.Add(new DatabaseField("Team_1_VP_Adjustment", "NUMBER")); fields.Add(new DatabaseField("Team_2_VP_Adjustment", "NUMBER")); List <string> primaryKeys = new List <string>(); primaryKeys.Add("Round_Number"); primaryKeys.Add("Table_Number"); AccessDatabaseUtilities.createTable(m_databaseFileName, Constants.TableName.EventScores, fields, primaryKeys); }
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 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); }