private void dbConnectCreateTableBtn_Click(object sender, EventArgs e)
{
//test create table "menu"
DBConnection dbConnect;
string queryString = "";
if (radioButtonDatabaseMySql.Checked)
{
dbConnect = new DBConnection_MySQL();
queryString = String.Format("create table menu (id INTEGER AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30), type VARCHAR(20), price VARCHAR(10), modifiedDate datetime);");
}
else
{
dbConnect = new DBConnection_Azure_MsSQL();
queryString = String.Format("create table menu (id INT IDENTITY(1,1) PRIMARY KEY, name VARCHAR(30), type VARCHAR(20), price VARCHAR(10), modifiedDate datetime);");
}
//queryString = $"create table if not exists menu (id INTEGER AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30), type VARCHAR(20), price VARCHAR(10), modifiedDate datetime);";
dbConnect.executeQuery(queryString);
if (dbConnect.IsSuccess())
{
MessageBox.Show("Table Created");
}
else
{
MessageBox.Show(dbConnect.getErrorString());
}
}
private void dbConnectDropTableBtn_Click(object sender, EventArgs e)
{
//test drop table "menu"
DBConnection dbConnect;
if (radioButtonDatabaseMySql.Checked)
{
dbConnect = new DBConnection_MySQL();
}
else
{
dbConnect = new DBConnection_Azure_MsSQL();
}
string queryString = "";
//queryString = $"drop table if exists menu;";
queryString = "drop table menu;";
dbConnect.executeQuery(queryString);
if (dbConnect.IsSuccess())
{
MessageBox.Show("Table Droped");
}
else
{
MessageBox.Show(dbConnect.getErrorString());
}
}
private void dbConnectBtn_Click(object sender, EventArgs e)
{
DBConnection dbConnect;
if (radioButtonDatabaseMySql.Checked)
{
dbConnect = new DBConnection_MySQL();
}
else
{
dbConnect = new DBConnection_Azure_MsSQL();
}
//test connection
if (dbConnect.Connect())
{
//disconnect
if (dbConnect.Disconnect())
{
MessageBox.Show("Connect Test Success.");
}
else
{
MessageBox.Show(dbConnect.getErrorString());
}
}
else
{
MessageBox.Show(dbConnect.getErrorString());
}
}
private void dbConnectInsertBtn_Click(object sender, EventArgs e)
{
//test insert data into table "menu"
DBConnection dbConnect;
string queryString1 = "";
string queryString2 = "";
if (radioButtonDatabaseMySql.Checked)
{
dbConnect = new DBConnection_MySQL();
queryString1 = "INSERT INTO menu (name, type, price, modifiedDate) VALUES('Beef Noodle', 'Noodle', '8.99', NOW());";
queryString2 = "INSERT INTO menu(name, type, price, modifiedDate) VALUES('Fired Chicken Rice', 'Rice', '7.99', NOW());";
}
else
{
dbConnect = new DBConnection_Azure_MsSQL();
queryString1 = "INSERT INTO menu (name, type, price, modifiedDate) VALUES('Beef Noodle', 'Noodle', '8.99', GETDATE());";
queryString2 = "INSERT INTO menu(name, type, price, modifiedDate) VALUES('Fired Chicken Rice', 'Rice', '7.99', GETDATE());";
}
dbConnect.executeQuery(queryString1);
if (dbConnect.IsSuccess())
{
MessageBox.Show("Inserted first record");
}
else
{
MessageBox.Show(dbConnect.getErrorString());
return;
}
dbConnect.executeQuery(queryString2);
if (dbConnect.IsSuccess())
{
MessageBox.Show("Inserted second record");
}
else
{
MessageBox.Show(dbConnect.getErrorString());
return;
}
}
private void dbConnectSelectBtn_Click(object sender, EventArgs e)
{
DBConnection dbConnect;
if (radioButtonDatabaseMySql.Checked)
{
dbConnect = new DBConnection_MySQL();
}
else
{
dbConnect = new DBConnection_Azure_MsSQL();
}
List <string> resultList = dbConnect.SelectTest();
string finalResult = "";
foreach (string result in resultList)
{
finalResult += result + '\n';
}
MessageBox.Show(finalResult);
}