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 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 bool checkTimeTable() { List <int> lecturesIDs = SQLFunctions.findStudentLecturesIDs(userStudnet.getUserID()); List <int> lectureCoursesIDs = new List <int>(); List <int> practiceCoursesIDs = new List <int>(); if (userStudnet.getSemeterPoints() < 10 || userStudnet.getSemeterPoints() > 30) { MessageBox.Show("Semester points doesn't meet requirment"); return(false); } for (int i = 0; i < lecturesIDs.Count; i++) { if ((SQLFunctions.findLectureProperties(lecturesIDs[i])[7]) == "Lecture") { lectureCoursesIDs.Add(Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesIDs[i])[2])); } if ((SQLFunctions.findLectureProperties(lecturesIDs[i])[7]) == "Practice") { practiceCoursesIDs.Add(Convert.ToInt32(SQLFunctions.findLectureProperties(lecturesIDs[i])[2])); } } if ((lectureCoursesIDs.Count != lectureCoursesIDs.Distinct().Count()) || (practiceCoursesIDs.Count != practiceCoursesIDs.Distinct().Count())) { MessageBox.Show("Exists duplicated letures"); return(false); } if (!(lectureCoursesIDs.All(practiceCoursesIDs.Contains) && practiceCoursesIDs.All(lectureCoursesIDs.Contains))) { MessageBox.Show("Not all lectures has a practice or not all pratice has a lecture"); return(false); } return(true); }