Class VisibleForRecordData

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

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

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

Constructors

VisibleForRecordData()

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

Declaration
public VisibleForRecordData()
Remarks

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

Fields

AppointmentId

Shortcut: appointment id, if tableId = appointment; to give faster joins

Declaration
public int AppointmentId
Field Value
Type Description
int
Remarks

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

EncryptedCheck

Encrypted checksum field, to prevent tampering

Declaration
public string EncryptedCheck
Field Value
Type Description
string
Remarks

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

ForAll

1 = visible to all, 0 = not visible to all

Declaration
public int ForAll
Field Value
Type Description
int
Remarks

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

ForAssocId

0 = not visible to any particular associate, or ID of associate

Declaration
public int ForAssocId
Field Value
Type Description
int
Remarks

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

ForGroupId

0 = not visible to any particular group, or ID of group

Declaration
public int ForGroupId
Field Value
Type Description
int
Remarks

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

RecordId

ID of row this right applies to

Declaration
public int RecordId
Field Value
Type Description
int
Remarks

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

SaleHistId

Shortcut: salehist id, if tableId = salehist to give faster joins

Declaration
public int SaleHistId
Field Value
Type Description
int
Remarks

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

SaleId

Shortcut: sale id, if tableId = sale to give faster joins

Declaration
public int SaleId
Field Value
Type Description
int
Remarks

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

SelectionId

Shortcut: selection id, if tableId = selection to give faster joins

Declaration
public int SelectionId
Field Value
Type Description
int
Remarks

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

TableId

ID of table this right is valid for

Declaration
public short TableId
Field Value
Type Description
short
Remarks

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

VisibleForId

Primary key

Declaration
public int VisibleForId
Field Value
Type Description
int
Remarks

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

Extension Methods