private void Button1_Click(object sender, EventArgs e)
{
//check that the length is not more than 10 digits
if ((textBox1.Text.Trim()).Length > 10 || (textBox1.Text.Trim()).Length < 10)
{
MessageBox.Show("Enter only 10 numbers");
}
//not more than 10 digits
else
{
cn.Open();
//check if the id exist
SqlCommand cmd = new SqlCommand
("select count(*) from hospitalRecords where id=" + textBox1.Text.Trim() + ";", cn);
string s = cmd.ExecuteScalar().ToString();
if (s.Equals("1"))
{ //the id is correct
//check that id is not in the waiting patients
cmd = new SqlCommand
("select count(*) from waitingPatients where id=" + textBox1.Text.Trim() + ";", cn);
string t = cmd.ExecuteScalar().ToString();
if (t.Equals("1")) // if it's in the waiting patients
{
MessageBox.Show("you are already registered please wait until your name is called");
}
else
{
string id = textBox1.Text.Trim();
new currentPatientID(Int32.Parse(id));
if (go == "services")
{
this.Hide();
services services = new services(textBox1.Text.Trim());
services.Show();
}
else if (go == "redCases")
{
this.Hide();
redCases redCases = new redCases();
redCases.Show();
}
}
cn.Close();
}
else
{
MessageBox.Show("Wrong ID number");
}
}
cn.Close();
}
private void Button1_Click(object sender, EventArgs e)
{
//check that the length is not more than 10 digits
if ((textBox1.Text.Trim()).Length > 10 || (textBox1.Text.Trim()).Length < 10)
{
MessageBox.Show("أدخل 10 ارقام فقط");
}
//not more than 10 digits
else
{
cn.Open();
//check if the id exist
SqlCommand cmd = new SqlCommand
("select count(*) from hospitalRecords where id=" + textBox1.Text.Trim() + ";", cn);
string s = cmd.ExecuteScalar().ToString();
if (s.Equals("1"))
{ //the id is correct
//check that id is not in the waiting patients
cmd = new SqlCommand
("select count(*) from waitingPatients where id=" + textBox1.Text.Trim() + ";", cn);
string t = cmd.ExecuteScalar().ToString();
if (t.Equals("1")) // if it's in the waiting patients
{
MessageBox.Show("لقد تم تسجيلك بالفعل، رجاءاً انتظر حتى يتم نداء اسمك");
}
else
{
string id = textBox1.Text.Trim();
new currentPatientID(Int32.Parse(id));
if (go == "services")
{
this.Hide();
services services = new services(textBox1.Text.Trim());
services.Show();
}
else if (go == "redCases")
{
this.Hide();
redCasesAr redCases = new redCasesAr();
redCases.Show();
}
}
cn.Close();
}
else
{
MessageBox.Show("رقم هوية خاطئ");
}
}
}