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
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 IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy : AppointmentRows.AppointmentRowsIdx, ICloneable, ISentryIgnorable

Constructors

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(Int32, AppointmentType, DateTime, DateTimeSearchType, Int32, Int32, Int32, Int32, Int32)

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
Int32 projectId
AppointmentType type
DateTime activeDate
DateTimeSearchType activeDateSearchType

How to search for ActiveDate

Int32 documentId
Int32 associateId
Int32 groupIdx
Int32 motherId
Int32 assignedBy

IdxProjectIdTypeActiveDateDocumentIdAssociateIdGroupIdxMotherIdAssignedBy(Int32, AppointmentType, DateTime, Int32, Int32, Int32, Int32, Int32)

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
Int32 projectId
AppointmentType type
DateTime activeDate
Int32 documentId
Int32 associateId
Int32 groupIdx
Int32 motherId
Int32 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
Int32

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

GroupIdx

Group of owning associate at the time tha ppnt was created

Declaration
public int GroupIdx { 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

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
Int32

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 |  Back to top