Class ChatSessionRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the chat_session table.

Inheritance
object
ChatSessionRecordData
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class ChatSessionRecordData
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

ChatSessionRecordData()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the chat_session table.

Declaration
public ChatSessionRecordData()
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

AlertLevel

The alert level for this chat session.

Declaration
public int AlertLevel
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ChatSessionId

The primary key (auto-incremented)

Declaration
public int ChatSessionId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ChatbotIsactive

Indicates that a chatbot is active on the session. This will cause bot triggers to fire. Set to 0 when bot hands off to user.

Declaration
public short ChatbotIsactive
Field Value
Type Description
short
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CompanyName

The name of the customers company, if provided

Declaration
public string CompanyName
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Consented

The customer consented when starting the session

Declaration
public short Consented
Field Value
Type Description
short
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ContactId

The contact that this chat session is connected to

Declaration
public int ContactId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Country

The country that the chat customer selected.

Declaration
public int Country
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CustomerAlias

The alias for the customer.

Declaration
public string CustomerAlias
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CustomerFetch

The last time the customer's client refetched the data. Used to detect 'dead' session.

Declaration
public DateTime CustomerFetch
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CustomerHost

The hostname or IP address for the customer.

Declaration
public string CustomerHost
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CustomerId

The reference to the associated customer. May be NULL or -1.

Declaration
public int CustomerId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Email

The email address of the customer, if provided

Declaration
public string Email
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

FirstMessage

A copy of the first message in the chat session

Declaration
public string FirstMessage
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Flags

Various flags for the chat session

Declaration
public ChatSessionFlags Flags
Field Value
Type Description
ChatSessionFlags
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Idle

The last time anyone sent a message for this session.

Declaration
public DateTime Idle
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

InitialQueuePos

The initial queue pos (i.e. the number of pending sessions + 1) when the session was requested.

Declaration
public int InitialQueuePos
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LastMessage

A copy of the last message in the chat session

Declaration
public string LastMessage
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Name

The name of customer, if provided

Declaration
public string Name
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Phone

The phone number of the customer, if provided

Declaration
public string Phone
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ProjectId

The project that this chat session is connected to

Declaration
public int ProjectId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Rank

Lowest possible unique number for active sessions for user. User for color index. Starting at 1.

Declaration
public int Rank
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Rating

Rating of this chat conversation given by the customer

Declaration
public int Rating
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SaleId

The sale that this chat session is connected to

Declaration
public int SaleId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SessionKey

Key used to authenticate the session.

Declaration
public string SessionKey
Field Value
Type Description
string
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Status

Enum indicating the status for the session (pending, active, closed, etc).

Declaration
public ChatSessionStatus Status
Field Value
Type Description
ChatSessionStatus
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TicketId

The ticket that this chat session is connected to

Declaration
public int TicketId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TopicId

The reference to the associated chat topic.

Declaration
public int TopicId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TransferTo

The ejuser that has a pending transfer of the chat session

Declaration
public int TransferTo
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UserId

The reference to the associated user.

Declaration
public int UserId
Field Value
Type Description
int
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

WhenEnded

When the session was ended.

Declaration
public DateTime WhenEnded
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

WhenRequested

When the session was requested by the customer.

Declaration
public DateTime WhenRequested
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

WhenStarted

When the session was accepted by a user.

Declaration
public DateTime WhenStarted
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ChatSessionRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ChatSessionTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods