Completed

Employee Timetable using jquery, html, .NET

This project was successfully completed by salmanaim for €257 EUR in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
€30 - €250 EUR
Completed In
5 days
Total Bids
30
Project Description

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([url removed, login to view](0,4)), CInt([url removed, login to view](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/[url removed, login to view]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online