SchedulerStorage.SetAppointmentId(Appointment, Object) Method

Sets the identifier of the specified appointment to a specified value.

Namespace: DevExpress.XtraScheduler

Assembly: DevExpress.XtraScheduler.v18.2.dll

Declaration

C#

public virtual void SetAppointmentId(
    Appointment apt,
    object id
)

VB.NET

Public Overridable Sub SetAppointmentId(
    apt As Appointment,
    id As Object
)

Parameters

Name	Type	Description
apt	Appointment	An Appointment object.
id	Object	An object that is the appointment identifier to assign.

Remarks

Important

This API is intended to be used with the legacy SchedulerStorage only. Starting with version 18.1, SchedulerStorage and all of its satellite storages are replaced with their updated versions.

• SchedulerDataStorage replaces SchedulerStorage
• AppointmentDataStorage replaces AppointmentStorage
• ResourceDataStorage replaces ResourceStorage
• AppointmentDependencyDataStorage replaces AppointmentDependencyStorage

Use the SetAppointmentId method to assign an arbitrary identifier to an appointment. The method sets the Appointment.Id value.

There are two common situations for using the SetAppointmentId method.

Application Sets the ID

If the scheduler is bound to a data source, and you initialize the appointment Ids manually by using the SetAppointmentId method, it is necessary to enable the AppointmentStorage.CommitIdToDataSource option to post the Appointment.Id property value to the data storage.

Database Sets the ID

The SetAppointmentId method can also be utilized to assign the appointment identifier after the newly created appointment is committed to the data source with an auto incremented Id field, as described below.

After a new record in the data source is created, use a SELECT @IDENTITY statement or an OUT parameter of a corresponding stored procedure to get the identifier assigned to a new appointment in the database. The obtained value is used to fill the ID column in the current data row of the appointment data source (handle the RowUpdated event of the data adapter). Then, handle the SchedulerStorageBase.AppointmentsInserted event to set the PersistentObject.Id property of the currently inserted appointment. Now, the appointment in the Scheduler has the same Id as the specified corresponding database record.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SetAppointmentId(Appointment, Object) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-bind-the-scheduler-to-a-microsoft-sql-ce-database-a-sample-application-e5056/CS/Scheduler_SQLCE_Example/Form1.cs#L56

    DataRowView dataRow = apt.GetSourceObject(this.schedulerStorage1) as DataRowView;
    this.schedulerStorage1.SetAppointmentId(apt, dataRow.Row["UniqueID"]);
}

how-to-enable-gantt-view-for-the-schedulercontrol-bound-to-collection-of-business-objects-t185539/CS/dxT183299/Form1.cs#L33

void schedulerStorage_AppointmentInserting(object sender, PersistentObjectCancelEventArgs e) {
    this.schedulerControl.Storage.SetAppointmentId(((Appointment)e.Object), nextId++);
}

how-to-create-gantt-chart-using-the-scheduler-bound-to-ms-sql-server-database-e3574/CS/GanttExample/Form1.cs#L76

    CommitTask();
    schedulerStorage1.SetAppointmentId(((Appointment)e.Objects[0]), id);
}

how-to-enable-gantt-view-for-the-xtrascheduler-bound-to-xpo-session-e3648/CS/Gantt_on_XPO/Form1.cs#L43

    xpObject.Save();
    schedulerStorage1.SetAppointmentId(apt, xpObject.Oid);
}

VB.NET

how-to-bind-the-scheduler-to-a-microsoft-sql-ce-database-a-sample-application-e5056/VB/Scheduler_SQLCE_Example/Form1.vb#L56

    Dim dataRow As DataRowView = TryCast(apt.GetSourceObject(Me.schedulerStorage1), DataRowView)
    Me.schedulerStorage1.SetAppointmentId(apt, dataRow.Row("UniqueID"))
Next apt

how-to-enable-gantt-view-for-the-schedulercontrol-bound-to-collection-of-business-objects-t185539/VB/dxT183299/Form1.vb#L32

Private Sub schedulerStorage_AppointmentInserting(ByVal sender As Object, ByVal e As PersistentObjectCancelEventArgs)
    Me.schedulerControl.Storage.SetAppointmentId((CType(e.Object, Appointment)), nextId)
    nextId += 1

how-to-create-gantt-chart-using-the-scheduler-bound-to-ms-sql-server-database-e3574/VB/GanttExample/Form1.vb#L78

    CommitTask()
    schedulerStorage1.SetAppointmentId((CType(e.Objects(0), Appointment)), id)
End Sub

how-to-enable-gantt-view-for-the-xtrascheduler-bound-to-xpo-session-e3648/VB/Gantt_on_XPO/Form1.vb#L46

    xpObject.Save()
    schedulerStorage1.SetAppointmentId(apt, xpObject.Oid)
End If

Implements

SetAppointmentId(Appointment, Object)