Show Bid Request
.NET/SQL Server Project Status Tracking App
Bid Request Id: 48869
|
|
|
Description:
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
Must be 100% finished and received by buyer on:
Mar 1, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$50 (USD)
|
Feb 20, 2003
4:15:42 AM EDT
|
9.84
(Excellent)
|
|
|
Hello,
I send attach with StatusReportBySystemPriority.aspx.vb, sp StatusReportBySystemPriority and Relations.jpg.
Coder SlavaTT spoke with you about me.
I have additional questions.
For work with MS SQL server you want to use stored procedures or SQL routine in VB code.
Example:
For addition of record in the table tblPriority to use:
1. exec tblPriority_add varPriority,varDescription
(varPriority=7
varDescription='Test')
with sp code
CREATE PROCEDURE tblPriority_add
[at]Priority int,
[at]Description text
AS
INSERT INTO tblPriority ( Priority,[Description])
VALUES ([at]Priority,[at]Description)
GO
2.
To use SQL routine in VB
SQL='INSERT INTO tblPriority (Priority,[Description]) VALUES (' & varPriority & ', ' & varDescription & ')
Thanks,
Nikolay
|
|
|
Attached File
|
|
|
|
|
|
