private void button_Accept_Click(object sender, EventArgs e) { if (textBox_UserID.Enabled == true) { if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_UserID.Text)) == true) { if (SQLFunctions.checkRole(Convert.ToInt32(textBox_UserID.Text)) != comboBox_Permission.Text || comboBox_Permission.Text == "Student") { if (comboBox_Permission.Text == "Students Secretary") { SQLFunctions.updateUserRole(Convert.ToInt32(textBox_UserID.Text), "SecretaryA", comboBox_Department.Text); } else if (comboBox_Permission.Text == "Department Secretary") { SQLFunctions.updateUserRole(Convert.ToInt32(textBox_UserID.Text), "Secretary", comboBox_Department.Text); } else { SQLFunctions.updateUserRole(Convert.ToInt32(textBox_UserID.Text), comboBox_Permission.Text, comboBox_Department.Text); } if (comboBox_Permission.SelectedIndex == 0) { if (SQLFunctions.checkExistsStudents(Convert.ToInt32(textBox_UserID.Text)) == true) { SQLFunctions.updateStudentYearAndSemester(Convert.ToInt32(Convert.ToInt32(textBox_UserID.Text)), Convert.ToInt32(comboBox_Year.Text), Convert.ToChar(comboBox_Semester.Text)); } else { SQLFunctions.addStudent(Convert.ToInt32(Convert.ToInt32(textBox_UserID.Text)), Convert.ToInt32(comboBox_Year.Text), Convert.ToChar(comboBox_Semester.Text)); } } else { if (SQLFunctions.checkExistsStudents(Convert.ToInt32(textBox_UserID.Text)) == true) { SQLFunctions.deleteStudent(Convert.ToInt32(Convert.ToInt32(textBox_UserID.Text))); } } MessageBox.Show("User permission was changed to " + comboBox_Permission.Text + "."); this.Hide(); FormMenuAdmin adminForm = new FormMenuAdmin(); adminForm.Show(); } else { MessageBox.Show("This user is already " + comboBox_Permission.Text); } } else { MessageBox.Show("User was not found"); } } else { if (SQLFunctions.checkExistsUsers(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString())) == true) { if (SQLFunctions.checkRole(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString())) != comboBox_Permission.Text || comboBox_Permission.Text == "Student") { if (comboBox_Permission.Text == "Students Secretary") { SQLFunctions.updateUserRole(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString()), "SecretaryA", comboBox_Department.Text); } else if (comboBox_Permission.Text == "Department Secretary") { SQLFunctions.updateUserRole(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString()), "Secretary", comboBox_Department.Text); } else { SQLFunctions.updateUserRole(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString()), comboBox_Permission.Text, comboBox_Department.Text); } if (comboBox_Permission.SelectedIndex == 0) { if (SQLFunctions.checkExistsStudents(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString())) == true) { SQLFunctions.updateStudentYearAndSemester(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString()), Convert.ToInt32(comboBox_Year.Text), Convert.ToChar(comboBox_Semester.Text)); } else { SQLFunctions.addStudent(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString()), Convert.ToInt32(comboBox_Year.Text), Convert.ToChar(comboBox_Semester.Text)); } } else { if (SQLFunctions.checkExistsStudents(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString())) == true) { SQLFunctions.deleteStudent(Convert.ToInt32(allUsers.Rows[comboBox_users.SelectedIndex]["ID"].ToString())); } } MessageBox.Show("User permission was changed to " + comboBox_Permission.Text + "."); this.Hide(); FormMenuAdmin adminForm = new FormMenuAdmin(); adminForm.Show(); } } else { MessageBox.Show("User was not found"); } } }