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