Scheduler Mappings

6 posts, 0 answers
  1. Timothy
    Timothy avatar
    37 posts
    Member since:
    Nov 2012

    Posted 06 Mar 2013 Link to this post

    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).

  2. Julian Benkov
    Admin
    Julian Benkov avatar
    1135 posts

    Posted 11 Mar 2013 Link to this post

    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.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Timothy
    Timothy avatar
    37 posts
    Member since:
    Nov 2012

    Posted 07 May 2013 Link to this post

    Can you tell me if RecurrenceId is still used? Do I need to persist it in my database?

    Thanks,
    Tim
  5. Peter
    Admin
    Peter avatar
    1148 posts

    Posted 10 May 2013 Link to this post

    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.
  6. Timothy
    Timothy avatar
    37 posts
    Member since:
    Nov 2012

    Posted 10 May 2013 Link to this post

    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.
  7. Peter
    Admin
    Peter avatar
    1148 posts

    Posted 15 May 2013 Link to this post

    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?
Back to Top
UI for WinForms is Visual Studio 2017 Ready