OpenPetra
Free Administration Software for Non-Profits
Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable Class Reference

defines a discount that depends on other conditions or can just be assigned to an invoice or article More...

Inheritance diagram for Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable:
Ict.Common.Data.TTypedDataTable

Public Member Functions

 AArDiscountTable ()
 constructor More...
 
 AArDiscountTable (string ATablename)
 constructor More...
 
 AArDiscountTable (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context)
 constructor for serialization More...
 
override void InitVars ()
 assign columns to properties, set primary key More...
 
AArDiscountRow NewRowTyped (bool AWithDefaultValues)
 create a new typed row More...
 
AArDiscountRow NewRowTyped ()
 create a new typed row, always with default values More...
 
AArDiscountTable GetChangesTyped ()
 get typed set of changes More...
 
override OdbcParameter CreateOdbcParameter (Int32 AColumnNr)
 get an odbc parameter for the given column More...
 
new DataTable GetChanges ()
 make sure that we use GetChangesType instead of GetChanges More...
 
virtual string GetCustomReportPermission ()
 string to indicate which permissions a user needs to access table for custom reports (e.g. "PTNRUSER", "OR(FINANCE-1,DEVUSER)", "AND(PTNRUSER,FINANCE-1)" This should be returned by method in derived class More...
 
virtual bool IsAvailableForCustomReport ()
 Is this table generally available in custom reports? More...
 
virtual List< String > GetCustomReportFieldList ()
 Return a list of fields that are available for custom reports More...
 
DataTable GetChangesTypedInternal ()
 our own version of GetChanges More...
 
void RemoveColumnsNotInTableTemplate (DataTable ATableTemplate)
 remove columns that are not needed More...
 

Static Public Member Functions

static string GetTableName ()
 return the CamelCase name of the table More...
 
static string GetTableDBName ()
 return the name of the table as it is used in the database More...
 
static string GetTableDBLabel ()
 static method to return the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about) More...
 
static string GetArDiscountCodeDBName ()
 get the name of the field in the database for this column More...
 
static short GetArDiscountCodeLength ()
 get character length for column More...
 
static string GetArDiscountCodeHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArDateValidFromDBName ()
 get the name of the field in the database for this column More...
 
static short GetArDateValidFromLength ()
 get character length for column More...
 
static string GetArDateValidFromHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArAdhocDBName ()
 get the name of the field in the database for this column More...
 
static short GetArAdhocLength ()
 get character length for column More...
 
static string GetArAdhocHelp ()
 get the help text for the field in the database for this column More...
 
static string GetActiveDBName ()
 get the name of the field in the database for this column More...
 
static short GetActiveLength ()
 get character length for column More...
 
static string GetActiveHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArDiscountPercentageDBName ()
 get the name of the field in the database for this column More...
 
static short GetArDiscountPercentageLength ()
 get character length for column More...
 
static string GetArDiscountPercentageHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArDiscountAbsoluteDBName ()
 get the name of the field in the database for this column More...
 
static short GetArDiscountAbsoluteLength ()
 get character length for column More...
 
static string GetArDiscountAbsoluteHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArAbsoluteAmountDBName ()
 get the name of the field in the database for this column More...
 
static short GetArAbsoluteAmountLength ()
 get character length for column More...
 
static string GetArAbsoluteAmountHelp ()
 get the help text for the field in the database for this column More...
 
static string GetCurrencyCodeDBName ()
 get the name of the field in the database for this column More...
 
static short GetCurrencyCodeLength ()
 get character length for column More...
 
static string GetCurrencyCodeHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArNumberOfItemsDBName ()
 get the name of the field in the database for this column More...
 
static short GetArNumberOfItemsLength ()
 get character length for column More...
 
static string GetArNumberOfItemsHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArMinimumNumberOfItemsDBName ()
 get the name of the field in the database for this column More...
 
static short GetArMinimumNumberOfItemsLength ()
 get character length for column More...
 
static string GetArMinimumNumberOfItemsHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArNumberOfNightsDBName ()
 get the name of the field in the database for this column More...
 
static short GetArNumberOfNightsLength ()
 get character length for column More...
 
static string GetArNumberOfNightsHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArMinimumNumberOfNightsDBName ()
 get the name of the field in the database for this column More...
 
static short GetArMinimumNumberOfNightsLength ()
 get character length for column More...
 
static string GetArMinimumNumberOfNightsHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArWholeRoomDBName ()
 get the name of the field in the database for this column More...
 
static short GetArWholeRoomLength ()
 get character length for column More...
 
static string GetArWholeRoomHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArChildrenDBName ()
 get the name of the field in the database for this column More...
 
static short GetArChildrenLength ()
 get character length for column More...
 
static string GetArChildrenHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArEarlyBookingDaysDBName ()
 get the name of the field in the database for this column More...
 
static short GetArEarlyBookingDaysLength ()
 get character length for column More...
 
static string GetArEarlyBookingDaysHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArEarlyPaymentDaysDBName ()
 get the name of the field in the database for this column More...
 
static short GetArEarlyPaymentDaysLength ()
 get character length for column More...
 
static string GetArEarlyPaymentDaysHelp ()
 get the help text for the field in the database for this column More...
 
static string GetArArticleCodeDBName ()
 get the name of the field in the database for this column More...
 
static short GetArArticleCodeLength ()
 get character length for column More...
 
static string GetArArticleCodeHelp ()
 get the help text for the field in the database for this column More...
 
static string GetPartnerTypeCodeDBName ()
 get the name of the field in the database for this column More...
 
static short GetPartnerTypeCodeLength ()
 get character length for column More...
 
static string GetPartnerTypeCodeHelp ()
 get the help text for the field in the database for this column More...
 
static string GetDateCreatedDBName ()
 get the name of the field in the database for this column More...
 
static short GetDateCreatedLength ()
 get character length for column More...
 
static string GetDateCreatedHelp ()
 get the help text for the field in the database for this column More...
 
static string GetCreatedByDBName ()
 get the name of the field in the database for this column More...
 
static short GetCreatedByLength ()
 get character length for column More...
 
static string GetCreatedByHelp ()
 get the help text for the field in the database for this column More...
 
static string GetDateModifiedDBName ()
 get the name of the field in the database for this column More...
 
static short GetDateModifiedLength ()
 get character length for column More...
 
static string GetDateModifiedHelp ()
 get the help text for the field in the database for this column More...
 
static string GetModifiedByDBName ()
 get the name of the field in the database for this column More...
 
static short GetModifiedByLength ()
 get character length for column More...
 
static string GetModifiedByHelp ()
 get the help text for the field in the database for this column More...
 
static string GetModificationIdDBName ()
 get the name of the field in the database for this column More...
 
static short GetModificationIdLength ()
 get character length for column More...
 
static string GetModificationIdHelp ()
 get the help text for the field in the database for this column More...
 
static OdbcParameter CreateOdbcParameter (short ATableNumber, TSearchCriteria ASearchCriteria)
 create an odbc parameter for the given column More...
 
static OdbcParameter CreateOdbcParameter (short ATableNumber, Int32 AColumnNr)
 create an odbc parameter for the given column More...
 
static void ResetStaticVariables ()
 reset the static variables for each Web Request call. More...
 
static string GetTableNameSQL (short ATableNumber)
 the table name as it is in the SQL database More...
 
static string GetTableName (short ATableNumber)
 the table name in CamelCase More...
 
static TTypedTableInfo GetTableByName (string ATableName)
 the table name in CamelCase More...
 
static string GetColumnNameSQL (short ATableNumber, short AColumnNr)
 the column name as it is in the SQL database More...
 
static string GetLabel (short ATableNumber, short AColumnNr)
 returns the translated label for the column More...
 
static Int32 GetLength (short ATableNumber, short AColumnNr)
 get the maximum length for the field More...
 
static Int32 GetLength (string ATableName, string AColumnName)
 get the maximum length for the field More...
 
static string[] GetKeyColumnStringList (short ATableNumber, int[] AKeyColumnsOrder)
 get the names of the columns that are part of the key More...
 
static string[] GetPrimaryKeyColumnStringList (short ATableNumber)
 get the names of the columns that are part of the primary key More...
 
static string[] GetUniqueKeyColumnStringList (short ATableNumber)
 get the names of the columns that are part of the unique key More...
 
static int[] GetPrimaryKeyColumnOrdList (short ATableNumber)
 get the order number of the columns that are part of the primary key More...
 
static int[] GetUniqueKeyColumnOrdList (short ATableNumber)
 get the order number of the columns that are part of a unique key More...
 
static string[] GetColumnStringList (short ATableNumber)
 get the names of the columns in this table More...
 

Public Attributes

DataColumn ColumnArDiscountCode
 code that identifies the discount More...
 
DataColumn ColumnArDateValidFrom
 date from which this discount is valid More...
 
DataColumn ColumnArAdhoc
 this discount has only be created on the fly and should not be reusable elsewhere More...
 
DataColumn ColumnActive
 flag that prevents this discount from being used, to avoid too long lists in comboboxes etc More...
 
DataColumn ColumnArDiscountPercentage
 discount percentage; can be negative for expensive rooms etc More...
 
DataColumn ColumnArDiscountAbsolute
 the absolute discount that is substracted from the article price; can be negative as well More...
 
DataColumn ColumnArAbsoluteAmount
 the absolute amount that is charged if this discount applies; e.g. 3 books for 5 Pound More...
 
DataColumn ColumnCurrencyCode
 the currency in which the absolute discount or amount is given More...
 
DataColumn ColumnArNumberOfItems
 this discount applies for this number of items that are bought at the same time More...
 
DataColumn ColumnArMinimumNumberOfItems
 this discount applies for all of the items if at least this number of items is bought at the same time More...
 
DataColumn ColumnArNumberOfNights
 this discount applies for this number of nights that the individual or group stays; this is needed because 100 people staying for one night do cost more than 50 people staying for 2 nights More...
 
DataColumn ColumnArMinimumNumberOfNights
 this discount applies for all of the nights if the individual or group stays at least for the given amount of nights; this is needed because 100 people staying for one night do cost more than 50 people staying for 2 nights More...
 
DataColumn ColumnArWholeRoom
 this discount applies when a whole room is booked rather than just a bed More...
 
DataColumn ColumnArChildren
 this discount applies for a children (e.g. meals) More...
 
DataColumn ColumnArEarlyBookingDays
 this discount applies when the booking has been done so many days before the stay (using ph_booking.ph_confirmed_d and ph_in_d) More...
 
DataColumn ColumnArEarlyPaymentDays
 this discount applies when the payment has been received within the given number of days after the invoice has been charged More...
 
DataColumn ColumnArArticleCode
 this discount applies if the article code matches More...
 
DataColumn ColumnPartnerTypeCode
 this discounts applies to partners of this type More...
 
DataColumn ColumnDateCreated
 The date the record was created. More...
 
DataColumn ColumnCreatedBy
 User ID of who created this record. More...
 
DataColumn ColumnDateModified
 The date the record was modified. More...
 
DataColumn ColumnModifiedBy
 User ID of who last modified this record. More...
 
DataColumn ColumnModificationId
 This identifies the current version of the record. More...
 
bool ThrowAwayAfterSubmitChanges = false
 if you want the datatable to be cleared after submitchanges. This will increase the speed significantly: no updating of modificationID, no slow AcceptChanges. More...
 
bool DontThrowAwayAfterSubmitChanges = false
 if you want no warning about that the datatable should be cleared after submitchanges. in some cases you must keep the data, eg when you need the new keys after INSERT More...
 

Static Public Attributes

static readonly short TableId = 182
 TableId for Ict.Common.Data generic functions. More...
 
static readonly short ColumnArDiscountCodeId = 0
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArDateValidFromId = 1
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArAdhocId = 2
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnActiveId = 3
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArDiscountPercentageId = 4
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArDiscountAbsoluteId = 5
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArAbsoluteAmountId = 6
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnCurrencyCodeId = 7
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArNumberOfItemsId = 8
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArMinimumNumberOfItemsId = 9
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArNumberOfNightsId = 10
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArMinimumNumberOfNightsId = 11
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArWholeRoomId = 12
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArChildrenId = 13
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArEarlyBookingDaysId = 14
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArEarlyPaymentDaysId = 15
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnArArticleCodeId = 16
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnPartnerTypeCodeId = 17
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnDateCreatedId = 18
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnCreatedById = 19
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnDateModifiedId = 20
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnModifiedById = 21
 used for generic TTypedDataTable functions More...
 
static readonly short ColumnModificationIdId = 22
 used for generic TTypedDataTable functions More...
 

Protected Member Functions

override void InitClass ()
 create the columns More...
 
override System.Data.DataRow NewRowFromBuilder (System.Data.DataRowBuilder builder)
 new typed row using DataRowBuilder More...
 

Static Protected Attributes

static SortedList< short, TTypedTableInfoTableInfo = new SortedList <short, TTypedTableInfo>()
 stores information about typed tables More...
 

Properties

AArDiscountRow this[int i] [get]
 Access a typed row by index. More...
 
override string TableDBLabel [get]
 instance property to get the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about) More...
 
int Count [get]
 the number of rows in the current table More...
 

Detailed Description

defines a discount that depends on other conditions or can just be assigned to an invoice or article

Constructor & Destructor Documentation

◆ AArDiscountTable() [1/3]

Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.AArDiscountTable ( )
inline

constructor

◆ AArDiscountTable() [2/3]

Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.AArDiscountTable ( string  ATablename)
inline

constructor

◆ AArDiscountTable() [3/3]

Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.AArDiscountTable ( System.Runtime.Serialization.SerializationInfo  info,
System.Runtime.Serialization.StreamingContext  context 
)
inline

constructor for serialization

Member Function Documentation

◆ CreateOdbcParameter() [1/3]

override OdbcParameter Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.CreateOdbcParameter ( Int32  AColumnNr)
inlinevirtual

get an odbc parameter for the given column

Implements Ict.Common.Data.TTypedDataTable.

◆ CreateOdbcParameter() [2/3]

static OdbcParameter Ict.Common.Data.TTypedDataTable.CreateOdbcParameter ( short  ATableNumber,
Int32  AColumnNr 
)
inlinestaticinherited

create an odbc parameter for the given column

◆ CreateOdbcParameter() [3/3]

static OdbcParameter Ict.Common.Data.TTypedDataTable.CreateOdbcParameter ( short  ATableNumber,
TSearchCriteria  ASearchCriteria 
)
inlinestaticinherited

create an odbc parameter for the given column

◆ GetActiveDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetActiveDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetActiveHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetActiveHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetActiveLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetActiveLength ( )
inlinestatic

get character length for column

◆ GetArAbsoluteAmountDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArAbsoluteAmountDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArAbsoluteAmountHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArAbsoluteAmountHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArAbsoluteAmountLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArAbsoluteAmountLength ( )
inlinestatic

get character length for column

◆ GetArAdhocDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArAdhocDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArAdhocHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArAdhocHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArAdhocLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArAdhocLength ( )
inlinestatic

get character length for column

◆ GetArArticleCodeDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArArticleCodeDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArArticleCodeHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArArticleCodeHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArArticleCodeLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArArticleCodeLength ( )
inlinestatic

get character length for column

◆ GetArChildrenDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArChildrenDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArChildrenHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArChildrenHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArChildrenLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArChildrenLength ( )
inlinestatic

get character length for column

◆ GetArDateValidFromDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDateValidFromDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArDateValidFromHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDateValidFromHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArDateValidFromLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDateValidFromLength ( )
inlinestatic

get character length for column

◆ GetArDiscountAbsoluteDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountAbsoluteDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArDiscountAbsoluteHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountAbsoluteHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArDiscountAbsoluteLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountAbsoluteLength ( )
inlinestatic

get character length for column

◆ GetArDiscountCodeDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountCodeDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArDiscountCodeHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountCodeHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArDiscountCodeLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountCodeLength ( )
inlinestatic

get character length for column

◆ GetArDiscountPercentageDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountPercentageDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArDiscountPercentageHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountPercentageHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArDiscountPercentageLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArDiscountPercentageLength ( )
inlinestatic

get character length for column

◆ GetArEarlyBookingDaysDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArEarlyBookingDaysDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArEarlyBookingDaysHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArEarlyBookingDaysHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArEarlyBookingDaysLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArEarlyBookingDaysLength ( )
inlinestatic

get character length for column

◆ GetArEarlyPaymentDaysDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArEarlyPaymentDaysDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArEarlyPaymentDaysHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArEarlyPaymentDaysHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArEarlyPaymentDaysLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArEarlyPaymentDaysLength ( )
inlinestatic

get character length for column

◆ GetArMinimumNumberOfItemsDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArMinimumNumberOfItemsDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArMinimumNumberOfItemsHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArMinimumNumberOfItemsHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArMinimumNumberOfItemsLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArMinimumNumberOfItemsLength ( )
inlinestatic

get character length for column

◆ GetArMinimumNumberOfNightsDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArMinimumNumberOfNightsDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArMinimumNumberOfNightsHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArMinimumNumberOfNightsHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArMinimumNumberOfNightsLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArMinimumNumberOfNightsLength ( )
inlinestatic

get character length for column

◆ GetArNumberOfItemsDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArNumberOfItemsDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArNumberOfItemsHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArNumberOfItemsHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArNumberOfItemsLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArNumberOfItemsLength ( )
inlinestatic

get character length for column

◆ GetArNumberOfNightsDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArNumberOfNightsDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArNumberOfNightsHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArNumberOfNightsHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArNumberOfNightsLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArNumberOfNightsLength ( )
inlinestatic

get character length for column

◆ GetArWholeRoomDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArWholeRoomDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetArWholeRoomHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArWholeRoomHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetArWholeRoomLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetArWholeRoomLength ( )
inlinestatic

get character length for column

◆ GetChanges()

new DataTable Ict.Common.Data.TTypedDataTable.GetChanges ( )
inlineinherited

make sure that we use GetChangesType instead of GetChanges

Returns
throws an exception

◆ GetChangesTyped()

AArDiscountTable Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetChangesTyped ( )
inline

get typed set of changes

◆ GetChangesTypedInternal()

DataTable Ict.Common.Data.TTypedDataTable.GetChangesTypedInternal ( )
inlineinherited

our own version of GetChanges

Returns
returns a typed table with the changes

◆ GetColumnNameSQL()

static string Ict.Common.Data.TTypedDataTable.GetColumnNameSQL ( short  ATableNumber,
short  AColumnNr 
)
inlinestaticinherited

the column name as it is in the SQL database

◆ GetColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetColumnStringList ( short  ATableNumber)
inlinestaticinherited

get the names of the columns in this table

◆ GetCreatedByDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetCreatedByDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetCreatedByHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetCreatedByHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetCreatedByLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetCreatedByLength ( )
inlinestatic

get character length for column

◆ GetCurrencyCodeDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetCurrencyCodeDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetCurrencyCodeHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetCurrencyCodeHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetCurrencyCodeLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetCurrencyCodeLength ( )
inlinestatic

get character length for column

◆ GetCustomReportFieldList()

virtual List< String > Ict.Common.Data.TTypedDataTable.GetCustomReportFieldList ( )
inlinevirtualinherited

Return a list of fields that are available for custom reports

◆ GetCustomReportPermission()

virtual string Ict.Common.Data.TTypedDataTable.GetCustomReportPermission ( )
inlinevirtualinherited

string to indicate which permissions a user needs to access table for custom reports (e.g. "PTNRUSER", "OR(FINANCE-1,DEVUSER)", "AND(PTNRUSER,FINANCE-1)" This should be returned by method in derived class

◆ GetDateCreatedDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetDateCreatedDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetDateCreatedHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetDateCreatedHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetDateCreatedLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetDateCreatedLength ( )
inlinestatic

get character length for column

◆ GetDateModifiedDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetDateModifiedDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetDateModifiedHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetDateModifiedHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetDateModifiedLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetDateModifiedLength ( )
inlinestatic

get character length for column

◆ GetKeyColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetKeyColumnStringList ( short  ATableNumber,
int[]  AKeyColumnsOrder 
)
inlinestaticinherited

get the names of the columns that are part of the key

◆ GetLabel()

static string Ict.Common.Data.TTypedDataTable.GetLabel ( short  ATableNumber,
short  AColumnNr 
)
inlinestaticinherited

returns the translated label for the column

◆ GetLength() [1/2]

static Int32 Ict.Common.Data.TTypedDataTable.GetLength ( short  ATableNumber,
short  AColumnNr 
)
inlinestaticinherited

get the maximum length for the field

◆ GetLength() [2/2]

static Int32 Ict.Common.Data.TTypedDataTable.GetLength ( string  ATableName,
string  AColumnName 
)
inlinestaticinherited

get the maximum length for the field

◆ GetModificationIdDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetModificationIdDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetModificationIdHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetModificationIdHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetModificationIdLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetModificationIdLength ( )
inlinestatic

get character length for column

◆ GetModifiedByDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetModifiedByDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetModifiedByHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetModifiedByHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetModifiedByLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetModifiedByLength ( )
inlinestatic

get character length for column

◆ GetPartnerTypeCodeDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetPartnerTypeCodeDBName ( )
inlinestatic

get the name of the field in the database for this column

◆ GetPartnerTypeCodeHelp()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetPartnerTypeCodeHelp ( )
inlinestatic

get the help text for the field in the database for this column

◆ GetPartnerTypeCodeLength()

static short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetPartnerTypeCodeLength ( )
inlinestatic

get character length for column

◆ GetPrimaryKeyColumnOrdList()

static int[] Ict.Common.Data.TTypedDataTable.GetPrimaryKeyColumnOrdList ( short  ATableNumber)
inlinestaticinherited

get the order number of the columns that are part of the primary key

◆ GetPrimaryKeyColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetPrimaryKeyColumnStringList ( short  ATableNumber)
inlinestaticinherited

get the names of the columns that are part of the primary key

◆ GetTableByName()

static TTypedTableInfo Ict.Common.Data.TTypedDataTable.GetTableByName ( string  ATableName)
inlinestaticinherited

the table name in CamelCase

◆ GetTableDBLabel()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetTableDBLabel ( )
inlinestatic

static method to return the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about)

◆ GetTableDBName()

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetTableDBName ( )
inlinestatic

return the name of the table as it is used in the database

◆ GetTableName() [1/2]

static string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.GetTableName ( )
inlinestatic

return the CamelCase name of the table

◆ GetTableName() [2/2]

static string Ict.Common.Data.TTypedDataTable.GetTableName ( short  ATableNumber)
inlinestaticinherited

the table name in CamelCase

◆ GetTableNameSQL()

static string Ict.Common.Data.TTypedDataTable.GetTableNameSQL ( short  ATableNumber)
inlinestaticinherited

the table name as it is in the SQL database

◆ GetUniqueKeyColumnOrdList()

static int[] Ict.Common.Data.TTypedDataTable.GetUniqueKeyColumnOrdList ( short  ATableNumber)
inlinestaticinherited

get the order number of the columns that are part of a unique key

◆ GetUniqueKeyColumnStringList()

static string[] Ict.Common.Data.TTypedDataTable.GetUniqueKeyColumnStringList ( short  ATableNumber)
inlinestaticinherited

get the names of the columns that are part of the unique key

◆ InitClass()

override void Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.InitClass ( )
inlineprotectedvirtual

create the columns

Implements Ict.Common.Data.TTypedDataTable.

◆ InitVars()

override void Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.InitVars ( )
inlinevirtual

assign columns to properties, set primary key

Implements Ict.Common.Data.TTypedDataTable.

◆ IsAvailableForCustomReport()

virtual bool Ict.Common.Data.TTypedDataTable.IsAvailableForCustomReport ( )
inlinevirtualinherited

Is this table generally available in custom reports?

◆ NewRowFromBuilder()

override System.Data.DataRow Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.NewRowFromBuilder ( System.Data.DataRowBuilder  builder)
inlineprotected

new typed row using DataRowBuilder

◆ NewRowTyped() [1/2]

AArDiscountRow Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.NewRowTyped ( )
inline

create a new typed row, always with default values

◆ NewRowTyped() [2/2]

AArDiscountRow Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.NewRowTyped ( bool  AWithDefaultValues)
inline

create a new typed row

◆ RemoveColumnsNotInTableTemplate()

void Ict.Common.Data.TTypedDataTable.RemoveColumnsNotInTableTemplate ( DataTable  ATableTemplate)
inlineinherited

remove columns that are not needed

Parameters
ATableTemplatethis table only contains the columns that should be kept

◆ ResetStaticVariables()

static void Ict.Common.Data.TTypedDataTable.ResetStaticVariables ( )
inlinestaticinherited

reset the static variables for each Web Request call.

Member Data Documentation

◆ ColumnActive

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnActive

flag that prevents this discount from being used, to avoid too long lists in comboboxes etc

◆ ColumnActiveId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnActiveId = 3
static

used for generic TTypedDataTable functions

◆ ColumnArAbsoluteAmount

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArAbsoluteAmount

the absolute amount that is charged if this discount applies; e.g. 3 books for 5 Pound

◆ ColumnArAbsoluteAmountId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArAbsoluteAmountId = 6
static

used for generic TTypedDataTable functions

◆ ColumnArAdhoc

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArAdhoc

this discount has only be created on the fly and should not be reusable elsewhere

◆ ColumnArAdhocId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArAdhocId = 2
static

used for generic TTypedDataTable functions

◆ ColumnArArticleCode

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArArticleCode

this discount applies if the article code matches

◆ ColumnArArticleCodeId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArArticleCodeId = 16
static

used for generic TTypedDataTable functions

◆ ColumnArChildren

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArChildren

this discount applies for a children (e.g. meals)

◆ ColumnArChildrenId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArChildrenId = 13
static

used for generic TTypedDataTable functions

◆ ColumnArDateValidFrom

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDateValidFrom

date from which this discount is valid

◆ ColumnArDateValidFromId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDateValidFromId = 1
static

used for generic TTypedDataTable functions

◆ ColumnArDiscountAbsolute

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDiscountAbsolute

the absolute discount that is substracted from the article price; can be negative as well

◆ ColumnArDiscountAbsoluteId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDiscountAbsoluteId = 5
static

used for generic TTypedDataTable functions

◆ ColumnArDiscountCode

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDiscountCode

code that identifies the discount

◆ ColumnArDiscountCodeId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDiscountCodeId = 0
static

used for generic TTypedDataTable functions

◆ ColumnArDiscountPercentage

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDiscountPercentage

discount percentage; can be negative for expensive rooms etc

◆ ColumnArDiscountPercentageId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArDiscountPercentageId = 4
static

used for generic TTypedDataTable functions

◆ ColumnArEarlyBookingDays

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArEarlyBookingDays

this discount applies when the booking has been done so many days before the stay (using ph_booking.ph_confirmed_d and ph_in_d)

◆ ColumnArEarlyBookingDaysId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArEarlyBookingDaysId = 14
static

used for generic TTypedDataTable functions

◆ ColumnArEarlyPaymentDays

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArEarlyPaymentDays

this discount applies when the payment has been received within the given number of days after the invoice has been charged

◆ ColumnArEarlyPaymentDaysId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArEarlyPaymentDaysId = 15
static

used for generic TTypedDataTable functions

◆ ColumnArMinimumNumberOfItems

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArMinimumNumberOfItems

this discount applies for all of the items if at least this number of items is bought at the same time

◆ ColumnArMinimumNumberOfItemsId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArMinimumNumberOfItemsId = 9
static

used for generic TTypedDataTable functions

◆ ColumnArMinimumNumberOfNights

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArMinimumNumberOfNights

this discount applies for all of the nights if the individual or group stays at least for the given amount of nights; this is needed because 100 people staying for one night do cost more than 50 people staying for 2 nights

◆ ColumnArMinimumNumberOfNightsId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArMinimumNumberOfNightsId = 11
static

used for generic TTypedDataTable functions

◆ ColumnArNumberOfItems

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArNumberOfItems

this discount applies for this number of items that are bought at the same time

◆ ColumnArNumberOfItemsId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArNumberOfItemsId = 8
static

used for generic TTypedDataTable functions

◆ ColumnArNumberOfNights

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArNumberOfNights

this discount applies for this number of nights that the individual or group stays; this is needed because 100 people staying for one night do cost more than 50 people staying for 2 nights

◆ ColumnArNumberOfNightsId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArNumberOfNightsId = 10
static

used for generic TTypedDataTable functions

◆ ColumnArWholeRoom

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArWholeRoom

this discount applies when a whole room is booked rather than just a bed

◆ ColumnArWholeRoomId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnArWholeRoomId = 12
static

used for generic TTypedDataTable functions

◆ ColumnCreatedBy

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnCreatedBy

User ID of who created this record.

◆ ColumnCreatedById

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnCreatedById = 19
static

used for generic TTypedDataTable functions

◆ ColumnCurrencyCode

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnCurrencyCode

the currency in which the absolute discount or amount is given

◆ ColumnCurrencyCodeId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnCurrencyCodeId = 7
static

used for generic TTypedDataTable functions

◆ ColumnDateCreated

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnDateCreated

The date the record was created.

◆ ColumnDateCreatedId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnDateCreatedId = 18
static

used for generic TTypedDataTable functions

◆ ColumnDateModified

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnDateModified

The date the record was modified.

◆ ColumnDateModifiedId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnDateModifiedId = 20
static

used for generic TTypedDataTable functions

◆ ColumnModificationId

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnModificationId

This identifies the current version of the record.

◆ ColumnModificationIdId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnModificationIdId = 22
static

used for generic TTypedDataTable functions

◆ ColumnModifiedBy

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnModifiedBy

User ID of who last modified this record.

◆ ColumnModifiedById

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnModifiedById = 21
static

used for generic TTypedDataTable functions

◆ ColumnPartnerTypeCode

DataColumn Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnPartnerTypeCode

this discounts applies to partners of this type

◆ ColumnPartnerTypeCodeId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.ColumnPartnerTypeCodeId = 17
static

used for generic TTypedDataTable functions

◆ DontThrowAwayAfterSubmitChanges

bool Ict.Common.Data.TTypedDataTable.DontThrowAwayAfterSubmitChanges = false
inherited

if you want no warning about that the datatable should be cleared after submitchanges. in some cases you must keep the data, eg when you need the new keys after INSERT

◆ TableId

readonly short Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.TableId = 182
static

TableId for Ict.Common.Data generic functions.

◆ TableInfo

SortedList<short, TTypedTableInfo> Ict.Common.Data.TTypedDataTable.TableInfo = new SortedList <short, TTypedTableInfo>()
staticprotectedinherited

stores information about typed tables

◆ ThrowAwayAfterSubmitChanges

bool Ict.Common.Data.TTypedDataTable.ThrowAwayAfterSubmitChanges = false
inherited

if you want the datatable to be cleared after submitchanges. This will increase the speed significantly: no updating of modificationID, no slow AcceptChanges.

Property Documentation

◆ Count

int Ict.Common.Data.TTypedDataTable.Count
getinherited

the number of rows in the current table

◆ TableDBLabel

override string Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.TableDBLabel
get

instance property to get the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about)

◆ this[int i]

AArDiscountRow Ict.Petra.Shared.MFinance.AR.Data.AArDiscountTable.this[int i]
get

Access a typed row by index.


The documentation for this class was generated from the following file: