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