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 LoginSQL(LoginForm loginForm) // Constructor
{
this.sqlConnection = SQLConnection.GetSqlConnection();
this.adapter = new SqlDataAdapter();
this.loginForm = loginForm;
CourseSQL.LoadAllCoursesAsObjects();
}
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 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.");
}
}