private void button9_Click(object sender, EventArgs e)
{
con.Open();
string Query = "INSERT INTO `staff`(`Sid`, `name`, `Login_id`, `phone`, `DoB`, `Address`) VALUES ('" + Convert.ToInt32(this.textBox12.Text) + "','" + this.textBox19.Text + "','" + this.textBox14.Text + "','" + this.textBox16.Text + "','" + this.dateTimePicker3.Text + "','" + this.textBox15.Text + "')";
MySqlCommand MyCommand = new MySqlCommand(Query, con);
MySqlDataReader MyReader = MyCommand.ExecuteReader();
con.Close();
signup sup = new signup(textBox14.Text, "Staff");
sup.Show();
}
private void button6_Click(object sender, EventArgs e)
{
con.Open();
String gender = null;
if (radioButton4.Checked)
{
gender = radioButton4.Text;
radioButton3.Checked = false;
}
if (radioButton4.Checked)
{
gender = radioButton4.Text;
radioButton3.Checked = false;
}
string Query = "INSERT INTO `doctorreg`(`Did`, `Name`, `Login_id`, `Gender`, `Department`, `DoB`, `Email`, `Mno`, `Qualification`) VALUES ('" + Convert.ToInt32(this.textBox12.Text) + "','" + this.textBox11.Text + "','" + this.textBox13.Text + "','" + gender + "','" + this.textBox10.Text + "','" + this.dateTimePicker2.Text + "','" + this.textBox9.Text + "','" + this.textBox8.Text + "','" + this.textBox7.Text + "')";
MySqlCommand MyCommand = new MySqlCommand(Query, con);
MySqlDataReader MyReader = MyCommand.ExecuteReader();
con.Close();
signup sup = new signup(textBox13.Text, "Doctor");
sup.Show();
}