Class DynamicPersonExtender

Customized dynamic extender for the Person table, with some special features

Inheritance
object
ExtensibleColumnsBase
ExtenderBase<TableInfo>
TableExtenderBase<TableInfo>
DynamicExtenderBase
DynamicExtender
DynamicPersonExtender
Inherited Members
Namespace: SuperOffice.CRM.ArchiveLists
Assembly: SoDataBase.dll
Syntax
[DynamicExtender("person")]
public class DynamicPersonExtender : DynamicExtender, IArchiveProviderQueryMapping, IArchiveDynamicExtender, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible, IArchiveProviderDynamicExtend
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

Constructors

DynamicPersonExtender()

Construct and set up all links and subextenders

Declaration
public DynamicPersonExtender()
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

Fields

TableName

Name of handled table

Declaration
public const string TableName = "person"
Field Value
Type Description
string
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_FirstName

Customized dynamic extender for the Person table, with some special features

Declaration
protected ArchiveColumnInfo _FirstName
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_LastName

Customized dynamic extender for the Person table, with some special features

Declaration
protected ArchiveColumnInfo _LastName
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_MiddleName

Customized dynamic extender for the Person table, with some special features

Declaration
protected ArchiveColumnInfo _MiddleName
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_Position

Customized dynamic extender for the Person table, with some special features

Declaration
protected ArchiveColumnInfo _Position
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_Rank

Customized dynamic extender for the Person table, with some special features

Declaration
protected ArchiveColumnInfo _Rank
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_colFullName

Full name columns

Declaration
protected ArchiveColumnInfo _colFullName
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

_colPhone

Phone number column

Declaration
protected ArchiveColumnInfo _colPhone
Field Value
Type Description
ArchiveColumnInfo
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

Methods

InnerModifyQuery()

Override: Handle needed fields for fullName, address, and phone

Declaration
protected override void InnerModifyQuery()
Overrides
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

InnerPopulateRowFromReader(SoDataReader, ArchiveRow)

Override: Populate fullname through helper, and address through helper. Phone is handled by root base class

Declaration
protected override void InnerPopulateRowFromReader(SoDataReader reader, ArchiveRow row)
Parameters
Type Name Description
SoDataReader reader
ArchiveRow row
Overrides
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

SetDesiredColumns(params string[])

Override: Handle address columns through helper

Declaration
public override void SetDesiredColumns(params string[] columnIds)
Parameters
Type Name Description
string[] columnIds
Overrides
Remarks

The following special fields are handled:
fullName - gives persons full, formatted name
phone/formattedNumber - gives the first phone number for the person (first of direct, mobile, private, pager, fax - in this order)
emailAddress - email address with rank = 1
address/ a number of fields: addressId, line1 - line3, county, city, zip; includes fallback logic to contact address if no person address

Most of the logic is taken from the PersonExtenderHelper, to avoid duplication of significant code with the PersonExtenderBase.

Implements

Extension Methods