OpenPetra
Free Administration Software for Non-Profits
|
Contains functions to be used by the Server and the Client that perform certain calculations - specific for the Partner Module. More...
Classes | |
class | TOverallContactSettings |
Holds the 'Overall Contact Settings' of an arbitrary number of Partners. More... | |
class | TPartnersOverallContactSettings |
Holds details of a Partners' 'Overall Contact Settings' More... | |
Public Types | |
enum | TPartnerLocationFormatEnum { plfCommaSeparated , plfLineBreakSeparated , plfHtmlLineBreak } |
Specifies how to format the String that is returned by Method M:Ict.Petra.Server.MPartner.Common.Calculations.DetermineLocationString(Ict.Petra.Shared.MPartner.Partner.Data.PLocationRow, Ict.Petra.Shared.MPartner.Calculations.TPartnerLocationFormatEnum). More... | |
enum | TOverallContSettingKind { ocskPrimaryEmailAddress = 1 , ocskPrimaryPhoneNumber = 2 , ocskEmailAddressWithinOrg = 4 , ocskPhoneNumberWithinOrg = 8 , ocskPrimaryContactMethod = 16 , ocskSecondaryEmailAddress = 32 } |
Kinds of 'Overall Contact Settings' More... | |
Static Public Member Functions | |
static void | DeterminePartnerLocationsDateStatus (DataSet APartnerLocationsDS) |
check the validity of each location and update the icon for each location (current address, old address, future address) for the current date More... | |
static void | DeterminePartnerLocationsDateStatus (DataTable APartnerLocationsDT, DateTime ADateToCheck) |
check the validity of each location and update the icon of each location (current address, old address, future address) More... | |
static TLocationPK | DetermineBestAddress (DataSet APartnerLocationsDS) |
Determines which address is the 'Best Address' of a Partner, and marks it in the DataColumn 'BestAddress'. More... | |
static TLocationPK | DetermineBestAddress (DataTable APartnerLocationsDT) |
Determines which address is the 'Best Address' of a Partner, and marks it in the DataColumn 'BestAddress'. More... | |
static bool | DetermineBestAddress (DataTable APartnerLocationsDT, out Int64 ASiteKey, out int ALocationKey) |
Determines which address is the 'Best Address' of a Partner, and marks it in the DataColumn 'BestAddress'. More... | |
static PLocationRow | FindBestAddressLocation (PartnerEditTDSPPartnerLocationTable APartnerLocationDT, PLocationTable ALocationDT) |
Returns the PLocationRow of the 'Best Address'. More... | |
static PLocationRow | FindBestAddressLocation (TLocationPK ABestLocationPK, PLocationTable ALocationDT) |
Returns the PLocationRow of the 'Best Address'. More... | |
static String | DetermineLocationString (PLocationRow ALocationDR, TPartnerLocationFormatEnum APartnerLocationStringFormat=TPartnerLocationFormatEnum.plfLineBreakSeparated, Int32 AaddressOrder=0, String ACountryName="") |
Builds a formatted String out of the data that is contained in a Location. More... | |
static String | DetermineLocationString (String ABuilding1, String ABuilding2, String ALocality, String AStreetName, String AAddress3, String ASuburb, String ACity, String ACounty, String APostalCode, String ACountryName, TPartnerLocationFormatEnum PartnerLocationStringFormat=TPartnerLocationFormatEnum.plfLineBreakSeparated, Int32 AaddressOrder=0) |
Builds a formatted String out of the data that is contained in a Location. More... | |
static DataView | DetermineCurrentAddresses (PPartnerLocationTable ATable) |
get the current address from a location table More... | |
static bool | GetPrimaryEmailAddress (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, out string APrimaryEmailAddress) |
Gets the 'Primary E-Mail Address' of a Partner. More... | |
static bool | GetPrimaryEmailAddress (TPartnersOverallContactSettings APrimaryContactAttributes, out string APrimaryEmailAddress) |
Gets the 'Primary E-Mail Address' of a Partner. More... | |
static bool | GetPrimaryPhoneNumber (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, out string APrimaryPhoneNumber) |
Gets the 'Primary Phone Number' of a Partner. More... | |
static bool | GetPrimaryPhoneNumber (TPartnersOverallContactSettings APrimaryContactAttributes, out string APrimaryPhoneNumber) |
Gets the 'Primary Phone Number' of a Partner. More... | |
static bool | GetWithinOrganisationEmailAddress (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, out string AWithinOrganisationEmailAddress) |
Gets the 'Within Organisation E-Mail Address' of a Partner. More... | |
static bool | GetWithinOrganisationEmailAddress (TPartnersOverallContactSettings APrimaryContactAttributes, out string AWithinOrganisationEmailAddress) |
Gets the 'Within Organisation E-Mail Address' of a Partner. More... | |
static bool | GetPrimaryEmailAndPrimaryPhone (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, out string APrimaryPhoneNumber, out string APrimaryEmailAddress) |
Gets the 'Primary Phone Number' and the 'Primary E-mail Address' of a Partner. More... | |
static bool | GetPrimaryEmailAndPrimaryPhone (TPartnersOverallContactSettings APrimaryContactAttributes, out string APrimaryPhoneNumber, out string APrimaryEmailAddress) |
Gets the 'Primary Phone Number' and the 'Primary E-mail Address' of a Partner. More... | |
static TPartnersOverallContactSettings | DeterminePrimaryOrWithinOrgSettingsForPartner (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, TOverallContSettingKind AOverallContSettingKind) |
Determines the 'Primary' and/or 'Within Organisation' setting(s) for the Partner whose PPartnerAttributes records are contained in APPartnerAttributeDT . More... | |
static TOverallContactSettings | DeterminePrimaryOrWithinOrgSettings (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, TOverallContSettingKind AOverallContSettingKind, Int64 APartnerKey=-1) |
Determines the 'Primary' and/or 'Within Organisation' setting(s) for (each of) the Partner(s) contained in APPartnerAttributeDT . More... | |
static void | DeterminePartnerSystemCategorySettings (TDBTransaction AReadTransaction, PPartnerAttributeTable APartnerAttributeDT, ref TPartnersOverallContactSettings AOverallContactSettings, TOverallContSettingKind AOverallContSettingKind) |
Determines the 'System Category' setting(s) for the Partner whose PPartnerAttributes records are contained in APartnerAttributeDT . More... | |
static bool | RowHasPhoneAttributeType (DataView APhoneAttributesDV, PPartnerAttributeRow APartnerAttributeRow) |
Checks whether the DataRow passed in with APartnerAttributeRow has got an AttributeType that constitutes a Phone Number (but not a Fax Number). More... | |
static bool | RowHasPhoneOrFaxAttributeType (DataView APhoneAttributesDV, PPartnerAttributeRow APartnerAttributeRow, bool AExcludeFax) |
Checks whether the DataRow passed in with APartnerAttributeRow has got an AttributeType that constitutes a Phone Number or a Fax Number (but the latter only if AExcludeFax isn't true). More... | |
static string | ConcatenatePhoneOrFaxNumberWithIntlCountryPrefix (PPartnerAttributeRow ARow) |
Prefixes a Phone Number or Fax Number with the International Country Code. More... | |
static DataRow | FindCountryRowInCachedCountryList (string ACountryCode) |
Looks up a Country by its Country Code in the 'CountryList' Cacheable DataTable. More... | |
static string | ConcatenatePhoneOrFaxNumberWithIntlCountryPrefix (string AValue, string AInternatTelephoneCode) |
Prefixes a Phone Number or Fax Number with the International Country Code. More... | |
static DataView | DeterminePhoneAttributes (PPartnerAttributeTypeTable APPartnerAttributeTypeDT) |
Determines which p_partner_attribute_type records have p_category_code_c 'Phone' More... | |
static DataView | DeterminePartnerPhoneNumbers (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, bool AOnlyCurrentPhoneNumbers, bool AIncludeFaxNumbers) |
Determines all p_partner_attribute records whose p_attribute_type points to a p_partner_attribute_type record that has p_category_code_c 'Phone' and returns the result. More... | |
static string | DeterminePartnerFaxNumber (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT) |
Determines the (first) current 'Fax Number' that is contained in the p_partner_attribute records of a given Partner. More... | |
static string | DeterminePhonePartnerAttributeTypes (PPartnerAttributeTypeTable APPartnerAttributeTypeDT) |
Determines all p_partner_attribute_type records that have p_category_code_c 'Phone' and returns the result. More... | |
static DataView | DetermineEmailAttributes (PPartnerAttributeTypeTable APPartnerAttributeTypeDT) |
Determines which p_partner_attribute_type records are of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' More... | |
static string | DetermineEmailPartnerAttributeTypes (PPartnerAttributeTypeTable APPartnerAttributeTypeDT) |
Determines all p_partner_attribute_type records that are of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' and returns the result. More... | |
static DataView | DeterminePartnerEmailAddresses (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT, bool AOnlyCurrentEmailAddresses) |
Determines all p_partner_attribute records whose p_attribute_type points to a p_partner_attribute_type record that is of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' and returns the result. More... | |
static string | GetSystemCategorySettingsConcatStr (TDBTransaction AReadTransaction) |
Determines all p_partner_attribute_type records which constitute Partner Contact Details and returns the result. More... | |
static string | GetEmailPartnerAttributesConcatStr (TDBTransaction AReadTransaction) |
Determines all p_partner_attribute_type records that are of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' and returns the result. More... | |
static string | GetPhonePartnerAttributesConcatStr (TDBTransaction AReadTransaction) |
Determines all p_partner_attribute_type records that have p_category_code_c 'Phone'. More... | |
static int | DeterminePartnerContactDetailAttributes (TDBTransaction AReadTransaction, PPartnerAttributeTable APPartnerAttributeDT) |
Determines which Partner Attributes are and which aren't Partner Contact Attributes, and marks them in the DataColumn 'PartnerContactDetail': Partner Attributes whose AttributeType is not a PartnerAttributeType whose PartnerAttributeCategory is a Partner Contact one PPartnerAttributeCategory.PartnerContactCategory Column holds 'false') aren't! More... | |
static void | DetermineValueKindOfPartnerAttributeRecord (object AAttributeDR, PPartnerAttributeTypeTable APPartnerAttributeType, out PPartnerAttributeTypeRow AContactTypeDR, out TPartnerAttributeTypeValueKind AValueKind) |
Determines the Value Kind (TPartnerAttributeTypeValueKind) of a p_partner_attribute record. More... | |
static TPartnerAttributeTypeValueKind | GetValueKind (PPartnerAttributeTypeRow AContactTypeDR) |
Gets the Value Kind (TPartnerAttributeTypeValueKind) of a p_partner_attribute_type record. More... | |
static void | CreateCustomDataColumnsForAttributeTable (PPartnerAttributeTable APPartnerAttributeDT, PPartnerAttributeTypeTable APPartnerAttributeTypeDT) |
Creates custom DataColumns that will be added to an instance of a PPartnerAttribute Table. More... | |
static void | SetColumnExpressions (PPartnerAttributeTable APPartnerAttributeDT) |
Sets the Column Expressions for the calculated DataColumns More... | |
static string | BuildLinkWithValue (string AValue, TPartnerAttributeTypeValueKind AValueKind, string AHyperlinkFormat) |
Constructs a valid URL string from a Value that is of a Contact Type that has got a Hyperlink Format set up. More... | |
static String | DeterminePartnerShortName (String AName, String ATitle, String AFirstName, String AMiddleName) |
format the shortname for a partner in a standardized way More... | |
static String | DeterminePartnerShortName (String AName, String ATitle, String AFirstName) |
overload for DeterminePartnerShortName, no middle name More... | |
static String | DeterminePartnerShortName (String AName, String ATitle) |
overload for DeterminePartnerShortName, no middle name and no first name More... | |
static String | DeterminePartnerShortName (String AName) |
overload for DeterminePartnerShortName, no title, firstname and middle name More... | |
static void | CalculateTabCountsContacts (PContactLogTable ATable, out Int32 ATotalContacts) |
Count the subscriptions More... | |
static string | FormatShortName (string AShortname, eShortNameFormat AFormat) |
convert shortname from Lastname, firstname, title to another shortname format TODO: use partner key to get to the full name, resolve issues with couples that have different family names etc More... | |
static string | FormalGreeting (string APartnerShortName) |
format a formal greeting for the given partner short name. this formal greeting can be used in a letter More... | |
static int | CalculateAge (DateTime ABirthday) |
Calculates the age in years at the current date. More... | |
static int | CalculateAge (DateTime ABirthday, DateTime ACalculationDate) |
Calculates the age in years at a given date. More... | |
static void | CalculateTabCountsAddresses (PPartnerLocationTable ATable, out Int32 ATotalAddresses, out Int32 ACurrentAddresses) |
count the available current addresses and the total number of addresses More... | |
static void | CalculateTabCountsPartnerContactDetails (PartnerEditTDSPPartnerAttributeTable ATable, out Int32 ATotalPartnerContactDetails, out Int32 AActivePartnerContactDetails) |
Count the Partner Contact Details. More... | |
static void | CalculateTabCountsSubscriptions (PSubscriptionTable ATable, out Int32 ATotalSubscriptions, out Int32 AActiveSubscriptions) |
Count the subscriptions More... | |
static void | CalculateTabCountsPartnerRelationships (PPartnerRelationshipTable ATable, out Int32 ATotalRelationships) |
Count the relationships More... | |
Static Public Attributes | |
const String | PARTNERLOCATION_BESTADDR_COLUMN = "BestAddress" |
column name for best address More... | |
const String | PARTNERLOCATION_ICON_COLUMN = "Icon" |
column name for the location icon More... | |
const string | ATTR_TYPE_PARTNERS_PRIMARY_CONTACT_METHOD = "PARTNERS_PRIMARY_CONTACT_METHOD" |
Partner Attribute Type that denotes the 'Primary Contact Method'. More... | |
const string | ATTR_TYPE_PARTNERS_SECONDARY_EMAIL_ADDRESS = "PARTNERS_SECONDARY_EMAIL_ADDRESS" |
Partner Attribute Type that denotes the 'Secondary E-mail Address'. More... | |
static readonly String | PARTNERATTRIBUTE_PARTNERCONTACTDETAIL_COLUMN = "PartnerContactDetail" |
Column name for the column 'Partner Contact Detail' that can get added to a PPartnerAttribute Table (gets added by Method DeterminePartnerContactDetailAttributes). More... | |
static readonly string | CALCCOLUMNNAME_PARTNERATTRIBUTETYPE = "Parent_" + PPartnerAttributeTypeTable.GetAttributeTypeDBName() |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
static readonly string | CALCCOLUMNNAME_PARENTATTRIBUTEINDEX = "Parent_AttributeIndex" |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
static readonly string | CALCCOLUMNNAME_PARENTPARENTCATEGORYINDEX = "Parent_Parent_CategoryIndex" |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
static readonly string | CALCCOLUMNNAME_CONTACTTYPE = "ContactType" |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
static readonly string | CALCCOLUMNNAME_INTLPHONEPREFIX = "InternationalPhonePrefix" |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
static readonly string | CALCCOLUMNNAME_VALUE = "CalculatedValue" |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
static readonly string | CALCCOLUMNNAME_CATEGORYINDEX = "CategoryIndex" |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable). More... | |
Contains functions to be used by the Server and the Client that perform certain calculations - specific for the Partner Module.
There is anoher part of this Partial Class that holds only Methods that are to do with the 'Contact Detail' implementation.
This part of this Partial Class holds only Methods that are to do with the 'Contact Detail' implementation.
There are two further parts of this Partial Class, Calculations.Address.cs and Calculations.ContactDetails.cs that hold only Methods that are to do with the 'Addresses' and 'Contact Detail'-related implementations!
Kinds of 'Overall Contact Settings'
Specifies how to format the String that is returned by Method M:Ict.Petra.Server.MPartner.Common.Calculations.DetermineLocationString(Ict.Petra.Shared.MPartner.Partner.Data.PLocationRow, Ict.Petra.Shared.MPartner.Calculations.TPartnerLocationFormatEnum).
|
inlinestatic |
Constructs a valid URL string from a Value that is of a Contact Type that has got a Hyperlink Format set up.
AValue | Value that should replace THyperLinkHandling.HYPERLINK_WITH_VALUE_VALUE_PLACEHOLDER_IDENTIFIER in the Hyperlink Format string. |
AValueKind | Value Kind of Partner Attribute Type. MUST be TPartnerAttributeTypeValueKind.CONTACTDETAIL_HYPERLINK_WITHVALUE! |
AHyperlinkFormat | Format string for building the URL in which the placeholder gets replaced with AValue . |
|
inlinestatic |
Calculates the age in years at the current date.
ABirthday | The birthday from which to calculate the current age |
|
inlinestatic |
Calculates the age in years at a given date.
ABirthday | The birthday from which to calculate the age |
ACalculationDate | The date against which the birthday should be calculated |
|
inlinestatic |
count the available current addresses and the total number of addresses
ATable | table with locations |
ATotalAddresses | returns the total number of address |
ACurrentAddresses | returns the number of current addresses |
|
inlinestatic |
Count the subscriptions
ATable | table with contacts |
ATotalContacts | returns the total number of contacts |
|
inlinestatic |
|
inlinestatic |
Count the relationships
ATable | table with subscriptions |
ATotalRelationships | returns the total number of relationships |
|
inlinestatic |
Count the subscriptions
ATable | table with subscriptions |
ATotalSubscriptions | returns the total number of subscriptions |
AActiveSubscriptions | returns the number of active subscriptions |
|
inlinestatic |
Prefixes a Phone Number or Fax Number with the International Country Code.
ARow | Type p_partner_attribute row. |
|
inlinestatic |
Prefixes a Phone Number or Fax Number with the International Country Code.
AValue | Phone Number or Fax Number. |
AInternatTelephoneCode | International Country Code for a Phone Number. |
|
inlinestatic |
Creates custom DataColumns that will be added to an instance of a PPartnerAttribute Table.
|
inlinestatic |
Determines which address is the 'Best Address' of a Partner, and marks it in the DataColumn 'BestAddress'.
There are convenient overloaded server-side Methods, Ict.Petra.Server.MPartner.ServerCalculations.DetermineBestAddress, which work by specifying the PartnerKey of a Partner in an Argument.
APartnerLocationsDS | Dataset containing the addresses of a Partner. |
|
inlinestatic |
Determines which address is the 'Best Address' of a Partner, and marks it in the DataColumn 'BestAddress'.
There are convenient overloaded server-side Methods, Ict.Petra.Server.MPartner.ServerCalculations.DetermineBestAddress, which work by specifying the PartnerKey of a Partner in an Argument.
APartnerLocationsDT | DataTable containing the addresses of a Partner. |
|
inlinestatic |
Determines which address is the 'Best Address' of a Partner, and marks it in the DataColumn 'BestAddress'.
This method overload exists primarily for use in data migration from a legacy DB system. It gets called via .NET Reflection from Ict.Tools.DataDumpPetra2! DO NOT REMOVE THIS METHOD - although an IDE will not find any references to this Method!
APartnerLocationsDT | DataTable containing the addresses of a Partner. |
ASiteKey | Site Key of the 'Best Address'. |
ALocationKey | Location Key of the 'Best Address'. |
|
inlinestatic |
get the current address from a location table
ATable | table with locations |
|
inlinestatic |
Determines which p_partner_attribute_type records are of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS'
APPartnerAttributeTypeDT | Pass an instance of PPartnerAttributeTypeTable that holds Contact Detail datarows |
|
inlinestatic |
Determines all p_partner_attribute_type records that are of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' and returns the result.
APPartnerAttributeTypeDT | Pass an instance of PPartnerAttributeTypeTable that holds datarows that constitute Contact Details |
|
inlinestatic |
Builds a formatted String out of the data that is contained in a Location.
ALocationDR | DataRow containing the Location data. |
APartnerLocationStringFormat | Specifies how to format the String that is returned. |
AaddressOrder | AddressOrder from PCountry row |
ACountryName | If this is blank, the PLocationRow CountryCode will be used. |
|
inlinestatic |
Builds a formatted String out of the data that is contained in a Location.
ABuilding1 | building name 1 |
ABuilding2 | building name 2 |
ALocality | locality |
AStreetName | street name |
AAddress3 | address 3 |
ASuburb | suburb |
ACity | city |
ACounty | county |
APostalCode | postal code |
ACountryName | country name |
PartnerLocationStringFormat | requested format |
AaddressOrder | AddressOrder from PCountry row |
|
inlinestatic |
Determines which Partner Attributes are and which aren't Partner Contact Attributes, and marks them in the DataColumn 'PartnerContactDetail': Partner Attributes whose AttributeType is not a PartnerAttributeType whose PartnerAttributeCategory is a Partner Contact one PPartnerAttributeCategory.PartnerContactCategory Column holds 'false') aren't!
AReadTransaction | |
APPartnerAttributeDT | Partner Attribute Table in which the Partner Contact Attributes should be determined. |
|
inlinestatic |
Determines all p_partner_attribute records whose p_attribute_type points to a p_partner_attribute_type record that is of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' and returns the result.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of a given Partner - or of MANY (!) Partners. |
AOnlyCurrentEmailAddresses | Set to true to only return 'Valid' p_partner_attribute records (i.e. p_partner_attribute records whose p_current_l Flag is set to true). |
|
inlinestatic |
Determines the (first) current 'Fax Number' that is contained in the p_partner_attribute records of a given Partner.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of a given Partner. |
|
inlinestatic |
check the validity of each location and update the icon for each location (current address, old address, future address) for the current date
APartnerLocationsDS | the dataset with the locations |
|
inlinestatic |
check the validity of each location and update the icon of each location (current address, old address, future address)
APartnerLocationsDT | the datatable to check |
ADateToCheck |
|
inlinestatic |
Determines all p_partner_attribute records whose p_attribute_type points to a p_partner_attribute_type record that has p_category_code_c 'Phone' and returns the result.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of a given Partner - or of MANY (!) Partners. |
AOnlyCurrentPhoneNumbers | Set to true to only return 'Valid' p_partner_attribute records (i.e. p_partner_attribute records whose p_current_l Flag is set to true). |
AIncludeFaxNumbers | Set to false to exclude p_partner_attribute records whose p_attribute_type_c is 'Fax'. |
|
inlinestatic |
overload for DeterminePartnerShortName, no title, firstname and middle name
AName | surname |
|
inlinestatic |
overload for DeterminePartnerShortName, no middle name and no first name
AName | surname |
ATitle | title |
|
inlinestatic |
overload for DeterminePartnerShortName, no middle name
AName | surname |
ATitle | title |
AFirstName | firstname |
|
inlinestatic |
format the shortname for a partner in a standardized way
AName | surname of partner |
ATitle | title |
AFirstName | first name |
AMiddleName | middle name |
|
inlinestatic |
Determines the 'System Category' setting(s) for the Partner whose PPartnerAttributes records are contained in APartnerAttributeDT .
AReadTransaction | |
APartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of a given Partner. The DataTable must have a special DataColumn added that Method 'DeterminePartnerContactDetailAttributes' adds, hence that Method must be called before calling this Method. |
AOverallContactSettings | Pass in an instance of TOverallContactSettings. |
AOverallContSettingKind | Specify the kind of Overall Contact Setting(s) that you want returned. Combine multiple ones with the binary OR operator ( | ). |
|
inlinestatic |
Determines which p_partner_attribute_type records have p_category_code_c 'Phone'
APPartnerAttributeTypeDT | Pass an instance of PPartnerAttributeTypeTable that holds Contact Detail datarows |
|
inlinestatic |
Determines all p_partner_attribute_type records that have p_category_code_c 'Phone' and returns the result.
APPartnerAttributeTypeDT | Pass an instance of PPartnerAttributeTypeTable that holds datarows that constitute Contact Details |
|
inlinestatic |
Determines the 'Primary' and/or 'Within Organisation' setting(s) for (each of) the Partner(s) contained in APPartnerAttributeDT .
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of a given Partner - or of MANY (!) Partners. The DataTable must have a special DataColumn added that Method 'DeterminePartnerContactDetailAttributes' adds, hence that Method must be called before calling this Method. |
APartnerKey | Set this to a Partners' PartnerKey to retrieve the desired 'Primary' and/or 'Within Organisation' setting(s) for a specific Partner only (in case there are many Partners' PPartnerAttribute records contained in APPartnerAttributeDT ). (Default = -1, meaning: determine the 'Primary' and/or 'Within Organisation' setting(s) for each Partner for which PPartnerAttribute records exist in APPartnerAttributeDT . |
Caveat 1: If you only need to determine the 'Primary' and/or 'Within Organisation' setting(s) for a single Partner and you have an instance of APPartnerAttributeDT that holds only the records for that Partner then it is more effective to call the Method DeterminePrimaryOrWithinOrgSettingsForPartner than the present Method!
Caveat 2: Don't call this Method multiple times, each time specifying a certain PartnerKey! Instead, don't pass anything for the optional APartnerKey Argument and use the Method TPrimaryContactAttributes.GetPrimaryEmailAddress for the retrieval of the individual Partners' 'Primary' and/or 'Within Organisation' setting(s)!
AOverallContSettingKind | Specify the kind of Overall Contact Setting(s) that you want returned. Combine multiple ones with the binary OR operator ( | ). |
|
inlinestatic |
Determines the 'Primary' and/or 'Within Organisation' setting(s) for the Partner whose PPartnerAttributes records are contained in APPartnerAttributeDT .
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of a given Partner. The DataTable must have a special DataColumn added that Method 'DeterminePartnerContactDetailAttributes' adds, hence that Method must be called before calling this Method. |
AOverallContSettingKind | Specify the kind of Overall Contact Setting(s) that you want returned. Combine multiple ones with the binary OR operator ( | ). |
|
inlinestatic |
Determines the Value Kind (TPartnerAttributeTypeValueKind) of a p_partner_attribute record.
AAttributeDR | Typed p_partner_attribute record. Must be of one of the following Types: PPartnerAttributeTypeRow, PartnerEditTDSPPartnerAttributeRow or PartnerInfoTDSPPartnerAttributeRow! |
APPartnerAttributeType | Typed p_partner_attribute Table. |
AContactTypeDR | Typed p_partner_attribute row that matches the Attribute Type of AAttributeDR . |
AValueKind | Value Kind (TPartnerAttributeTypeValueKind) of the p_partner_attribute record that got passed in with Argument AAttributeDR . |
|
inlinestatic |
Returns the PLocationRow of the 'Best Address'.
One of the 'DetermineBestAddress' Methods must have been run before on the PartnerLocation Table that gets passed in in the APartnerLocationDT Argument!!!
APartnerLocationDT | Typed PartnerLocation Table that was already processed by one of the 'DetermineBestAddress' Methods. |
ALocationDT | Location Table that contains all Location records that are referenced in APartnerLocationDT . |
|
inlinestatic |
Returns the PLocationRow of the 'Best Address'.
The 'DetermineBestAddress' Method overload that returns a TLocationPK must have been run before and that return value must be passed into the present Method with the ABestLocationPK Argument!!!
ABestLocationPK | Primary Key of the 'Best Location' (as determined by the 'DetermineBestAddress' Method overload that returns a TLocationPK). |
ALocationDT | Location Table that contains the Location record that is referenced with ABestLocationPK . |
|
inlinestatic |
Looks up a Country by its Country Code in the 'CountryList' Cacheable DataTable.
ACountryCode | Country Code of the Country that is to be looked up. |
|
inlinestatic |
format a formal greeting for the given partner short name. this formal greeting can be used in a letter
|
inlinestatic |
convert shortname from Lastname, firstname, title to another shortname format TODO: use partner key to get to the full name, resolve issues with couples that have different family names etc
|
inlinestatic |
Determines all p_partner_attribute_type records that are of p_attribute_type_value_kind_c 'CONTACTDETAIL_EMAILADDRESS' and returns the result.
|
inlinestatic |
Determines all p_partner_attribute_type records that have p_category_code_c 'Phone'.
|
inlinestatic |
Gets the 'Primary E-Mail Address' of a Partner.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of the Partner whose 'Primary Email Address' should be determined. |
APrimaryEmailAddress | The 'Primary Email Address' if the Partner has got one, otherwise null. |
|
inlinestatic |
Gets the 'Primary E-Mail Address' of a Partner.
APrimaryContactAttributes | TPartnersOverallContactSettings instance that contains the 'Overall Contact Details' of a certain Partner. |
APrimaryEmailAddress | The 'Primary E-Mail Address' if the Partner has got one, otherwise null. |
|
inlinestatic |
Gets the 'Primary Phone Number' and the 'Primary E-mail Address' of a Partner.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of the Partner whose 'Primary Phone Number' and 'Primary E-mail Address'should be determined. |
APrimaryPhoneNumber | The 'Primary Phone Number' if the Partner has got one, otherwise null. |
APrimaryEmailAddress | The 'Primary E-mail Address' if the Partner has got one, otherwise null. |
|
inlinestatic |
Gets the 'Primary Phone Number' and the 'Primary E-mail Address' of a Partner.
APrimaryContactAttributes | TPartnersOverallContactSettings instance that contains the 'Overall Contact Details' of a certain Partner. records of the Partner whose 'Primary Phone Number' and 'Primary E-mail Address'should be determined. |
APrimaryPhoneNumber | The 'Primary Phone Number' if the Partner has got one, otherwise null. |
APrimaryEmailAddress | The 'Primary E-mail Address' if the Partner has got one, otherwise null. |
|
inlinestatic |
Gets the 'Primary Phone Number' of a Partner.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of the Partner whose 'Primary Phone Number' should be determined. |
APrimaryPhoneNumber | The 'Primary Phone Number' if the Partner has got one, otherwise null. |
|
inlinestatic |
Gets the 'Primary Phone Number' of a Partner.
APrimaryContactAttributes | TPartnersOverallContactSettings instance that contains the 'Overall Contact Details' of a certain Partner. |
APrimaryPhoneNumber | The 'Primary Phone Number' if the Partner has got one, otherwise null. |
|
inlinestatic |
|
inlinestatic |
Gets the Value Kind (TPartnerAttributeTypeValueKind) of a p_partner_attribute_type record.
AContactTypeDR | Type p_partner_attribute_type record. |
|
inlinestatic |
Gets the 'Within Organisation E-Mail Address' of a Partner.
AReadTransaction | |
APPartnerAttributeDT | PPartnerAttributeTable that contains the Contact Detail records of the Partner whose 'Within Organisation E-Mail Address' should be determined. |
AWithinOrganisationEmailAddress | The 'Within Organisation E-Mail Address' if the Partner has got one, otherwise null. |
|
inlinestatic |
Gets the 'Within Organisation E-Mail Address' of a Partner.
APrimaryContactAttributes | TPartnersOverallContactSettings instance that contains the 'Overall Contact Details' of a certain Partner. |
AWithinOrganisationEmailAddress | The 'Within Organisation E-Mail Address' if the Partner has got one, otherwise null. |
|
inlinestatic |
Checks whether the DataRow passed in with APartnerAttributeRow has got an AttributeType that constitutes a Phone Number (but not a Fax Number).
APhoneAttributesDV | Must be the return value of a call to Method DeterminePhoneAttributes. |
APartnerAttributeRow | Typed p_partner_attribute Row. |
|
inlinestatic |
Checks whether the DataRow passed in with APartnerAttributeRow has got an AttributeType that constitutes a Phone Number or a Fax Number (but the latter only if AExcludeFax isn't true).
APhoneAttributesDV | Must be the return value of a call to Method DeterminePhoneAttributes. |
APartnerAttributeRow | Typed p_partner_attribute Row. |
AExcludeFax | Set to true to exclude Fax Numbers in the check, set to false to include them in the check. |
|
inlinestatic |
Sets the Column Expressions for the calculated DataColumns
|
static |
Partner Attribute Type that denotes the 'Primary Contact Method'.
|
static |
Partner Attribute Type that denotes the 'Secondary E-mail Address'.
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for a column that can get added to a PPartnerAttribute Table (gets added by Method CreateCustomDataColumnsForAttributeTable).
|
static |
Column name for the column 'Partner Contact Detail' that can get added to a PPartnerAttribute Table (gets added by Method DeterminePartnerContactDetailAttributes).
|
static |
column name for best address
|
static |
column name for the location icon