public DerecognitionOfHours_Form()
{
InitializeComponent();
this.sqlConnection = SQLConnection.GetSqlConnection();
headOfDepartmentSQL = new HeadOfDepartmentSQL(sqlConnection);
headOfDepartmentSQL.LoadPeopleWithDerecognitionRequestListView(ref this.listView);
}
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 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);
}