private void btnDelete_Click(object sender, EventArgs e) { if (lblSelected.Text == "") { MessageBox.Show("Please select a class to delete"); } else { Classes newClasses = new Classes(); int classNum = Convert.ToInt32(lblSelected.Text); newClasses.ClassID = classNum; ClassesDB.ClassDelete(newClasses); List <Teacher> teacherList = TeacherDB.TeacherLoad(); foreach (Teacher teacher in teacherList) { foreach (int classid in teacher.ClassID) { if (classid == newClasses.ClassID) { teacher.ClassID.Remove(classid); TeacherDB.TeacherDelete(teacher); TeacherDB.TeacherSave(teacher); } } } RefreshTable(); } }
public static void PeriodConstructor(int totalTeachers, int maxClassSize) { //Find teacher availabilty to determine max classes per hour (store in a list that is zero indexed) //Take the number of teachers and the desired class size and use that to determine the number of classes each hour List <Teacher> TeacherList = TeacherDB.TeacherLoad(); List <int> AvailableSlots = new List <int>(); //For loop gains total number of available slots, zero indexed foreach (Teacher teacher in TeacherList) { for (int i = 0; i < teacher.Availability.Count; i++) { if (teacher.Availability[i] == 1) { AvailableSlots[i] += 1; } } } //Start with first class in the list, place the remaing x number of compatible classes List <Schedule> Schedules = ScheduleLoad(); //Move to 2nd Period, place next classes }
private void RefreshTable() { dataGridView1.Rows.Clear(); dataGridView1.Refresh(); List <Teacher> teacherList = new List <Teacher>(); teacherList = TeacherDB.TeacherLoad(); dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "Teacher ID"; dataGridView1.Columns[1].Name = "First Name"; dataGridView1.Columns[2].Name = "Last Name"; foreach (Teacher teacher in teacherList) { string[] row = new string[] { teacher.TeacherID.ToString(), teacher.FirstName, teacher.LastName }; dataGridView1.Rows.Add(row); } int id = 0; foreach (Teacher teacher in teacherList) { if (teacher.TeacherID >= id) { id = teacher.TeacherID + 1; } } teacherIDLabel1.Text = id.ToString(); }
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); } }
private void SchedulePlan_Load(object sender, EventArgs e) { List <Classes> ClassList = ClassesDB.ClassLoad(); List <Teacher> TeacherList = TeacherDB.TeacherLoad(); List <Student> StudentList = StudentDB.StudentLoad(); txtClasses.Text = ClassList.Count.ToString(); txtStudents.Text = StudentList.Count.ToString(); txtTeachers.Text = TeacherList.Count.ToString(); txtErrors.Text = "3"; txtClassSize.Text = "10"; //Needs to be set based on a formula (Total Teachers, Periods, Classes and Students) int classSize = Convert.ToInt32(txtClassSize.Text); double classesPerHour = StudentList.Count / classSize; txtClassesPerHour.Text = classesPerHour.ToString(); }
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(); }