Very straight forward order screen needed for our customers. Our company sells Ice Cream and Store supplies to various ice Cream stores, Nursing homes and restaraunts. We want to give our customers a way to order on-line.
The data exists in our server which sql server database. We will write the stored procedures that will allow you to populate the screen with products and prices as well as the procedure which will except the ordered items and apply other charges.
The programmer needs to handle the following.
1. Allow the user to login. We will supply a stored procedure which evaluates user and password info. Then the stored procedure will return a product listing of products that have been ordered in the past as well as other products we offer and pricing.
2. The customer will enter qty's next to the items they order and a total will be calculated. Once the customer confirms the order they can print it if they'd like, and you forward the ordered items to our server through a stored procedure. The system will provide you an order number after the customer confirms their order.
3. Once the order is confirmed by the customer you will initiate the following stored procedures.
? ? ? ? a. Add Confirmed Order
? ? ? ? B. Add item to order (for each item and quanity.)
Once the order has been updated. The customer is thanked and taken out of the order screen. We email the customer with an order confirmation, that is done separately and not part of the project.
I will want you to write the necessary store procedures in sql server to interact with the system.
1. stored procedure for login to system
2. stored procedure to bring back previously ordered items and last price purchased.
3. stored procedure to insert new order to database.
we will provide all necessary log in information, table structures and will help test all results.
## Deliverables
* * *This broadcast message was sent to all bidders on Friday Mar 19, 2010 10:53:09 AM:
HI, Please reread project description for changes to the scope and resubmit your final bid. I will accept a coder today. The main change to the scope is the addition of the stored procedures to be written by the coder. Thanks