schedule and Sqlite and other questions

[Phil Allcock]

Hi All just wondering if someone can tell me the best way to save appointments to sqlite database and recall them back.

I'm using a similar approach to your Appointment Editor in the demo to produce the schedule.

Also If recursive appointments are set will it make separate Db rows or just one with recursive rule.

Any help would be great..

[Subburaj Pandian Veluchamy]

Hi Phil, 

  

Thank you for contacting Syncfusion support. 

  

Query 1: Regarding Schedule with SQLite database 

Schedule supports to load and retrieve appointments from SQLite database. We have published a KB documentation for the same. Kindly refer our KB documentation to know more about loading the data from SQLite database into schedule. 

 

KB Link : https://www.syncfusion.com/kb/9125/how-to-load-the-data-from-sqlite-offline-database-into-sfschedule 

  

Query 2: Regarding database row count for recursive appointments 

For recursive appointments single appointment with recurrence rule is enough, separate rows are not needed in the database. 

  

We hope this helps, kindly revert us if you have any concern. 

 

Regards,
Subburaj Pandian V 

[Phil]

Thank you for the reply. 

Sorry to pester you more but I'm still wondering the best way to SAVE the appointments to SQLite when a single appointment has been changed or added. 

Also I'm a bit worried that this could be a problem when a lot of appointments are in the database (What do you think?), could load on demand be utilises with this approach ( I have no idea how to do this, only collecting SQLite data when needed , could you help?).

My question about recursive is an issue I've encountered when editing a later appointment created with recursive rule. It edits the whole block not just the single later appointment.

I can change this to create separate DB appointments but I was hoping I would not need to for DB access time.

Thanks in advance.

[Karthikraja Arumugam]

Hi Phil, 

 

Thank you for the update. 

 

Query 1: Regarding save single appointment in SQLite  

When a new appointment is added raise CollectionChanged event of your appointment collection, in the event get the appointment details and store it into the database. 

 

Code Snippet: 

 

Meetings.CollectionChanged += Meetings_CollectionChanged; 

 

private void Meetings_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e) 

{ 

 

   if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Add) 

   { 

      var newMeeting = e.NewItems[0] as Meeting; 

      database.Query<AppointmentDB>("INSERT INTO AppointmentDB (Subject,StartTime,EndTime,AllDay,Color)values ('Yoga Therapy','" + newMeeting.From.ToString() + "', '" + newMeeting.To.ToString() + "','" + newMeeting.AllDay +"' , '" + newMeeting.Color +"')"); 

    } 

} 

 

We have modified our KB sample for the same. 

Sample link: SqliteSample 

 

Query 2: Regarding load appointment on demand basis 

You can get current view DateRange from VisibleDatesChanged event and based on visual dates load appointments from database. Kindly refer our UG documentation to know more about VisibleDatesChanged event. 

 

UG link: https://help.syncfusion.com/xamarin/sfschedule/date-navigations#visibledateschanged-event 

 

Query 3: Regarding recurrence appointment 

You can add/remove the recurrence exception appointments and recurrence exception dates to ScheduleAppointment by using its properties RecurrenceExceptionDates, RecurrenceId, ExceptionOccurenceActualDate. Kindly refer our UG documentation to know more about recurrence pattern exceptions. 

 

UG link: https://help.syncfusion.com/xamarin/sfschedule/data-bindings#recurrence-pattern-exceptions 

 

We hope this helps, kindly revert us if you have any concerns. 

 

Regards, 

Karthik Raja A 

[Phil Allcock]

You are a star. 

Thank you.

[Subburaj Pandian Veluchamy]

Hi Phil, 

 

Thank you for the update. We are glad that the given solution meets your requirement.

Please get in touch with us if you would require any further assistance in future. 

 

Regards,
Subburaj Pandian V  

[Phil Allcock]

Hi. Me again..

Please bear with me I'm a bit new to c#.

Running into an issue with load on demand using this approach. I've got the visible dates and select them from the Db ok.

Creating a new observable collection with just these triggers the NotifyCollectionChangedAction.Add, which then adds them to the database as duplicate records and displays  nothing in the schedule view, even though the collection binding has data.

I've also tried using the ScheduleAppointmentCollection class instead of my custom class to load the data as with your demo. This works as it should and displays basic data, but it does not pass my custom fields of cause and causes an issue when I select the appointment.

I'm running around in circles. Help..

[Jagadeesan Pichaimuthu]

Hi Phil, 

  

Thank you for the update. 

  

We have analyzed your requirement “How to restrict CollectionChanged event from adding duplicate appointment to database?”. Schedule has property called Notes which can be used to provide unique id for each appointment by using this property you can restrict the duplicate appointments from adding into database. Kindly refer our UG documentation to know more about Notes property in Schedule. 

  

UG link: https://help.syncfusion.com/xamarin-android/sfschedule/data-bindings#mapping 

  

After retrieving appointments from database update the appointment collection and DataSource of schedule to reflect appointments in view. 

  

We hope this helps. kindly revert us if you have any concern. 

  

Regards, 

Jagadeesan