C#, SQL and RecurrencePatterns

Hi,

The calendar events objects model, like tree is similar to the following:

<Normal event>
<Recurrence master event>
    <Recurrence pattern>
        <Recurrence occurrences list> - virtual events. They are not stored but generated by request.
        <Recurrence exception>        - instances stored inside pattern and used when generating occurrences.


Recurrence Exception event has a few special fields to connect to its occurrence:
RExceptionStartTimeOrig, RExceptionEndTimeOrig, and of cause RecurrencePatternID.
These fields mean original occurrence Start/End times (and of cause RecurrencePatternID is used there too)

The event object has such properties but they are not in the interface. You cannot set them directly.

When MakeAsRException() is called - event StartTime/EndTime is copied to RExceptionStartTimeOrig / RExceptionEndTimeOrig.

Other thing is that you have call AddEvent only for Normal and Master events.
For Exceptions/Occurrences you have to call ChangeEvent method.

The logic is that firstly you add master event with recurrence pattern. After that all occurrences virtually exist.

Then you call ChangeEvent() to change some occurrences and make them as exceptions.

EXAMPLE:
    // sort your records by RecurrenceState to be shure that master event
    // will be added before ocurrences.

    // Master event processing

    pMasterEvent.CreateRecurrenceEx(pEve ntRS("RecurrencePatternID"));

    // .....
    
    // Exception event processing


    pEvent.StartTime = pEventRS("RExceptionStartTimeOrig");
    pEvent.EndTime = pEventRS("RExceptionEndTimeOrig");
    
    pEvent.MakeAsRExceptionEx(pEventRS(" RecurrencePatternID"));



    pEvent.StartTime = pEventRS("StartDateTime");
    pEvent.EndTime = pEventRS("EndDateTime");
    
    pData.ChangeEvent(pEvent);

NOTE:
Unfortunately, following methods members for ActiveX control will be available only with the next release.
    CalendarEvent.CreateRecurrenceEx(Pat ternID As Long)
    CalendarEvent.MakeAsRExceptionEx(Pat ternID As Long)
    CalendarRecurrencePattern.Id
    CalendarRecurrencePattern.MasterEven tId

Let me know whether this is clear.

--
WBR,
Serge

njcurrie wrote: So i guess the only question i have left to ask is when the new release will be out?

I already sent you a PM about 10 minutes ago, but in case your popup blocker prevents you from seeing it: Version 9.80 was released a few hours ago. Check the Downloads section.

Edited by gshawn