private void button2_Click_1(object sender, EventArgs e)
{
Form f = new profile_p(n);
f.Show();
this.Hide();
}
private void b_submit_Click(object sender, EventArgs e)
{
int x = int.Parse(textBox1.Text) / 1000;
connect();
cmd = new OracleCommand();
if (x == 1)
{
cmd.CommandText = "select * from patient_pers";
cmd.CommandType = CommandType.Text;
DataSet ds = new DataSet();
da = new OracleDataAdapter(cmd.CommandText, con);
da.Fill(ds, "patient_pers");
dt = ds.Tables["patient_pers"];
int t = dt.Rows.Count;
for (i = 0; i < t; i++)
{
dr = dt.Rows[i];
if ((textBox1.Text == dr["patient_id"].ToString()) && (textBox2.Text == dr["password"].ToString()))
{
string a = dr["name"].ToString();
Form f = new profile_p(a);
f.Show();
this.Hide();
break;
}
}
if (i == t)
{
label2.Visible = true;
}
}
else if (x == 2)
{
cmd.CommandText = "select * from doc_pers";
cmd.CommandType = CommandType.Text;
DataSet ds = new DataSet();
da = new OracleDataAdapter(cmd.CommandText, con);
da.Fill(ds, "doc_pers");
dt = ds.Tables["doc_pers"];
int t = dt.Rows.Count;
for (i = 0; i < t; i++)
{
dr = dt.Rows[i];
if ((textBox1.Text == dr["doc_id"].ToString()) && (textBox2.Text == dr["password"].ToString()))
{
string a = dr["name"].ToString();
Form f = new profile_d(a);
f.Show();
this.Hide();
break;
}
}
if (i == t)
{
label2.Visible = true;
}
}
else
{
label2.Visible = true;
}
}