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");
}
}
}
