Class EjuserRecordData

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

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

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

Constructors

EjuserRecordData()

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

Declaration
public EjuserRecordData()
Remarks

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

Fields

AccessLevel

The access level for this user.

Declaration
public int AccessLevel
Field Value
Type Description
int
Remarks

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

ChatStatus

Various chat statuses for an agent

Declaration
public ChatStatus ChatStatus
Field Value
Type Description
ChatStatus
Remarks

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

DateFormat

The preferred format of dates and datetimes (enum) for this user.

Declaration
public short DateFormat
Field Value
Type Description
short
Remarks

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

DateFormatLongString

Chosen date format for lists as a string for this user

Declaration
public string DateFormatLongString
Field Value
Type Description
string
Remarks

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

DateFormatString

Chosen date format as a string for this user

Declaration
public string DateFormatString
Field Value
Type Description
string
Remarks

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

DbiKey

The primary key for the integrated entry in the external datasource.

Declaration
public string DbiKey
Field Value
Type Description
string
Remarks

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

DbiLastModified

When the entry was last modified.

Declaration
public DateTime DbiLastModified
Field Value
Type Description
DateTime
Remarks

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

DbiLastSyncronized

Last external syncronization.

Declaration
public DateTime DbiLastSyncronized
Field Value
Type Description
DateTime
Remarks

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

DefaultCategory

The default category for this user when posting tickets and use_last_category is false.

Declaration
public int DefaultCategory
Field Value
Type Description
int
Remarks

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

DefaultStatusAddMessage

Default status on add message.

Declaration
public int DefaultStatusAddMessage
Field Value
Type Description
int
Remarks

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

DefaultStatusNewTicket

Default status on new requests.

Declaration
public int DefaultStatusNewTicket
Field Value
Type Description
int
Remarks

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

DefaultUser

The default user to set on new tickets in this category (1=automatically, 2=unasigned, 3=the owner

Declaration
public int DefaultUser
Field Value
Type Description
int
Remarks

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

Dictionary

A string indicating the user's prefered dictionary language ('no' or 'en').

Declaration
public string Dictionary
Field Value
Type Description
string
Remarks

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

EjuserId

The primary key (auto-incremented)

Declaration
public int EjuserId
Field Value
Type Description
int
Remarks

Please use this class instead of a full EjuserRow 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 EjuserTableInfo 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 for this user.

Declaration
public string Email
Field Value
Type Description
string
Remarks

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

EmailMask

A bitmask indicated to which extent the user should recieve email warnings for various events.

Declaration
public int EmailMask
Field Value
Type Description
int
Remarks

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

Firstname

The firstname for this user.

Declaration
public string Firstname
Field Value
Type Description
string
Remarks

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

Flags

A bitmask indicating flags for this entry.

Declaration
public int Flags
Field Value
Type Description
int
Remarks

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

HiddenBagBitset

Each character represent a bit to set a HtmlBagHideable to default open or closed (1=open 0=closed)

Declaration
public string HiddenBagBitset
Field Value
Type Description
string
Remarks

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

IdleTime

Number of seconds the user has been idle. Updated by TrayIcon or simular external programs.

Declaration
public int IdleTime
Field Value
Type Description
int
Remarks

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

Language

A string indicating the user's language ('no' or 'en').

Declaration
public string Language
Field Value
Type Description
string
Remarks

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

LastCategory

The last chosen category for this user when posting tickets.

Declaration
public int LastCategory
Field Value
Type Description
int
Remarks

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

LastLoginAttempt

The last time the user tried to log in without success

Declaration
public DateTime LastLoginAttempt
Field Value
Type Description
DateTime
Remarks

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

Lastname

The lastname for this user.

Declaration
public string Lastname
Field Value
Type Description
string
Remarks

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

LoginAttempts

The number of times the user has attempted to login with the wrong password

Declaration
public int LoginAttempts
Field Value
Type Description
int
Remarks

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

Loginname

The unique loginname for this user.

Declaration
public string Loginname
Field Value
Type Description
string
Remarks

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

Middlename

The middlename for this user.

Declaration
public string Middlename
Field Value
Type Description
string
Remarks

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

MinuteOffset

Offset in hours between server and ejuser timezone.

Declaration
public int MinuteOffset
Field Value
Type Description
int
Remarks

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

NewGui

Whether to use the new gui or not

Declaration
public short NewGui
Field Value
Type Description
short
Remarks

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

NotPresent

Comment to add for user when status is not present.

Declaration
public string NotPresent
Field Value
Type Description
string
Remarks

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

NotifyExternalLock

A datetime lock to make sure notifications are only displayed by one notifcation system (ejournal or external programs)

Declaration
public DateTime NotifyExternalLock
Field Value
Type Description
DateTime
Remarks

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

NotifyExternalSource

A name (id) of the external notifications system (ejournal or external programs)

Declaration
public string NotifyExternalSource
Field Value
Type Description
string
Remarks

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

NotifyMask

A bitmask indicating to which extent the user should recieve pop-up warnings for various events.

Declaration
public int NotifyMask
Field Value
Type Description
int
Remarks

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

NumExpandedMessages

The number of expanded messages in show-ticket view.

Declaration
public int NumExpandedMessages
Field Value
Type Description
int
Remarks

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

Password

The encrypted password for this user.

Declaration
public string Password
Field Value
Type Description
string
Remarks

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

PictureId

The attachment.id this reference is connected to.

Declaration
public int PictureId
Field Value
Type Description
int
Remarks

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

ProfileId

Reference to the profile connected to this ejuser

Declaration
public int ProfileId
Field Value
Type Description
int
Remarks

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

Signature

The users signature.

Declaration
public string Signature
Field Value
Type Description
string
Remarks

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

SimultaneousLogin

A boolean telling if the user is counted as one of the simultaneous ones, or one who alway may log in

Declaration
public short SimultaneousLogin
Field Value
Type Description
short
Remarks

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

Sms

The SMS number for this user

Declaration
public string Sms
Field Value
Type Description
string
Remarks

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

SmsMask

A bitmask indicated to which extent the user should recieve sms warnings for various events.

Declaration
public int SmsMask
Field Value
Type Description
int
Remarks

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

Status

The status (enum) for this user.

Declaration
public short Status
Field Value
Type Description
short
Remarks

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

Textareasize

Size of textarea for each user, example '80x40'

Declaration
public string Textareasize
Field Value
Type Description
string
Remarks

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

TimeFormatString

Chosen time format as a string for this user

Declaration
public string TimeFormatString
Field Value
Type Description
string
Remarks

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

Usergroup

The group this user is member of

Declaration
public int Usergroup
Field Value
Type Description
int
Remarks

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

Username

The unique username for this user.

Declaration
public string Username
Field Value
Type Description
string
Remarks

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

Extension Methods