private void button2_Click(object sender, EventArgs e) { Nurse n = new Nurse(); this.Hide(); n.Show(); }
private void button1_Click(object sender, EventArgs e) { OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; //cmd.Parameters.Add("id", (textBox1.Text.ToString())); if (radioButton1.Checked) { cmd.CommandText = "select Doc_ID from Doctor where SID=:id "; cmd.Parameters.Add("id", textBox1.Text.ToString()); cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Doctor d = new Doctor(); d.Show(); this.Hide(); } else { MessageBox.Show("Invalid Credentials"); } dr.Close(); } else if (radioButton2.Checked) { cmd.CommandText = "select pat_id from patient where SSN = :id "; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("id", textBox1.Text.ToString()); //cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); // MessageBox.Show(textBox1.Text.ToString()); if (dr.Read()) { //MessageBox.Show(textBox1.Text.ToString()); Patient p = new Patient(int.Parse(textBox1.Text)); p.Show(); this.Hide(); } else { MessageBox.Show("Invalid Credentials"); } dr.Close(); } else if (radioButton3.Checked) { cmd.CommandText = "select N_ID from nurse where SID = :id"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("id", textBox1.Text.ToString()); OracleDataReader dr = cmd.ExecuteReader(); // MessageBox.Show( textBox1.Text.ToString()); if (dr.Read()) { Nurse n = new Nurse(); n.Show(); this.Hide(); } else { MessageBox.Show("Invalid Credentials"); } dr.Close(); } }