Show Bid Request
Online Quotation System
Bid Request Id: 12678
|
|
|
|
Posted by: |
Oliver (0 ratings)
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Apr 4, 2002
7:32:20 PM EDT
|
|
Bidding Closes: |
Apr 7, 2002
6:00:00 PM EDT
|
|
Viewed (by coders): |
514 times
|
|
Deadline: |
4/9/2002 6:00:00 PM
TIME EXPIRED
|
|
|
|
|
Description:
I need a coder to complete a project for me in a very short space of time! I am desgining a web site (for a college project) that allows users to attain quotes online. These quotes are are for coach journeys within the UK, and their prices vary according to the number of passengers travelling and the whereabouts of their destination.
Using ASP, these prices must be calculated. If a user then chooses to submit their quote, it will be written to tables in an access 2000 database, where it will be stored.
Existing customers should be quoted a price inclusive of a 10% discount on provision of their customer number, as well as their date of birth (for verification)
The back office database should be fairly simple, holding two tables. One of the tables relates to the customers details. The other for any quotes that the company has received.
I have a set list of requirements that would need to be adhered to, should any coders wish to take up this project for me. Unfortunately, I am really pushed for time. The project would need to be completed and returned to me within 48 hours of commencement.
Apart from the ASP pages, I have written some HTML pages for the company website using Microsoft Front Page 2000. Therefore, I would need the coder to produce the ASP coding as well as the link to the database. I would also be grateful for the instructions to implement the new system on my computer, in order that I can run the program with Microsoft Personal Web Server.
If any information is obscure, or queries arise, I will be happy to discuss them.
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Complete copyrights to all work purchased.
There are three main areas for ASP Development, and then an area that is concerned with the database.
FIRST ASP PAGE "Newcustomer"
Enter Surname (max 20 chars)
Enter Forenames (max 25 chars)
Enter Date of Birth (max 10 chars(format:dd/mm/yyyy)
Enter Telephone number (max 15 chars)
Enter Email address (max 35 chars)
There should be a button to submit these details.
The user should be prompted to input details if any text boxes are left blank.
Ideally, if an existing customer enters their personal details, the system should inform them that they match those already on the system and prompt them to access the 'Existing Customer' Page instead. This could be done by the error message "It appears that you are already registered as a customer. Please select 'Existing Customer' in order to log in"
Submission of valid personal details should bring up the 'Quotation' page.
Second ASP Page "Existingcustomer"
Enter CustomerID (random number generated by database)
Enter Date of Birth (format:dd/mm/yyyy)
Entering the users security details should cause the system to acces the database, so that the customer can be verified. If the customer is not recognised, the error message "Incorrect security details. Are you definitely an existing customer. If so, please contact the company or try again. If not, please register as a 'New User'".
Valid submission of security details should take the user onto the 'Quotation' Page.
Third ASP Page 'CustomerQuotation'.
This is probably the most detailed part of the site. Firstly, it should be pointed out that those who registered as a 'New Customer' should be quoted full price and those who were an 'Existing Customer' should be quoted a 10% discount. This is meant as an incentive for repeat business (but does complicate matters!)
The customer should be asked how many passengers will be travelling in their party. A drop down list should present 3 options (1-16, 17-33 or 34-49). The importance of these options will be mentioned soon.
Then, they should pick their departure point. They should be presented with the option of either South Shields Keppel Street, Sunderland Park Lane or Newcastle Gallowgate. These options should also be in the form of a drop down list, but this selection is for company use only and will not have any bearing on the journey price.
Next the user will choose their destination. This will be EITHER the town they are travelling to, or the county. This will require two drop down boxes, but only ONE of these can be selected for the calculation of the quote. Each destination should be assigned a value (either A,B,C,D,E or F) according to its distance.
The next step is to calculate the quote.
If the number of passengers is 1-16 the value is 50.
If the number of passengers is 17-33 the value is 80.
If the number of passengers is 34-49 the value is 100.
This value is multiplied by either distance A(2), B(3),C(4), D(5), or E(6). This gives a total price per trip in £GBP. For example, 12 passengers travelling to a destination with distance C would be 50*4 = £200GBP.
Selection of Distance F would be to travel abroad, thus subject to negotiation. A message should appear in this case advising the user to contact the company.
Please note that a full list of all the cities and counties to be used will be sent to the chosen coder by e-mail (there are at least 200 places).
A quote price will then be displayed and the if the customer accepts it, the quote details and thier customer number will be submitted to the quote table on the database.
The database to run alongside will be fairly simple. Due to lack of space, the requirements of the database can also be sent via email. Hopefully this system will not be as complicated to build as I have made it sound!
Platform:
Must run on Windows 1998, using MS Access 2000, MSInternetExplorer5, FrontPage 2000, using VBscript for ASP.Compatibility with PWS is essential as the project is to be demonstrated on a laptop.
Must be 100% finished and received by buyer on:
Apr 9, 2002 6:00:00 PM 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.
Special Conditions / Other:
2 days may be highly optimistic, but time is a major constraint as the project must be completed in its entirety for wenesday 10th April 2002.
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 |
|
|
|
|
|
$75 (USD)
|
Apr 4, 2002
10:23:04 PM EDT
|
9.73
(Excellent)
|
|
|
Hello!
If you accept it by 12PM Friday EST, you will have it by your deadline date. Please dont forget to checkout my ratings...I have deep experience in ASP and Access. I really hope to work with you. Lets get in touch.
Regards,
Zaid Farooqui |
|
|
|
|
|
|
N/A
|
Apr 4, 2002
10:40:42 PM EDT
|
9.73
(Excellent)
|
|
|
I am truly waiting to hear from you! I have read complete requirements and am confident that I can get through this on TIME! Thanks!
--Zaid Farooqui |
|
|
|
|
|
|
N/A
|
Apr 5, 2002
2:14:27 PM EDT
|
9.73
(Excellent)
|
|
|
| Waiting to begin the project! |
|
|
|
|
This bid was accepted by the buyer!
|
$60 (USD)
|
Apr 5, 2002
2:20:53 PM EDT
|
9.73
(Excellent)
|
|
|
Here you go!
Lets get started. |
|
|
|
|
|
|
N/A
|
Apr 5, 2002
2:29:21 PM EDT
|
9.73
(Excellent)
|
|
|
| Waiting for the details...I will get started immediately. |
|
|
|
|
|
|
Cyquester Technologies</a><img src=