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 listView1_DoubleClick(object sender, EventArgs e) { textBox1.Text = listView1.SelectedItems[0].SubItems[1].Text; textBox1.Visible = false; List <string> coursesNames = new List <string>(); List <int> coursesID = new List <int>(); int flag = 0; if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox1.Text)) == true) { int j = 0; comboBox_CourseList.Visible = true; label_Course.Visible = true; textBox1.Visible = false; button_Accept.Visible = true; AcceptButton = button_Accept; List <int> lecturesList = SQLFunctions.findStudentLecturesIDs(Convert.ToInt32(textBox1.Text)); if (lecturesList != null) { for (int i = 0; i < lecturesList.Count; i++) { flag = 0; for (j = 0; j < coursesID.Count; j++) { if (Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesList[i])[2]) == coursesID[j]) { flag = 1; } } if (flag == 0) { coursesID.Add(Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesList[i])[2])); coursesNames.Add(SQLFunctions.findCourseProperties(coursesID[j])[0]); } } comboBox_CourseList.Items.Clear(); comboBox_CourseList.ResetText(); for (int i = 0; i < coursesNames.Count; i++) { comboBox_CourseList.Items.Add(coursesNames[i]); } } else { MessageBox.Show("The student is not registered to courses"); } } else { MessageBox.Show("This student isnt registered"); } }
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 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 button_OK_Click(object sender, EventArgs e) { List <string> coursesNames = new List <string>(); List <int> coursesID = new List <int>(); int flag = 0; if (SQLFunctions.checkExistsUsers(Convert.ToInt32(textBox_studentID.Text)) == true) { int j = 0; comboBox_CourseList.Visible = true; label_Course.Visible = true; textBox_studentID.Visible = false; button_OK.Visible = false; label_studentID.Visible = false; button_Accept.Visible = true; AcceptButton = button_Accept; List <int> lecturesList = SQLFunctions.findStudentLecturesIDs(Convert.ToInt32(textBox_studentID.Text)); for (int i = 0; i < lecturesList.Count; i++) { flag = 0; for (j = 0; j < coursesID.Count; j++) { if (Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesList[i])[2]) == coursesID[j]) { flag = 1; } } if (flag == 0) { coursesID.Add(Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesList[i])[2])); coursesNames.Add(SQLFunctions.findCourseProperties(coursesID[j])[0]); } } for (int i = 0; i < coursesNames.Count; i++) { comboBox_CourseList.Items.Add(coursesNames[i]); } } else { MessageBox.Show("This student isnt registered"); } }
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"); } } }