Business Process (This section provided for background. You just need to create a page that calculates the charge after a car was returned. You do not need to open a invoice, save it and then later on edit it to add the final mileage etc.)

1. Campus employees currently call to reserve a vehicle. The employee records the check-out date, return-date and type of vehicle needed.

2. The motor pool employee then does a manual calculation of the cost and provides a price quote and notice of reservation.

3. On the day the vehicle is picked up, the motor pool employee and the driver do a walk around the vehicle to check for damage, the starting mileage is recorded, then they give the paperwork and keys to the renter

4. On the day the vehicle is returned, the motor pool employee and the driver do a walk around the vehicle to check for damage, the ending mileage is recorded, then they return the keys.

5. A final invoice is drawn up, saved to the motor pool system, and sent to the renter's department. The final cost is based on the # days (which may be different than requested in the reservation process) rental, the mileage driven, and any special expenses (such as extra cleaning, minor accidents, etc.)

6. Keep a running total of the number of reservations. Show this in a label or textbox.

For this version of the program we will not use a database, and a reservation and invoice close out process. For this version of the program just make a program that is to be used when the car is returned. We will return to this later to add the extra functionality of editing a database record.

System Requirements

1. When the requesting WSU authorized driver is returning a vehicle they should receive an invoice for the cost which is based on # days driven and mileage. The motor pool rents out three different cars, 4-door sedan ($30 per day), 8 passenger van ($70 per day), and 3/4 ton pick-up truck ($80 per day). Use two calendar controls or two textboxes in datetime mode to count the number of days and perform the calculations. The charge is per day, you do not have to calculate partial day costs.

2. When the invoice is made the cost should be shown in a nicely formatted manner so that the departmental administrator can check their budget and prepare payment.

3. The cost of the rental is

a) the daily cost of the vehicle

b) The motor pool also charges a flat .25 cents per mile the vehicle accrues. So you will need to record the mileage when the car is picked up and returned.

c) additional charges for damage may be charged.

Add Data Structures to the Auto Reservation System

The previous assignment had you create a program that can calculate the charge for renting a WSU vehicle from the motor pool. In this assignment you take that prior work and extend that program such that it can store records of data, which are estimates for the rental of a WSU vehicle. This is an intermediate step in the functionality of this program.

Requirements:

1. Add a datatable to your webpage called dtReservations. Each reservation estimate will be saved as a new row in this table. Start with an auto-number field called ReservationID which has the datatype integer.

2. Add other fields as necessary to record the details of the reservation estimate. The scenario is that you are inserting a row of data that records the estimate for the vehicle rental, when it is reserved. The dollar estimate is based on the daily cost for the vehicle, and mileage charge. Have a column RentalPrice which is numeric (10,2).

3. Write code that saves new rows into the data structure. After the record is saved to the data struture, show the one row of data in a gridview on the ASP.NET webpage.

5. Write different update procedures to keep track of business operations, such as number days each category of vehicle was rented, revenue gained from each type of vehicle rented, etc. In each case update a data table and display the updated data in a gridview.

As an emerging designer, you are asked to consider the business needs of the WSU motor vehicle and deliver different functionality. Higher grades for more thoughtful, and elaborate systems.