Class TravellerRecordData

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

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

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

Constructors

TravellerRecordData()

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

Declaration
public TravellerRecordData()
Remarks

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

Fields

AreaId

ID of Area this traveller is on

Declaration
public int AreaId
Field Value
Type Description
int
Remarks

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

Databasetype

The database type he has

Declaration
public short Databasetype
Field Value
Type Description
short
Remarks

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

DbTag

Database tag, used for encryption key

Declaration
public string DbTag
Field Value
Type Description
string
Remarks

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

DefaultMakeReturn

Default value for the 'make return log' checkbox, based on last answer

Declaration
public short DefaultMakeReturn
Field Value
Type Description
short
Remarks

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

EncryptedComm

Use encrypted communication for this traveller: 0 = no, 1 = serial no as key, 2 = target db tag as key (secure but lots of hassle for support)

Declaration
public TravelEncryptionChild EncryptedComm
Field Value
Type Description
TravelEncryptionChild
Remarks

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

Generatedtime

Time of exit (local update)

Declaration
public DateTime Generatedtime
Field Value
Type Description
DateTime
Remarks

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

LastPlaybacknumber

File number of last file receieved from this traveller

Declaration
public int LastPlaybacknumber
Field Value
Type Description
int
Remarks

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

LastPlaybacktime

Datetime when we last read a file from this traveller

Declaration
public DateTime LastPlaybacktime
Field Value
Type Description
DateTime
Remarks

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

LastRecordnumber

Record ID of last traveltranslog record receieved from this traveller

Declaration
public int LastRecordnumber
Field Value
Type Description
int
Remarks

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

LastRecordtime

Datestamp from last traveltrans record read from this traveller (async)

Declaration
public DateTime LastRecordtime
Field Value
Type Description
DateTime
Remarks

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

Systemlevel

level in hierarchy

Declaration
public short Systemlevel
Field Value
Type Description
short
Remarks

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

TravelId

Central=0, Departm.=H01000000-H7F000000, Travel=assoc_id

Declaration
public int TravelId
Field Value
Type Description
int
Remarks

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

TravellerId

Primary key

Declaration
public int TravellerId
Field Value
Type Description
int
Remarks

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

Extension Methods