Show / Hide Table of Contents

Class AppointmentRows.IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType

Class representing index 'IMother_idStatusActiveDateReg'. 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.IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType
Implements
ICloneable
ISentryIgnorable
Inherited Members
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.InnerReturnFields
PrivateSelect.InnerOrderBy
PrivateSelect.IsDistinct
PrivateSelect.ForceRecompile
PrivateSelect.InnerGroupBy
PrivateSelect.InnerJoinRestriction
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
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public sealed class IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType : AppointmentRows.AppointmentRowsIdx, ICloneable, ISentryIgnorable

Constructors

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(Int32, AppointmentStatus, DateTime, DateTimeSearchType, Int32, DateTime, DateTimeSearchType, Int32, Int32, AppointmentType)

Constructor for class AppointmentRows.IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType This class represents index 'IMother_idStatusActiveDateReg_idRegAssignedByGrp_idxTypeAssoc_idId'.

Declaration
public IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int motherId, AppointmentStatus status, DateTime activeDate, DateTimeSearchType activeDateSearchType, int registeredAssociateId, DateTime registered, DateTimeSearchType registeredSearchType, int assignedBy, int groupIdx, AppointmentType type)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
DateTimeSearchType activeDateSearchType

How to search for ActiveDate

Int32 registeredAssociateId
DateTime registered
DateTimeSearchType registeredSearchType

How to search for Registered

Int32 assignedBy
Int32 groupIdx
AppointmentType type

IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(Int32, AppointmentStatus, DateTime, Int32, DateTime, Int32, Int32, AppointmentType)

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

Declaration
public IdxMotherIdStatusActiveDateRegisteredAssociateIdRegisteredAssignedByGroupIdxType(int motherId, AppointmentStatus status, DateTime activeDate, int registeredAssociateId, DateTime registered, int assignedBy, int groupIdx, AppointmentType type)
Parameters
Type Name Description
Int32 motherId
AppointmentStatus status
DateTime activeDate
Int32 registeredAssociateId
DateTime registered
Int32 assignedBy
Int32 groupIdx
AppointmentType type

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

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

Registered

Registered date

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

RegisteredAssociateId

Registered by whom

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

Status

status=done,started, not started, hidden

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

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
SuperOffice.CRM.Rows.IdxBase.UpdateRow(SuperOffice.CRM.Rows.TableRowBase)

Implements

System.ICloneable
ISentryIgnorable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
QueryExectionExtensions.ExecuteReader(SqlCommand, Boolean)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand, Boolean)
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