I am developing a reporting system for schools in asp.net and wish to integrate Timetable generation for teachers to help them in their daily schedules
I have 3 tables that supports timetable generation. The tables are
- WorkDay: Contains the days of the week that the teachers work in school. (Monday - Friday)
- LecturePeriods: The periods for a course. (Period 1 - 9.00am - 10.00am )
- Timetable: The table in which the above is referenced as foreign relationships. Subjects and Teachers are also foreign references.
Now I found a way to populate the Timetable table with all the required fields and even performed some validations on it without hassles. But the problem I have here is presenting the data in a table generated on an .aspx page. The number of rows in the table should be the same as the number of records in theWorkDay table and the number of columns should also match the number of records in theLecturePeriods Table while the subjects will be filled in the cells appropriately as it is in the database. Below lies the illustration I'm talking about.
|
|
9.00am – 9.30am
|
9.30am – 10.00am
|
10.00am – 10.30am
|
10.30am – 11.00am
|
11.00am – 11.30am
|
|
Monday
|
|
|
|
|
|
|
Tuesday
|
|
|
|
|
|
|
Wednesday
|
|
|
|
|
|
|
Thursday
|
|
|
|
|
|
|
Friday
|
|
|
|
|
|
I have searched the internet for a solution to this but didn't find any. I'm hoping one of you whiz-coders will help me out of this challenge. Many Thanks.