Show / Hide Table of Contents

Class AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateId

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.IdxProjectIdTypeActiveDateDocumentIdAssociateId
Implements
ICloneable
ISentryIgnorable
Inherited Members
AppointmentRow.AppointmentRowIdxBase.ToAppointmentRow()
AppointmentRow.AppointmentRowIdxBase.ToAppointmentRow(ITableRowLoadHandler)
AppointmentRow.AppointmentRowIdxBase.ToAppointmentRows()
AppointmentRow.AppointmentRowIdxBase.ToAppointmentRows(ITableRowLoadHandlerFactory)
AppointmentRow.AppointmentRowIdxBase.AppointmentTableInfo
IdxBase<AppointmentTableInfo>.TableInfo
IdxBase.OnIndexChanged()
IdxBase.BeginIgnoreSentryCheck()
IdxBase.EndIgnoreSentryCheck()
IdxBase.InnerOrderBy
IdxBase.InnerGroupBy
IdxBase.InnerJoinRestriction
IdxBase.InnerReturnFields
IdxBase.JoinRestriction
IdxBase.ReturnFields
IdxBase.IsSentryIgnored
PrivateSelect._isDistinct
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.CreateOrderBy()
PrivateSelect.IsDistinct
PrivateSelect.ForceRecompile
PrivateSelect.ForceJoinOrder
PrivateSelect.SqlType
SqlCommand.Origin
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()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public sealed class IdxProjectIdTypeActiveDateDocumentIdAssociateId : AppointmentRows.AppointmentRowsIdx, ICloneable, ISentryIgnorable

Constructors

IdxProjectIdTypeActiveDateDocumentIdAssociateId(Int32, AppointmentType, DateTime, DateTimeSearchType, Int32, Int32)

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

Declaration
public IdxProjectIdTypeActiveDateDocumentIdAssociateId(int projectId, AppointmentType type, DateTime activeDate, DateTimeSearchType activeDateSearchType, int documentId, int associateId)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
DateTimeSearchType activeDateSearchType

How to search for ActiveDate

Int32 documentId
Int32 associateId

IdxProjectIdTypeActiveDateDocumentIdAssociateId(Int32, AppointmentType, DateTime, Int32, Int32)

Constructor for class AppointmentRows.IdxProjectIdTypeActiveDateDocumentIdAssociateId 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 IdxProjectIdTypeActiveDateDocumentIdAssociateId(int projectId, AppointmentType type, DateTime activeDate, int documentId, int associateId)
Parameters
Type Name Description
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId

Properties

ActiveDate

The date to be used for searching & showing

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

AssociateId

ID of associate whose diary the appointment is in, REQUIRED

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

DocumentId

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

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

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

ProjectId

ID of project referred to, may be 0

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

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

System.ICloneable
ISentryIgnorable

Extension Methods

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