Show / Hide Table of Contents

Class AppointmentRows.IdxAssociateIdStatusDoBy

Class representing index 'IAssoc_idStatusDo_byEndDate'. 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.IdxAssociateIdStatusDoBy
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.IdxAssociateIdStatusDoBy : AppointmentRows.AppointmentRowsIdx, ICloneable, ISentryIgnorable

Constructors

IdxAssociateIdStatusDoBy(int, AppointmentStatus, DateTime)

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

Declaration
public IdxAssociateIdStatusDoBy(int associateId, AppointmentStatus status, DateTime doBy)
Parameters
Type Name Description
int associateId
AppointmentStatus status
DateTime doBy

IdxAssociateIdStatusDoBy(int, AppointmentStatus, DateTime, DateTimeSearchType)

Constructor for class AppointmentRows.IdxAssociateIdStatusDoBy This class represents index 'IAssoc_idStatusDo_byEndDate'.

Declaration
public IdxAssociateIdStatusDoBy(int associateId, AppointmentStatus status, DateTime doBy, DateTimeSearchType doBySearchType)
Parameters
Type Name Description
int associateId
AppointmentStatus status
DateTime doBy
DateTimeSearchType doBySearchType

How to search for DoBy

Properties

AssociateId

ID of associate whose diary the appointment is in, REQUIRED

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

DoBy

date + start time planned

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

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

Status

status=done,started, not started, hidden

Declaration
public AppointmentStatus Status { get; set; }
Property Value
Type Description
AppointmentStatus

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