public FormExamDepartment_ShowCourse(int course_ID)
{
InitializeComponent();
courseID = course_ID;
LecturesID = SQLFunctions.getLectureIDByCourseID(courseID);
courseName = SQLFunctions.covertCourseIDtoCourseName(courseID);
if (LecturesID != null && StudentsID != null)
{
for (int i = 0; i < LecturesID.Count; i++)
{
if (SQLFunctions.getStudentsIDfromLectureID(LecturesID[i]) != null)
{
if (StudentsID.Count == 0)
{
StudentsID = (SQLFunctions.getStudentsIDfromLectureID(LecturesID[i]));
}
else
{
StudentsID.Union(SQLFunctions.getStudentsIDfromLectureID(LecturesID[i])).ToList();
}
}
}
for (int i = 0; i < StudentsID.Count; i++)
{
dataGridView1.Rows.Add(courseID, courseName, StudentsID[i], SQLFunctions.covertStudentIDtoStudentLastName(Convert.ToInt32(StudentsID[i])) + " " + SQLFunctions.covertStudentIDtoStudentFirstName(Convert.ToInt32(StudentsID[i])));
}
}
}
public FormExamDepartment_GradeStudent(int course_ID = 0, int student_ID = 0)
{
InitializeComponent();
textBox1.Visible = false;
textBox1.MaxLength = 9;
textBox_grade.MaxLength = 3;
comboBox_CourseList.DropDownStyle = ComboBoxStyle.DropDownList;
DataTable students = SQLFunctions.getStudents();
if (students != null)
{
for (int i = 0; i < students.Rows.Count; i++)
{
string[] row = { students.Rows[i]["LastName"].ToString() + " " + students.Rows[i]["FirstName"].ToString(), students.Rows[i]["ID"].ToString(), students.Rows[i]["Year"].ToString(), students.Rows[i]["Semester"].ToString(), students.Rows[i]["Department"].ToString() };
ListViewItem item = new ListViewItem(row);
listView1.Items.Add(item);
}
}
if (student_ID != 0 && course_ID != 0)
{
listView1.Visible = false;
label_headline.Visible = true;
textBox1.Text = Convert.ToString(student_ID);
textBox1.Visible = false;
comboBox_CourseList.Items.Add(Convert.ToString(SQLFunctions.covertCourseIDtoCourseName(course_ID)));
comboBox_CourseList.SelectedIndex = 0;
comboBox_CourseList.Visible = false;
textBox_grade.Visible = true;
label_grade.Visible = true;
button_Accept.Visible = true;
}
}
private void StudentGrades_Load(object sender, EventArgs e)
{
DataTable studentsGrades = new DataTable();
studentsGrades = SQLFunctions.getStudentsGrades(id);
if (studentsGrades != null)
{
int k = 0;
for (int i = 0; i < studentsGrades.Rows.Count; i++)
{
//marks failed in red (under 56)
dataGridView1.Rows.Add(SQLFunctions.covertCourseIDtoCourseName(Convert.ToInt32(studentsGrades.Rows[i]["CourseID"])), studentsGrades.Rows[i]["Grade"]);
if (Convert.ToInt32(studentsGrades.Rows[i]["Grade"]) < 56)
{
dataGridView1.Rows[k].DefaultCellStyle.ForeColor = Color.Red;
}
k++;
}
}
}
public FormExamDepartment_GradeStudent(int course_ID = 0, int student_ID = 0)
{
InitializeComponent();
textBox_studentID.MaxLength = 9;
textBox_grade.MaxLength = 3;
comboBox_CourseList.DropDownStyle = ComboBoxStyle.DropDownList;
if (student_ID != 0 && course_ID != 0)
{
textBox_studentID.Text = Convert.ToString(student_ID);
textBox_studentID.Visible = false;
comboBox_CourseList.Items.Add(Convert.ToString(SQLFunctions.covertCourseIDtoCourseName(course_ID)));
comboBox_CourseList.SelectedIndex = 0;
comboBox_CourseList.Visible = false;
label_studentID.Visible = false;
textBox_grade.Visible = true;
label_grade.Visible = true;
button_OK.Visible = false;
button_Accept.Visible = true;
}
}
