public Assign_Form(String type) { InitializeComponent(); this.type = type; chooseWorker_listView.FullRowSelect = true; workerCourses_listView.FullRowSelect = true; otherCourses_listView.FullRowSelect = true; if (CourseSQL.Get_Courses() == null) { CourseSQL.LoadAllCoursesAsObjects(); } allCourses = CourseSQL.Get_Courses(); HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection()); sql.LoadAllPeopleInListView(ref this.chooseWorker_listView, type); if (type == "Lecturer") { choose_Button.Text = "Choose Lecturer"; tabPage1_label.Text = "Choose Lecturer To Assign"; coursesWantToTeach_label.Text = "Courses Lecturer Wants To Teach:"; } else if (type == "TeachingAssistant") { choose_Button.Text = "Choose TeachingAssistant"; tabPage1_label.Text = "Choose Teaching-Assistant To Assign"; coursesWantToTeach_label.Text = "Courses TeachingAssistant Wants To Teach:"; } tabControl.SelectedIndexChanged += new System.EventHandler( this.tabControl_SelectedIndexChanged); currentTabPage = choose_tabPage; tabControl.SelectedTab = currentTabPage; }
private void iTalk_Button_21_Click(object sender, EventArgs e) { //this.selfCourses = null; //teachingAssistant.CoursesToTeach = null; Course[] courses = new Course[myCourses_listView.Items.Count]; Course[] allCourses = CourseSQL.Get_Courses(); for (int i = 0; i < courses.Length; i++) { //courses[i] = new Course(); //courses[i].CourseID = Convert.ToInt16(myCourses_listView.Items[i].SubItems[0].Text); //courses[i].CourseName = myCourses_listView.Items[i].SubItems[1].Text; int courseId = Convert.ToInt16(myCourses_listView.Items[i].SubItems[0].Text); for (int j = 0; j < allCourses.Length; j++) { if (allCourses[j].CourseID == courseId) { courses[i] = new Course(); courses[i].CourseID = allCourses[j].CourseID; courses[i].CourseName = allCourses[j].CourseName; courses[i].YearTaught = allCourses[j].YearTaught; courses[i].SemesterTaught = allCourses[j].SemesterTaught; break; } } } this.employee.Set_CoursesToTeach(courses); MessageBox.Show("Changes saved successfully."); this.Close(); }
public OpenOrCloseCourse_Form() { InitializeComponent(); CourseSQL.LoadCoursesToListView(ref openCourses_listView); openCourses_listView.FullRowSelect = true; closeCourses_listView.FullRowSelect = true; if (CourseSQL.Get_Courses() == null) { CourseSQL.LoadAllCoursesAsObjects(); } allCourses = CourseSQL.Get_Courses(); foreach (ListViewItem item in openCourses_listView.Items) { for (int i = 0; i < allCourses.Length; i++) { if (Convert.ToInt16(item.SubItems[0].Text) == allCourses[i].CourseID) { if (allCourses[i].IsOpen == false) { ListViewItem temp = item; openCourses_listView.Items.Remove(item); closeCourses_listView.Items.Add(item); } break; } } } }
private void search_Button_Click(object sender, EventArgs e) { if (textBox.Text.Length == 0) { MessageBox.Show("No text was entered, try again please."); return; } CourseSQL.LoadAllCoursesAsObjects(); Course[] allCourses = CourseSQL.Get_Courses(); Course result = null; if (select_comboBox.Text == "Course Name") { foreach (Course course in allCourses) { if (course != null && course.CourseName == textBox.Text) { result = course; break; } } } else if (select_comboBox.Text == "Course ID") { int courseID; try { courseID = Convert.ToInt32(textBox.Text); } catch (Exception err) { MessageBox.Show("Course ID must be an Integer."); err.ToString(); return; } foreach (Course course in allCourses) { if (course != null && course.CourseID == courseID) { result = course; break; } } } if (result != null) { MessageBox.Show("Results:\n" + "Course ID: " + result.CourseID + "\n" + "Course Name: " + result.CourseName + "\n" + "Year Taught: " + result.YearTaught + "\n" + "Semester Taught: " + result.SemesterTaught); } else { MessageBox.Show("No result was found."); } }