Schedule Control Recurrence Rule Default Render Prevent Based on Recurrence Rule

[Mayank Patel]

We are Creating One Functionality where user can create recurrence Appointment.

for that we had create one Table in Database ,Id(increment),StartDate,EndDate,Subject,RecurrenceRule,RecurrenceId

For Example,

If User first create one Appointment with the following settings

FREQ=DAILY;INTERVAL=1;UNTIL=20191005T080703Z

In Database We Find Dates Between Date and Store each date Separate Appointment.

Now when We load data and pass to scheduler control Datasource 

 {

            Id: 1,

            Subject: 'Appointment1',

            StartTime: new Date(2019, 09, 21, 9, 30),

            EndTime: new Date(2019, 09, 22, 11, 30),

            IsAllDay: false,

            RoomId: 1,

            RecurrenceRule: "FREQ=DAILY;INTERVAL=1;UNTIL=20191005T080703Z;",

            RecurrenceStartDate: new Date(2019, 8, 2, 9, 30),

            RecurrenceEndDate: new Date(2019, 8, 2, 9, 30)

        },

       

        {

            Id: 2,

            Subject: 'Appintment2',

            StartTime: new Date(2019, 8, 8, 9, 30),

            EndTime: new Date(2019, 8, 8, 11, 30),

            IsAllDay: false,

            RoomId: 1,

            RecurrenceRule: "FREQ=DAILY;INTERVAL=1;UNTIL=20191005T080703Z;",

            

        },

In above Scenario i Can see two time Appointment for Date the reason is Based on Rule Calendar also Render Appointment based on Rule

How can we default rendering false based on Recurrence Rule ,can we render event as per Datasource?

[Karthigeyan Krishnamurthi]

Hi Mayank, 

 

Syncfusion greetings. 

 

We can perform CRUD operations using DataManager and kindly refer the below links. 

UG: https://ej2.syncfusion.com/javascript/documentation/schedule/data-binding/?no-cache=1#scheduler-crud-actions 

JS: https://stackblitz.com/edit/rayioo-5jbuxa?file=index.js 

Service: https://www.syncfusion.com/downloads/support/forum/146492/ze/ServiceCRUD-1167518423 

 

Note: Run the service sample before JS to fetch and load the events in UI. 

 

By default DB contain only the parent recurrence event and it is handled internally. Please find the below details.  

 

Recurrence Appointment Db structure for JS2.   

  

   

  

Adding recurrence appointment to db:    

  

When single occurrence is edited its date will be added to parent event’s RecurrenceException field in ISO format and the edited occurrence’s RecurrenceID field is updated with parent event id value like below.  

https://ej2.syncfusion.com/javascript/documentation/schedule/appointments/?no-cache=1#editing-an-occurrence-from-a-series  

  

   

 

We strongly recommend not to manually update the events.  

 

Regards, 

Karthi 

 

 

 

 

 

 

[Rahul Jain]

Support,
I have tried this (https://stackblitz.com/edit/react-prevent-ovelap-on-recurrence-event?file=index.js ) solution also but that is not working completely,

When I update event in same day with different time that time that is working,

But this solution is not working for other events.

Please let me know , How to prevent all types of events.

I want only one appointment on a datetime .

Please let me know, I am waiting for Response.

Thank you -

Rahul Jain

[Ravikumar Venkatesan]

Hi Rahul,

Greetings from Syncfusion support.

We have validated your query “I want only one appointment on a datetime” at our end. Based on your query we suspect that you want only one appointment at the slot and if any new events are added, or existing events are modified to an already appointment-scheduled slot you need to prevent it. Can you kindly confirm whether this is your requirement or not? If this is your requirement can you kindly share what kind of issue you facing with your shared sample like a video demo illustration explaining the issue etc?

Regards,

Ravikumar Venkatesan