public WithdrawTeams(string databaseFileName)
{
m_databaseFileName = databaseFileName;
m_tableName = Constants.TableName.EventNames;
InitializeComponent();
withdrawTeamsDataGridView.DataSource = AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, m_tableName);
}
private void loadTeams(string eventName)
{
DataTable table = AccessDatabaseUtilities.loadDatabaseToTable(Constants.getEventScoresFileName(eventName), Constants.TableName.EventNames);
m_dataViews[eventName] = new DataView(table);
m_dataViews[eventName].Sort = "Rank ASC, Tiebreaker_Score ASC";
}
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 reloadNumberOfSessionsButton_Click(object sender, EventArgs e)
{
if (Utilities.confirmReload(Constants.TableName.KnockoutSessions))
{
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutSessions);
Utilities.showBalloonNotification("Reload Completed", Constants.TableName.KnockoutSessions + " reloaded from database successfully");
}
}
private void reloadKnockoutScoresButton_Click(object sender, EventArgs e)
{
if (Utilities.confirmReload("Knockout Scores"))
{
int roundNumber = knockoutRoundsCombobox.SelectedIndex + 1;
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
}
}
private void reloadWithdrawTeamsButton_Click(object sender, EventArgs e)
{
if (Utilities.confirmReload(Constants.TableName.EventNames))
{
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, m_tableName);
Utilities.showBalloonNotification("Reload Completed", m_tableName + " reloaded from database successfully");
}
}
private void assignLeftTeams()
{
if (!createMatch(m_drawRoundNumber, 1, m_numberOfMatchesLeft, m_assigned, m_teamNumber))
{
MessageBox.Show("Unable to generate random draw for round : " + m_drawRoundNumber + Environment.NewLine + "Please generate by hand and enter directly.", "Random Draw Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.EventScores);
}
}
private void reloadScoresButton_Click(object sender, EventArgs e)
{
if (Utilities.confirmReload(Constants.KnockoutScoresFileName))
{
int roundNumber = knockoutRoundsCombobox.SelectedIndex + 1;
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + roundNumber);
Utilities.showBalloonNotification("Reloaded " + Constants.KnockoutScoresFileName + " from database successfully", "Reload Done");
}
}
private void initialize()
{
m_tourneyInfoFileName = Constants.getCurrentTourneyInformationFileName();
m_tourneyEventsFileName = Constants.getCurrentTourneyEventsFileName();
m_tourneyName = NiniUtilities.getStringValue(m_tourneyInfoFileName, Constants.TourneyNameFieldName);
this.Text = "Tourney Name : " + m_tourneyName;
m_tourneyInfo = new TourneyInfo(Constants.getCurrentTourneyInformationFileName(), false);
this.tourneyInfoPropertyGrid.SelectedObject = m_tourneyInfo;
m_eventsTable = AccessDatabaseUtilities.loadDatabaseToTable(m_tourneyEventsFileName, Constants.TableName.TourneyEvents);
loadEvents();
}
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 void load()
{
NiniUtilities.loadNiniConfig(m_niniFileName);
numberOfTeams = NiniUtilities.getIntValue(m_niniFileName, Constants.NumberOfTeamsFieldName);
numberOfRounds = NiniUtilities.getIntValue(m_niniFileName, Constants.NumberOfRoundsFieldName);
DataTable table = AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutSessions);
foreach (DataRow dRow in table.Rows)
{
int roundNumber = (int)dRow["Round_Number"];
int numberOfSessions = (int)dRow["Number_Of_Sessions"];
m_oldNumberOfSessions[roundNumber] = numberOfSessions;
}
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutTeams);
for (int i = 1; i <= numberOfRounds; i++)
{
AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, Constants.TableName.KnockoutScores + "_" + i);
}
}
private DataTable loadTable(string tableName, string query = "")
{
return(AccessDatabaseUtilities.loadDatabaseToTable(m_databaseFileName, tableName, query));
}
