//Getting the number of rows in the table
public int CountRowsInDatabase()
{
var numberOfRows = 0;
try
{
var mySqlConnectionString = MySQLMethods.MakeMySqlConnectionString();
var conn = new MySqlConnection {
ConnectionString = mySqlConnectionString
};
using (var cmd = new MySqlCommand("SELECT COUNT(*) FROM " + Program.selectedEventName, conn))
{
conn.Open();
numberOfRows = int.Parse(cmd.ExecuteScalar().ToString());
conn.Close();
return(numberOfRows);
}
}
catch (MySqlException ex)
{
ConsoleWindow.WriteLine("Error Code: " + ex.ErrorCode);
ConsoleWindow.WriteLine(ex.Message);
}
return(numberOfRows);
}
private void testConnectionToDatabaseButton_Click(object sender, EventArgs e)
{
try
{
string mySqlConnectionString = MySQLMethods.MakeMySqlConnectionString();
var conn = new MySqlConnection {
ConnectionString = mySqlConnectionString
};
conn.Open();
if (conn.Ping())
{
Console.WriteLine("You have successfully connected to your database!");
ConsoleWindow.WriteLine("You have successfully connected to your database!");
connectionDisplay.BackColor = Color.Chartreuse;
connectionDisplay.Text = ("Successfully Connected to Database.");
try
{
MySQLMethods.InitializeDatabases();
}
catch (Exception exception)
{
Console.WriteLine("Error Message: " + exception.Message);
ConsoleWindow.WriteLine("Error Message: " + exception.Message);
}
}
else
{
Console.WriteLine("You have unsuccessfully connected to your database!");
ConsoleWindow.WriteLine("You have unsuccessfully connected to your database!");
connectionDisplay.BackColor = Color.Red;
connectionDisplay.Text = ("Connection to Database Failed.");
}
conn.Close();
}
catch (MySqlException ex)
{
connectionDisplay.BackColor = Color.Red;
connectionDisplay.Text = ("Connection to Database Failed.");
Console.WriteLine("Error Code: " + ex.ErrorCode);
Console.WriteLine("Error Message " + ex.Message);
ConsoleWindow.WriteLine("Error Code: " + ex.ErrorCode);
ConsoleWindow.WriteLine("Error Message " + ex.Message);
}
}
private void submitDataButton_Click(object sender, EventArgs e)
{
UpdateLabels();
if (Settings.Default.allowExportToTextFile)
{
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
var writer = new StreamWriter(saveFileDialog.FileName);
writer.WriteLine("Time Created: " + Time.GetCurrentTime());
writer.WriteLine("FRC_Scouting_V2 Match #: " + Convert.ToString(matchNumber));
writer.WriteLine("Did the robot die?: " + didRobotDie);
writer.WriteLine("===============================================");
writer.WriteLine("Team Name: " + Convert.ToString(Program.selectedTeamName));
writer.WriteLine("Team Number: " + Convert.ToString(Program.selectedTeamNumber));
writer.WriteLine("Team Color During Match: " + teamColour);
writer.WriteLine("===============================================");
writer.WriteLine();
writer.WriteLine("Points Scored");
writer.WriteLine("Auto High Tally: " + Convert.ToString(autoHighTally));
writer.WriteLine("Auto Low Tally: " + Convert.ToString(autoLowTally));
writer.WriteLine("Manually Controlled High Tally: " + Convert.ToString(controlledHighTally));
writer.WriteLine("Manually Controlled Low Tally: " + Convert.ToString(controlledLowTally));
writer.WriteLine("Hot Goals Scored: " + Convert.ToString(hotGoalTally));
writer.WriteLine("===============================================");
writer.WriteLine("Ball Control");
writer.WriteLine("Autonomous Ball Pickups: " + Convert.ToString(autoPickupTally));
writer.WriteLine("Controlled Ball Pickups: " + Convert.ToString(controlledPickupTally));
writer.WriteLine("Missed Pickups/Loads: " + Convert.ToString(missedPickupsTally));
writer.WriteLine("===============================================");
writer.WriteLine("Comments");
writer.WriteLine(Convert.ToString(comments));
writer.WriteLine("===============================================");
writer.WriteLine("Starting Location");
writer.WriteLine("X Starting Location: " + Convert.ToString(xStarting));
writer.WriteLine("Y Starting Location: " + Convert.ToString(yStarting));
writer.WriteLine("===============================================");
writer.WriteLine("END OF FILE");
writer.Close();
}
}
//MySQL Database
//MySQL Database Connection Info
var mySqlConnectionString = MySQLMethods.MakeMySqlConnectionString();
try
{
//Creating the connection to the database and opening the connection
var conn = new MySqlConnection {
ConnectionString = mySqlConnectionString
};
conn.Open();
//Checking if the connection is successful
if (conn.Ping())
{
ConsoleWindow.WriteLine("The connection to your database has been made successfully.");
}
//Creating the MySQLCommand object
var cmd = conn.CreateCommand();
//Trying to create the table
try
{
var createTable =
string.Format(
"CREATE TABLE `{0}` (`EntryID` int(11) NOT NULL,`TeamName` varchar(45) NOT NULL DEFAULT 'Default', `TeamNumber` int(11) NOT NULL DEFAULT '0',`TeamColour` varchar(45) NOT NULL DEFAULT 'Default',`MatchNumber` int(11) NOT NULL DEFAULT '0',`AutoHighTally` int(11) NOT NULL DEFAULT '0',`AutoLowTally` int(11) NOT NULL DEFAULT '0',`ControlledHighTally` int(11) NOT NULL DEFAULT '0',`ControlledLowTally` int(11) NOT NULL DEFAULT '0',`HotGoalTally` int(11) NOT NULL DEFAULT '0',`AutoPickup` int(11) NOT NULL DEFAULT '0',`ControlledPickup` int(11) NOT NULL DEFAULT '0',`MissedPickups` int(11) NOT NULL DEFAULT '0',`StartingLocationX` int(11) NOT NULL DEFAULT '0',`StartingLocationY` int(11) NOT NULL DEFAULT '0',`Comments` varchar(45) DEFAULT 'No Comment',`DidRobotDie` tinyint(4) NOT NULL DEFAULT '0',PRIMARY KEY (`EntryID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8",
Program.selectedEventName);
cmd.CommandText = createTable;
cmd.ExecuteNonQuery();
ConsoleWindow.WriteLine("The table: " + Program.selectedEventName + " has been created.");
//end of creating the table
}
catch (MySqlException createException)
{
ConsoleWindow.WriteLine("If there is an error it is most likely because the table is already made.");
ConsoleWindow.WriteLine("Errorcode: " + createException.ErrorCode);
ConsoleWindow.WriteLine(createException.Message);
}
//Submit data into the database
var insertDataString =
string.Format(
"Insert into {0} (EntryID,TeamName,TeamNumber,TeamColour,MatchNumber,AutoHighTally,AutoLowTally,ControlledHigHTally,ControlledLowTally,HotGoalTally,AutoPickup,ControlledPickup,MissedPickups,StartingLocationX,StartingLocationY,Comments,DidRobotDie) values('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}');",
Program.selectedEventName, CountRowsInDatabase() + 1,
Program.selectedTeamName,
Program.selectedTeamNumber, teamColour, matchNumber, autoHighTally, autoLowTally,
controlledHighTally, controlledLowTally, hotGoalTally, autoPickupTally, controlledPickupTally,
missedPickupsTally, xStarting, yStarting, comments, didRobotDieINT);
cmd.CommandText = insertDataString;
cmd.ExecuteNonQuery();
ConsoleWindow.WriteLine("Data has been inserted into the database!");
contextDisplayLabel.Text = "Your data has been inserted into the database!";
//Closing the connection
conn.Close();
cmd.Dispose();
}
catch (MySqlException ex)
{
contextDisplayLabel.Text = "An error has occured!";
ConsoleWindow.WriteLine("Error Code: " + ex.ErrorCode);
ConsoleWindow.WriteLine(ex.Message);
}
}
private void initializeDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
{
MySQLMethods.InitializeDatabases();
}
private void MainSettings_Load(object sender, EventArgs e)
{
if (Settings.Default.clickToEmptyTextBoxes)
{
clickEmptyTextBoxChecker.Checked = true;
}
else
{
if (Settings.Default.clickToEmptyTextBoxes == false)
{
clickEmptyTextBoxChecker.Checked = false;
}
}
if (Settings.Default.minimizeHomeWentEventLoads)
{
minimizeHomeCheckbox.Checked = true;
}
else
{
if (Settings.Default.minimizeHomeWentEventLoads == false)
{
minimizeHomeCheckbox.Checked = false;
}
}
if (Settings.Default.clearConsoleOnToggle)
{
clearConsoleOnToggleCheckBox.Checked = true;
}
else
{
if (Settings.Default.clearConsoleOnToggle == false)
{
clearConsoleOnToggleCheckBox.Checked = false;
}
}
if (Settings.Default.allowExportToTextFile)
{
allowExportToTextFileCheckBox.Checked = true;
}
else
{
if (Settings.Default.allowExportToTextFile == false)
{
allowExportToTextFileCheckBox.Checked = false;
}
}
if (Settings.Default.showQuestionButtons)
{
showQuestionButtonsCheckBox.Checked = true;
}
else
{
if (Settings.Default.showQuestionButtons == false)
{
showQuestionButtonsCheckBox.Checked = false;
}
}
if (Settings.Default.colourTeamComparisonStatistics)
{
colourTeamComparisonStatisticsCheckBox.Checked = true;
}
else
{
if (Settings.Default.colourTeamComparisonStatistics == false)
{
colourTeamComparisonStatisticsCheckBox.Checked = false;
}
}
teamComparisonEqualValueColourDisplay.BackColor = Settings.Default.teamComparisonEqualValueColour;
usernameTextBox.Text = Settings.Default.username;
databaseIPTextBox.Text = Settings.Default.databaseIP;
databasePortTextBox.Text = Settings.Default.databasePort;
databaseUsernameTextBox.Text = Settings.Default.databaseUsername;
databasePasswordTextBox.Text = Security.DeCryptString(Settings.Default.databasePassword);
databaseNameTextBox.Text = Settings.Default.databaseName;
try
{
string mySqlConnectionString = MySQLMethods.MakeMySqlConnectionString();
var conn = new MySqlConnection {
ConnectionString = mySqlConnectionString
};
conn.Open();
if (conn.Ping())
{
Console.WriteLine("You have successfully connected to your database!");
ConsoleWindow.WriteLine("You have successfully connected to your database!");
connectionDisplay.BackColor = Color.Chartreuse;
connectionDisplay.Text = ("Successfully Connected to Database.");
}
else
{
Console.WriteLine("You have unsuccessfully connected to your database!");
ConsoleWindow.WriteLine("You have unsuccessfully connected to your database!");
connectionDisplay.BackColor = Color.Red;
connectionDisplay.Text = ("Connection to Database Failed.");
}
conn.Close();
}
catch (MySqlException ex)
{
connectionDisplay.BackColor = Color.Red;
connectionDisplay.Text = ("Connection to Database Failed.");
Console.WriteLine("Error Code: " + ex.ErrorCode);
Console.WriteLine("Error Message " + ex.Message);
ConsoleWindow.WriteLine("Error Code: " + ex.ErrorCode);
ConsoleWindow.WriteLine("Error Message " + ex.Message);
}
}
