//Confirm Buttton
private void metroButton1_Click(object sender, EventArgs e)
{
String query1 = "INSERT INTO `teachers` (`T_ID`, `F_NAME`, `L_NAME`, `teachers`.`D_ID`, `POSITION`, `Priority`) VALUES ('" + metroTextBox1.Text + "', '" + metroTextBox2.Text + "', '" + metroTextBox3.Text + "', '" + Convert.ToInt32(metroTextBox4.Text) + "', '" + metroTextBox6.Text + "', '1')";
String query2 = "INSERT INTO `prioritytable` (`ID`, `Password`, `Priority`) VALUES ('" + metroTextBox1.Text + "', '" + metroTextBox5.Text + "', 1)";
DBConnect conn = new DBConnect();
if (metroTextBox1.Text == null || metroTextBox2.Text == null || metroTextBox3.Text == null || metroTextBox4.Text == null || metroTextBox5.Text == null || metroTextBox6.Text == null)
{
MessageBox.Show("Fill in all Form and try again");
}
else
{
try
{
conn.Insert(query1);
conn.CloseConnection();
conn.Insert(query2);
MessageBox.Show("User Registration Successful");
this.Close();
aTab.Show();
}
catch (Exception ex)
{
MessageBox.Show("User Already Exists");
}
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
this.Hide();
TeacherHighAddSelection aSelection = new TeacherHighAddSelection(this);
aSelection.Show();
}
//Confirm Buttton
private void metroButton1_Click(object sender, EventArgs e)
{
// String query1 = "INSERT INTO `teachers` (`T_ID`, `F_NAME`, `L_NAME`, `teachers`.`D_ID`, `POSITION`, `Priority`) VALUES ('"+ metroTextBox1.Text +"', '"+ metroTextBox2.Text +"', '"+ metroTextBox3.Text +"', '"+ Convert.ToInt32(metroTextBox4.Text) +"', '"+ metroTextBox6.Text +"', '1')";
//String query2 = "INSERT INTO `prioritytable` (`ID`, `Password`, `Priority`) VALUES ('"+ metroTextBox1.Text +"', '"+ metroTextBox5.Text +"', 1)";
string oradb = "Data Source=XE; User Id=RIAD;Password=1133;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
if (metroTextBox1.Text == null || metroTextBox2.Text == null || metroTextBox3.Text == null || metroTextBox4.Text == null || metroTextBox5.Text == null || metroTextBox6.Text == null)
{
MessageBox.Show("Fill in all Form and try again");
}
else
{
try
{
cmd.CommandText = "ADDTEACHER";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("A", OracleType.VarChar).Value = metroTextBox1.Text;
cmd.Parameters.Add("B", OracleType.VarChar).Value = metroTextBox2.Text;
cmd.Parameters.Add("C", OracleType.VarChar).Value = metroTextBox3.Text;
cmd.Parameters.Add("D", OracleType.VarChar).Value = Convert.ToInt32(metroTextBox4.Text);
cmd.Parameters.Add("E", OracleType.VarChar).Value = metroTextBox6.Text;
cmd.Parameters.Add("F", OracleType.VarChar).Value = metroTextBox5.Text;
cmd.ExecuteNonQuery();
MessageBox.Show("User Registration Successful");
this.Close();
aTab.Show();
}
catch (Exception ex)
{
MessageBox.Show("Fill All Fields");
}
}
}
private void metroButton2_Click(object sender, EventArgs e)
{
this.Close();
aTab.Show();
}
