private void buttonLogin_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkLogIn(Convert.ToInt32(textBoxID.Text), textBoxPassword.Text))
{
this.Hide();
if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Student")
{
FormMenuStudent mainForm = new FormMenuStudent();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Secretary")
{
FormMenuSecretary mainForm = new FormMenuSecretary();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Exam Department")
{
FormMenuExamDepratment mainForm = new FormMenuExamDepratment();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Admin")
{
}
else
{
MessageBox.Show("Unknown Error");
}
}
else
{
MessageBox.Show("Logon Failure: unknown ID or bad password");
}
}
private void login1()
{
if (!link)
{
DataRow dataRow = SQLFunctions.checkFbLogIn(fbMail);
if (dataRow == null)
{
MessageBox.Show("This facebook account is not linked to any system user\nPlease link your Facebook account and try again");
B_8.login login = new B_8.login();
login.Show();
}
else if (SQLFunctions.checkLogIn(Convert.ToInt32(dataRow[0]), dataRow[1].ToString()))
{
if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "Student")
{
FormMenuStudent mainForm = new FormMenuStudent(Convert.ToInt32(dataRow[0]), dataRow[1].ToString());
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "SecretaryA")
{
FormMenuSecretary mainForm = new FormMenuSecretary(Convert.ToInt32(dataRow[0]), dataRow[1].ToString());
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "Exam Department")
{
FormMenuExamDepartment mainForm = new FormMenuExamDepartment();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(dataRow[0])) == "Admin")
{
FormMenuAdmin mainForm = new FormMenuAdmin();
mainForm.Show();
}
else
{
B_8.login login = new B_8.login(true, SQLFunctions.convertFbMailToMail(fbMail), dataRow[1].ToString());
}
}
}
else
{
SQLFunctions.linkFbAccount(mail, fbMail);
MessageBox.Show("Your facebook account was succesfuly linked");
this.Hide();
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_UserID.Text)) == true)
{
if (SQLFunctions.checkRole(Convert.ToInt32(textBox_UserID.Text)) != comboBox_Permission.Text)
{
SQLFunctions.updateUserRole(Convert.ToInt32(textBox_UserID.Text), comboBox_Permission.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 ID could not be located in the database");
}
}
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");
}
}
}
