private void button1_Click(object sender, EventArgs e) { if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_ID.Text)) == false) { if (!SQLFunctions.checkExistsEmail(textBox_email.Text)) { if (textBox_email.Text.Contains("@")) { if (comboBox_Permission.Text == "Student Secretary") { SQLFunctions.insertUser(textBox_email.Text, Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, "SecretaryA", comboBox_Department.Text); } else if (comboBox_Permission.Text == "Department Secretary") { SQLFunctions.insertUser(textBox_email.Text, Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, "Secretary", comboBox_Department.Text); } else { SQLFunctions.insertUser(textBox_email.Text, Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, comboBox_Permission.Text, comboBox_Department.Text); } if (comboBox_Permission.SelectedIndex == 3) { MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text); } else if (comboBox_Permission.SelectedIndex == 2) { MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text + " employee"); } else { MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as a " + comboBox_Permission.Text + " in " + comboBox_Department.Text + " department."); } this.Hide(); FormMenuAdmin adminForm = new FormMenuAdmin(); adminForm.Show(); } else { MessageBox.Show("Invalid Email address"); } } else { MessageBox.Show("Email " + textBox_email.Text + " is already registered in the system"); } } else { MessageBox.Show("Student " + textBox_FirstName.Text + " is already registered in the system"); } }