Finalize a user control that selects product from a products MSSQL database. The table in the database is already create. The layout of the controls on the user control is already made. The selection of products is based on user inputs.

The products are "greenfees" (golf course tickets), and the sellers of these are Golf clubs.

The database contains some golf clubs and the greenfees that they want to sell.
The golf club details in the database are zip code, address, name, etc.

The regions on the map must represent a spand of zip-codes. These I will specify - for instance one region could be zip-codes from 6000-6999.

The greenfees for sale are time specific. For instance must be used on a specific date, on a specific time of the day. For instanse between 08.00 21/5-2010 and 14.00 21/5-2010. The greenfees are listed with a start and end date containing number of hours on the given day.


The filtering controls are:

• A graphic map of Denmark with five regions. Mouseover on region makes it change color, and change color on selection.
• Two calender controls to specify time a spand
• Time specification in a dropdown with "before x", "between x and y", "later than x"
• A checkbox that indicates the type of golf course (two options).
• A dropdown of Golf clubs (Bane) that must be filled based on the selection of region on the country map, and can be selected for filtering offers related to a specific golf club

The user control must be able to run on Umbraco and therefore must be applicable to the 2.0 framework.

Some additional information:
The database tables and fields does have English names.
The code already writen is in English also.