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();
}
