private void resetHours_Button_Click(object sender, EventArgs e) { if (listView.SelectedItems.Count == 0) { MessageBox.Show("No request was selected."); return; } else if (listView.SelectedItems.Count > 1) { MessageBox.Show("Choose only one request at the time."); return; } TeachingAssistantSQL teachingAssistant = new TeachingAssistantSQL(); try { teachingAssistant.Insert_actualTeachingHours(0, this.listView.SelectedItems[0].SubItems[2].Text, "TeachingAssistantTable"); } catch (Exception) { } try { teachingAssistant.Insert_actualTeachingHours(0, this.listView.SelectedItems[0].SubItems[2].Text, "LecturerTable"); } catch (Exception) { } listView.Clear(); headOfDepartmentSQL.LoadPeopleWithDerecognitionRequestListView(ref this.listView); }
private void newSql_button_Click(object sender, EventArgs e) { Boolean isConnected = SQLConnection.InitConnection(); if (isConnected == true) { MessageBox.Show("Connected successfully!"); } else { MessageBox.Show("Error, failed to connect."); } if (isConnected == true) { SqlConnection temp = SQLConnection.GetSqlConnection(); TeachingAssistantSQL tempt = new TeachingAssistantSQL(); //tempt.GetID(); /*Days[] days = new Days[2]; * days[0] = Days.Sunday; * days[1] = Days.Thursday; * tempt.Insert_DaysToTeach(days, "135792468");*/ /*Semester[] semesters = new Semester[2]; * semesters[0] = Semester.First; * semesters[1] = Semester.Third; * tempt.Insert_SemestersToTeach(semesters, "307889402");*/ /*DateTime[] hoursToTeach = new DateTime[2]; * hoursToTeach[0] = new DateTime(2000,1,1,10,10,0); * hoursToTeach[0].AddHours(8); * hoursToTeach[0].AddMinutes(30); * hoursToTeach[1] = new DateTime(2000, 1, 1, 11, 15, 0); * hoursToTeach[1].AddHours(13); * hoursToTeach[1].AddMinutes(45); * * tempt.Insert_HoursToTeach(hoursToTeach, "307889402");*/ /*int minTimeBetweenClasses = 37; * tempt.Insert_MinTimeBetweenClasses(minTimeBetweenClasses, "135792468")*/ /*int numOfDaysToTeach = 5; * tempt.Insert_NumOfDaysToTeach(numOfDaysToTeach, "307889402");*/ } }
private void choose_Button_Click(object sender, EventArgs e) { if (listView.SelectedItems.Count == 0) { MessageBox.Show("No request was selected."); return; } else if (listView.SelectedItems.Count > 1) { MessageBox.Show("Choose only one request at the time."); return; } TeachingAssistantSQL teachingAssistant = new TeachingAssistantSQL(); teachingAssistant.Insert_actualTeachingHours(int.Parse(this.listView.SelectedItems[0].SubItems[5].Text) * (-1), this.listView.SelectedItems[0].SubItems[2].Text, "TeachingAssistantTable"); headOfDepartmentSQL.removeRequest(this.listView.SelectedItems[0].SubItems[2].Text); listView.Clear(); headOfDepartmentSQL.LoadPeopleWithDerecognitionRequestListView(ref this.listView); }
private void choose_Button_Click(object sender, EventArgs e) { if (chooseWorker_listView.SelectedItems.Count == 0) { if (type == "Lecturer") { MessageBox.Show("No Lecturer has been selected, try again please."); } else { MessageBox.Show("No Teaching-Assistant has been selected, try again please."); } return; } currentTabPage = assignCourse_tabPage; tabControl.SelectedTab = currentTabPage; CourseSQL.LoadCoursesToListView(ref this.workerCourses_listView); if (type == "Lecturer") { TeachingAssistantSQL sql = new TeachingAssistantSQL(); this.selectedLecturer = sql.SearchLecturer( "id", chooseWorker_listView.SelectedItems[0].SubItems[2].Text); } else { TeachingAssistantSQL sql = new TeachingAssistantSQL(); this.selectedTeachingAssist = sql.SearchTeachingAssistant( "id", chooseWorker_listView.SelectedItems[0].SubItems[2].Text); } foreach (ListViewItem item in workerCourses_listView.Items) { if (IsCourseInSelfCourses(Convert.ToInt32(item.SubItems[0].Text)) == false) { ListViewItem copy = item; workerCourses_listView.Items.Remove(item); otherCourses_listView.Items.Add(copy); } } }
protected virtual void SaveOnClosing() { TeachingAssistantSQL sql = new TeachingAssistantSQL(); sql.UpdateTeachingAssistantOnClosing(this.teachingAssist); }
protected override void SaveOnClosing() { TeachingAssistantSQL sql = new TeachingAssistantSQL(); sql.UpdateOnClosing(this.lecturer); }