Class ActivityList.ActivityListQuery

ActivityListQuery is a nested class containing the necessary information to provide its outer class with enough information to build the list.

Inheritance

object

SqlCommand

TableExpression

ActivityList.ActivityListQuery

ActivityList.FromContact

ActivityList.FromProject

Inherited Members

TableExpression.GetTableInfos()

TableExpression.Add(params Select[])

TableExpression.TableExp

TableExpression.TableExpOrderBy

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.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Archives

Assembly: SoDataBase.dll

Syntax

public abstract class ActivityList.ActivityListQuery : TableExpression

Fields

_a

The AppointmentTableInfo to use in the list.

Declaration

protected AppointmentTableInfo _a

Field Value

Type	Description
AppointmentTableInfo

_ass

The AssociateTableInfo to use in the list.

Declaration

protected AssociateTableInfo _ass

Field Value

Type	Description
AssociateTableInfo

_assRegistered

The AssociateTableInfo to use in the list for the user who created the appointment.

Declaration

protected AssociateTableInfo _assRegistered

Field Value

Type	Description
AssociateTableInfo

_associates

Associates of interest.

Declaration

protected int[] _associates

Field Value

Type	Description
int[]

_contact_id

The contact of interest.

Declaration

protected int _contact_id

Field Value

Type	Description
int

_d

The DocumentTableInfo to use in the list.

Declaration

protected DocumentTableInfo _d

Field Value

Type	Description
DocumentTableInfo

_date

What kind of time period do we want to look at?

Declaration

protected DateTimeSearchType _date

Field Value

Type	Description
DateTimeSearchType

_dt

The DocTmplTableInfo to use in the list.

Declaration

protected DocTmplTableInfo _dt

Field Value

Type	Description
DocTmplTableInfo

_dummyParameter

Dummy parameter. Used as null-value in the queries.

Declaration

protected Parameter _dummyParameter

Field Value

Type	Description
Parameter

_endDate

Enddate (and time) for DateTimeSearchType-less queries.

Declaration

protected DateTime _endDate

Field Value

Type	Description
DateTime

_p

The PersonTableInfo to use in the list.

Declaration

protected PersonTableInfo _p

Field Value

Type	Description
PersonTableInfo

_personRegistered

The AssociateTableInfo to use in the list for the user who created the appointment.

Declaration

protected PersonTableInfo _personRegistered

Field Value

Type	Description
PersonTableInfo

_pr

The ProjectTableInfo to use in the list.

Declaration

protected ProjectTableInfo _pr

Field Value

Type	Description
ProjectTableInfo

_prob

The ProbTableInfo to use in the list.

Declaration

protected ProbTableInfo _prob

Field Value

Type	Description
ProbTableInfo

_project_id

Project of interest.

Declaration

protected int _project_id

Field Value

Type	Description
int

_s

The SaleTableInfo to use in the list.

Declaration

protected SaleTableInfo _s

Field Value

Type	Description
SaleTableInfo

_startDate

Startdate (and time) for DateTimeSearchType-less queries.

Declaration

protected DateTime _startDate

Field Value

Type	Description
DateTime

_t

The TextTableInfo to use in the list.

Declaration

protected TextTableInfo _t

Field Value

Type	Description
TextTableInfo

_ta

The TaskTableInfo to use in the list.

Declaration

protected TaskTableInfo _ta

Field Value

Type	Description
TaskTableInfo

_type

How to filter information.

Declaration

protected ArchiveFilterType _type

Field Value

Type	Description
ArchiveFilterType

Properties

SqlType

SqlType

Declaration

public override SqlType SqlType { get; }

Property Value

Type	Description
SqlType

Overrides

SqlCommand.SqlType

Methods

ToActivityListAsync(CancellationToken)

ToActivityList creates the ActivityList based on the information that is contained in its class.

Declaration

public Task<ActivityList> ToActivityListAsync(CancellationToken cancellationToken = default)

Parameters

Type	Name	Description
CancellationToken	cancellationToken

Returns

Type	Description
Task<ActivityList>	The ActivityList.

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)