Help with RadScheduler and resources

[Stephen]

I'm trying to understand and add a RadScheduler to my winforms app that has resources available.  I'm having issues trying to get the resources working.

First item, are the below tables being create correctly (Oracle DB backend using entity framework)?

CREATE TABLE APP_APT_SCHED
(
AAS_ID  RAW(16) default SYS_GUID(),
AAS_START  TIMESTAMP(0),
AAS_END   TIMESTAMP(0),
AAS_SUMMARY  NVARCHAR2(1000),
AAS_DESC  NVARCHAR2(1000),
AAS_LOC  NVARCHAR2(1000),
AAS_VISIBLE  NUMBER(1),
AAS_ALL_DAY  NUMBER(1),
AAS_ALLOW_DEL  NUMBER(1),
AAS_ALLOW_EDIT  NUMBER(1),
AAS_BACKGRND  NUMBER(10),
AAS_STATUS  NUMBER(10),
AAS_RECUR  NVARCHAR2(2000),
AAS_RECUR_ID  NVARCHAR2(2000),
AAS_EXCEPT  NVARCHAR2(2000),
AAS_REMINDER  NUMBER(10),
CONSTRAINT PK_APP_APT_SCHED PRIMARY KEY (AAS_ID)
);

CREATE TABLE APP_APT_SCHED_RES
(
ASR_ID  RAW(16) default SYS_GUID(),
ASR_RESOURCE  NVARCHAR2(100),
ASR_VISIBLE  NUMBER(1),
CONSTRAINT PK_APP_APT_SCHED_RES PRIMARY KEY (ASR_ID)
);

CREATE TABLE APP_APT_SCHED_RSCMAP
(
ASM_ID  NUMBER(38),
ASM_AAS_ID  RAW(16),
ASM_ASR_ID  RAW(16),
CONSTRAINT PK_APP_APT_SCHED_RSCMAP PRIMARY KEY (ASM_ID),
CONSTRAINT FK_ASM_AAS FOREIGN KEY (ASM_AAS_ID) REFERENCES APP_APT_SCHED (AAS_ID),
CONSTRAINT FK_ASM_ASR FOREIGN KEY (ASM_ASR_ID) REFERENCES APP_APT_SCHED_RES (ASR_ID)
);

[Stephen]

Are the below mappings correct, schedule:

 

The above ResourceID I'm confused on what's it's supposed to be, currently it's an old field I use to have.

Mapping for resource

[Stephen]

I see the resources listed in the drop down.  Does 2020 R1 version support multiple resources instead of just "all"?

[Stephen]

When I set the ResourceID to the foreign key for the mapping table and try to save a new record I get below:

[Dess | Tech Support Engineer, Principal]

Hello, Stephen,

As of R1 2021 the EditAppointmentDialog provides UI for selecting multiple resources per appointment. In certain cases (e.g. unbound mode), the Resource RadDropDownList is replaced with a RadCheckedDropDownList. Otherwise, the default drop down with single selection for resources is shown. To enable the multiple resources selection in bound mode, it is necessary to specify the AppointmentMappingInfo.Resources property. The Resources property should be set to the name of the relation that connects the Appointments and the AppointmentsResources tables.

I would recommend you to have a look at the following data binding tutorial which offers a complete solution in C# and VB.NET at the end of the article:

https://docs.telerik.com/devtools/winforms/knowledge-base/scheduler-databinding-tutorial 

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik