In Progress

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

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,

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.

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.

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.

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: .NET, ASP, HTML, SQL, Website Design

See more: sql 2008, sql pdf files, sql pdf file, project front page design sample, developing website using php, data front, website, search for search for, net developing, ms access 2013, invoice front, Front end website , front end database design, path pdf, database design sample, using front end project, php sql pdf, project database design pdf, website front end design, grid invoice php, sql front end design, design simple sql, sql search asp, login front end, net pop table

About the Employer:
( 18 reviews ) Oldbury, United Kingdom

Project ID: #4139708

Awarded to:


Expert .NET developer with experience building POD systems.

£200 GBP in 5 days
(21 Reviews)

23 freelancers are bidding on average £210 for this job


have a glance at Pm. regards, shmai

£500 GBP in 19 days
(211 Reviews)

Thanks for the invite, here's our bid.

£250 GBP in 14 days
(24 Reviews)

Hi, .Net and Web Application expert here. Please have a look at private mesaage for details. Thanks

£200 GBP in 15 days
(50 Reviews)

We know that we are new to freelancer but not in this industry. You can see our previous works in the inbox message and decide for yourself. You would have the best professional work possible. Look forward to discuss f More

£240 GBP in 16 days
(15 Reviews)

Hi, I am a C# and SQL Server developer with plenty of experience under my belt.

£250 GBP in 8 days
(28 Reviews)

Hi, my team has many expert programmers on .NET framework, C++, Sql Server 2005/2008. I sure, we can do your job on time with high quality. Please view my message for detail. Thanks!

£150 GBP in 4 days
(18 Reviews)

Hi i am the expert of ASP .NET , PHP , Photoshop & HTML/CSS and i have 3 years experience. ************************************************************** Please check my shopping cart website in ASP .NET in the fo More

£200 GBP in 10 days
(33 Reviews)

Please read my private message

£180 GBP in 12 days
(19 Reviews)

Please, See my private Message.

£200 GBP in 15 days
(3 Reviews)

Dear Sir / Madam, We have more than 10 years of experience in IT Field and more over We have handled projects in various domains such as Trading, Manufacturing, Health care Management. I was associated with top c More

£250 GBP in 10 days
(2 Reviews)


£149 GBP in 8 days
(26 Reviews)

We are looking forward to work with you and we guarantee an extraordinary result in less than anticipating time.

£240 GBP in 10 days
(2 Reviews)

Hi, I have 5 years of web development exp in, SQL, MySQL. Pls consider

£120 GBP in 20 days
(3 Reviews)

Hi, I have good expertise in .NET. I can do this. Ready to start now. Thanks.

£150 GBP in 2 days
(9 Reviews)

Hi, I am expert in can do this job easily for you.

£100 GBP in 6 days
(4 Reviews)

Hi, Experts are here to help you. We are into this business from last fifteen years. We have done similar projects in past and will deliver it within given time and amount. Please see PMB.

£220 GBP in 14 days
(1 Review)

We have gone through your requirement and would happy to share that Project is very much in line with our technical strength and ability. We have developed almost similar sites before and I encourage you to kindly ch More

£90 GBP in 15 days
(1 Review)

I have very good knowledge and working experience in dotnet.

£100 GBP in 1 day
(3 Reviews)

Hi, We have a team of 06 developers who are expert in java with minimum 03 years to 8 years experience. We have good experience in Object Oriented commercial Software Design and Software Development. We are resul More

£200 GBP in 20 days
(1 Review)

Experienced developer at service. Our details are attached. Like to do this project. Lets do it.

£100 GBP in 14 days
(1 Review)