DataSource.FetchAppointments Event

Allows you to load appointments only for the specified date range.

Namespace: DevExpress.Xpf.Scheduling

Assembly: DevExpress.Xpf.Scheduling.v20.2.dll

NuGet Packages: DevExpress.WindowsDesktop.Wpf.Scheduling, DevExpress.Wpf.Scheduling

Declaration

C#

public event FetchDataEventHandler FetchAppointments

VB.NET

Public Event FetchAppointments As FetchDataEventHandler

Event Data

The FetchAppointments event's data class is FetchDataEventArgs. The following properties provide information specific to this event:

Property	Description
Ids	Returns the identifiers of scheduler items that have been reloaded by the ReloadAppointments/ReloadTimeRegions methods.
Interval	Returns the time range for which to fetch the scheduler items.
Result	Specifies the list of scheduler items to load from the data source.

The event data class exposes the following methods:

Method	Description
GetFetchExpression<T>()	Generates an expression that you can use to obtain appointments from the data source.

Remarks

Specify AppointmentMappings.QueryStart and AppointmentMappings.QueryEnd mappings to handle the FetchAppointments event.

These mappings allow you to calculate the correct interval that is used in a SELECT query when you handle the FetchAppointments event. The use of the AppointmentMappings.Start and AppointmentMappings.End properties is not recommended in this scenario because such an interval may not include appointment patterns and the corresponding appointment exceptions.

The example below illustrates how to fetch appointments from a DbContext source. The FetchMode property is set to Bound.

C#

public class SchedulingDataContext : DbContext {
    public SchedulingDataContext() : base(CreateConnection(), true) { }
    static DbConnection CreateConnection() {
        //...
    }
    public DbSet<AppointmentEntity> AppointmentEntities { get; set; }

    //...
}
private void dataSource_FetchAppointments(object sender, DevExpress.Xpf.Scheduling.FetchDataEventArgs e) {
    using (var dbContext = new SchedulingDataContext()) {
        e.Result = dbContext.AppointmentEntities
            .Where(x => x.QueryStart <= e.Interval.End
                && x.QueryEnd >= e.Interval.Start)
            .ToArray();
    }
}

VB.NET

 Public Class SchedulingDataContext
    Inherits DbContext

    Public Sub New()
        MyBase.New(CreateConnection(), True)
    End Sub
    Private Shared Function CreateConnection() As DbConnection
        '...
    End Function
    Public Property AppointmentEntities() As DbSet(Of AppointmentEntity)

    '...
End Class
Private Sub dataSource_FetchAppointments(ByVal sender As Object, ByVal e As DevExpress.Xpf.Scheduling.FetchDataEventArgs)
    Using dbContext = New SchedulingDataContext()
        e.Result = dbContext.AppointmentEntities.Where(Function(x) x.QueryStart <= e.Interval.End AndAlso x.QueryEnd >= e.Interval.Start).ToArray()
    End Using
End Sub

The FetchRange property specifies the time interval for which to fetch the appointments. FetchAppointments loads items for the SchedulerControl.VisibleIntervals extended up to the FetchRange.

Refer to the Load Data on Demand topic for more information.