Automobile type website, ASP.net? based and SQL server Database. I would like to have for (4) main pages:
?
1- web form used to enter car's information into database including uploading pictures.
2- display car information page, includes car details and pictures (9 pictures). ([[login to view URL]][1] can be used as example)
3- inventory search? page.? search criteria should be easier, such as vehicle type (cars, trucks, SUVs,...), and year.
4-search result display page. 20 items per page with a small picture of the vehicule in the left side.
vehicle information (fields in database)
Vehicle? info table
----------------------
-stock # (primary key)
-make
-model
-year
-transmition
-exterior color
-interior color
-engine size
-# of cylinders
-mileage
-body style
-vin #
-price
-fuel type
-description
Vehicle Options table
---------------------------
Stock #
option
(vehicle Options will be a radio check buttons where the user can choose any number he wants. the result must be stored in the vehicle options table each option as new entry.)
Vehicle pictures table
---------------------------
stock#
picture name
vehicle info table is linked to vehicle options and vehicle pictures by one to many relation. (one vehicle may have many options and many pictures)
the code must be working and testable. it must be easy to include in any webpage.
i would like this project to be done ASAP.