public FormMenuSecretary(int _id, string _password)
{
InitializeComponent();
id = _id;
password = _password;
userSecretary = new Users(_id, _password, SQLFunctions.covertStudentIDtoStudentFirstName(_id), SQLFunctions.covertStudentIDtoStudentLastName(_id), SQLFunctions.getStudentDepartment(_id));
combobox_Year.DropDownStyle = ComboBoxStyle.DropDownList;
combobox_Semester.DropDownStyle = ComboBoxStyle.DropDownList;
}
public Student(int _id, string _password) : base(_id, _password, SQLFunctions.covertStudentIDtoStudentFirstName(_id), SQLFunctions.covertStudentIDtoStudentLastName(_id), SQLFunctions.getStudentDepartment(_id))
{
year = SQLFunctions.getStudentYear(_id);
semester = SQLFunctions.getStudentSemester(_id);
failedCoursesID = SQLFunctions.getStudentFailedCoursesIDs(_id);
semesterPoints = SQLFunctions.getStudentSemesterPoints(_id);
notification = SQLFunctions.getStudentNotificationsState(_id);
weeklyHours = SQLFunctions.getStudentWeeklyHours(_id);
registeredLessonsIDs = SQLFunctions.findStudentLecturesIDs(_id);
}
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])));
}
}
}
