protected void Page_Load(object sender, EventArgs e)
{
/* Load all courses */
List <Course> allCourses = new List <Course>();
List <SchoolClass> allclasses = new List <SchoolClass>();
List <StudentEnrollmentEntry> allEnrollment = new List <StudentEnrollmentEntry>();
String dbConnectionString = ConfigurationManager.ConnectionStrings["SchoolLogicDatabase"].ConnectionString;
using (SqlConnection connection = new SqlConnection(dbConnectionString))
{
allCourses = Course.loadAllCourses(connection);
allclasses = SchoolClass.loadAllClasses(connection);
allEnrollment = StudentEnrollmentEntry.loadAllStudentEnrollment(connection);
}
/* Populate table */
tblCourses.Rows.Clear();
foreach (Course course in allCourses)
{
tblCourses.Rows.Add(addCourseTableRow(course));
tblCourses.Rows.Add(addClassTableHeaders());
int classCount = 0;
foreach (SchoolClass thisClass in allclasses)
{
if (thisClass.courseid == course.id)
{
/* Figure out student enrollment */
foreach (StudentEnrollmentEntry studentEE in allEnrollment)
{
if (studentEE.classID == thisClass.classid)
{
thisClass.enrollmentCount++;
}
}
tblCourses.Rows.Add(addClassTableRow(thisClass));
classCount++;
}
}
if (classCount == 0)
{
tblCourses.Rows.Add(addNoClassesRow());
}
tblCourses.Rows.Add(addEmptyRow());
}
lblClassCount.Text = allclasses.Count.ToString();
lblCourseCount.Text = allCourses.Count.ToString();
}
