Availibilty Calendar

I have a requirement to display the availibilty of multiple units, the reservation dates of which will be held in a MS SQL Database. There will be 3 categories to display within the calendar referenced by individual colours. I wish to display the availibilty of the units individually in a Table Calendar with the reserved dates displayed as an alternative colour to the non reserved dates and dates when the status is unknown. I will also need to display the start and end dates of each reservation in an alternative manner. I require that the calendar will also be used to record multiple new reservations by way of selecting the start and end date of the new reservation on the calendar, which will then be passed to the MS SQL database.