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)
);
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
When I set the ResourceID to the foreign key for the mapping table and try to save a new record I get below: