private void deleteCourse_button_Click(object sender, EventArgs e)
{
if (listView.SelectedItems.Count == 0)
{
MessageBox.Show("No course was selected.");
return;
}
else if (listView.SelectedItems.Count > 1)
{
MessageBox.Show("Choose only one course to delete at the time.");
return;
}
HeadOfDepartmentSQL headOfDepartmentSql = new HeadOfDepartmentSQL(this.sqlConnection);
int courseID;
try
{
courseID = Convert.ToInt16(this.listView.SelectedItems[0].SubItems[0].Text);
}
catch (Exception errorMsg)
{
MessageBox.Show(errorMsg.Message);
return;
}
headOfDepartmentSql.DeleteCourse(courseID);
CourseSQL.LoadCoursesToListView(ref this.listView);
}
public ExeptionOfHours_Form()
{
InitializeComponent();
this.sqlConnection = SQLConnection.GetSqlConnection();
headOfDepartmentSQL = new HeadOfDepartmentSQL(sqlConnection);
headOfDepartmentSQL.LoadPeopleWithExeptionRequestListView(ref this.listView);
}
private void Edit_Worker_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count == 0)
{
MessageBox.Show("No worker was selected.");
return;
}
else if (listView1.SelectedItems.Count > 1)
{
MessageBox.Show("Choose only one worker to delete at the time.");
return;
}
HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection());
BasicUser temp = new BasicUser();
temp.FirstName = listView1.SelectedItems[0].SubItems[0].Text;
temp.LastName = listView1.SelectedItems[0].SubItems[1].Text;
temp.Id = listView1.SelectedItems[0].SubItems[2].Text;
temp.Age = int.Parse(listView1.SelectedItems[0].SubItems[3].Text);
temp.Username = listView1.SelectedItems[0].SubItems[4].Text;
String id = temp.Id;
BasicUser_Registration_Form regForm = new BasicUser_Registration_Form(ref temp, false);
regForm.FormClosed += new FormClosedEventHandler(FormClosedHandling);
regForm.ShowDialog();
sql.UpdateWorker(id, job, temp);
listView1.Items.Clear();
sql.LoadAllPeopleInListView(ref this.listView1, job);
}
public PeopleWithAbnormalHours_Form(int isIncrease)
{
InitializeComponent();
this.sqlConnection = SQLConnection.GetSqlConnection();
headOfDepartmentSQL = new HeadOfDepartmentSQL(sqlConnection);
headOfDepartmentSQL.LoadPeopleWithAbnormalHoursListView(ref this.listView, isIncrease);
}
public PrintAllLecturer()
{
InitializeComponent();
headOfDeptSQL = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection());
headOfDeptSQL.printAllLecturerListView(this.listView1);
listView1.View = View.Details;
}
public PrintAllTeachingAssists()
{
InitializeComponent();
headOfDeptSQL = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection());
headOfDeptSQL.printAllTeachingAssistantsInListView(this.listView1);
listView1.View = View.Details;
}
private void iTalk_Button_21_Click(object sender, EventArgs e)
{
String courseName = this.courseName_textBox.Text;
int yearTaught = this.yearTaught_checkedListBox.SelectedIndex + 1;
int semesterTaught = this.semesterTaught_checkedListBox.SelectedIndex + 1;
Semester semester;
String errorMsg = "";
if (courseName.Length == 0)
{
errorMsg += "\n-No course name was entered.";
}
if (yearTaught_checkedListBox.SelectedItems.Count == 0)
{
errorMsg += "\n-No year was choosen.";
}
if (semesterTaught_checkedListBox.SelectedItems.Count == 0)
{
errorMsg += "\n-No semester was choosen.";
}
if (errorMsg.Length > 0)
{
MessageBox.Show("The following errors occured:" + errorMsg);
return;
}
switch (semesterTaught)
{
case 1: semester = Semester.First;
break;
case 2: semester = Semester.Second;
break;
case 3: semester = Semester.Third;
break;
default: semester = Semester.First;
break;
}
SqlConnection connection = SQLConnection.GetSqlConnection();
if (connection == null)
{
MessageBox.Show("SQL connection hasn't been initialized or has been closed.");
return;
}
HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(connection);
//MessageBox.Show("Last Added Course ID= " + sql.GetLastAddedCourseID());
sql.AddNewCourse(new Course(sql.GetLastAddedCourseID(), courseName, yearTaught, semester, false));
this.Dispose();
}
private void Secretary_Click(object sender, EventArgs e)
{
this.Hide();
Secretary secretary = new Secretary();
secretary.FirstName = "empty";
BasicUser temp = (BasicUser)secretary;
BasicUser_Registration_Form regForm = new BasicUser_Registration_Form(ref temp, true);
regForm.FormClosed += new FormClosedEventHandler(FormClosedHandling);
regForm.ShowDialog();
if (temp != null && temp.FirstName != "empty")
{
String tempt = "The new user details: FirstName:" + temp.FirstName + ", lastname:" + temp.LastName + ",password:"******"SecretaryTable");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (listView1.SelectedItems.Count == 0)
{
MessageBox.Show("No worker was selected.");
return;
}
else if (listView1.SelectedItems.Count > 1)
{
MessageBox.Show("Choose only one worker to delete at the time.");
return;
}
HeadOfDepartmentSQL headOfDepartmentSql = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection());
String ID = listView1.SelectedItems[0].SubItems[2].Text;
headOfDepartmentSql.DeleteWorker(ID, listView1.SelectedItems[0].SubItems[5].Text);
listView1.Items.Clear();
headOfDepartmentSql.LoadAllPeopleInListView(ref this.listView1, "TeachingAssistant");
headOfDepartmentSql.LoadAllPeopleInListView(ref this.listView1, "Lecturer");
//sql.LoadAllPeopleInListView(ref this.listView1, "Secretary");
}
public DeleteWorker_Form(String str)
{
job = str;
InitializeComponent();
HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection());
if (str == "TeachingAssistant")
{
this.DeleteWorker_button.Hide();
sql.LoadAllPeopleInListView(ref this.listView1, "TeachingAssistant");
}
else if (str == "Lecturer")
{
this.DeleteWorker_button.Hide();
sql.LoadAllPeopleInListView(ref this.listView1, "Lecturer");
}
else if (str == "Delete")
{
this.Edit_Worker.Hide();
sql.LoadAllPeopleInListView(ref this.listView1, "TeachingAssistant");
sql.LoadAllPeopleInListView(ref this.listView1, "Lecturer");
//sql.LoadAllPeopleInListView(ref this.listView1, "Secretary");
}
}
private void iTalk_Button_21_Click(object sender, EventArgs e)
{
String errorMsg = "";
if (courseName_textBox.Text.Length == 0)
{
errorMsg += "-No course name was entered.\n";
}
if (yearTaught_checkedListBox.SelectedItems.Count == 0)
{
errorMsg += "-No year was chosen.\n";
}
if (semesterTaught_checkedListBox.SelectedItems.Count == 0)
{
errorMsg += "-No semester was chosen.\n";
}
if (errorMsg.Length > 0)
{
MessageBox.Show("The following errors occured:\n" + errorMsg);
return;
}
course.CourseName = this.courseName_textBox.Text;
course.YearTaught = this.yearTaught_checkedListBox.SelectedIndex + 1;
int semesterTaught = this.semesterTaught_checkedListBox.SelectedIndex + 1;
switch (semesterTaught)
{
case 1:
course.SemesterTaught = Semester.First;
break;
case 2:
course.SemesterTaught = Semester.Second;
break;
case 3:
course.SemesterTaught = Semester.Third;
break;
default:
course.SemesterTaught = Semester.First;
break;
}
MessageBox.Show("Course name = " + course.CourseName + "\n" +
"Year Taught = " + course.YearTaught + "\n" +
"SemesterTaught = " + course.SemesterTaught);
SqlConnection connection = SQLConnection.GetSqlConnection();
if (connection == null)
{
MessageBox.Show("SQL connection hasn't been initialized or has been closed.");
return;
}
HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(connection);
//MessageBox.Show("Last Added Course ID= " + sql.GetLastAddedCourseID());
sql.UpdateCourse(course);
this.Close();
}