Recurring Events - Reminder Email implementation

Scheduler Javascript
#1

Hi,

thank u … finally i have successfully implemented Recurring events in native lightbox in Asp.Net. i have another one requirement …that is sending reminder emails about the meeting.

for normal events, i am adding an entry to my Cron table about the mailing date…so on that date, the emails will be sent automatically… on meeting Date - 1 hr before and Before meeting date - 24 hrs before. that was working fine.

But for recurring events, i cannot add as many entries till the enddate for sending email. i thought to have additional columns in my cron table to handle this… But couldnt get it …

Can you please suggest a way for sending mails about recurring events on the Meeting Date and Before meeting date?

#2

Hi,

is it possible to advice, how to calculate the next occurrence of the current event in recurring events, i will handle the rest of the things…please

#3

You can use
scheduler.getRecDates(id);
// scheduler.getRecDates(id, 100); 100 - max count of results

to get the array of event occurencies

#4

Hi,

Thank you. this method is really useful.

But, i have to send email automatically on each recurring date in Server code of cron file.

thus, i should get the next occuring date on server-code.

is there any way to get next event-occurring date on code-behind? can you please advice?

thanks for helping

#5

If you are using php - you can try to use the helper class
support.dhtmlx.com/x-files/sched … events.zip

It was taken from scheduler-plugin, and can produce all events for specified range of dates, including the occurences of recurring ones.

#6

Hi,

Thanks for replying.

But i am using Asp.Net. Can you suggest any Asp.net helper methods?

Sorry to be a disturbance… pls help

#7

hi,

Can you please suggest ASP.Net Helper method for finding occurrences of Recurring Events please?

Thanks for any help!

#8

There is no ready to use solution for .Net now, we will add it as part of next update for Scheduler.Net

#9

Hello,
helper for recurring events was added, if you still need it
http://blog.scheduler-net.com/post/2012/03/27/helpers-for-scheduler-net-in-use.aspx#get_occurrences

#10

Hi,

thank you for the link. I am still looking for it…

My problem is implementation of
helper.GetOccurrences(New DHXSchedulerDataContext().Recurrings, Startdate, endDate)

Here i am not using DataContext, instead i am using manual coding using stroed procedures for inserting, updating, selecting events in SchedulersaveData.ashx

the first parameter for GetOccurrences should always be a context Table ?, is it possible to use stored procedure results there?

Please help me to get a soln for this.

Thank you for helping

#11

hi again,

i created a manual datacontext for my events table and called it like this

var db = new MyDataContext(connectionstring); var recurring = db.Events; DHXEventsHelper helper = new DHXEventsHelper(); DateTime onwhen = DateTime.Parse("5/5/2012 1:00:00 PM"); DateTime onend = DateTime.Parse("4/3/2013 12:00:00 AM "); List<object> items = helper.GetOccurrences(recurring, onWhen, onEnd);

even the table has rows for recurring events, it returns nothing when debugging.

But var Results= from a in db.Events; - returns all the rows without issues.

can you tell me what i am doing wrong in getOccurrences implementation?

the given dates has recurring type as “month_3___#”