Class EmailPhoneProvider

[MDOProviderPlugin("emailphone")]
[MDOAdditionalInfo("phoneOnly", "Only phone numbers are searched", false)]
[MDOAdditionalInfo("operator", "Operator used for search. Available values: 'contains', 'startsWith'. Default value is 'contains'.", "contains")]
public class EmailPhoneProvider : AnyTableListProviderBase, ISoListProvider, ISoList, IPlugin

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

Constructors

EmailPhoneProvider()

Constructor

Declaration

public EmailPhoneProvider()

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

Fields

_contactTable

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected ContactTableInfo _contactTable

Field Value

Type	Description
ContactTableInfo

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

_emailTable

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected EmailTableInfo _emailTable

Field Value

Type	Description
EmailTableInfo

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

_personTable

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected PersonTableInfo _personTable

Field Value

Type	Description
PersonTableInfo

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

_phoneTable

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected PhoneTableInfo _phoneTable

Field Value

Type	Description
PhoneTableInfo

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

_searchTerms

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected string[] _searchTerms

Field Value

Type	Description
String[]

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

ProviderName

"emailphone"

Declaration

public const string ProviderName = "emailphone"

Field Value

Type	Description
String

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

Properties

TableInfo

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override TableInfo TableInfo { get; }

Property Value

Type	Description
TableInfo

Overrides

AnyTableListProviderBase.TableInfo

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

Methods

ExecuteQuery(Select, List<ISoListItem>)

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override void ExecuteQuery(Select sql, List<ISoListItem> resultCollection)

Parameters

Type	Name	Description
Select	sql
List<ISoListItem>	resultCollection

Overrides

AnyTableListProviderBase.ExecuteQuery(Select, List<ISoListItem>)

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

GetContactPhoneQuery()

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected Select GetContactPhoneQuery()

Returns

Type	Description
Select

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

GetHistoryItems()

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override List<ISoListItem> GetHistoryItems()

Returns

Type	Description
List<ISoListItem>

Overrides

AnyTableListProviderBase.GetHistoryItems()

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

GetMainQuery()

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override Select GetMainQuery()

Returns

Type	Description
Select

Overrides

AnyTableListProviderBase.GetMainQuery()

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

GetRootItems()

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override List<ISoListItem> GetRootItems()

Returns

Type	Description
List<ISoListItem>

Overrides

AnyTableListProviderBase.GetRootItems()

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

Init()

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override void Init()

Overrides

AnyTableListProviderBase.Init()

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

OnPostGetRootItems(List<ISoListItem>)

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override void OnPostGetRootItems(List<ISoListItem> items)

Parameters

Type	Name	Description
List<ISoListItem>	items

Overrides

AnyTableListProviderBase.OnPostGetRootItems(List<ISoListItem>)

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

OnRead(SoDataReader, Int16)

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override ISoListItem OnRead(SoDataReader reader, short lastRank)

Parameters

Type	Name	Description
SoDataReader	reader
Int16	lastRank

Returns

Type	Description
ISoListItem

Overrides

AnyTableListProviderBase.OnRead(SoDataReader, Int16)

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

SetSearchRestriction(Select, String)

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected override void SetSearchRestriction(Select sql, string searchValue)

Parameters

Type	Name	Description
Select	sql
String	searchValue

Overrides

AnyTableListProviderBase.SetSearchRestriction(Select, String)

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

SortItemsByScore(List<ISoListItem>)

List of e-mail addresses and phone numbers matching the search value Searches e-mail address, phone number, person name, company name.

E-mail address/phone number matches: return e-mail addresses/phone numbers + owner name (person or contact name)

Person name matches: return all e-mail addresses/phone numbers for matched persons

Company name matches. return all persons + first e-mail address/phone number for matched persons.

Declaration

protected void SortItemsByScore(List<ISoListItem> items)

Parameters

Type	Name	Description
List<ISoListItem>	items

Remarks

Returns: list item with

Id = e-mail address/phone number id

Name = name + e-mail/phone

ExtraInfo = e-mail address/phone number

Type = "Email" or "Phone"

Implements

ISoListProvider

ISoList

Extension Methods

EnumUtil.MapEnums<From, To>(From)

ObjectExtensions.AssignByReflection<T>(T, T)

ObjectExtensions.GraphCopy<T>(T)

Converters.MapEnums<From, To>(From)