ASP.NET front-end website for MS SQL 2008 database

IN PROGRESS
Bids
25
Avg Bid (GBP)
£212
Project Budget (GBP)
£20 - £250

Project Description:
We need a simple ASP.NET website developing which allows customers to search for POD (proof of delivery) documents (tiff or pdf) that have been scanned into the database.

We have two SQL 2008 tables each of which contain consignment details and partial path to the file/directory. These are in a different formats as we are moving from one scanning system to another. I have attached sample data.

SourceDB1 is the new table format. The POD field contains the path to a PDF file containing the scanned PODs.
SourceDB2 is the old table format. The consSig field contains a path to a folder containing the scanned PODs in several TIF files. The ImageCount field shows the number of files.

We need a website that allows customers to logon and search for POD files using the following search fields:

1) Consignment number
2) Reference number
3) Invoice number
4) Date range (start and end date)

All this information is in the two SQL tables. We need the website to be able to search for PODs from both tables,

Results should be displayed in a grid showing:
1) Account number
2) Consignment number
3) Reference number
4) Invoice number
5) Collection Address
6) Delivery Address
7) Collection date
8) Delivery date
9) Link to POD.

Where there is more than one POD for a consignment, a pop up window should appear allowing the user to select which one to download/display.


We also need an admin page for the website where administrators can setup user logins for the site.

Each user login should have access to PODs from specific accounts so we need an admin page where we can assign accounts to different user logins. Administrators should be able to see PODs from all accounts.

We do not have a SQL table for user logins so that should be designed as part of this project,

Additional Project Description:
01/18/2013 at 16:37 GMT
Note - the website should be delivered to us as un-compiled ASPX / ASPX.VB / ASPX.CS files so we can make our own changes if needed.

Note - the consReference fields are long text stings that we need to search within. The consReference fields are setup with Full Text Indexing so we can use WHERE CONTAINS statements in SQL to search them.


01/20/2013 at 9:17 GMT
Note - The date search should be performed by a user selecting the Start Date and End Date of the search. This search should display PODs for all deliveries that were collected, delivered, or in progress during those dates.

Please see the attached DateSearch spreadsheet for details.


01/20/2013 at 9:18 GMT
Note - The date search should be performed by a user selecting the Start Date and End Date of the search. This search should display PODs for all deliveries that were collected, delivered, or in progress during those dates.

Please see the attached DateSearch spreadsheet for details.


01/20/2013 at 9:32 GMT
A user searches for all consignments between 01 Jan 2013 and 10 Jan 2013. They should see PODs for all the following deliveries.


Collection Date Delivery Date
Delivery 1: 30 December 2012 12 January 2013
Delivery 2: 03 January 2013 04 January 2013
Delivery 3: 29 December 2012 05 January 2013
Delivery 4: 07 January 2013 11 January 2013

Skills required:
.NET, ASP, HTML, SQL, Website Design
Additional Files: SourceDB2.xlsx SourceDB1.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 500
in 19 days
£ 250
in 14 days
£ 200
in 15 days
£ 240
in 16 days
Hire bldroid
£ 200
in 5 days
£ 250
in 8 days
Hire Codoc1010
£ 150
in 4 days
£ 200
in 10 days
Hire sinharavi
£ 180
in 12 days
£ 200
in 15 days