.NET/SQL Server Project Status Tracking App

I have a SQL Server 2000 database that contains a couple of tables. The tables are: tblCategory - Reference table for Category field in tblProject. tblNonAvailableReason - Reference table for Reason field in tblNonAvailableTime. tblNonAvailableTime - Data table containing information related to why resources are not available such as vacation etc. tblPhase - Reference table for Phase field in tblProject. tblPriority - Reference table for Priority field in tblProject. tblProject - Data table containing information related to projects. tblProjectStatus - Data table containing a historical account of project status values. tblResource - Data table containing information related to available resources. tblResourceAllocation - Data table containing a list of projects from tblProject and their assigned resources from tblResource. Each record has a BeginDate and EndDate of allocation that forms part of the key as well as Actual and Estimated time values. tblSystem - Reference table for the System field in tblProject. The idea is to keep track of and report on resource allocation for different projects together with hours of availability. I have ported the tables to an Access 97 database which can be found in the attached ZIP file. The ZIP file also contains a backup of the actual SQL Server 2000 database. If you have SQL Server, simply restore the database. To make transition easier, create a system DSN named "ResourceReport" that points to your data source, be it Access or SQL. That way it will match up with our system on this side. The scope of this project is to create a few simple input forms for data update and a couple of report forms for output. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) Code to be based on ASP.NET in ASPX format developed with VB.NET. 5) The following INPUT forms are required: a. Form to provide the Add/Update/Delete capability for the tblCategory reference table. b. Form to provide the Add/Update/Delete capability for the tblNonAvailableReason reference table. c. Form to provide the Add/Update/Delete capability for the tblPhase reference table. d. Form to provide the Add/Update/Delete capability for the tblPriority reference table. e. Form to provide the Add/Update/Delete capability for the tblSystem reference table. f. Form to provide the Add/Update/Delete capability for the tblNonAvailableTime data table. g. Form to provide the Add/Update/Delete capability for the tblProject data table. h. Form to provide the Add/Update/Delete capability for the tblProjectStatus data table. i. Form to provide the Add/Update/Delete capability for the tblResource data table. j. Form to provide the Add/Update/Delete capability for the tblResourceAllocation data table. 6) Should provide the ability to navigate to any one of the aforementioned screens. 7) The logical flow should be when entering data on the tblProject to take the user to the tblResourceAllocation screen automatically. Upon completion of this screen, the user should be taken to the tblProjectStatus update screen. 8) The following report forms should be provided: a. Report on projects with all fields as filterable criteria. b. Status report showing project info as well as the status history from the tblProjectStatus table with the option of selecting the number of historical entries to display i.e. the user can choose 1 and only get the latest status on the report. c. Allocation report showing time available and consumed by either resource or project depending on the user selection. The basic calculation asumes 7 hours per day Monday through Friday which would leave the system to calculate the total available time for the given/selected date range while subtracing any time found in the tblNonAvailableTime table from the total. ## Platform Windows 2000 Server IIS IE 5.5 + ASP.NET VB.NET