Class ProjectRecordData

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

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

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

Constructors

ProjectRecordData()

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

Declaration
public ProjectRecordData()
Remarks

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

Fields

The number of Erp Sync connections this record is synced with; count of the ErpExternalKey+ErpInternalKey relations

Declaration
public int ActiveErpLinks
Field Value
Type Description
int

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

Number of active links to documents, other appointments, and such

Declaration
public uint ActiveLinks
Field Value
Type Description
uint

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

AssociateId

Project manager/owner

Declaration
public int AssociateId
Field Value
Type Description
int
Remarks

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

Done

Done (0=false, 1=true). Status implies changes in which fields are shown in GUI, as well as which fields can be updated

Declaration
public short Done
Field Value
Type Description
short
Remarks

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

EndDate

Planned end date for project, inhertied from type and later editable

Declaration
public DateTime EndDate
Field Value
Type Description
DateTime
Remarks

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

GroupId

Group id of original owning associate, semantics like appnt.grp_id

Declaration
public int GroupId
Field Value
Type Description
int
Remarks

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

Name

Project name

Declaration
public string Name
Field Value
Type Description
string
Remarks

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

NextMilestoneDate

Calculated date, reflects date of closest non-complete future milestone activity

Declaration
public DateTime NextMilestoneDate
Field Value
Type Description
DateTime
Remarks

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

NmdAppointmentId

ID of appointment that "caused" the nextMilestoneDate, can be 0

Declaration
public int NmdAppointmentId
Field Value
Type Description
int
Remarks

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

PostitTextId

Paperclip text

Declaration
public int PostitTextId
Field Value
Type Description
int
Remarks

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

ProjectId

Primary key

Declaration
public int ProjectId
Field Value
Type Description
int
Remarks

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

ProjectNumber

Automatically generated number

Declaration
public string ProjectNumber
Field Value
Type Description
string
Remarks

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

Registered

Registered date in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

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

SoundEx

What the name sounds like, for duplicate detection

Declaration
public string SoundEx
Field Value
Type Description
string
Remarks

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

Source

How did we get this project? For future integration needs

Declaration
public short Source
Field Value
Type Description
short
Remarks

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

StatusIdx

Link to ProjStatus list

Declaration
public int StatusIdx
Field Value
Type Description
int
Remarks

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

TextId

Description field

Declaration
public int TextId
Field Value
Type Description
int
Remarks

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

TypeIdx

Link to ProjType list

Declaration
public int TypeIdx
Field Value
Type Description
int
Remarks

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

TzLocationId

Default timezone location for this project

Declaration
public int TzLocationId
Field Value
Type Description
int
Remarks

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

Updated

Last updated date in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

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

Userdef2Id

User defined table record 2

Declaration
public int Userdef2Id
Field Value
Type Description
int
Remarks

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

UserdefId

Pointer to userdef small table

Declaration
public int UserdefId
Field Value
Type Description
int
Remarks

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

Extension Methods