This is a migrated thread and some comments may be shown as answers.

Scheduler Mappings

5 Answers 90 Views
Scheduler and Reminder
This is a migrated thread and some comments may be shown as answers.
Timothy
Top achievements
Rank 1
Timothy asked on 07 Mar 2013, 12:21 AM
I was not able to find a concise listing of the Appointments table mappings. So, after hours of trial and error and searching through the help and forums I came up with my own documentation. I'm sharing it here in the hopes that others will not have to spend so much time to figure this out. I'm sure Telerik can clarify and fill in the missing information. The formatting of this didn't come out so well so I am also including a screen shot.
Appointment Property Data Type Length Example Data Notes
Start datetime 01/1/2013 12:00:00
End datetime 01/1/2013 13:00:00
Duration time 7 01:00:00 Can this be set to a datetime in older databases?
Summary nvarchar 255 Lunch with Steve Corresponds to Subject
Description ntext On the corner of 5th and Main Corresponds to the large textbox without a label (i.e. details, etc.)
Location nvarchar 255 Tony Roma's
Visible bit/boolean 1/True
AllDay bit/boolean 0/False I would expect this to be associated with the All Day checkbox but it's always null in the database
AllowDelete bit/boolean 1/True
AllowEdit bit/boolean 1/True
UniqueID int/uniqueidentifier 5  /  6706202d-ca29-40bc-81ab-b2a405c9e929 I'm not sure what this field is for. Maybe if you don't have Auto-Increment or Row GUID set to true it creates a default value for you. I know that if you do have Auto-Increment set you don't want this property pointing to that field.
BackgroundID int 1 Corresponds to Background color (i.e. category)
StatusID int 2 Corresponds to the "Show time as" drop down
RecurrenceRule nvarchar 1024 FREQ=WEEKLY;BYDAY=MO,TU,WE;WKST=SU
MasterEventID int/uniqueidentifier 5  /  6706202d-ca29-40bc-81ab-b2a405c9e929 This will contain the record id of the parent appointment if an indvidual appointment in a recurrence set has changed.
ResourceID int/uniqueidentifier 6  /  1367f9f9-e4af-4036-9821-477fd86b81bf This not on the appointments table but rather on the table that connects appointments to resources.
RecurrenceId datetime 01/1/2013 12:00:00 Not sure what the point of this field is. It appears to be the Start date/time for an appointment that is an exception of a recurrence.
Resources This is not a field on the database but rather the name of the relationship between the Appointments table and the AppointmentsResources table.
Exceptions This is not a field on the database but rather the name of the relationship between child appointment (i.e. exception) and the parent appointment (master event).

5 Answers, 1 is accepted

Sort by
0
Julian Benkov
Telerik team
answered on 11 Mar 2013, 03:45 PM
Hello Timothy,

Thank your for the provided detailed information about RadScheduler binding and mapping of Appointments. We will improve and include this information in our online documentation.

I have updated your Telerik points accordingly.

Kind regards,
Julian Benkov
the Telerik team
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
0
Timothy
Top achievements
Rank 1
answered on 07 May 2013, 10:06 PM
Can you tell me if RecurrenceId is still used? Do I need to persist it in my database?

Thanks,
Tim
0
Peter
Telerik team
answered on 10 May 2013, 02:06 PM
Hello Timothy,

Thank you for the question.

The DateTime? RecurrenceId property is still in use in the RadScheduler event's object. Also, this property is exported and imported from/to ICAL files.

I hope that you find this information useful.

Regards,
Peter
the Telerik team
WinForms Q1 2013 boasts PivotGrid, PDF Viewer, Chart enhancements and more. Check out all of the latest highlights.
0
Timothy
Top achievements
Rank 1
answered on 10 May 2013, 05:28 PM
Can you be more specific as to it's purpose and when it's used. Please be as specific and provide as much detail as possible.

I recently spent several days debugging an error that started to occur when saving an appointment. I'm not sure whether it was something I did or whether it started after downloading a new version of your code. The error wasn't trappable and would crash the program. My best guess is that it was occurring when the code was trying to populate the Recurrence Id in the table adapter. It said something about using DBNULL instead of Nothing. I was able to fix the error by overloading the Recurrence Id property. Using the ConvertToDataSource/ConvertToScheduler functions didn't work.

Anyway, I'm not worried about the error so please don't dwell on it. I need more specific information on when the Recurrence Id should be saved to the database so and I can figure out if that's working. So far I've not been able to see the Recurrence Id persisted to the database since I've overloaded it.
0
Peter
Telerik team
answered on 15 May 2013, 02:13 PM
Hello Timothy,

Thank you for writing back.

This property is used when adding an exception in the events recurrence sequence (the appointment in the exception collection) and it is also used in the export to ICall format. It is referenced in the following classes: AppointmentMappingInfo, MappingInfoDialog, SchedulerICalendarExporter, SchedulerUIHelper, SchedulerInplaceEditorControl, SchedulerView and EditAppointmentDialog classes.

You can download the source code of our controls in order to debug the exception that you received and to access the code where this property is used. The source code is available only for our customer, not for trial users. You can download it by following these steps:
  • Login to your account
  • Click on Products and Subscriptions > DevCraft Complete
  • Click on Download installer and other resources button on the right
  • Click on Browse all product files link in the RadControls for Winforms pane
  • Click the Source code link

Also, you can build the assemblies for the source code and you will be able to produce a stack trace when the error occurs.

I hope this helps.

All the best,
Peter
the Telerik team
RadChart for WinForms is obsolete. Now what?
Tags
Scheduler and Reminder
Asked by
Timothy
Top achievements
Rank 1
Answers by
Julian Benkov
Telerik team
Timothy
Top achievements
Rank 1
Peter
Telerik team
Share this question
or