Show / Hide Table of Contents

Class AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy

Class representing index 'IProj_idTypeActiveDateDoc_idA'. This particular class implements a from-the-left subset of the fields, to ease coding of these efficient searches

Inheritance
object
SqlCommand
PrivateSelect
IdxBase
IdxBase<AppointmentTableInfo>
AppointmentRow.AppointmentRowIdxBase
AppointmentRows.AppointmentRowsIdx
AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy
Implements
ICloneable
ISentryIgnorable
Inherited Members
PrivateSelect.GetTableInfos()
PrivateSelect.GetRelations(TableInfo)
PrivateSelect.GetRelations(TableInfo, SoTable)
PrivateSelect.IsTableOuterJoined(TableInfo)
PrivateSelect.GetTablesInOrderBy()
PrivateSelect.GetTablesLeadingToTable(TableInfo)
PrivateSelect.ValidateJoin()
PrivateSelect.Clone()
PrivateSelect.CloneSelect()
PrivateSelect.ToString()
PrivateSelect.GetCachingHash()
PrivateSelect.GetRestrictionTables()
PrivateSelect.IsDistinct
PrivateSelect.ForceRecompile
PrivateSelect.SqlType
SqlCommand.Origin
SqlCommand.AdditionalInfo
SqlCommand.AddIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.AddIgnoreAutoSentryTableInfo(IEnumerable<TableInfo>)
SqlCommand.RemoveIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.ClearIgnoreAutoSentryTableInfos()
SqlCommand.IsAutoSentryIgnoredOnTableInfo(TableInfo)
SqlCommand.GetPrivateSaves()
SqlCommand.GetInserts()
SqlCommand.GetUpdates()
SqlCommand.GetDeletes()
SqlCommand.GetSelect()
SqlCommand.AutoSentryIgnoredTables
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public sealed class AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy : AppointmentRows.AppointmentRowsIdx, ICloneable, ISentryIgnorable

Constructors

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int, AppointmentType, DateTime, DateTimeSearchType, int, int, int, int, int)

Constructor for class AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy This class represents index 'IProj_idTypeActiveDateDoc_idAssoc_idGrp_idxMother_idAssignedByIdRegReg_id'.

Declaration
public IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int projectId, AppointmentType type, DateTime activeDate, DateTimeSearchType activeDateSearchType, int documentId, int associateId, int groupIdx, int motherId, int assignedBy)
Parameters
Type Name Description
int projectId
AppointmentType type
DateTime activeDate
DateTimeSearchType activeDateSearchType

How to search for ActiveDate

int documentId
int associateId
int groupIdx
int motherId
int assignedBy

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int, AppointmentType, DateTime, int, int, int, int, int)

Constructor for class AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy This class represents index 'IProj_idTypeActiveDateDoc_idAssoc_idGrp_idxMother_idAssignedByIdRegReg_id'. This particular class implements a from-the-left subset of the fields, to ease coding of these efficient searches

Declaration
public IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId, int groupIdx, int motherId, int assignedBy)
Parameters
Type Name Description
int projectId
AppointmentType type
DateTime activeDate
int documentId
int associateId
int groupIdx
int motherId
int assignedBy

Properties

ActiveDate

The date to be used for searching & showing

Declaration
public DateTime ActiveDate { get; set; }
Property Value
Type Description
DateTime

AssignedBy

Who (last) assigned this appointment to associate_id?

Declaration
public int AssignedBy { get; set; }
Property Value
Type Description
int

AssociateId

ID of associate whose diary the appointment is in, REQUIRED

Declaration
public int AssociateId { get; set; }
Property Value
Type Description
int

DocumentId

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

Declaration
public int DocumentId { get; set; }
Property Value
Type Description
int

GroupIdx

Group of owning associate at the time tha ppnt was created

Declaration
public int GroupIdx { get; set; }
Property Value
Type Description
int

InnerRestriction

The Restriction passed to the Select statement.

Declaration
protected override Restriction InnerRestriction { get; }
Property Value
Type Description
Restriction

Restriction object holding the restrictions for the select statement.

Overrides
PrivateSelect.InnerRestriction

MotherId

ID of mother appointment; self if booking master, master ID if booking slave, 0 if normal appointment. However, if 0 and assoc_id != reg_id then this is an assigned appointment, indicated vt type = kBooking

Declaration
public int MotherId { get; set; }
Property Value
Type Description
int

ProjectId

ID of project referred to, may be 0

Declaration
public int ProjectId { get; set; }
Property Value
Type Description
int

Type

where=no start time,note,docin, docout

Declaration
public AppointmentType Type { get; set; }
Property Value
Type Description
AppointmentType

Methods

UpdateRow(TableRowBase)

Update the AppointmentRow with the values from the index.

Declaration
public override void UpdateRow(TableRowBase baseRow)
Parameters
Type Name Description
TableRowBase baseRow

The row to update. This must be an instance of AppointmentRow.

Overrides
IdxBase.UpdateRow(TableRowBase)

Implements

ICloneable
ISentryIgnorable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
QueryExectionExtensions.ExecuteNonQuery(SqlCommand)
QueryExectionExtensions.ExecuteNonQueryAsync(SqlCommand, CancellationToken)
QueryExectionExtensions.ExecuteReader(SqlCommand, bool)
QueryExectionExtensions.ExecuteReaderAsync(SqlCommand, bool, CancellationToken)
QueryExectionExtensions.ExecuteScalarAsync<T>(SqlCommand, bool, CancellationToken)
QueryExectionExtensions.ExecuteScalarAsync<T>(SqlCommand, CancellationToken)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top