Wheels For Hire
Home
Customer
Add a new Customer
Edit a customer
Bicycle
Bicycle Rentals
Add a Bicycle to Database
Order Bicycle into Stock
Edit a Bicycle
Scooter
Scooter Rentals
Add a Scooter to Database
Order Scooter into Stock
Edit a Scooter
Sales
Product Sales
Add a Product to the Database
Order a Product into Stock
Edit a Product
Reports
Product Sale Search by Date
Bicycle Rental Report by Date
Scooter Rental Report by Date
Customer Search
Delete
Delete a Customer
Product Sale Report by date
SELECT productId, productName , unitCost, stock FROM productType;Resource id #7
Bicycle Pump 5.99 The stock Levels are: 11
Scooter Pump 22.22 The stock Levels are: 23
Drinks Bottle 6.99 The stock Levels are: 11
Shox Sniper Solid Motorcycle Helmet 27.99 The stock Levels are: 16
Leather Vented Motorcycle Gloves 29.90 The stock Levels are: 4
Dri-Seat Waterproof 6.99 The stock Levels are: 18
Full Finger Bicyclin 12.99 The stock Levels are: 25
Digital Speedometer 7.99 The stock Levels are: 35
Bike Light Set 17.98 The stock Levels are: 20
Air Rocket Cycle Pump 60.00 The stock Levels are: 0
Date From:
Date To: