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
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class EjMessageRecordData : ObjectRemarks
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()
Declaration
public EjMessageRecordData()Fields
Author
A string representing the author of the message. Could be a user's name, or a persons email address.
Declaration
public string AuthorField Value
| Type | Description |
|---|---|
| System.String |
Badge
Badge to explicitly determine how a message was generated
Declaration
public BadgeType BadgeField Value
| Type | Description |
|---|---|
| BadgeType |
Body
The textbody for the message.
Declaration
public string BodyField Value
| Type | Description |
|---|---|
| System.String |
BodyAttachment
If the body is too long for the database, it's stored in this attachment instead.
Declaration
public int BodyAttachmentField Value
| Type | Description |
|---|---|
| System.Int32 |
ChangedAt
When the message was changed.
Declaration
public DateTime ChangedAtField Value
| Type | Description |
|---|---|
| System.DateTime |
ChangedBy
The id of the user who changed the message.
Declaration
public int ChangedByField Value
| Type | Description |
|---|---|
| System.Int32 |
CreatedAt
When the message was posted.
Declaration
public DateTime CreatedAtField Value
| Type | Description |
|---|---|
| System.DateTime |
CreatedBy
The id of the user who posted the message. The value 1 (system user) for externally posted messages.
Declaration
public int CreatedByField Value
| Type | Description |
|---|---|
| System.Int32 |
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 CustomerIdField Value
| Type | Description |
|---|---|
| System.Int32 |
DebugInfo
The debug info for the message.
Declaration
public string DebugInfoField Value
| Type | Description |
|---|---|
| System.String |
EjMessageId
The primary key (auto-incremented)
Declaration
public int EjMessageIdField Value
| Type | Description |
|---|---|
| System.Int32 |
EmailHeader
The email header is saved in this field as raw text
Declaration
public string EmailHeaderField Value
| Type | Description |
|---|---|
| System.String |
HtmlBody
The html body for the message (if any).
Declaration
public string HtmlBodyField Value
| Type | Description |
|---|---|
| System.String |
HtmlBodyAttachment
If the htmlbody is too long for the database, it's stored in this attachment instead.
Declaration
public int HtmlBodyAttachmentField Value
| Type | Description |
|---|---|
| System.Int32 |
HtmlBodyInlineConverted
True if the html_body has converted inline image links.
Declaration
public short HtmlBodyInlineConvertedField Value
| Type | Description |
|---|---|
| System.Int16 |
Important
If this message is important or not.
Declaration
public short ImportantField Value
| Type | Description |
|---|---|
| System.Int16 |
Inbox
The id of the inbox entry which created this message. Note: inbox entries are regularily deleted.
Declaration
public int InboxField Value
| Type | Description |
|---|---|
| System.Int32 |
Language
The language this message is in, based on some kind of analysis
Declaration
public string LanguageField Value
| Type | Description |
|---|---|
| System.String |
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 MailSorterField Value
| Type | Description |
|---|---|
| System.String |
MessageCategory
Defines what kind of message this is.
Declaration
public TicketMessageCategory MessageCategoryField Value
| Type | Description |
|---|---|
| TicketMessageCategory |
MessageId
The Message-Id header value from the email. Used for threading, i.e. connecting messages to existing tickets.
Declaration
public string MessageIdField Value
| Type | Description |
|---|---|
| System.String |
SearchTitle
A copy of the title of the ticket, for search optimisation and simpler reporting.
Declaration
public string SearchTitleField Value
| Type | Description |
|---|---|
| System.String |
Sentiment
Sentiment index, 100 = completely happy; -100 = suicidally unhappy; 0 = no idea
Declaration
public int SentimentField Value
| Type | Description |
|---|---|
| System.Int32 |
SentimentConfidence
Confidence of sentiment index, 0 = no idea, 100 = completely sure
Declaration
public int SentimentConfidenceField Value
| Type | Description |
|---|---|
| System.Int32 |
Slevel
The securitylevel of the message.
Declaration
public TicketSecurityLevel SlevelField Value
| Type | Description |
|---|---|
| TicketSecurityLevel |
TicketId
The ticket this message is a child of.
Declaration
public int TicketIdField Value
| Type | Description |
|---|---|
| System.Int32 |
TimeCharge
The amount of time (minutes) which should be invoiced for this message.
Declaration
public int TimeChargeField Value
| Type | Description |
|---|---|
| System.Int32 |
TimeSpent
The time spent (minutes) for this message.
Declaration
public int TimeSpentField Value
| Type | Description |
|---|---|
| System.Int32 |
Type
The type of the message (plaintext/html).
Declaration
public TicketMessageType TypeField Value
| Type | Description |
|---|---|
| TicketMessageType |