• 0

[ASP.NET/SQL] track record


Question

I have a database with the Employees' information, I want them to be able to log on to the site and record how many hours they've worked during the day. I want to be able to see the total number of hrs each employee worked for a certain number of days, i.e. a week. Any ideas on how to do that?

I'm using VS2008 and SQL Server 2009. I've added a GridView control, went to Tasks and added a hyperlinked "Details" column to view each Employees' details. Is there a similar way for input data, perhaps?

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Log on / sessions is easy in asp.net there are built in controls to do it or for you, so don't worry about that

re: the table to input data, without much more to go on.. perhaps..

1. Create a table to hold the dates and which ones are working days / holidays / weekends etc

2. When the page loads, utilise the current date to work out what the current week is, and flag/colour any days(cells) that are not working days

3. Populate the grid with already submitted (saved) data from the database

4. This depends on how/where you want to see the total time..

this is potentially quite a large task, and could be quite tricky to get right..

p.s. it's sql 2008 ;)

Link to comment
Share on other sites

  • 0

haha, this is tough, been trying at it...

i made a table with DateID, DayofWeek, Hours, and Time, created an object adapter. I have an Hours column for input (if possible) and timestamp to record the time of writing the numbers of hours. Don't know if that approach is near correct. Ideas?

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.