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 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); }
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); } }
private void button1_Click(object sender, EventArgs e) { List <Teacher> TeacherList = TeacherDB.TeacherLoad(); Teacher teacher = TeacherDB.TempLoad(); int[] schedule = { 0, 0, 0, 0, 0, 0, 0, 0 }; List <int> teacherAvailability = new List <int>(schedule); for (int i = 0; i < chkListBoxPeriod.Items.Count; i++) { if (chkListBoxPeriod.GetItemChecked(i)) { teacherAvailability[i] = 1; } } Teacher newTeacher = TeacherDB.TeacherFind(teacher.TeacherID); newTeacher.Availability = teacherAvailability; TeacherDB.TeacherDelete(newTeacher); TeacherDB.TeacherSave(newTeacher); this.Close(); }