private void ClassAddTeacher_Load(object sender, EventArgs e)
{
RefreshTable();
List <Classes> ClassList = ClassesDB.ClassLoad();
List <Teacher> TeacherList = TeacherDB.TeacherLoad();
foreach (Classes classes in ClassList)
{
cmbClasses.Items.Add(classes.ClassID.ToString() + " " + classes.ClassTitle);
}
foreach (Teacher teacher in TeacherList)
{
cmbTeachers.Items.Add(teacher.TeacherID + " " + teacher.FirstName + " " + teacher.LastName);
}
}
public void RefreshTable()
{
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
List <Classes> classList = ClassesDB.ClassLoad();
List <Teacher> teacherList = TeacherDB.TeacherLoad();
dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].Name = "Class ID";
dataGridView1.Columns[1].Name = "Class Title";
dataGridView1.Columns[2].Name = "Class Track";
dataGridView1.Columns[3].Name = "Teacher";
dataGridView1.Columns[4].Name = "Teacher(s)";
dataGridView1.Columns[5].Name = "Teacher(s)";
dataGridView1.Columns[6].Name = "Teacher(s)";
foreach (Classes classes in classList)
{
string[] row;
List <string> teacherNames = new List <string>()
{
"", "", "", "", "", "", "", "", "", ""
};
int count = 0;
foreach (int teacherid in classes.TeacherID)
{
if (teacherid != 0)
{
Teacher newTeacher = TeacherDB.TeacherFind(teacherid);
teacherNames[count] = newTeacher.TeacherID.ToString() + " " + newTeacher.FirstName + " " + newTeacher.LastName;
count++;
}
}
row = new string[] { classes.ClassID.ToString(), classes.ClassTitle, classes.ClassTrack, teacherNames[0], teacherNames[1], teacherNames[2], teacherNames[3] };
dataGridView1.Rows.Add(row);
}
}
