SQL based timesheet system

Design and code a timesheet system for a small consulting company using SQL 2008 as the back-end and .NET for the client web interface. ## Deliverables **Business background and requirements** Develop for IT consultancy, whose works falls into 2 main categories ·? ? ? ? ? ? ? ? Time based consulting, where clients are simply charged an hourly rate for consultant time ·? ? ? ? ? ? ? ? Pre-paid support agreements, where a number of hours is purchased up-front, and the support work is completed as required ? The goal for this engagement is to obtain a database driven time-sheet application which will allow for strong reporting on many details of client and consultant time. **? ** ****Back-end**** Database: SQL 2008 Web Server: IIS7 Must work when reverse published via ISA 2006 ? **Interfaces** Web only ? **Compatibility** Windows 2008 x64 and IIS7 (server-side) IE 6, 7, 8, Mozilla Firefox 2, 3 (client side) ? **Source Code** All source code will be delivered to us as part of the project ? **Security** AD-integrated auth (for consultants),? internal authentication (clients) ? **Support** Bug fix support must be provided for a minimum of 3 months after delivery A quote for on-going support and minor upgrades should be included separately ? **Languages** .NET Framework ASP.NET preferred **Functionality** Administration ·? ? ? ? ? ? ? ? Add/Remove/Modify Client list ·? ? ? ? ? ? ? ? Add/Remove/Modify project list (as part of client list) ·? ? ? ? ? ? ? ? Add/Remove/Modify Consultant list ·? ? ? ? ? ? ? ? Final approval of consultant submitted timesheet, tickbox to allocate hours to support agreement ? Consultant ·? ? ? ? ? ? ? ? Add timesheet for current week ·? ? ? ? ? ? ? ? Review previous weeks ·? ? ? ? ? ? ? ? View status of annual leave/sick leave, utilisation etc ·? ? ? ? ? ? ? ? Reporting o? ? Client support agreement status o? ? Client work history o? ? Client job history o? ? Consultant work history ? Manager ·? ? ? ? ? ? ? ? Approve timesheets of staff ·? ? ? ? ? ? ? ? Mass import of time via csv and/or excel import (with data integrity check) ??" must allow multiple csv’s/xls’s to be selected at once o? ? When an import is performed and the client name does not match any known clients, the user should be prompted to §? Create a new client or §? Select an existing client from a drop down list o? ? Mass import functionality is required as a once off only ??" therefore it is not vital that this is incorporated into the main application, it may be an additional small program ? Clients ·? ? ? ? ? ? ? ? View report of work carried out over the previous x days/months/years ·? ? ? ? ? ? ? ? View remaining time left on support agreements ? General ·? ? ? ? ? ? ? ? Option to email o? ? Consultant with timesheet reminders o? ? Consultant with timesheet modified by manager notification o? ? Clients with support agreement summary link ·? ? ? ? ? ? ? ? When entering time, consultants must be forced to enter time in 15 minute (.25 hour) increments (eg 8:00, 8.25, 8.5 etc) ·? ? ? ? ? ? ? ? All configuration information should be stored in the SQL database where-ever possible ·? ? ? ? ? ? ? ? The entire application disaster recovery scenario should involve only the backup/restore of the application database (one SQL connection string within the application is acceptable) ? Reports ·? ? ? ? ? ? ? ? General report, has checkboxes for client and consultant, and from/to date range ·? ? ? ? ? ? ? ? Client viewable reports o? ? Client support agreement summary ??" no parameters o? ? Client work review ??" date range filter available, but all shown by default ·? ? ? ? ? ? ? ? Consultant reports o? ? Consultant summary ??" Shows employment data such as commencement date, salary, address etc. Also shows calculated fields such as sick leave remaining, annual leave remaining, last weeks timesheet, utilisation o? ? Consultant work filter ??" Shows timesheet data with filters for Client and date range o? ? Can also view support agreement summaries from “client reports?? ·? ? ? ? ? ? ? ? Manager reports o? ? All reports specified above o? ? Utilisation summary ??" view utilisation, consultant and date range filters available o? ? Client job summaries ??" filter by client, open/closed, date range Example SQL table structure attached. This project is being completed for an IT infrastructure consultancy, and as such, we recognise that our requirements and example database structure will need to be fleshed out and modified by experienced programmers. The first part of this engagement will involve taking? the information listed above and clarifying these requirements. * * *This broadcast message was sent to all bidders on Wednesday Jun 24, 2009 7:33:28 AM: Hi all coders and thanks for bidding on my project. Due to unforseen cirumstances, im going to be putting this project on hold (hopefully temporarily). I'd like to thank you all for bidding - and let you know that i appreciate the work you put into your bids. I hope that i will be able to un-hide this project and choose a bidder in the coming weeks and/or utilise the obvious pool of talent here for projects in the future.