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