public Assign_Form(String type)
{
InitializeComponent();
this.type = type;
chooseWorker_listView.FullRowSelect = true;
workerCourses_listView.FullRowSelect = true;
otherCourses_listView.FullRowSelect = true;
if (CourseSQL.Get_Courses() == null)
{
CourseSQL.LoadAllCoursesAsObjects();
}
allCourses = CourseSQL.Get_Courses();
HeadOfDepartmentSQL sql = new HeadOfDepartmentSQL(SQLConnection.GetSqlConnection());
sql.LoadAllPeopleInListView(ref this.chooseWorker_listView, type);
if (type == "Lecturer")
{
choose_Button.Text = "Choose Lecturer";
tabPage1_label.Text = "Choose Lecturer To Assign";
coursesWantToTeach_label.Text = "Courses Lecturer Wants To Teach:";
}
else if (type == "TeachingAssistant")
{
choose_Button.Text = "Choose TeachingAssistant";
tabPage1_label.Text = "Choose Teaching-Assistant To Assign";
coursesWantToTeach_label.Text = "Courses TeachingAssistant Wants To Teach:";
}
tabControl.SelectedIndexChanged += new System.EventHandler(
this.tabControl_SelectedIndexChanged);
currentTabPage = choose_tabPage;
tabControl.SelectedTab = currentTabPage;
}
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 iTalk_Button_21_Click(object sender, EventArgs e)
{
//this.selfCourses = null;
//teachingAssistant.CoursesToTeach = null;
Course[] courses = new Course[myCourses_listView.Items.Count];
Course[] allCourses = CourseSQL.Get_Courses();
for (int i = 0; i < courses.Length; i++)
{
//courses[i] = new Course();
//courses[i].CourseID = Convert.ToInt16(myCourses_listView.Items[i].SubItems[0].Text);
//courses[i].CourseName = myCourses_listView.Items[i].SubItems[1].Text;
int courseId = Convert.ToInt16(myCourses_listView.Items[i].SubItems[0].Text);
for (int j = 0; j < allCourses.Length; j++)
{
if (allCourses[j].CourseID == courseId)
{
courses[i] = new Course();
courses[i].CourseID = allCourses[j].CourseID;
courses[i].CourseName = allCourses[j].CourseName;
courses[i].YearTaught = allCourses[j].YearTaught;
courses[i].SemesterTaught = allCourses[j].SemesterTaught;
break;
}
}
}
this.employee.Set_CoursesToTeach(courses);
MessageBox.Show("Changes saved successfully.");
this.Close();
}
public LoginSQL(LoginForm loginForm) // Constructor
{
this.sqlConnection = SQLConnection.GetSqlConnection();
this.adapter = new SqlDataAdapter();
this.loginForm = loginForm;
CourseSQL.LoadAllCoursesAsObjects();
}
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 static void RegisterSQL(MigrationBuilder migrationBuilder)
{
migrationBuilder.Sql(TeacherSQL.SpGetTeacherById());
migrationBuilder.Sql(CourseSQL.CoursesByTeacherView());
migrationBuilder.Sql(CourseSQL.CourseInsertTrigger());
}
public PrintAllCourses()
{
InitializeComponent();
CourseSQL.LoadCoursesToListView(ref this.listView1);
listView1.View = View.Details;
}
//
private void Secretary_Form_FormClosed(Object sender, FormClosedEventArgs e)
{
CourseSQL.SaveAllCoursesOnClosing();
}
private void search_Button_Click(object sender, EventArgs e)
{
if (textBox.Text.Length == 0)
{
MessageBox.Show("No text was entered, try again please.");
return;
}
CourseSQL.LoadAllCoursesAsObjects();
Course[] allCourses = CourseSQL.Get_Courses();
Course result = null;
if (select_comboBox.Text == "Course Name")
{
foreach (Course course in allCourses)
{
if (course != null && course.CourseName == textBox.Text)
{
result = course;
break;
}
}
}
else if (select_comboBox.Text == "Course ID")
{
int courseID;
try
{
courseID = Convert.ToInt32(textBox.Text);
}
catch (Exception err)
{
MessageBox.Show("Course ID must be an Integer.");
err.ToString();
return;
}
foreach (Course course in allCourses)
{
if (course != null && course.CourseID == courseID)
{
result = course;
break;
}
}
}
if (result != null)
{
MessageBox.Show("Results:\n" +
"Course ID: " + result.CourseID + "\n" +
"Course Name: " + result.CourseName + "\n" +
"Year Taught: " + result.YearTaught + "\n" +
"Semester Taught: " + result.SemesterTaught);
}
else
{
MessageBox.Show("No result was found.");
}
}
