Hello,

I was wondering whether it's possible to create a booking request using the COM API. Basically, I would like to reproduce the behaviour of the roombooker application, so that a user can fill in a request to book a room, and then this request would appear to the administrator (through the celcat client).

Thanks for your help !

Matthew

Hi Matthew

The status is actually an attribute of the booking (CT_BOOKING table).

To make a booking you would need to:

1. insert a row in CT_BOOKING
2. Optionally insert row(s) into CT_BOOKING_REQUIREMENT to specify the room(s) required (if known)
3. Insert row(s) into CT_BOOKING_SLOT - one for each of the time slots required by the booking
4. Create an event and add the event reference to each slot

If you want to add a room booking request to an exsting event, you just need the first 3 steps.

This is a much simplified and high-level view of the operation and I'm sure there are lots of subtleties along the way. Needless to say, if you attempt this don't work on live data!

Rgds
Antony