Angus Cheung
Top achievements
Rank 1
Rank 1
Angus Cheung
asked on 22 Jun 2010, 12:43 PM
Hi,
I have a scenario here which I would like to make it to a booking form in the scheduler.
Basically, I want to create bookings which I can choose the room, time and equipment needed.
While there are limited number of rooms to choose from, there could be an infinite number of equipment I have to pick for each booking, e.g. sometimes I only need 1 piece of equipment, but other times I may need hundreds or even more.
I am thinking to have 2 datatables which are related to one another, but I am having problem binding 2 datatables in scheduler datasource with save and update avaiable.
Examples:
Appointment 1:
Room Time Equipment
A 16:00-17:00 Chair
Computer
Project
desk
Printer
Appointment 2:
Room Time Equipment
B 13:00-17:00 Ruler
Pencil
Microphone
I have a scenario here which I would like to make it to a booking form in the scheduler.
Basically, I want to create bookings which I can choose the room, time and equipment needed.
While there are limited number of rooms to choose from, there could be an infinite number of equipment I have to pick for each booking, e.g. sometimes I only need 1 piece of equipment, but other times I may need hundreds or even more.
I am thinking to have 2 datatables which are related to one another, but I am having problem binding 2 datatables in scheduler datasource with save and update avaiable.
Examples:
Appointment 1:
Room Time Equipment
A 16:00-17:00 Chair
Computer
Project
desk
Printer
Appointment 2:
Room Time Equipment
B 13:00-17:00 Ruler
Pencil
Microphone
1 Answer, 1 is accepted
0
Hi Angus Cheung,
Thank you for writing.
The many-to-many relation that you want to incorporate in your scenario should be supported by three tables, but not by two. For additional information about such a scenario, please refer to our documentation. These three tables will allow you to add many resources to one appointment. In addition, you should replace the default EditAppointmentDialog with a custom one, because the default dialog does not allow the user to select more than one resources for an appointment. Basically, the idea is to use a checked list box instead of a combo box to display a list of the available resources.
I hope that this will help you. If you have additional questions, feel free to ask.
Sincerely yours,
Dobry Zranchev
the Telerik team
Thank you for writing.
The many-to-many relation that you want to incorporate in your scenario should be supported by three tables, but not by two. For additional information about such a scenario, please refer to our documentation. These three tables will allow you to add many resources to one appointment. In addition, you should replace the default EditAppointmentDialog with a custom one, because the default dialog does not allow the user to select more than one resources for an appointment. Basically, the idea is to use a checked list box instead of a combo box to display a list of the available resources.
I hope that this will help you. If you have additional questions, feel free to ask.
Sincerely yours,
Dobry Zranchev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items