Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess Class Reference

Lists the attendees at a conference. More...

Inheritance diagram for Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess:

Public Types
enum	eSubmitChangesOperations { eUpdate = 1 , eDelete = 2 , eInsert = 4 , eAll = 7 }
	enumeration of operations that can be selected for SubmitChanges More...

Static Public Member Functions
static void	LoadAll (DataSet ADataSet, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	this method is called by all overloads More...
static void	LoadAll (DataSet AData, TDBTransaction ATransaction)
	auto generated More...
static void	LoadAll (DataSet AData, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadAll (StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadAll (TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadAll (StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeRow	LoadByPrimaryKey (DataSet ADataSet, Int64 AConferenceKey, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	this method is called by all overloads More...
static PcAttendeeRow	LoadByPrimaryKey (DataSet AData, Int64 AConferenceKey, Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeRow	LoadByPrimaryKey (DataSet AData, Int64 AConferenceKey, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadByPrimaryKey (Int64 AConferenceKey, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadByPrimaryKey (Int64 AConferenceKey, Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadByPrimaryKey (Int64 AConferenceKey, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadUsingTemplate (DataSet ADataSet, PcAttendeeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	this method is called by all overloads More...
static void	LoadUsingTemplate (DataSet AData, PcAttendeeRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static void	LoadUsingTemplate (DataSet AData, PcAttendeeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (PcAttendeeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (PcAttendeeRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (PcAttendeeRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (PcAttendeeRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadUsingTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	this method is called by all overloads More...
static void	LoadUsingTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	LoadUsingTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadUsingTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static int	CountAll (TDBTransaction ATransaction)
	this method is called by all overloads More...
static bool	Exists (Int64 AConferenceKey, Int64 APartnerKey, TDBTransaction ATransaction)
	check if a row exists by using the primary key More...
static int	CountUsingTemplate (PcAttendeeRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	this method is called by all overloads More...
static int	CountUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	this method is called by all overloads More...
static void	LoadViaPcConference (DataSet ADataSet, Int64 AConferenceKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPcConference (DataSet AData, Int64 AConferenceKey, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPcConference (DataSet AData, Int64 AConferenceKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConference (Int64 AConferenceKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPcConference (Int64 AConferenceKey, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConference (Int64 AConferenceKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPcConferenceTemplate (DataSet ADataSet, PcConferenceRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPcConferenceTemplate (DataSet AData, PcConferenceRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPcConferenceTemplate (DataSet AData, PcConferenceRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (PcConferenceRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (PcConferenceRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (PcConferenceRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (PcConferenceRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPcConferenceTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPcConferenceTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPcConferenceTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPcConferenceTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPcConference (Int64 AConferenceKey, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPcConferenceTemplate (PcConferenceRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPcConferenceTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPPerson (DataSet ADataSet, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPPerson (DataSet AData, Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPPerson (DataSet AData, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPerson (Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPPerson (Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPerson (Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPPersonTemplate (DataSet ADataSet, PPersonRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPPersonTemplate (DataSet AData, PPersonRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPPersonTemplate (DataSet AData, PPersonRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (PPersonRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (PPersonRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (PPersonRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (PPersonRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPPersonTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPPersonTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPPersonTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPPersonTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPPerson (Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPPersonTemplate (PPersonRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPPersonTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPUnit (DataSet ADataSet, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPUnit (DataSet AData, Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPUnit (DataSet AData, Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnit (Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPUnit (Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnit (Int64 APartnerKey, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPUnitTemplate (DataSet ADataSet, PUnitRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPUnitTemplate (DataSet AData, PUnitRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPUnitTemplate (DataSet AData, PUnitRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (PUnitRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (PUnitRow ATemplateRow, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (PUnitRow ATemplateRow, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (PUnitRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPUnitTemplate (DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static void	LoadViaPUnitTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	LoadViaPUnitTemplate (DataSet AData, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static PcAttendeeTable	LoadViaPUnitTemplate (TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPUnit (Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPUnitTemplate (PUnitRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	auto generated More...
static int	CountViaPUnitTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	DeleteByPrimaryKey (Int64 AConferenceKey, Int64 APartnerKey, TDBTransaction ATransaction)
	auto generated More...
static void	DeleteUsingTemplate (PcAttendeeRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	auto generated More...
static void	DeleteUsingTemplate (TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	auto generated More...
static void	SubmitChanges (PcAttendeeTable ATable, TDBTransaction ATransaction)
	Auto generated code ... More...
static void	AddOrModifyRecord (Int64 AConferenceKey, Int64 APartnerKey, PcAttendeeTable ATable, PcAttendeeRow ANewRow, bool ADoNotOverwrite, TDBTransaction ATransaction)
static bool	NoDefaultColumn (String AColumnName)
	This function returns true if the column name is not one of the special columns, that are written automatically: modified date and by, created date and by, modification id More...
static void	GetStoredModification (short ATableId, string[] AColumnNames, int[] APrimKeyColumnOrdList, DataRow ADataRow, DB.TDBTransaction ATransaction, out DateTime AModificationID, out String AModifiedBy, out System.DateTime AModifiedDate, bool ATreatRowAsAdded=false)
	This function returns the modification details of a row More...
static void	InsertRow (short ATableId, ref DataRow ADataRow, String ACurrentUser, StringBuilder AInsertStatement, List< OdbcParameter >AInsertParameters)
	This function is called by the DataStore (SubmitChanges). it will not update the modification id. More...
static void	InsertRow (short ATableId, ref DataRow ADataRow, TDBTransaction ATransaction, String ACurrentUser, bool ATreatRowAsAdded)
	This function is called by the DataStore (SubmitChanges). it will update the modification id. More...
static void	UpdateRow (short ATableId, bool AThrowAwayAfterSubmitChanges, ref DataRow ADataRow, DB.TDBTransaction ATransaction, String ACurrentUser)
	This function is called by the DataStore (SubmitChanges) More...
static void	DeleteRow (short ATableId, DataRow ADataRow, DB.TDBTransaction ATransaction)
	This function is called by the DataStore (SubmitChanges) More...
static String	GenerateSelectClause (StringCollection AFieldList, short ATableID, bool AIncludeTableNames=false)
	This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will return a proper Select Clause. More...
static String	GenerateSelectClauseLong (String ATableName, StringCollection AFieldList, short ATableId)
	This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will prefix all fields with the given tablename. needed for selecting from join statements. It will return a proper Select Clause. If a field has already a dot in the name, the ATablename is not put before it: That way you can do SUM(PUB_table.p_something). More...
static String	GenerateWhereClause (string[] AColumnNames, DataRow ADataRow, StringCollection ATemplateOperators)
	This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values. More...
static String	GenerateWhereClause (string[] AColumnNames, DataRow ADataRow)
	This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values. More...
static String	GenerateWhereClause (TSearchCriteria[] ASearchCriteria)
	This function expects an empty table that contains all existing columns, and search criteria. It will return a Where clause, using the given values. More...
static String	GenerateWhereClauseFromPrimaryKey (short ATableId)
	this function generates a where clause for the primary key of the given table More...
static String	GenerateWhereClauseFromUniqueKey (short ATableId)
	this function generates a where clause for the unique key of the given table More...
static String	GenerateWhereClauseLong (String ATableName, short ATableId, DataRow ADataRow, StringCollection ATemplateOperators)
	This function expects a string list of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
static String	GenerateWhereClauseLong (String ATableName, TSearchCriteria[] ASearchCriteria)
	This function expects a string list of all existing columns, and a criteria list of values to search for. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
static String	GenerateWhereClauseLong (String ATableName, short ATableId, DataRow ADataRow)
	This function expects a string array with the names of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname More...
static String	GenerateOrderByClause (StringCollection AOrderBy)
	This function expects a list of string, where the first string is either "order by" or "group by", and the rest of the string is e.g. "p_partner.p_partner_key_n ASC" It will return the appropriate part of the sql query More...
static OdbcParameter	CreateOdbcParameter (short ATableId, Int32 AColumnNr, Type AType)
	This function creates an odbc parameter with the correct type, based on the obj which comes from a DataRow More...
static System.Object	GetSafeValue (DataRow ADataRow, System.Int32 AColumnNr, DataRowVersion AVersion)
	This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc. More...
static System.Object	GetSafeValue (DataRow ADataRow, String AColumnName, DataRowVersion AVersion)
	This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc. More...
static bool	NotEquals (DataRow ADataRow, System.Int32 AColumnNr, ref System.Object ACurrentValue)
	Compare the original and the current value of a column in a datarow. Make sure some mono specific troubles are worked around. More...
static OdbcParameter[]	GetParametersForWhereClause (short ATableId, DataRow ADataRow)
	This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL More...
static OdbcParameter[]	GetParametersForWhereClause (short ATableNumber, TSearchCriteria[] ASearchCriteria)
	This function provides the actual parameters for the GenerateWhereClause More...
static OdbcParameter[]	GetParametersForWhereClauseWithPrimaryKey (short ATableId, DataRow ADataRow)
	This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL More...
static List< OdbcParameter >	GetParametersForInsertClause (short ATableId, ref DataRow ADataRow, Int32 ANumberDBColumns, String ACurrentUser, bool AIncludeDefaultColumns)
	This function provides the actual parameters for the GenerateInsertClause uses only the values that are not DBNULL adds the next modification ID More...
static OdbcParameter[]	GetParametersForUpdateClause (short ATableId, ref DataRow ADataRow, int[] APrimaryKeyColumnOrd, Int32 ANumberDBColumns, String ACurrentUser)
	This function provides the actual parameters for the GenerateUpdateClause uses only the values that are changed (comparing the current and the original version of the row) More...
static OdbcParameter[]	GetParametersForDeleteClause (short ATableId, DataRow ADataRow, int[] APrimaryKeyColumnOrd)
	This function provides the actual parameters for the GenerateDeleteClause it uses the OriginalVersion of the primary key values More...
static String	GenerateInsertClause (String ATableName, string[] AColumnNames, DataRow ADataRow, bool AIncludeDefaultColumns)
	This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. It will return a complete INSERT Clause. More...
static String	GenerateUpdateClause (String ATableName, string[] AColumnNames, DataRow ADataRow, int[] APrimKeyColumnOrdList)
	This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. More...
static DataRow	LoadByPrimaryKey (short ATableId, DataSet ADataSet, System.Object[] APrimaryKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	load data row by primary key into a dataset More...
static DataRow	LoadByPrimaryKey (short ATableId, TTypedDataTable ADataTable, System.Object[] APrimaryKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	different version for data table More...
static void	LoadByUniqueKey (short ATableId, DataSet ADataSet, System.Object[] AUniqueKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	load data row by unique key into a dataset More...
static void	LoadByUniqueKey (short ATableId, TTypedDataTable ADataTable, System.Object[] AUniqueKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	different version for data table More...
static void	LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, System.Object[] AForeignKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	load data for the current table via a foreign key, eg. load all extracts created by user x More...
static void	LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, System.Object[] AForeignKeyValues, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	load data for the current table via a foreign key, eg. load all extracts created by user x More...
static void	LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	Load via other table, using template values. More...
static void	LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	Load via other table, using template values. More...
static void	LoadViaForeignKey (short ATableId, short AOtherTableId, DataSet ADataSet, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	Load via other table, using template values. More...
static void	LoadViaForeignKey (short ATableId, short AOtherTableId, TTypedDataTable ADataTable, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	Load via other table, using template values. More...
static int	CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, System.Object[] AForeignKeyValues, TDBTransaction ATransaction)
	count the rows by the values of a foreign key More...
static int	CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, DataRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	count the rows by the values of a foreign key More...
static int	CountViaForeignKey (short ATableId, short AOtherTableId, string[] AThisFieldNames, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	count the rows by the values of a foreign key More...
static void	DeleteByPrimaryKey (short ATableId, System.Object[] APrimaryKeyValues, TDBTransaction ATransaction)
	delete by primary key values More...
static bool	Exists (short ATableId, System.Object[] APrimaryKeyValues, TDBTransaction ATransaction)
	check if row exists with the primary key More...
static bool	ExistsUniqueKey (short ATableId, System.Object[] AUniqueKeyValues, TDBTransaction ATransaction)
	check if row exists with the unique key More...
static void	LoadUsingTemplate (short ATableID, DataSet ADataSet, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	loads all rows matching certain search criteria into a dataset More...
static void	LoadUsingTemplate (short ATableID, TTypedDataTable ATypedTableToLoad, TSearchCriteria[] ASearchCriteria, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	loads all rows matching certain search criteria into a typed data table More...
static void	LoadUsingTemplate (short ATableId, DataSet ADataSet, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	load using a template row More...
static void	LoadUsingTemplate (short ATableId, TTypedDataTable ADataTable, DataRow ATemplateRow, StringCollection ATemplateOperators, StringCollection AFieldList, TDBTransaction ATransaction, StringCollection AOrderBy, int AStartRecord, int AMaxRecords)
	load using a template row More...
static void	DeleteUsingTemplate (short ATableId, DataRow ATemplateRow, StringCollection ATemplateOperators, TDBTransaction ATransaction)
	delete all rows matching the given row More...
static void	DeleteUsingTemplate (short ATableId, TSearchCriteria[] ASearchCriteria, TDBTransaction ATransaction)
	delete all rows matching the search criteria More...
static void	SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, eSubmitChangesOperations ASelectedOperations, string AUserId, string ASequenceName, string ASequenceField)
	submit those rows in the table that have been modified or created or deleted More...
static void	SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, string AUserId, string ASequenceName, string ASequenceField)
	overloaded version without ASelectedOperations More...
static void	SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, string AUserId)
	overloaded version without sequence More...
static void	SubmitChanges (TTypedDataTable ATable, TDBTransaction ATransaction, eSubmitChangesOperations ASelectedOperations, string AUserId)
	overloaded version without sequence, but with ASelectedOperations More...
static TVerificationResultCollection	BuildVerificationResultCollectionFromRefTables (string AThisTable, string AThisTableLabel, Dictionary< string, object >APKInfo, List< TRowReferenceInfo >AReferences, TResultSeverity AResultSeverity=TResultSeverity.Resv_Critical)
	Builds a TVerificationResultCollection from DB Table references created by a cascading count Method. It will contain only a single TVerificationResult. More...

Static Public Attributes
const string	DATATABLENAME = "PcAttendee"
	CamelCase version of table name. More...
const string	DBTABLENAME = "pc_attendee"
	original table name in database More...
const string	MODIFICATION_ID = "s_modification_id_t"
	name of the column used for tracking changes, one ID per change More...
const string	MODIFIED_BY = "s_modified_by_c"
	who has last modified the row More...
const string	MODIFIED_DATE = "s_date_modified_d"
	when was the last change to the row More...
const string	CREATED_BY = "s_created_by_c"
	who has originally created this row More...
const string	CREATED_DATE = "s_date_created_d"
	when was this row originally created More...
static readonly DateTime	MODIFICATION_ID_DELETEDROW_INDICATOR = DateTime.MaxValue
	indicates whether a row has been deleted More...

Detailed Description

Lists the attendees at a conference.

Member Enumeration Documentation

eSubmitChangesOperations

enum Ict.Common.Data.TTypedDataAccess.eSubmitChangesOperations

inherited

enumeration of operations that can be selected for SubmitChanges

Enumerator
eUpdate	update records
eDelete	delete records
eInsert	add new records
eAll	execute all operations, no matter if it is update, delete, insert

Member Function Documentation

AddOrModifyRecord()

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.AddOrModifyRecord ( Int64  AConferenceKey, Int64  APartnerKey, PcAttendeeTable  ATable, PcAttendeeRow  ANewRow, bool  ADoNotOverwrite, TDBTransaction  ATransaction  )

inlinestatic

If a record with this primary key already exists in the database, that record will be updated. otherwise a new record will be added.

BuildVerificationResultCollectionFromRefTables()

static TVerificationResultCollection Ict.Common.Data.TTypedDataAccess.BuildVerificationResultCollectionFromRefTables ( string  AThisTable, string  AThisTableLabel, Dictionary< string, object >  APKInfo, List< TRowReferenceInfo >  AReferences, TResultSeverity  AResultSeverity = TResultSeverity.Resv_Critical  )

inlinestaticinherited

Builds a TVerificationResultCollection from DB Table references created by a cascading count Method. It will contain only a single TVerificationResult.

Returns

TVerificationResultCollection from DB Table references created by a cascading count Method. In case AReferences does not contain elements a TVerificationResultCollection containing no elements will be returned.

Parameters

AThisTable	Name of the DB Table (as in the DB) that the references point to.
AThisTableLabel	Label (='friendly name' for the user) of the DB Table that the references point to.
APKInfo	Dictionary<T, T> consisting of a string-object pair for each Primary Key Column. The string (Key) is the Label ('friendly name' for the user) of the PK Column and the object (Value) holds the actual data of the PK Column.
AReferences	A List<T> of TRowReferenceInfo objects that contain information about the DB Table references created by a cascading count Method.
AResultSeverity	Allows the specification of a TResultSeverity for the TVerificationResult that gets added to the return value. (Default=TResultSeverity.Resv_Critical.)

Returns

A TVerificationResultCollection containing a single TVerificationResult that contains information about DB Table references created by a cascading count Method.

CountAll()

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountAll ( TDBTransaction  ATransaction )

inlinestatic

this method is called by all overloads

CountUsingTemplate() [1/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountUsingTemplate ( PcAttendeeRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestatic

this method is called by all overloads

CountUsingTemplate() [2/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountUsingTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

this method is called by all overloads

CountViaForeignKey() [1/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId, short  AOtherTableId, string[]  AThisFieldNames, DataRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestaticinherited

count the rows by the values of a foreign key

CountViaForeignKey() [2/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId, short  AOtherTableId, string[]  AThisFieldNames, System.Object[]  AForeignKeyValues, TDBTransaction  ATransaction  )

inlinestaticinherited

count the rows by the values of a foreign key

CountViaForeignKey() [3/3]

static int Ict.Common.Data.TTypedDataAccess.CountViaForeignKey ( short  ATableId, short  AOtherTableId, string[]  AThisFieldNames, TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestaticinherited

count the rows by the values of a foreign key

CountViaPcConference()

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPcConference ( Int64  AConferenceKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPcConferenceTemplate() [1/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPcConferenceTemplate ( PcConferenceRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPcConferenceTemplate() [2/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPcConferenceTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPPerson()

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPPerson ( Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPPersonTemplate() [1/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPPersonTemplate ( PPersonRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPPersonTemplate() [2/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPPersonTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPUnit()

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPUnit ( Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPUnitTemplate() [1/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPUnitTemplate ( PUnitRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CountViaPUnitTemplate() [2/2]

static int Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.CountViaPUnitTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

CreateOdbcParameter()

static OdbcParameter Ict.Common.Data.TTypedDataAccess.CreateOdbcParameter ( short  ATableId, Int32  AColumnNr, Type  AType  )

inlinestaticinherited

This function creates an odbc parameter with the correct type, based on the obj which comes from a DataRow

Parameters

ATableId	Table that we are operating on
AColumnNr	which column should the parameter be generated for
AType	the value that needs to be converted to OdbcParameter

Returns

the Odbc parameter

DeleteByPrimaryKey() [1/2]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.DeleteByPrimaryKey ( Int64  AConferenceKey, Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

DeleteByPrimaryKey() [2/2]

static void Ict.Common.Data.TTypedDataAccess.DeleteByPrimaryKey ( short  ATableId, System.Object[]  APrimaryKeyValues, TDBTransaction  ATransaction  )

inlinestaticinherited

delete by primary key values

Parameters

ATableId
APrimaryKeyValues
ATransaction

DeleteRow()

static void Ict.Common.Data.TTypedDataAccess.DeleteRow ( short  ATableId, DataRow  ADataRow, DB.TDBTransaction  ATransaction  )

inlinestaticinherited

This function is called by the DataStore (SubmitChanges)

Returns

void

DeleteUsingTemplate() [1/4]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.DeleteUsingTemplate ( PcAttendeeRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestatic

auto generated

DeleteUsingTemplate() [2/4]

static void Ict.Common.Data.TTypedDataAccess.DeleteUsingTemplate ( short  ATableId, DataRow  ATemplateRow, StringCollection  ATemplateOperators, TDBTransaction  ATransaction  )

inlinestaticinherited

delete all rows matching the given row

Parameters

ATableId
ATemplateRow
ATemplateOperators
ATransaction

DeleteUsingTemplate() [3/4]

static void Ict.Common.Data.TTypedDataAccess.DeleteUsingTemplate ( short  ATableId, TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestaticinherited

delete all rows matching the search criteria

Parameters

ATableId	specify which typed table is used
ASearchCriteria
ATransaction

DeleteUsingTemplate() [4/4]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.DeleteUsingTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

Exists() [1/2]

static bool Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.Exists ( Int64  AConferenceKey, Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

check if a row exists by using the primary key

Exists() [2/2]

static bool Ict.Common.Data.TTypedDataAccess.Exists ( short  ATableId, System.Object[]  APrimaryKeyValues, TDBTransaction  ATransaction  )

inlinestaticinherited

check if row exists with the primary key

Parameters

ATableId
APrimaryKeyValues
ATransaction

ExistsUniqueKey()

static bool Ict.Common.Data.TTypedDataAccess.ExistsUniqueKey ( short  ATableId, System.Object[]  AUniqueKeyValues, TDBTransaction  ATransaction  )

inlinestaticinherited

check if row exists with the unique key

Parameters

ATableId
AUniqueKeyValues
ATransaction

GenerateInsertClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateInsertClause ( String  ATableName, string[]  AColumnNames, DataRow  ADataRow, bool  AIncludeDefaultColumns  )

inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column. It will return a complete INSERT Clause.

Returns

the INSERT statement

GenerateOrderByClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateOrderByClause ( StringCollection  AOrderBy )

inlinestaticinherited

This function expects a list of string, where the first string is either "order by" or "group by", and the rest of the string is e.g. "p_partner.p_partner_key_n ASC" It will return the appropriate part of the sql query

Parameters

AOrderBy

String list with instructions how to order or group the result

Returns

the order by / group by clause

GenerateSelectClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateSelectClause ( StringCollection  AFieldList, short  ATableID, bool  AIncludeTableNames = false  )

inlinestaticinherited

This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will return a proper Select Clause.

Returns

the Select Clause

GenerateSelectClauseLong()

static String Ict.Common.Data.TTypedDataAccess.GenerateSelectClauseLong ( String  ATableName, StringCollection  AFieldList, short  ATableId  )

inlinestaticinherited

This function expects a StringCollection that can be filled, empty or nil. It also needs the list of the primary key columns, because otherwise the returned row will fail the constraints. It will prefix all fields with the given tablename. needed for selecting from join statements. It will return a proper Select Clause. If a field has already a dot in the name, the ATablename is not put before it: That way you can do SUM(PUB_table.p_something).

Returns

the Select Clause

GenerateUpdateClause()

static String Ict.Common.Data.TTypedDataAccess.GenerateUpdateClause ( String  ATableName, string[]  AColumnNames, DataRow  ADataRow, int[]  APrimKeyColumnOrdList  )

inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a value or an empty value for each column.

Returns

the UPDATE statement

GenerateWhereClause() [1/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( string[]  AColumnNames, DataRow  ADataRow  )

inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values.

Returns

the Where Clause

GenerateWhereClause() [2/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( string[]  AColumnNames, DataRow  ADataRow, StringCollection  ATemplateOperators  )

inlinestaticinherited

This function expects an empty table that contains all existing columns, and a datarow that has a string or an empty value for each column. It will return a Where clause, using the given values.

Parameters

AColumnNames	the column names
ADataRow	the data row with the the columns for the where clause
ATemplateOperators	Every template field can have an operator; the default version always used = or LIKE

Returns

the Where Clause

GenerateWhereClause() [3/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClause ( TSearchCriteria[]  ASearchCriteria )

inlinestaticinherited

This function expects an empty table that contains all existing columns, and search criteria. It will return a Where clause, using the given values.

Parameters

ASearchCriteria

Returns

the Where Clause

GenerateWhereClauseFromPrimaryKey()

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseFromPrimaryKey ( short  ATableId )

inlinestaticinherited

this function generates a where clause for the primary key of the given table

Parameters

ATableId

Returns

GenerateWhereClauseFromUniqueKey()

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseFromUniqueKey ( short  ATableId )

inlinestaticinherited

this function generates a where clause for the unique key of the given table

Parameters

ATableId

Returns

GenerateWhereClauseLong() [1/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName, short  ATableId, DataRow  ADataRow  )

inlinestaticinherited

This function expects a string array with the names of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters

ATableName	the table that the where clause is generated for
ATableId	id of the table to get the list of all columns of that table
ADataRow	contains the values for the where clause

Returns

the Where Clause

GenerateWhereClauseLong() [2/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName, short  ATableId, DataRow  ADataRow, StringCollection  ATemplateOperators  )

inlinestaticinherited

This function expects a string list of all existing columns, and a datarow that has a value or an empty value for each column. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters

ATableName	the table that the where clause is generated for
ATableId	id of the table to get the list of all columns of that table
ADataRow	contains the values for the where clause
ATemplateOperators	Every template field can have an operator; the default version always used = or LIKE

Returns

the Where Clause

GenerateWhereClauseLong() [3/3]

static String Ict.Common.Data.TTypedDataAccess.GenerateWhereClauseLong ( String  ATableName, TSearchCriteria[]  ASearchCriteria  )

inlinestaticinherited

This function expects a string list of all existing columns, and a criteria list of values to search for. It will return a Where clause, using the given values. It does not contain the WHERE keyword. It uses the long form, table.fieldname

Parameters

ATableName	the table that the where clause is generated for
ASearchCriteria

Returns

the Where Clause

GetParametersForDeleteClause()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForDeleteClause ( short  ATableId, DataRow  ADataRow, int[]  APrimaryKeyColumnOrd  )

inlinestaticinherited

This function provides the actual parameters for the GenerateDeleteClause it uses the OriginalVersion of the primary key values

Parameters

ATableId
ADataRow	values that are used as parameters
APrimaryKeyColumnOrd	has the order numbers of the columns that make up the primary key

Returns

an array of OdbcParameters

GetParametersForInsertClause()

static List< OdbcParameter > Ict.Common.Data.TTypedDataAccess.GetParametersForInsertClause ( short  ATableId, ref DataRow  ADataRow, Int32  ANumberDBColumns, String  ACurrentUser, bool  AIncludeDefaultColumns  )

inlinestaticinherited

This function provides the actual parameters for the GenerateInsertClause uses only the values that are not DBNULL adds the next modification ID

Parameters

ATableId
ADataRow	values that are used as parameters
ANumberDBColumns	the number of columns of this row that should be stored in the database; that allows some columns to be added temporarily, e.g. PPartnerLocation.BestAddress in PartnerEdit Dataset
ACurrentUser	for setting modified by
AIncludeDefaultColumns	only useful when saving many rows in one query

Returns

an array of OdbcParameters

GetParametersForUpdateClause()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForUpdateClause ( short  ATableId, ref DataRow  ADataRow, int[]  APrimaryKeyColumnOrd, Int32  ANumberDBColumns, String  ACurrentUser  )

inlinestaticinherited

This function provides the actual parameters for the GenerateUpdateClause uses only the values that are changed (comparing the current and the original version of the row)

Parameters

ATableId
ADataRow	values that are used as parameters
APrimaryKeyColumnOrd	can be empty; is needed for the UPDATE WHERE statement; it has the order numbers of the columns that make up the primary key
ANumberDBColumns	the number of columns of this row that should be stored in the database; that allows some columns to be added temporarily, e.g. PPartnerLocation.BestAddress in PartnerEdit Dataset
ACurrentUser	for setting modified by

Returns

an array of OdbcParameters

GetParametersForWhereClause() [1/2]

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClause ( short  ATableId, DataRow  ADataRow  )

inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL

Returns

an array of OdbcParameters

GetParametersForWhereClause() [2/2]

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClause ( short  ATableNumber, TSearchCriteria[]  ASearchCriteria  )

inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause

Returns

an array of OdbcParameters

GetParametersForWhereClauseWithPrimaryKey()

static OdbcParameter[] Ict.Common.Data.TTypedDataAccess.GetParametersForWhereClauseWithPrimaryKey ( short  ATableId, DataRow  ADataRow  )

inlinestaticinherited

This function provides the actual parameters for the GenerateWhereClause uses only the values that are not DBNULL

Parameters

ADataRow	values that are used as parameters
ATableId	identifier of the table to get the primary key from it

Returns

an array of OdbcParameters

GetSafeValue() [1/2]

static System.Object Ict.Common.Data.TTypedDataAccess.GetSafeValue ( DataRow  ADataRow, String  AColumnName, DataRowVersion  AVersion  )

inlinestaticinherited

This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc.

Returns

either a valid object or System.DBNull

GetSafeValue() [2/2]

static System.Object Ict.Common.Data.TTypedDataAccess.GetSafeValue ( DataRow  ADataRow, System.Int32  AColumnNr, DataRowVersion  AVersion  )

inlinestaticinherited

This function returns either a valid object or System.DBNull; this is necessary because mono sometimes has a nil pointer in the DataRow for the original version etc.

Returns

either a valid object or System.DBNull

GetStoredModification()

static void Ict.Common.Data.TTypedDataAccess.GetStoredModification ( short  ATableId, string[]  AColumnNames, int[]  APrimKeyColumnOrdList, DataRow  ADataRow, DB.TDBTransaction  ATransaction, out DateTime  AModificationID, out String  AModifiedBy, out System.DateTime  AModifiedDate, bool  ATreatRowAsAdded = false  )

inlinestaticinherited

This function returns the modification details of a row

Returns

void

InsertRow() [1/2]

static void Ict.Common.Data.TTypedDataAccess.InsertRow ( short  ATableId, ref DataRow  ADataRow, String  ACurrentUser, StringBuilder  AInsertStatement, List< OdbcParameter >  AInsertParameters  )

inlinestaticinherited

This function is called by the DataStore (SubmitChanges). it will not update the modification id.

InsertRow() [2/2]

static void Ict.Common.Data.TTypedDataAccess.InsertRow ( short  ATableId, ref DataRow  ADataRow, TDBTransaction  ATransaction, String  ACurrentUser, bool  ATreatRowAsAdded  )

inlinestaticinherited

This function is called by the DataStore (SubmitChanges). it will update the modification id.

LoadAll() [1/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadAll ( DataSet  AData, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadAll() [2/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadAll ( DataSet  AData, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadAll() [3/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadAll ( DataSet  ADataSet, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

this method is called by all overloads

LoadAll() [4/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadAll ( StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadAll() [5/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadAll ( StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadAll() [6/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadAll ( TDBTransaction  ATransaction )

inlinestatic

auto generated

LoadByPrimaryKey() [1/8]

static PcAttendeeRow Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadByPrimaryKey ( DataSet  AData, Int64  AConferenceKey, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadByPrimaryKey() [2/8]

static PcAttendeeRow Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadByPrimaryKey ( DataSet  AData, Int64  AConferenceKey, Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadByPrimaryKey() [3/8]

static PcAttendeeRow Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadByPrimaryKey ( DataSet  ADataSet, Int64  AConferenceKey, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

this method is called by all overloads

LoadByPrimaryKey() [4/8]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadByPrimaryKey ( Int64  AConferenceKey, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadByPrimaryKey() [5/8]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadByPrimaryKey ( Int64  AConferenceKey, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadByPrimaryKey() [6/8]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadByPrimaryKey ( Int64  AConferenceKey, Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadByPrimaryKey() [7/8]

static DataRow Ict.Common.Data.TTypedDataAccess.LoadByPrimaryKey ( short  ATableId, DataSet  ADataSet, System.Object[]  APrimaryKeyValues, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

load data row by primary key into a dataset

Parameters

ATableId
ADataSet
APrimaryKeyValues
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

LoadByPrimaryKey() [8/8]

static DataRow Ict.Common.Data.TTypedDataAccess.LoadByPrimaryKey ( short  ATableId, TTypedDataTable  ADataTable, System.Object[]  APrimaryKeyValues, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

different version for data table

LoadByUniqueKey() [1/2]

static void Ict.Common.Data.TTypedDataAccess.LoadByUniqueKey ( short  ATableId, DataSet  ADataSet, System.Object[]  AUniqueKeyValues, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

load data row by unique key into a dataset

Parameters

ATableId
ADataSet
AUniqueKeyValues
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

LoadByUniqueKey() [2/2]

static void Ict.Common.Data.TTypedDataAccess.LoadByUniqueKey ( short  ATableId, TTypedDataTable  ADataTable, System.Object[]  AUniqueKeyValues, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

different version for data table

LoadUsingTemplate() [1/17]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( DataSet  AData, PcAttendeeRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [2/17]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( DataSet  AData, PcAttendeeRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [3/17]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [4/17]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [5/17]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( DataSet  ADataSet, PcAttendeeRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

this method is called by all overloads

LoadUsingTemplate() [6/17]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( DataSet  ADataSet, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

this method is called by all overloads

LoadUsingTemplate() [7/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( PcAttendeeRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [8/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( PcAttendeeRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [9/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( PcAttendeeRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadUsingTemplate() [10/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( PcAttendeeRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [11/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableId, DataSet  ADataSet, DataRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

load using a template row

LoadUsingTemplate() [12/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableID, DataSet  ADataSet, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

loads all rows matching certain search criteria into a dataset

Parameters

ATableID	specify which typed table is used
ADataSet	the result will be added to this dataset
ASearchCriteria
AFieldList	fields to load from the database table
ATransaction
AOrderBy
AStartRecord
AMaxRecords

LoadUsingTemplate() [13/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableId, TTypedDataTable  ADataTable, DataRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

load using a template row

LoadUsingTemplate() [14/17]

static void Ict.Common.Data.TTypedDataAccess.LoadUsingTemplate ( short  ATableID, TTypedDataTable  ATypedTableToLoad, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

loads all rows matching certain search criteria into a typed data table

Parameters

ATableID	specify which typed table is used
ATypedTableToLoad	pre condition: has to have an object of the typed table
ASearchCriteria
AFieldList
ATransaction
AOrderBy
AStartRecord
AMaxRecords

LoadUsingTemplate() [15/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadUsingTemplate() [16/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadUsingTemplate() [17/17]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadUsingTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaForeignKey() [1/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId, short  AOtherTableId, DataSet  ADataSet, string[]  AThisFieldNames, DataRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

Load via other table, using template values.

LoadViaForeignKey() [2/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId, short  AOtherTableId, DataSet  ADataSet, string[]  AThisFieldNames, System.Object[]  AForeignKeyValues, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

load data for the current table via a foreign key, eg. load all extracts created by user x

LoadViaForeignKey() [3/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId, short  AOtherTableId, DataSet  ADataSet, string[]  AThisFieldNames, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

Load via other table, using template values.

LoadViaForeignKey() [4/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId, short  AOtherTableId, TTypedDataTable  ADataTable, string[]  AThisFieldNames, DataRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

Load via other table, using template values.

LoadViaForeignKey() [5/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId, short  AOtherTableId, TTypedDataTable  ADataTable, string[]  AThisFieldNames, System.Object[]  AForeignKeyValues, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

load data for the current table via a foreign key, eg. load all extracts created by user x

LoadViaForeignKey() [6/6]

static void Ict.Common.Data.TTypedDataAccess.LoadViaForeignKey ( short  ATableId, short  AOtherTableId, TTypedDataTable  ADataTable, string[]  AThisFieldNames, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestaticinherited

Load via other table, using template values.

LoadViaPcConference() [1/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConference ( DataSet  AData, Int64  AConferenceKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConference() [2/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConference ( DataSet  AData, Int64  AConferenceKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConference() [3/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConference ( DataSet  ADataSet, Int64  AConferenceKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPcConference() [4/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConference ( Int64  AConferenceKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConference() [5/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConference ( Int64  AConferenceKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPcConference() [6/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConference ( Int64  AConferenceKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [1/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( DataSet  AData, PcConferenceRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [2/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( DataSet  AData, PcConferenceRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [3/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [4/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [5/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( DataSet  ADataSet, PcConferenceRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [6/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( DataSet  ADataSet, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [7/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( PcConferenceRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [8/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( PcConferenceRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [9/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( PcConferenceRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [10/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( PcConferenceRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [11/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [12/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPcConferenceTemplate() [13/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPcConferenceTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPerson() [1/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPerson ( DataSet  AData, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPerson() [2/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPerson ( DataSet  AData, Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPerson() [3/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPerson ( DataSet  ADataSet, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPPerson() [4/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPerson ( Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPerson() [5/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPerson ( Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPPerson() [6/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPerson ( Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [1/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( DataSet  AData, PPersonRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [2/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( DataSet  AData, PPersonRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [3/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [4/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [5/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( DataSet  ADataSet, PPersonRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [6/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( DataSet  ADataSet, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [7/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( PPersonRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [8/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( PPersonRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [9/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( PPersonRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [10/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( PPersonRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [11/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [12/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPPersonTemplate() [13/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPPersonTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnit() [1/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnit ( DataSet  AData, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnit() [2/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnit ( DataSet  AData, Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnit() [3/6]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnit ( DataSet  ADataSet, Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPUnit() [4/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnit ( Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnit() [5/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnit ( Int64  APartnerKey, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPUnit() [6/6]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnit ( Int64  APartnerKey, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [1/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( DataSet  AData, PUnitRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [2/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( DataSet  AData, PUnitRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [3/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [4/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( DataSet  AData, TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [5/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( DataSet  ADataSet, PUnitRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [6/13]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( DataSet  ADataSet, TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [7/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( PUnitRow  ATemplateRow, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [8/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( PUnitRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [9/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( PUnitRow  ATemplateRow, StringCollection  ATemplateOperators, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [10/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( PUnitRow  ATemplateRow, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [11/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [12/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( TSearchCriteria[]  ASearchCriteria, StringCollection  AFieldList, TDBTransaction  ATransaction, StringCollection  AOrderBy, int  AStartRecord, int  AMaxRecords  )

inlinestatic

auto generated

LoadViaPUnitTemplate() [13/13]

static PcAttendeeTable Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.LoadViaPUnitTemplate ( TSearchCriteria[]  ASearchCriteria, TDBTransaction  ATransaction  )

inlinestatic

auto generated

NoDefaultColumn()

static bool Ict.Common.Data.TTypedDataAccess.NoDefaultColumn ( String  AColumnName )

inlinestaticinherited

This function returns true if the column name is not one of the special columns, that are written automatically: modified date and by, created date and by, modification id

Returns

true if this is no special auto column

NotEquals()

static bool Ict.Common.Data.TTypedDataAccess.NotEquals ( DataRow  ADataRow, System.Int32  AColumnNr, ref System.Object  ACurrentValue  )

inlinestaticinherited

Compare the original and the current value of a column in a datarow. Make sure some mono specific troubles are worked around.

Returns

result of comparison

SubmitChanges() [1/5]

static void Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.SubmitChanges ( PcAttendeeTable  ATable, TDBTransaction  ATransaction  )

inlinestatic

Auto generated code ...

Parameters

ATable
ATransaction

SubmitChanges() [2/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable, TDBTransaction  ATransaction, eSubmitChangesOperations  ASelectedOperations, string  AUserId  )

inlinestaticinherited

overloaded version without sequence, but with ASelectedOperations

SubmitChanges() [3/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable, TDBTransaction  ATransaction, eSubmitChangesOperations  ASelectedOperations, string  AUserId, string  ASequenceName, string  ASequenceField  )

inlinestaticinherited

submit those rows in the table that have been modified or created or deleted

Parameters

ATable
ATransaction
ASelectedOperations
AUserId	the current user, for auditing
ASequenceName
ASequenceField

Returns

SubmitChanges() [4/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable, TDBTransaction  ATransaction, string  AUserId  )

inlinestaticinherited

overloaded version without sequence

SubmitChanges() [5/5]

static void Ict.Common.Data.TTypedDataAccess.SubmitChanges ( TTypedDataTable  ATable, TDBTransaction  ATransaction, string  AUserId, string  ASequenceName, string  ASequenceField  )

inlinestaticinherited

overloaded version without ASelectedOperations

UpdateRow()

static void Ict.Common.Data.TTypedDataAccess.UpdateRow ( short  ATableId, bool  AThrowAwayAfterSubmitChanges, ref DataRow  ADataRow, DB.TDBTransaction  ATransaction, String  ACurrentUser  )

inlinestaticinherited

This function is called by the DataStore (SubmitChanges)

Returns

void

Member Data Documentation

CREATED_BY

const string Ict.Common.Data.TTypedDataAccess.CREATED_BY = "s_created_by_c"

staticinherited

who has originally created this row

CREATED_DATE

const string Ict.Common.Data.TTypedDataAccess.CREATED_DATE = "s_date_created_d"

staticinherited

when was this row originally created

DATATABLENAME

const string Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.DATATABLENAME = "PcAttendee"

static

CamelCase version of table name.

DBTABLENAME

const string Ict.Petra.Server.MConference.Data.Access.PcAttendeeAccess.DBTABLENAME = "pc_attendee"

static

original table name in database

MODIFICATION_ID

const string Ict.Common.Data.TTypedDataAccess.MODIFICATION_ID = "s_modification_id_t"

staticinherited

name of the column used for tracking changes, one ID per change

MODIFICATION_ID_DELETEDROW_INDICATOR

readonly DateTime Ict.Common.Data.TTypedDataAccess.MODIFICATION_ID_DELETEDROW_INDICATOR = DateTime.MaxValue

staticinherited

indicates whether a row has been deleted

MODIFIED_BY

const string Ict.Common.Data.TTypedDataAccess.MODIFIED_BY = "s_modified_by_c"

staticinherited

who has last modified the row

MODIFIED_DATE

const string Ict.Common.Data.TTypedDataAccess.MODIFIED_DATE = "s_date_modified_d"

staticinherited

when was the last change to the row

---

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

• csharp/ICT/Petra/Server/lib/data/Conference.Access-generated.cs