Help with RadScheduler and resources

1 Answer 125 Views
Scheduler and Reminder
Stephen
Top achievements
Rank 1
Iron
Iron
Stephen asked on 26 Oct 2021, 12:47 AM

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
Top achievements
Rank 1
Iron
Iron
commented on 26 Oct 2021, 01:17 AM | edited

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
Top achievements
Rank 1
Iron
Iron
commented on 26 Oct 2021, 01:28 AM | edited

I see the resources listed in the drop down.  Does 2020 R1 version support multiple resources instead of just "all"?
Stephen
Top achievements
Rank 1
Iron
Iron
commented on 26 Oct 2021, 02:11 AM

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

1 Answer, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 26 Oct 2021, 03:39 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
Scheduler and Reminder
Asked by
Stephen
Top achievements
Rank 1
Iron
Iron
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or