Show / Hide Table of Contents

Class AppointmentCollection

Appointments, documents (document_id != 0).

Collection of Appointment. Each element of the collection represents one entity based on Appointment.
Inheritance
Object
NestedPersist
NestedPersistFacade
NestedCollectionPersist
EntityCollectionBase
AppointmentCollection
Implements
INestedPersist
IEnumerable<INestedPersist>
ISoCollection
IList
ICollection
IEnumerable
INotifyCollectionChanged
IBindingList
Inherited Members
EntityCollectionBase._innerList
EntityCollectionBase.Delete()
EntityCollectionBase.GetEnumerator()
EntityCollectionBase.Add(EntityBase)
EntityCollectionBase.ISoCollection.Add(ISoItem)
EntityCollectionBase.ISoCollection.AddNew()
EntityCollectionBase.Remove(EntityBase)
EntityCollectionBase.IList.get_Item(Int32)
EntityCollectionBase.IList.set_Item(Int32, Object)
EntityCollectionBase.CopyTo(Array, Int32)
EntityCollectionBase.IList.Add(Object)
EntityCollectionBase.IList.Remove(Object)
EntityCollectionBase.IndexOf(Object)
EntityCollectionBase.Contains(Object)
EntityCollectionBase.IList.Clear()
EntityCollectionBase.IList.Insert(Int32, Object)
EntityCollectionBase.IList.RemoveAt(Int32)
EntityCollectionBase.AddIndex(PropertyDescriptor)
EntityCollectionBase.ApplySort(PropertyDescriptor, ListSortDirection)
EntityCollectionBase.Find(PropertyDescriptor, Object)
EntityCollectionBase.RemoveIndex(PropertyDescriptor)
EntityCollectionBase.RemoveSort()
EntityCollectionBase.IsDirty
EntityCollectionBase.Count
EntityCollectionBase.IList.Item[Int32]
EntityCollectionBase.ICollection.Count
EntityCollectionBase.IsFixedSize
EntityCollectionBase.IsReadOnly
EntityCollectionBase.ICollection.IsSynchronized
EntityCollectionBase.ICollection.SyncRoot
EntityCollectionBase.AllowEdit
EntityCollectionBase.AllowNew
EntityCollectionBase.AllowRemove
EntityCollectionBase.IsSorted
EntityCollectionBase.SortDirection
EntityCollectionBase.SortProperty
EntityCollectionBase.SupportsChangeNotification
EntityCollectionBase.SupportsSearching
EntityCollectionBase.SupportsSorting
EntityCollectionBase.CollectionChanged
EntityCollectionBase.ListChanged
NestedCollectionPersist.GetFacadingItems()
NestedCollectionPersist.IEnumerable<INestedPersist>.GetEnumerator()
NestedCollectionPersist.IsDeleted
NestedPersistFacade.OnPreIdUpdate()
NestedPersistFacade.OnPrimaryKeyRequest(PKContainer)
NestedPersistFacade.OnPrimaryKeyUpdate(PKContainer)
NestedPersistFacade.OnIdUpdate()
NestedPersistFacade.OnSave(BatchSave)
NestedPersistFacade.OnSaved(Boolean)
NestedPersist._saveOwner
NestedPersist._isSaving
NestedPersist.SetSaveOwner(INestedPersist)
NestedPersist.Save()
NestedPersist.INestedPersist.OnPreIdUpdate()
NestedPersist.INestedPersist.OnPrimaryKeyRequest(PKContainer)
NestedPersist.INestedPersist.OnPrimaryKeyUpdate(PKContainer)
NestedPersist.INestedPersist.OnIdUpdate()
NestedPersist.INestedPersist.OnSave(BatchSave)
NestedPersist.INestedPersist.OnSaved(Boolean)
NestedPersist.IsSaving
NestedPersist.IsMarkedForDelete
NestedPersist.OnElementSaved
NestedPersist.OnElementIdUpdate
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Entities
Assembly: SoDataBase.dll
Syntax
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 fieldsNested index class name
AppointmentIdAppointmentId:

Primary key

Nested index class: Appointment.IdxAppointmentId

Static Get method: GetFromIdxAppointmentId(Int32)

ActiveDate, MotherId, Type, DocumentId, AppointmentId, AssignedBy, AssociateId, ProjectId, GroupIdx, Registered, RegisteredAssociateIdActiveDate:

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, MotherIdActiveDate:

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, RegisteredAssociateIdAssociateId:

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 fieldsNested index class name
ActiveDate, Status, Type, AssociateIdActiveDate:

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, TypeContactId:

Contact ID of owning contact, may be 0

Type:

See note.

Nested index class: AppointmentCollection.IdxContactIdType

Static Get method: GetFromIdxContactIdType(Int32, AppointmentType)

ProjectId, TypeProjectId:

ID of project referred to, may be 0

Type:

See note.

Nested index class: AppointmentCollection.IdxProjectIdType

Static Get method: GetFromIdxProjectIdType(Int32, AppointmentType)

MotherIdMotherId:

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, AssociateIdDoBy:

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)

ActiveDateActiveDate:

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, TypeAssociateId:

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, RecurrenceRuleIdActiveDate:

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)

SourceSource:

For future integration use; source of record

Nested index class: AppointmentCollection.IdxSource

Static Get method: GetFromIdxSource(Int16)

ContactIdContactId:

Contact ID of owning contact, may be 0

Nested index class: AppointmentCollection.IdxContactId

Static Get method: GetFromIdxContactId(Int32)

ProjectIdProjectId:

ID of project referred to, may be 0

Nested index class: AppointmentCollection.IdxProjectId

Static Get method: GetFromIdxProjectId(Int32)

DocumentIdDocumentId:

Points to document record; 0 for non-document appointments!

Nested index class: AppointmentCollection.IdxDocumentId

Static Get method: GetFromIdxDocumentId(Int32)

AssociateId, Status, Done, TypeAssociateId:

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)

PersonIdPersonId:

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, ActiveDateAssociateId:

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)

GroupIdxGroupIdx:

Group of owning associate at the time the appnt was created

Nested index class: AppointmentCollection.IdxGroupIdx

Static Get method: GetFromIdxGroupIdx(Int32)

UserdefIdUserdefId:

User-defined table record 1 (for future use)

Nested index class: AppointmentCollection.IdxUserdefId

Static Get method: GetFromIdxUserdefId(Int32)

DoByDoBy:

Date + start time planned

Nested index class: AppointmentCollection.IdxDoBy

Static Get method: GetFromIdxDoBy(DateTime)

TextIdTextId:

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)

Userdef2IdUserdef2Id:

User-defined table record 2 (for future use)

Nested index class: AppointmentCollection.IdxUserdef2Id

Static Get method: GetFromIdxUserdef2Id(Int32)

DoneDone:

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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)

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 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)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top