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 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);
}
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);
}
}
}
public ChooseCoursesToTeach(Course[] courses, ref EmpInterface emp)
{
InitializeComponent();
this.employee = emp;
this.selfCourses = courses;
CourseSQL.LoadCoursesToListView(ref this.allCourses_listView);
this.myCourses_listView.FullRowSelect = true;
/*
* The following loop runs on all the available courses and removes the courses already
* chosen by the Teaching-Assistant or Lecturer and adds the items to the other
* listview containing the chosen courses (selfCourses).
* It's done by comparing the course ID, which is a unique parameter for each course.
*/
if (selfCourses != null)
{
try
{
foreach (ListViewItem item in allCourses_listView.Items)
{
for (int i = 0; i < selfCourses.Length; i++)
{
if (Convert.ToInt16(item.SubItems[0].Text) == selfCourses[i].CourseID)
{
ListViewItem temp = item;
allCourses_listView.Items.Remove(item);
myCourses_listView.Items.Add(item);
break;
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
}
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;
}
Course course = new Course();
try
{
course.CourseID = Convert.ToInt16(this.listView.SelectedItems[0].SubItems[0].Text);
}
catch (Exception errorMsg)
{
MessageBox.Show(errorMsg.Message);
return;
}
course.CourseName = this.listView.SelectedItems[0].SubItems[1].Text;
try
{
course.YearTaught = Convert.ToInt16(this.listView.SelectedItems[0].SubItems[2].Text);
}
catch (Exception errorMsg)
{
MessageBox.Show(errorMsg.Message);
return;
}
int temp;
try
{
temp = Convert.ToInt16(this.listView.SelectedItems[0].SubItems[3].Text);
}
catch (Exception errorMsg)
{
MessageBox.Show(errorMsg.Message);
return;
}
switch (temp)
{
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;
}
EditCourseDetail_Form editCourseDetailForm = new EditCourseDetail_Form(course);
this.Hide();
editCourseDetailForm.FormClosed += new FormClosedEventHandler(FormClosedHandling);
editCourseDetailForm.ShowDialog();
CourseSQL.LoadCoursesToListView(ref this.listView);
}
public EditCourse_Form()
{
InitializeComponent();
CourseSQL.LoadCoursesToListView(ref this.listView);
this.sqlConnection = SQLConnection.GetSqlConnection();
}
public PrintAllCourses()
{
InitializeComponent();
CourseSQL.LoadCoursesToListView(ref this.listView1);
listView1.View = View.Details;
}