Employee Timetable using jquery, html, .NET

Develop a single employee timetable html page. Data is being extracted from database (Microsoft sdf file). Page may be developed in vbhtml/cshtml/asp combined with jquery to do async load. Easy styling using Bootstrap. For each day/employee the data contains a record. This data is being updated everyday in a SQL CE sdf file. Using .NET generate a json/xml. Load the dynamically data into the website using jquery. Year= Show current year Month selection= 1 to 12 Days= show day number(determine last day of month using code. for example: DateSerial(cint([login to view URL](0,4)), CInt([login to view URL](4,2)) + 1, 0) parMy = 201401 etc.) Using Month button: table is being updated async with the data of that month. Ensure a nice effect when data is being loaded. Using scroll button you are even able to see across a single a month Ensure nice flued scrolling. To determine which kind of timecode, use the column Code in the dataset( see excel file). User is being able to filter on codes(multiple select) user is also able to filter on employee(multiple select Sort on Departments and then on EmployeeName. Only show departmentname at the first employee and only show a department name again if the empoyee is from another department (like in a report) Show weeknumber according to EU Dutch format. Week starts on a Monday. Workingdays are from monday to friday. Weekend is saturday and sunday. Show vertical lines(grid) to show/split weekend. Must be visible for user. When a event code is the same over multiple days use one beam. Or make sure it looks like one beam. When a user clicks a beam open a modal and show record id, employeename and code (for future development) Datatype: id = int (PK,Identity) employeeName = varchar(100) Date = numeric(8,0) Code = nchar(1) Department = varchar(100) Ensure quick performance! Determine by yourself if you load all data in one time(+/- 5000 records) or load dynamically and use jquery do load more data later. Maybe you can do cashing. No full page refresh. Using jquery/AJAX to update the table! Show progress indicator when loading data. For styling use css. Website is being hosted on a IIS7.5 enviroment supporting MVC 4.0/ASP.NET