Class AppointmentCollection

public class AppointmentCollection : EntityCollectionBase, INestedPersist, IEnumerable<INestedPersist>, ISoCollection, IList, ICollection, IEnumerable, ITableRowLoadHandlerFactory, INotifyCollectionChanged, IBindingList

Remarks

Entity collections can be created in several ways.

Use the static CreateNew() method to create a new, empty collection. You can then add objects of type to it, and use methods like to operate on the whole collection.
You can create a (nested) AppointmentCollection AppointmentCollection.CustomSearch object to obtain a query pre-populated with the correct tableinfo and return fields. This query can be modified with restrictions, etc. Then, use the static GetFromCustomSearch(AppointmentCollection.CustomSearch) method to apply the query to the database and obtain the result as an EntityCollection object, with one item for each table row that matched your query.
For each non-unique index defined for the table, there is a corresponding GetFromIdx method to make retrieving data via the indexes easy.

Unique indexes are handled through the Appointment object directly, which has nested classes and GetFromIdx methods for each unique index.

Unique indexes on table Appointment are:

Index fields	Nested index class name
AppointmentId	AppointmentId: Primary key Nested index class: Appointment.IdxAppointmentId Static Get method: GetFromIdxAppointmentId(Int32)
ActiveDate, MotherId, Type, DocumentId, AppointmentId, AssignedBy, AssociateId, ProjectId, GroupIdx, Registered, RegisteredAssociateId	ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status MotherId: ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment Type: See note. DocumentId: Points to document record; 0 for non-document appointments! AppointmentId: Primary key AssignedBy: Who (last) assigned this appointment to associate_id? AssociateId: ID of associate whose diary the appointment is in, REQUIRED ProjectId: ID of project referred to, may be 0 GroupIdx: Group of owning associate at the time the appnt was created Registered: Registered on RegisteredAssociateId: Registered by Nested index class: Appointment.IdxActiveDateMotherIdTypeDocumentIdAppointmentIdAssignedByAssociateIdProjectIdGroupIdxRegisteredRegisteredAssociateId Static Get method: GetFromIdxActiveDateMotherIdTypeDocumentIdAppointmentIdAssignedByAssociateIdProjectIdGroupIdxRegisteredRegisteredAssociateId(DateTime, Int32, AppointmentType, Int32, Int32, Int32, Int32, Int32, Int32, DateTime, Int32)
ActiveDate, AssociateId, AppointmentId, MotherId	ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status AssociateId: ID of associate whose diary the appointment is in, REQUIRED AppointmentId: Primary key MotherId: ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment Nested index class: Appointment.IdxActiveDateAssociateIdAppointmentIdMotherId Static Get method: GetFromIdxActiveDateAssociateIdAppointmentIdMotherId(DateTime, Int32, Int32, Int32)
AssociateId, GroupIdx, ActiveDate, Type, Registered, MotherId, AppointmentId, AssignedBy, Status, RegisteredAssociateId	AssociateId: ID of associate whose diary the appointment is in, REQUIRED GroupIdx: Group of owning associate at the time the appnt was created ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status Type: See note. Registered: Registered on MotherId: ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment AppointmentId: Primary key AssignedBy: Who (last) assigned this appointment to associate_id? Status: See note. RegisteredAssociateId: Registered by Nested index class: Appointment.IdxAssociateIdGroupIdxActiveDateTypeRegisteredMotherIdAppointmentIdAssignedByStatusRegisteredAssociateId Static Get method: GetFromIdxAssociateIdGroupIdxActiveDateTypeRegisteredMotherIdAppointmentIdAssignedByStatusRegisteredAssociateId(Int32, Int32, DateTime, AppointmentType, DateTime, Int32, Int32, Int32, AppointmentStatus, Int32)

Non-unique indexes on table Appointment are:

Index fields	Nested index class name
ActiveDate, Status, Type, AssociateId	ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status Status: See note. Type: See note. AssociateId: ID of associate whose diary the appointment is in, REQUIRED Nested index class: AppointmentCollection.IdxActiveDateStatusTypeAssociateId Static Get method: GetFromIdxActiveDateStatusTypeAssociateId(DateTime, AppointmentStatus, AppointmentType, Int32)
ContactId, Type	ContactId: Contact ID of owning contact, may be 0 Type: See note. Nested index class: AppointmentCollection.IdxContactIdType Static Get method: GetFromIdxContactIdType(Int32, AppointmentType)
ProjectId, Type	ProjectId: ID of project referred to, may be 0 Type: See note. Nested index class: AppointmentCollection.IdxProjectIdType Static Get method: GetFromIdxProjectIdType(Int32, AppointmentType)
MotherId	MotherId: ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment Nested index class: AppointmentCollection.IdxMotherId Static Get method: GetFromIdxMotherId(Int32)
DoBy, Type, EndDate, AssociateId	DoBy: Date + start time planned Type: See note. EndDate: Date + end time planned AssociateId: ID of associate whose diary the appointment is in, REQUIRED Nested index class: AppointmentCollection.IdxDoByTypeEndDateAssociateId Static Get method: GetFromIdxDoByTypeEndDateAssociateId(DateTime, AppointmentType, DateTime, Int32)
ActiveDate	ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status Nested index class: AppointmentCollection.IdxActiveDate Static Get method: GetFromIdxActiveDate(DateTime)
AssociateId, DoBy, Status, Type	AssociateId: ID of associate whose diary the appointment is in, REQUIRED DoBy: Date + start time planned Status: See note. Type: See note. Nested index class: AppointmentCollection.IdxAssociateIdDoByStatusType Static Get method: GetFromIdxAssociateIdDoByStatusType(Int32, DateTime, AppointmentStatus, AppointmentType)
ActiveDate, MotherId, RecurrenceRuleId	ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status MotherId: ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment RecurrenceRuleId: Pointer to recurrence rule, for recurring appointments, otherwise 0 Nested index class: AppointmentCollection.IdxActiveDateMotherIdRecurrenceRuleId Static Get method: GetFromIdxActiveDateMotherIdRecurrenceRuleId(DateTime, Int32, Int32)
Source	Source: For future integration use; source of record Nested index class: AppointmentCollection.IdxSource Static Get method: GetFromIdxSource(Int16)
ContactId	ContactId: Contact ID of owning contact, may be 0 Nested index class: AppointmentCollection.IdxContactId Static Get method: GetFromIdxContactId(Int32)
ProjectId	ProjectId: ID of project referred to, may be 0 Nested index class: AppointmentCollection.IdxProjectId Static Get method: GetFromIdxProjectId(Int32)
DocumentId	DocumentId: Points to document record; 0 for non-document appointments! Nested index class: AppointmentCollection.IdxDocumentId Static Get method: GetFromIdxDocumentId(Int32)
AssociateId, Status, Done, Type	AssociateId: ID of associate whose diary the appointment is in, REQUIRED Status: See note. Done: Date + start time this task was actually performed Type: See note. Nested index class: AppointmentCollection.IdxAssociateIdStatusDoneType Static Get method: GetFromIdxAssociateIdStatusDoneType(Int32, AppointmentStatus, DateTime, AppointmentType)
PersonId	PersonId: Person ID of person the appointment is with, may be 0; if nonzero, must match the contact_id (which must then also be nonzero). Nested index class: AppointmentCollection.IdxPersonId Static Get method: GetFromIdxPersonId(Int32)
AssociateId, RecurrenceRuleId, ActiveDate	AssociateId: ID of associate whose diary the appointment is in, REQUIRED RecurrenceRuleId: Pointer to recurrence rule, for recurring appointments, otherwise 0 ActiveDate: The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status Nested index class: AppointmentCollection.IdxAssociateIdRecurrenceRuleIdActiveDate Static Get method: GetFromIdxAssociateIdRecurrenceRuleIdActiveDate(Int32, Int32, DateTime)
GroupIdx	GroupIdx: Group of owning associate at the time the appnt was created Nested index class: AppointmentCollection.IdxGroupIdx Static Get method: GetFromIdxGroupIdx(Int32)
UserdefId	UserdefId: User-defined table record 1 (for future use) Nested index class: AppointmentCollection.IdxUserdefId Static Get method: GetFromIdxUserdefId(Int32)
DoBy	DoBy: Date + start time planned Nested index class: AppointmentCollection.IdxDoBy Static Get method: GetFromIdxDoBy(DateTime)
TextId	TextId: ID of record containing appointment text, may be 0 for no text; note that bookings share a common text record Nested index class: AppointmentCollection.IdxTextId Static Get method: GetFromIdxTextId(Int32)
Userdef2Id	Userdef2Id: User-defined table record 2 (for future use) Nested index class: AppointmentCollection.IdxUserdef2Id Static Get method: GetFromIdxUserdef2Id(Int32)
Done	Done: Date + start time this task was actually performed Nested index class: AppointmentCollection.IdxDone Static Get method: GetFromIdxDone(DateTime)

Constructors

AppointmentCollection(AppointmentCollection.AppointmentCollectionIdx)

Constructor for class AppointmentCollection.
This object represents a collection of rows in table 'appointment'. Table contact: "Tasks, appointments, followups, phone calls; and documents"

Declaration

protected AppointmentCollection(AppointmentCollection.AppointmentCollectionIdx idx)

Parameters

Type	Name	Description
AppointmentCollection.AppointmentCollectionIdx	idx

Fields

_idx

Fetcher class the collection is based on

Declaration

protected AppointmentCollection.AppointmentCollectionIdx _idx

Field Value

Type	Description
AppointmentCollection.AppointmentCollectionIdx

_rows

Row objects that the collection is based on.

Declaration

protected AppointmentRows _rows

Field Value

Type	Description
AppointmentRows

Properties

Index

Retrieve the index for AppointmentCollection

Declaration

public AppointmentCollection.AppointmentCollectionIdx Index { get; }

Property Value

Type	Description
AppointmentCollection.AppointmentCollectionIdx

Item[Int32]

Get a Appointment from the collection from its zero-based index.

Declaration

public Appointment this[int index] { get; }

Parameters

Type	Name	Description
Int32	index	Zero-based index in the collection.

Property Value

Type	Description
Appointment

Rows

The ecapsulated object AppointmentRows.

Declaration

public AppointmentRows Rows { get; }

Property Value

Type	Description
AppointmentRows

Sentries

The collection of sentries that are guarding this collection of rows. This collection is used by RDB entities which return HDB collections.

For example, the contact.Faxes returns a PhoneRows collection in which each row will need to check the contact's sentry for permission to read/write their field

Declaration

public override SentryCollection Sentries { get; }

Property Value

Type	Description
SentryCollection

Overrides

EntityCollectionBase.Sentries

Methods

Add(Appointment)

Add one Appointment to the collection.

Declaration

public int Add(Appointment appointment)

Parameters

Type	Name	Description
Appointment	appointment	An instance of Appointment to be added to the collection.

Returns

Type	Description
Int32	The index of the added Appointment.

AddNew()

Get a new instance of Appointment added to the collection.

Declaration

public Appointment AddNew()

Returns

Type	Description
Appointment	A new instance of Appointment added to the collection.

CreateChild()

Create a new instance of Appointment

Declaration

protected override EntityBase CreateChild()

Returns

Type	Description
EntityBase	New instance of Appointment

Overrides

EntityCollectionBase.CreateChild()

CreateNew()

Create a new instance of the AppointmentCollection.

Declaration

public static AppointmentCollection CreateNew()

Returns

Type	Description
AppointmentCollection	A new instance of the AppointmentCollection.

GetFromCustomSearch(AppointmentCollection.CustomSearch)

Create a new instance of the AppointmentCollection object, and populate it with data from a custom search. If the search returns no results, an empty collection will be returned; if the result contains rows, a collection of AppointmentRow objects representing each row will be returned.

Declaration

public static AppointmentCollection GetFromCustomSearch(AppointmentCollection.CustomSearch query)

Parameters

Type	Name	Description
AppointmentCollection.CustomSearch	query	The custom search to execute against the database

Returns

Type	Description
AppointmentCollection	A new instance of the AppointmentCollection object, reflecting the result of the query.

GetFromIdxActiveDate(DateTime)

Create a new instance of the AppointmentRows object, and populate it with AppointmentRow objects based on the result of a query on the table Appointment. This method is intended to make it easy to use efficient queries that match a database index.

Declaration

public static AppointmentCollection GetFromIdxActiveDate(DateTime activeDate)

Parameters

Type	Name	Description
DateTime	activeDate	The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntActiveDate. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxActiveDateMotherIdRecurrenceRuleId(DateTime, Int32, Int32)

Declaration

public static AppointmentCollection GetFromIdxActiveDateMotherIdRecurrenceRuleId(DateTime activeDate, int motherId, int recurrenceRuleId)

Parameters

Type	Name	Description
DateTime	activeDate	The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status
Int32	motherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment
Int32	recurrenceRuleId	Pointer to recurrence rule, for recurring appointments, otherwise 0

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IRecurrenceRuleIdActiveDateMother_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxActiveDateStatusTypeAssociateId(DateTime, AppointmentStatus, AppointmentType, Int32)

Declaration

public static AppointmentCollection GetFromIdxActiveDateStatusTypeAssociateId(DateTime activeDate, AppointmentStatus status, AppointmentType type, int associateId)

Parameters

Type	Name	Description
DateTime	activeDate	The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status
AppointmentStatus	status	See note.
AppointmentType	type	See note.
Int32	associateId	ID of associate whose diary the appointment is in, REQUIRED

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IAssoc_idTypeStatusActiveDate. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxAssociateIdDoByStatusType(Int32, DateTime, AppointmentStatus, AppointmentType)

Declaration

public static AppointmentCollection GetFromIdxAssociateIdDoByStatusType(int associateId, DateTime doBy, AppointmentStatus status, AppointmentType type)

Parameters

Type	Name	Description
Int32	associateId	ID of associate whose diary the appointment is in, REQUIRED
DateTime	doBy	Date + start time planned
AppointmentStatus	status	See note.
AppointmentType	type	See note.

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IAssoc_idTypeStatusDo_by. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxAssociateIdRecurrenceRuleIdActiveDate(Int32, Int32, DateTime)

Declaration

public static AppointmentCollection GetFromIdxAssociateIdRecurrenceRuleIdActiveDate(int associateId, int recurrenceRuleId, DateTime activeDate)

Parameters

Type	Name	Description
Int32	associateId	ID of associate whose diary the appointment is in, REQUIRED
Int32	recurrenceRuleId	Pointer to recurrence rule, for recurring appointments, otherwise 0
DateTime	activeDate	The date to be used for searching & showing, is either the same as the done or do_by dates depending on type and status

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IRecurrenceRuleIdActiveDateAssoc_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxAssociateIdStatusDoneType(Int32, AppointmentStatus, DateTime, AppointmentType)

Declaration

public static AppointmentCollection GetFromIdxAssociateIdStatusDoneType(int associateId, AppointmentStatus status, DateTime done, AppointmentType type)

Parameters

Type	Name	Description
Int32	associateId	ID of associate whose diary the appointment is in, REQUIRED
AppointmentStatus	status	See note.
DateTime	done	Date + start time this task was actually performed
AppointmentType	type	See note.

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IAssoc_idTypeStatusDone. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxContactId(Int32)

Declaration

public static AppointmentCollection GetFromIdxContactId(int contactId)

Parameters

Type	Name	Description
Int32	contactId	Contact ID of owning contact, may be 0

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntCont_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxContactIdType(Int32, AppointmentType)

Declaration

public static AppointmentCollection GetFromIdxContactIdType(int contactId, AppointmentType type)

Parameters

Type	Name	Description
Int32	contactId	Contact ID of owning contact, may be 0
AppointmentType	type	See note.

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index ICont_idType. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxDoBy(DateTime)

Declaration

public static AppointmentCollection GetFromIdxDoBy(DateTime doBy)

Parameters

Type	Name	Description
DateTime	doBy	Date + start time planned

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntDo_by. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxDoByTypeEndDateAssociateId(DateTime, AppointmentType, DateTime, Int32)

Declaration

public static AppointmentCollection GetFromIdxDoByTypeEndDateAssociateId(DateTime doBy, AppointmentType type, DateTime endDate, int associateId)

Parameters

Type	Name	Description
DateTime	doBy	Date + start time planned
AppointmentType	type	See note.
DateTime	endDate	Date + end time planned
Int32	associateId	ID of associate whose diary the appointment is in, REQUIRED

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IAssoc_idTypeEndDateDo_by. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxDocumentId(Int32)

Declaration

public static AppointmentCollection GetFromIdxDocumentId(int documentId)

Parameters

Type	Name	Description
Int32	documentId	Points to document record; 0 for non-document appointments!

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntDoc_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxDone(DateTime)

Declaration

public static AppointmentCollection GetFromIdxDone(DateTime done)

Parameters

Type	Name	Description
DateTime	done	Date + start time this task was actually performed

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntDone. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxGroupIdx(Int32)

Declaration

public static AppointmentCollection GetFromIdxGroupIdx(int groupIdx)

Parameters

Type	Name	Description
Int32	groupIdx	Group of owning associate at the time the appnt was created

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntGrp_idx. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxMotherId(Int32)

Declaration

public static AppointmentCollection GetFromIdxMotherId(int motherId)

Parameters

Type	Name	Description
Int32	motherId	ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntMother_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxPersonId(Int32)

Declaration

public static AppointmentCollection GetFromIdxPersonId(int personId)

Parameters

Type	Name	Description
Int32	personId	Person ID of person the appointment is with, may be 0; if nonzero, must match the contact_id (which must then also be nonzero).

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntPers_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxProjectId(Int32)

Declaration

public static AppointmentCollection GetFromIdxProjectId(int projectId)

Parameters

Type	Name	Description
Int32	projectId	ID of project referred to, may be 0

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntProj_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxProjectIdType(Int32, AppointmentType)

Declaration

public static AppointmentCollection GetFromIdxProjectIdType(int projectId, AppointmentType type)

Parameters

Type	Name	Description
Int32	projectId	ID of project referred to, may be 0
AppointmentType	type	See note.

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IProj_idType. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxSource(Int16)

Declaration

public static AppointmentCollection GetFromIdxSource(short source)

Parameters

Type	Name	Description
Int16	source	For future integration use; source of record

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntSource. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxTextId(Int32)

Declaration

public static AppointmentCollection GetFromIdxTextId(int textId)

Parameters

Type	Name	Description
Int32	textId	ID of record containing appointment text, may be 0 for no text; note that bookings share a common text record

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntText_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxUserdef2Id(Int32)

Declaration

public static AppointmentCollection GetFromIdxUserdef2Id(int userdef2Id)

Parameters

Type	Name	Description
Int32	userdef2Id	User-defined table record 2 (for future use)

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntUdef2_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

GetFromIdxUserdefId(Int32)

Declaration

public static AppointmentCollection GetFromIdxUserdefId(int userdefId)

Parameters

Type	Name	Description
Int32	userdefId	User-defined table record 1 (for future use)

Returns

Type	Description
AppointmentCollection	New AppointmentRows collection containing the result of the index query. If no rows matched, the collection will be empty.

Remarks

The query matches the fields on the non-unique index IDXAppntUdef_id. Unique indexes have corresponding Create methods directly on the AppointmentRow object, since such indexes always return zero or one rows.

Remove(Appointment)

Removes the given Appointment from the collection

Declaration

public void Remove(Appointment appointment)

Parameters

Type	Name	Description
Appointment	appointment	the Appointment to be removed

ToArray()

Declaration

public Appointment[] ToArray()

Returns

Type	Description
Appointment[]

ToString()

For debugging: Number of members, and the first (up to) 5 items

Declaration

public override string ToString()

Returns

Type	Description
String

Overrides

Object.ToString()

Implements

INestedPersist

System.Collections.Generic.IEnumerable<T>

ISoCollection

System.Collections.IList

System.Collections.ICollection

System.Collections.IEnumerable

System.Collections.Specialized.INotifyCollectionChanged

System.ComponentModel.IBindingList

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)