Class EjMessageRecordData

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

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

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

EjMessageRecordData()

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

Declaration
public EjMessageRecordData()
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

Author

A string representing the author of the message. Could be a user's name, or a persons email address.

Declaration
public string Author
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Badge

Badge to explicitly determine how a message was generated

Declaration
public BadgeType Badge
Field Value
Type Description
BadgeType
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Body

The textbody for the message.

Declaration
public string Body
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

BodyAttachment

If the body is too long for the database, it's stored in this attachment instead.

Declaration
public int BodyAttachment
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ChangedAt

When the message was changed.

Declaration
public DateTime ChangedAt
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ChangedBy

The id of the user who changed the message.

Declaration
public int ChangedBy
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CreatedAt

When the message was posted.

Declaration
public DateTime CreatedAt
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CreatedBy

The id of the user who posted the message. The value 1 (system user) for externally posted messages.

Declaration
public int CreatedBy
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CustomerId

If the message was created by email or from the customer center, this field will point to that customer. -1 if the message was created by an user

Declaration
public int CustomerId
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

DebugInfo

The debug info for the message.

Declaration
public string DebugInfo
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

EjMessageId

The primary key (auto-incremented)

Declaration
public int EjMessageId
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

EmailHeader

The email header is saved in this field as raw text

Declaration
public string EmailHeader
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

HtmlBody

The html body for the message (if any).

Declaration
public string HtmlBody
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

HtmlBodyAttachment

If the htmlbody is too long for the database, it's stored in this attachment instead.

Declaration
public int HtmlBodyAttachment
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

HtmlBodyInlineConverted

True if the html_body has converted inline image links.

Declaration
public short HtmlBodyInlineConverted
Field Value
Type Description
short
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Important

If this message is important or not.

Declaration
public short Important
Field Value
Type Description
short
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Inbox

The id of the inbox entry which created this message. Note: inbox entries are regularily deleted.

Declaration
public int Inbox
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Language

The language this message is in, based on some kind of analysis

Declaration
public string Language
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

MailSorter

The name of the mail sorter used when the email was imported. Note: We must use name instead of id since the id's change every time one changes the mail sorter. :-0

Declaration
public string MailSorter
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

MessageCategory

Defines what kind of message this is.

Declaration
public TicketMessageCategory MessageCategory
Field Value
Type Description
TicketMessageCategory
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

MessageId

The Message-Id header value from the email. Used for threading, i.e. connecting messages to existing tickets.

Declaration
public string MessageId
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SearchTitle

A copy of the title of the ticket, for search optimisation and simpler reporting.

Declaration
public string SearchTitle
Field Value
Type Description
string
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Sentiment

Sentiment index, 100 = completely happy; -100 = suicidally unhappy; 0 = no idea

Declaration
public int Sentiment
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SentimentConfidence

Confidence of sentiment index, 0 = no idea, 100 = completely sure

Declaration
public int SentimentConfidence
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Slevel

The securitylevel of the message.

Declaration
public TicketSecurityLevel Slevel
Field Value
Type Description
TicketSecurityLevel
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TicketId

The ticket this message is a child of.

Declaration
public int TicketId
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TimeCharge

The amount of time (minutes) which should be invoiced for this message.

Declaration
public int TimeCharge
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TimeSpent

The time spent (minutes) for this message.

Declaration
public int TimeSpent
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Type

The type of the message (plaintext/html).

Declaration
public TicketMessageType Type
Field Value
Type Description
TicketMessageType
Remarks

Please use this class instead of a full EjMessageRow 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 EjMessageTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods