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