private void button1_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_ID.Text)) == false)
{
SQLFunctions.insertUser(Convert.ToInt32(textBox_ID.Text), textBox_Password.Text, textBox_FirstName.Text, textBox_LastName.Text, comboBox_Permission.Text, comboBox_Department.Text);
if (comboBox_Permission.SelectedIndex == 0 || comboBox_Permission.SelectedIndex == 1)
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as a " + comboBox_Permission.Text + " in " + comboBox_Department.Text + " department.");
}
else if (comboBox_Permission.SelectedIndex == 3)
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text);
}
else
{
MessageBox.Show(textBox_LastName.Text + " " + textBox_FirstName.Text + " was added as an " + comboBox_Permission.Text + " employee");
}
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Student " + textBox_FirstName.Text + " is already registered in the system");
}
}
private void button_Back_Click(object sender, EventArgs e)
{
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
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");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsClassroom(textBox_ClassName.Text) == false)
{
SQLFunctions.addClassroom(textBox_ClassName.Text, Convert.ToInt32(textBox_Capacity.Text));
MessageBox.Show("class " + textBox_ClassName.Text + " was added with " + textBox_Capacity.Text + " seats.");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("class " + textBox_ClassName.Text + " is already exists.");
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsClassroom(textBox_ClassName.Text) == true)
{
SQLFunctions.deleteClassroom(textBox_ClassName.Text);
MessageBox.Show("Class " + textBox_ClassName.Text + " was deleted!");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Classroom could not be located in the database");
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsClassroom(listView1.SelectedItems[0].SubItems[0].Text) == true)
{
SQLFunctions.deleteClassroom(listView1.SelectedItems[0].SubItems[0].Text);
MessageBox.Show("Class " + listView1.SelectedItems[0].SubItems[0].Text + " was deleted!");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("Classroom was not found");
}
}
private void button_Accept_Click(object sender, EventArgs e)
{
if (SQLFunctions.checkExistsUsers(Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text)) == true)
{
SQLFunctions.deleteUser(Convert.ToInt32(listView1.SelectedItems[0].SubItems[0].Text));
MessageBox.Show("User with ID: " + listView1.SelectedItems[0].SubItems[0].Text + " was deleted!");
this.Hide();
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
else
{
MessageBox.Show("User ID could not be located in the database");
}
}
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 buttonLogin_Click(object sender, EventArgs e)
{
if (textBoxID.Text == "")
{
MessageBox.Show("Logon Failure: unknown ID or invalid password");
return;
}
if (SQLFunctions.checkLogIn(Convert.ToInt32(textBoxID.Text), textBoxPassword.Text))
{
this.Hide();
if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Student")
{
FormMenuStudent mainForm = new FormMenuStudent(Convert.ToInt32(textBoxID.Text), textBoxPassword.Text);
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Secretary")
{
FormMenuSecretary mainForm = new FormMenuSecretary(Convert.ToInt32(textBoxID.Text), textBoxPassword.Text);
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Exam Department")
{
FormMenuExamDepartment mainForm = new FormMenuExamDepartment();
mainForm.Show();
}
else if (SQLFunctions.checkRole(Convert.ToInt32(textBoxID.Text)) == "Admin")
{
FormMenuAdmin mainForm = new FormMenuAdmin();
mainForm.Show();
}
else
{
MessageBox.Show("Unknown Error");
}
}
else
{
MessageBox.Show("Logon Failure: unknown ID or invalid password");
}
}
private void FormAdminViewErros_FormClosing(object sender, FormClosingEventArgs e)
{
this.Hide();
List <int> errorIDs = new List <int>();
for (int i = 0; i < errors.Count; i++)
{
if (errors[i][4] == "True")
{
errorIDs.Add(Convert.ToInt32(errors[i][0]));
}
}
SQLFunctions.updateErrorsStatus(errorIDs);
FormMenuAdmin adminForm = new FormMenuAdmin();
adminForm.Show();
}
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");
}
}
}