private static void createSwissLeagueDatabases(string eventName, int numberOfTeams, int numberOfRounds)
{
AccessDatabaseUtilities.createDatabase(m_databaseFileName);
createSwissLeagueTeamsTable();
createSwissLeagueScoresTable();
createSwissLeagueComputedScoresTable(numberOfRounds);
}
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 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);
}
}
public KnockoutSessions(PropertyGrid grid, string eventName, string niniFileName, string databaseFileName, bool autoSave = false)
{
m_grid = grid;
if (m_grid != null)
{
m_grid.SelectedObject = this;
}
m_eventName = eventName;
m_autoSave = autoSave;
m_niniFileName = niniFileName;
m_databaseFileName = databaseFileName;
if (!File.Exists(m_niniFileName))
{
create();
}
if (!File.Exists(m_databaseFileName))
{
AccessDatabaseUtilities.createDatabase(m_databaseFileName);
createTeamsTable();
createSessionsTable();
}
load();
}
