Schedular recurrence

[Iry Lee]

i noticed schedular got recurrence with a few readonly property.
i couldn't find how i can store / set data.
normally how we can save the data?
and how about the all day check box?
i using asp.net with SQL database.

[robertw102]

I believe this help article should be of use:

http://www.telerik.com/help/aspnet-ajax/database-structure.html

It tells you the database structure needed to use recurrence.

[Iry Lee]

my question is actually how to get value from scheduluer to insert into db?
and how to set the value after i retrieve from database?

[Peter]

Hi Iry,

You can handle AppointmentUpdate/Delete/Insert events to access appointment values and manipulate the database with them. Here is a demo for reference:
http://demos.telerik.com/aspnet-ajax/scheduler/examples/bindtolist/defaultcs.aspx


Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

thanks for your reply.
I'm using AdvanceForm which the coding for get and set data is at AdvanceForm.ascx.vb file and it is different from the demo.

Just like subject and description, recurrence got a property function at AdvanceForm.ascx.vb:

<Bindable(BindableSupport.Yes, BindingDirection.TwoWay)> _
    Public Property RecurrenceRuleText() As String
        Get
            If Owner.RecurrenceSupport Then
                Dim rrule As RecurrenceRuleRecurrenceRule = RecurrenceRule.FromPatternAndRange(Pattern, Range)

                If rrule = Nothing Then
                    Return String.Empty
                End If

                Dim originalRule As RecurrenceRuleRecurrenceRule = RecurrenceRule.Empty
                If RecurrenceRule.TryParse(OriginalRecurrenceRule.Value, originalRule) Then
                    rrule.Exceptions = originalRule.Exceptions
                End If

                Return rrule.ToString()
            End If

            Return String.Empty
        End Get

        Set(ByVal value As String)
            OriginalRecurrenceRule.Value = value
        End Set
    End Property

then at the schedular page's aspx file, it bind the data:

RecurrenceRuleText='<%# Bind("RecurrenceRule") %>'

i assume recurrece's get/set data is the same with subject and description, so when insert appointment, i code as below to insert the data to database:

ALIN.Add(e.Appointment.RecurrenceRule)

but the RecurrenceRule column (nvarchar(1024)) is empty even i insert an appointment with recurrence. (is empty string, not NULL)

so, i wonder is that i get the data in a wrong way.
but i couldn't find any answer at demo and the forum.

[Iry Lee]

can someone help me?
i've been waiting for 5days

[Peter]

Hi Iry,

Yes, your assumption is correct - you can access RecurrenceRule just like any other property such as Subject, Start, End, etc...

Which event do you handle? Is it AppointmentInsert? Can you use a debugger to check what the value for RecurrenceRule is in the event handler?


All the best,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

thanks for your reply again Petter.
yes, it is in the insertappointment event handler.
here is the screen capture of the data i key in(insertevent.jpg), and the value that it gets(empty.jpg).

[Iry Lee]

still awaiting for the answer

[Peter]

Hello Iry,

We tested the case, but we could not replicate the problem locally. Here is the demo web site we used for our tests:

http://www.telerik.com/support/kb/aspnet-ajax/scheduler/sample-project-of-the-customizing-the-advanced-template-example.aspx

Please, try to modify this sample so that the problem can be seen and let us know what changes you have made to it.


Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Peter, thanks for your reply.
Here are steps that i modify the sample code.

1. at the default.aspx, the schedular properties there, i add:

OnAppointmentInsert="rs_AppoinmentInsert"
OnAppointmentUpdate="rs_AppoinmentUpdate"
OnAppointmentDelete ="rs_AppointmentDelete"
OnAppointmentCreated= "rs_AppoinmentCreated"
OnAppointmentDataBound =" rs_AppoinmentDataBound"
EnableCustomAttributeEditing="True"
CustomAttributeNames="Calendar,Location,Type"
StartInsertingInAdvancedForm ="true"
StarEditingInAdvancedForm = "true"

2. Add in the function for insert, update, delete, created and databound for appointment at default.aspx.vb
3. At AdvanceForm.ascx, i added a drop down for each custom attribute that i set (Calendar, Location and Type).
4. get& set custom attributes' data at AdvanceForm.ascx.vb

<Bindable(BindableSupport.Yes, BindingDirection.TwoWay)> _
 Public Property Selectedloc() As String
        Get
            If cbLocation.SelectedValue <> "" Then
                Return cbLocation.SelectedValue.ToString
            Else
                If cbLocation.Text = "" Then
                    Return 0

                Else
                    Dim ssql As String = "INSERT INTO CAE_location (LocationID, LocationName, Status, AddDate, AddBy) VALUES (@param1, @param2, @param3, @param4, @param5)"

                    Dim mClas As ExodusG2.dbOps = New ExodusG2.dbOps
                    Dim AlIn As ArrayList = New ArrayList
                    Dim sGuid As String = System.Guid.NewGuid().ToString
                    AlIn.Add(sGuid)
                    AlIn.Add(cbLocation.Text)
                    AlIn.Add("1")
                    AlIn.Add(Date.Now)
                    AlIn.Add(HttpContext.Current.User.Identity.Name)
                    mClas.execute_query(ssql, AlIn)
                    Return sGuid
                End If
            End If

        End Get

        Set(ByVal value As String)
            Dim selecteditem As RadComboBoxItem = New RadComboBoxItem()
            Dim mClas As ExodusG2.dbOps = New ExodusG2.dbOps
            'Dim dt As DataTable = New DataTable()
            Dim alout As ArrayList = New ArrayList()
            Dim AlIN As ArrayList = New ArrayList()

            AlIN.Add(value)
            alout = mClas.selectSingleRow("SELECT    LocationName, LocationID FROM  CAE_location WHERE     (LocationID = @param1)", AlIN, 2)

            If alout.Count > 0 Then

                selecteditem.Text = alout(0).ToString
                selecteditem.Value = alout(1).ToString
                selecteditem.Selected = True

                cbLocation.Items.Add(selecteditem)
            End If
        End Set
    End Property
    <Bindable(BindableSupport.Yes, BindingDirection.TwoWay)> _
Public Property Selectedcalendar() As String
        Get
            Return cbCalendar.SelectedValue.ToString
        End Get

        Set(ByVal value As String)
            For Each items As RadComboBoxItem In cbCalendar.items

                If items.Value = value Then
                    items.Selected = True
                End If
            Next
        End Set
    End Property

 <Bindable(BindableSupport.Yes, BindingDirection.TwoWay)> _
Public Property eventType() As String
        Get
            Return cbType.SelectedValue.ToString
        End Get

        Set(ByVal value As String)
            For Each items As RadComboBoxItem In cbType.items

                If items.Value = value Then
                    items.Selected = True
                End If
            Next
        End Set
    End Property

5. Bind custome attributes to the schedular at default.aspx

Selectedcalendar='<%# Bind("Calendar") %>'
                    Selectedloc='<%# Bind("Location") %>'
                    eventType='<%# Bind("Type") %>'

here is my source code, pls kindly refer to the source code if the way i explain it is confusing:
http://www.ximnet.com.my/upload/customTempSchedular.rar

[Peter]

Hello Iry,

Thanks for the sample. However, we could not run it since it is missing the data base. We will need a fully runnable demo to be able to pinpoint the problem.


Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Here is my updated application code file:
http://www.ximnet.com.my/upload/cae upload/Schedular_demoPage.rar

inside the web.config file, there are 2 connection string (connStr & connStrReadOnly).
the tool for decrypt/encrypt:
http://www.ximnet.com.my/aspnet35/setup/tripledes.aspx

Here is my db:
http://www.ximnet.com.my/upload/cae upload/db.zip

Thanks.

Regards,
Iry

[Peter]

Hi Iry,

We recovered the database with the sql script you sent, but we are not sure how to modify your sample to make it run. In the web.config you have the following connection strings - connStr and connStrReadOnly, but searching the entire solution, I couldn't find where you use them. When running the project, I got the exception in the attached screen capture. We will need the exact steps to run your project locally.


Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

the tripledes.aspx is not in soution
but use the http://www.ximnet.com.my/aspnet35/setup/tripledes.aspx to help you decrypt/encrypt the connection string
after u replace the connection string, the project should be able to run

Regards,
Iry

[Peter]

Hi Iry,

Yes, I used this converter, but i cannot use the connection string as it is. I replaced it with a connection string based on my local machine and server. But, the question is I don't see where and how you use these connection strings in your project.


Kind regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Hi Peter,

The connection string is in the dll to get DataTable and i use SQL query to get a DataTable to bind into the scheduler.
If you still fail to get the data, may be you can try to use normal way of getting the query into a DataTable.

Hope everything goes smoothly.
Thanks for your help.

Regards,
Iry

[Iry Lee]

Hi Peter,

I'm concern about the progress. Are you able to run the application?

Regards,
Iry

[Iry Lee]

Hi Peter,

The function below is the one i use for appointment insert, is this the correct way of storing recurrence data?
Anything else that i left out?
If it is wrong, how i should get and store the data in Vb?

Sub rs_AppoinmentInsert(ByVal o As Object, ByVal e As SchedulerCancelEventArgs)

Dim mclas As ExodusG2.dbOps = New ExodusG2.dbOps

Dim ALIN As ArrayList = New ArrayList()

ALIN.Add(System.Guid.NewGuid().ToString)

ALIN.Add(e.Appointment.Subject)

ALIN.Add(e.Appointment.Attributes("Location").ToString())

ALIN.Add(Server.HtmlEncode(e.Appointment.Start))

ALIN.Add(Server.HtmlEncode(e.Appointment.End))

ALIN.Add(e.Appointment.Attributes("Calendar").ToString())

ALIN.Add(e.Appointment.Attributes("Type").ToString())

ALIN.Add(e.Appointment.Description)

ALIN.Add(e.Appointment.RecurrenceRule)

ALIN.Add(1)

ALIN.Add(Now.ToString())

ALIN.Add(User.Identity.Name)

Dim ssql As String = "INSERT INTO CAE_EventList (EventID,EventSubject,LocationID,EventStartTime,EventEndTime,CalendarID,TypeID,EventDesc,RecurrenceRule,Status,AddDate,AddBy) VALUES (@param1, @param2,@param3,@param4,@param5,@param6, @param7, @param8, @param9, @param10, @param11,@param12)"

mclas.execute_query(ssql, ALIN)

Response.Redirect("default.aspx")

End Sub

And i notice something when i try to open the BooleanAttributeControl.ascx.vb from VS 2008 Pro, a window pop up about inconsistent line engdings. I made a print screen for it. Please help me to take a look.
Is that affect anything?

[Peter]

Hi Iry,

Good news, after inspecting agin your code, we believe we found what the problem is. You should set DataRecurrenceField and DataRecurrenceParentKeyField  for RadScheduler:

Sub RadScheduler1_NeedDataSource()
        Dim mclas As ExodusG2.dbOps = New ExodusG2.dbOps
        Dim dt As DataTable = New DataTable
        Dim ALIN As ArrayList = New ArrayList
        ALIN.Clear()
        '* * *
        RadScheduler1.DataKeyField = "EventID"
        RadScheduler1.DataSubjectField = "EventSubject"
        RadScheduler1.DataStartField = "EventStartTime"
        RadScheduler1.DataEndField = "EventEndTime"
        RadScheduler1.DataDescriptionField = "EventDesc"
    RadScheduler1.DataRecurrenceField = "RecurrenceRule"
    RadScheduler1.DataRecurrenceParentKeyField = "RecurrenceParentID"

        RadScheduler1.DataSource = dt
        ' RadScheduler1.DataSource = dtglobal
    End Sub

Let me know if this helped.


Greetings,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Hi Peter,

Billion thanks!
After setting DataRecurrenceField and DataRecurrenceParentKeyField, i manage to get the RecurrenceRule.

But when i add in the RecurrenceParentID to my insert appointment query, i failed to add the appointment.
(After enter the details of appointment and click save, the form didn't close and data didn't store into database.)
Steps that i did:
1. Add a column name RecurrenceParentID
2. Edit the query in rs_AppoinmentInsert() to store RecurrenceParentID
3. Add: ALIN.Add(e.Appointment.RecurrenceParentID)

Anything else that i need to do in order to get the RecurrenceParentID?

Regards,
Iry

[Peter]

Hi Iry Lee,

Can you check for the data type of your RecurrenceParentID field. It should be int. Here is a help topic for rerence - Database Structure.

Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Thanks for your reply, Peter.
Yes, my RecurrenceParentID field data type is Int.

Regards,
Iry

[Peter]

Hello Iry,

The RecurrenceParentID should be null when inserting a new appointment. It is used only when creating exceptions. Please, refer to the help topic on Working with Recurring Appointments.


Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Hi Peter,

Can we disable ajax for radschedular to see server-side errors instead of Ajax error ?

I have a problem when trying to edit the recurrence appointment.
Let's say i create the appointment at 30th March 2010, i set the appointment recur every tuesday and end by 14th April 2010.
So the appointment is appear 3 times in the calendar.

From the demo at http://demos.telerik.com/aspnet-ajax/scheduler/examples/outlook2007/defaultcs.aspx, i understand that when we edit recurrence appointment by choosing "Edit only this occurrence", then the edit form pop up with recurrence checkbox is unchecked and the recurrence option is hide.

But when i trying to edit:
1. the first appointment which is on 30th March by choosing "Edit only this occurrence". The edit form appear with Recurrence checkbox is checked and the recurrence options is shown.
2. the first appointment (30th March) by choosing "Edit the series". Error occured:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0)
Timestamp: Tue, 30 Mar 2010 03:22:01 UTC


Message: Object doesn't support this property or method
Line: 10
Char: 13
Code: 0
URI: http://develop.alchemedia-01.ximnet.my/joycube/joycube/cae/default.aspx


Message: Sys.WebForms.PageRequestManagerServerErrorException: Object reference not set to an instance of an object.
Line: 6
Char: 62099
Code: 0
URI: http://develop.alchemedia-01.ximnet.my/joyCube/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_cp_RadScriptManager1_HiddenField&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d3.5.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a1247b7d8-6b6c-419f-a45f-8ff264c90734%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2009.3.1103.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3a4552b812-caf7-4129-9b53-8f199b5bce6c%3a16e4e7cd%3aed16cbdc%3af7645509%3a24ee1bba%3a1e771326%3aaa288e2d%3a874f8ea2%3a650fdad%3aef9d9f4a%3a5aafb8ec%3aa51ee93e%3a59462f1%3ae330518b%3ac8618e41%3ae4f8f289

3. For other occurence (6th Apr & 13th Apr), no matter Edit only this occurrence or Edit the series, Error occured too:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; Tablet PC 2.0)
Timestamp: Tue, 30 Mar 2010 03:23:16 UTC


Message: Object doesn't support this property or method
Line: 10
Char: 13
Code: 0
URI: http://develop.alchemedia-01.ximnet.my/joycube/joycube/cae/default.aspx

Message: Sys.WebForms.PageRequestManagerServerErrorException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Line: 6
Char: 62099
Code: 0
URI: http://develop.alchemedia-01.ximnet.my/joyCube/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_cp_RadScriptManager1_HiddenField&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d3.5.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a1247b7d8-6b6c-419f-a45f-8ff264c90734%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%2c+Version%3d2009.3.1103.35%2c+Culture%3dneutral%2c+PublicKeyToken%3d121fae78165ba3d4%3aen-US%3a4552b812-caf7-4129-9b53-8f199b5bce6c%3a16e4e7cd%3aed16cbdc%3af7645509%3a24ee1bba%3a1e771326%3aaa288e2d%3a874f8ea2%3a650fdad%3aef9d9f4a%3a5aafb8ec%3aa51ee93e%3a59462f1%3ae330518b%3ac8618e41%3ae4f8f289

Anything can make these goes wrong? What i can do to solve these problem?

Regards,
Iry

[Peter]

Hi Iry,

We are not really sure why this problem occurs. We couldn't actually run your demo. Our previous suggestion was based on just reviewing the code. I will forward this case to our development team and if they have ideas, we will follow up here.


Greetings,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Thanks a lot! I'll wait for the development team then.
Hope they will bring me good news.

one more thing i notice about recurrence appointment is when i try to delete an occurence only, after the schedular reload that occurence is still there.

Regards,
Iry

[Iry Lee]

Hi Peter,
Any news from development team?

Regards,
Iry

[Iry Lee]

Hi Peter,
Any news from development team?

Regards,
Iry

[Peter]

Hi Iry Lee,

Unfortunately, we haven't been able to find out something new about this problem which could provide you with more hints.

Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Iry Lee]

Hi Peter,

10 days passed. Hope can get good news from you.
Thanks

Regards,
Iry