private void btnAdd_Click(object sender, EventArgs e)
{
string[] Name = cmbTeachers.Text.Split(' ');
string[] Title = cmbClasses.Text.Split(' ');
Teacher teacher = TeacherDB.TeacherFind(Convert.ToInt32(Name[0]));
Classes classes = ClassesDB.ClassFind(Convert.ToInt32(Title[0]));
foreach (int teacherId in classes.TeacherID)
{
if (teacherId == teacher.TeacherID)
{
MessageBox.Show("Teacher already part of class");
return;;
}
}
classes.TeacherID.RemoveAll(item => item == 0);
classes.TeacherID.Add(teacher.TeacherID);
teacher.ClassID.Add(classes.ClassID);
ClassesDB.ClassDelete(classes);
ClassesDB.ClassSave(classes);
TeacherDB.TeacherDelete(teacher);
TeacherDB.TeacherSave(teacher);
}
private void ClassEdit_Load(object sender, EventArgs e)
{
Classes newClass = ClassesDB.TempLoad();
txtClassTitle.Text = newClass.ClassTitle;
cmbTrack.Text = newClass.ClassTrack;
lblClassID.Text = newClass.ClassID.ToString();
}
private void btnSave_Click(object sender, EventArgs e)
{
Classes updatedClass = ClassesDB.ClassFind(Convert.ToInt32(lblClassID.Text));
updatedClass.ClassID = Convert.ToInt32(lblClassID.Text);
updatedClass.ClassTitle = txtClassTitle.Text;
updatedClass.ClassTrack = cmbTrack.Text;
ClassesDB.ClassDelete(updatedClass);
ClassesDB.ClassSave(updatedClass);
MessageBox.Show("Class Updated");
this.Close();
}
private void btnDelete_Click(object sender, EventArgs e)
{
string[] Name = cmbTeachers.Text.Split(' ');
string[] Title = cmbClasses.Text.Split(' ');
Teacher teacher = TeacherDB.TeacherFind(Convert.ToInt32(Name[0]));
Classes classes = ClassesDB.ClassFind(Convert.ToInt32(Title[0]));
classes.TeacherID.Remove(teacher.TeacherID);
teacher.ClassID.Remove(classes.ClassID);
ClassesDB.ClassDelete(classes);
ClassesDB.ClassSave(classes);
TeacherDB.TeacherDelete(teacher);
TeacherDB.TeacherSave(teacher);
}
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);
}
}
