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

Order of Events for Cell Formating

1 Answer 88 Views
Scheduler and Reminder
This is a migrated thread and some comments may be shown as answers.
Denis Cilliers
Top achievements
Rank 1
Denis Cilliers asked on 20 Dec 2012, 10:17 AM
Hi There

I'm having some trouble with the order of events for the Cell Format

We do some conditional cell formatting based on values returned from a database, such as what days to block - holidays etc
I managed to get it to work fine the first time round 

The issue arises on the following Navigator events
  • NavigateBackwardsClick
  • NavigateForwadsClick

as the following event fires before the Navigate event

  • Scheduler.CellFormating

This seems quite strange, I would have thought that they would be reversed.

How can I call a refresh of the data method and which event should it go in 
  • exceptionTimes = _service.GetSchedulerExceptionTimesByDateRange(RangeStartDate, RangeEndDate)

As putting the values in the Navigate events makes the cellformating event use the previous 
range of exception times for the previous date range as defined before the navigate event.

Below is some example code 
Private Sub snMain_NavigateBackwardsClick(sender As Object, e As EventArgs) Handles snMainNav.NavigateBackwardsClick
 
    RangeStartDate = rsScheduler.ActiveView.StartDate.AddDays(-1)
    RangeEndDate = rsScheduler.ActiveView.EndDate.AddDays(1)
 
    exceptionTimes = GetSchedulerExceptionTimesByDateRange(, RangeStartDate, RangeEndDate)
    GetAppointmentsByDateRange()
 
 End Sub
 
Private Sub rsScheduler_CellFormatting(sender As Object, e As SchedulerCellEventArgs) Handles rsScheduler.CellFormatting
    ' Other Code
    For Each Exception In exceptionTimes
        'Block etc
 
    Next
 
End Sub

1 Answer, 1 is accepted

Sort by
0
Ivan Todorov
Telerik team
answered on 21 Dec 2012, 12:04 PM
Hello Denis,

Thank you for contacting us.

The NavigateBackwardsClick fires after the view has been updated and the CellFormatting event fires during the update itself. Also, the NavigateBackwardsClick fires only when using the navigation buttons in RadSchedulerNavigator and will not cover cases when navigating using keyboard for example. Therefore, I would suggest using the PropertyChanged event of the active view. The following code snippet demonstrates this approach:
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    AddHandler Me.RadScheduler1.ActiveView.PropertyChanged, AddressOf ActiveView_PropertyChanged
    AddHandler Me.RadScheduler1.ActiveViewChanging, AddressOf RadScheduler1_ActiveViewChanging
    AddHandler Me.RadScheduler1.ActiveViewChanged, AddressOf RadScheduler1_ActiveViewChanged
End Sub
 
Private Sub RadScheduler1_ActiveViewChanging(sender As System.Object, e As Telerik.WinControls.UI.SchedulerViewChangingEventArgs)
    RemoveHandler Me.RadScheduler1.ActiveView.PropertyChanged, AddressOf ActiveView_PropertyChanged
End Sub
 
Private Sub RadScheduler1_ActiveViewChanged(sender As System.Object, e As Telerik.WinControls.UI.SchedulerViewChangedEventArgs)
    AddHandler Me.RadScheduler1.ActiveView.PropertyChanged, AddressOf ActiveView_PropertyChanged
End Sub
 
Private Sub ActiveView_PropertyChanged(sender As Object, e As System.ComponentModel.PropertyChangedEventArgs)
    If e.PropertyName = "StartDate" Then
        'get exception times
    End If
End Sub

I hope you find this useful. Should you have any additional questions, do not hesitate to ask.

Kind regards,
Ivan Todorov
the Telerik team
Q3’12 of RadControls for WinForms is available for download (see what's new). Get it today.
Tags
Scheduler and Reminder
Asked by
Denis Cilliers
Top achievements
Rank 1
Answers by
Ivan Todorov
Telerik team
Share this question
or