private void button1_Click(object sender, EventArgs e)
{
try
{
first = textBox1.Text;
last = textBox2.Text;
////username = first + last[0] + last[1];
reader = db.Select("*", "NewUsers", "Email", textBox6.Text);
int count = 0, count_id = 0;
while (reader.Read())
{
if (reader["Email"].ToString().Trim().Equals(textBox6.Text))
{
count++;
}
}
reader.Close();
reader = db.Select("*", "NewUsers", "ID", textBox3.Text);
while (reader.Read())
{
if (reader["ID"].ToString().Trim().Equals(textBox3.Text))
{
count_id++;
}
}
reader.Close();
if (count == 0 && count_id == 0)
{
reader.Close();
id = textBox3.Text;
password = textBox4.Text;
password_again = textBox5.Text;
email = textBox6.Text;
Role = role.Text;
department = Department_comboBox.Text;
unit = comboBox1.Text;
if (password == password_again)
{
db.InsertUser(first, last, id, email, password, Role, department, unit);
this.Hide();
main ss = new main();
ss.Show();
}
else
{
MessageBox.Show("Wrong input!\n The passwords are Different");
}
}
else if (count != 0)
{
MessageBox.Show("Wrong input!\n Email already exist in the system");
}
else if (count_id != 0)
{
MessageBox.Show("Wrong input!\n ID already exist in the system");
}
}
catch (Exception)
{
MessageBox.Show("Could not connect to sql");
}
finally
{
if (db.isconnected == true)
{
db.CloseConnection();
}
}
}
