Class EmailRecordData

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

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

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

Constructors

EmailRecordData()

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

Declaration
public EmailRecordData()
Remarks

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

Fields

AppointmentId

The id of the invitation appointment record, used when unknown person is associated with an appointment invitation

Declaration
public int AppointmentId
Field Value
Type Description
int
Remarks

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

BounceCount

Number of bounces detected

Declaration
public short BounceCount
Field Value
Type Description
short
Remarks

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

ContactId

Relations to possible owners

Declaration
public int ContactId
Field Value
Type Description
int
Remarks

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

DbiAgentId

Integration agent (eJournal)

Declaration
public int DbiAgentId
Field Value
Type Description
int
Remarks

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

Description

Visible field

Declaration
public string Description
Field Value
Type Description
string
Remarks

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

EmailAddress

The address itself

Declaration
public string EmailAddress
Field Value
Type Description
string
Remarks

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

EmailId

Primary key

Declaration
public int EmailId
Field Value
Type Description
int
Remarks

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

LastBounce

When did last bounce happen

Declaration
public DateTime LastBounce
Field Value
Type Description
DateTime
Remarks

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

LastBounceCode

If this email address has bounced and we have a bounce code, this field will contain the code for the last bounce

Declaration
public int LastBounceCode
Field Value
Type Description
int
Remarks

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

LastBounceReason

If this email address has bounced and we have a bounce reason, this field will contain the reason for the last bounce

Declaration
public string LastBounceReason
Field Value
Type Description
string
Remarks

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

LastSent

Last transmission (regardless of success/bounce)

Declaration
public DateTime LastSent
Field Value
Type Description
DateTime
Remarks

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

PersonId

Relations to possible owners

Declaration
public int PersonId
Field Value
Type Description
int
Remarks

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

ProjectId

Relations to possible owners

Declaration
public int ProjectId
Field Value
Type Description
int
Remarks

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

Protocol

SMTP, MSN, Skype, etc

Declaration
public string Protocol
Field Value
Type Description
string
Remarks

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

Rank

Rank order in lists

Declaration
public short Rank
Field Value
Type Description
short
Remarks

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

Registered

Registered when in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

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

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
Remarks

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

ReservedId1

Reserved for potential future owners

Declaration
public int ReservedId1
Field Value
Type Description
int
Remarks

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

ReservedId2

Reserved for potential future owners

Declaration
public int ReservedId2
Field Value
Type Description
int
Remarks

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

Type

0 = email, 1 = chat/instant msg, 2 = voip; see protocol field for more info

Declaration
public EmailType Type
Field Value
Type Description
EmailType
Remarks

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

Updated

Last updated when in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

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

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
Remarks

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

UpdatedCount

Number of updates made to this record

Declaration
public short UpdatedCount
Field Value
Type Description
short
Remarks

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

Extension Methods