private DataTable GetCostCentresLinkedToPartnerListTable(TDBTransaction AReadTransaction, System.Int32 ALedgerNumber, string ATableName)
{
DataTable CostCentreTable;
CostCentreTable = TCostCentresLinkedToPartner.GetData(ATableName, ALedgerNumber, AReadTransaction);
CostCentreTable.PrimaryKey = new DataColumn[] {
CostCentreTable.Columns[AValidLedgerNumberTable.GetLedgerNumberDBName()],
CostCentreTable.Columns[AValidLedgerNumberTable.GetCostCentreCodeDBName()],
CostCentreTable.Columns[AValidLedgerNumberTable.GetPartnerKeyDBName()]
};
return(CostCentreTable);
}
/// <summary>
/// check if the partner has a link to a cost centre (eg. a worker)
/// </summary>
/// <param name="APartnerKey"></param>
/// <param name="ACostCentreCode"></param>
/// <returns></returns>
public static Boolean HasPartnerCostCentreLink(Int64 APartnerKey, out String ACostCentreCode)
{
Boolean ReturnValue;
TDBTransaction ReadTransaction;
Boolean NewTransaction;
StringCollection RequiredColumns;
AValidLedgerNumberTable ValidLedgerNumberTable;
ACostCentreCode = "";
RequiredColumns = new StringCollection();
RequiredColumns.Add(AValidLedgerNumberTable.GetCostCentreCodeDBName());
TDataBase db = DBAccess.Connect("HasPartnerCostCentreLink");
ReadTransaction = db.GetNewOrExistingTransaction(IsolationLevel.ReadCommitted,
out NewTransaction);
try
{
ValidLedgerNumberTable = AValidLedgerNumberAccess.LoadViaPPartnerPartnerKey(
APartnerKey,
RequiredColumns,
ReadTransaction,
null,
0,
0);
if (ValidLedgerNumberTable.Rows.Count != 0)
{
ACostCentreCode = ValidLedgerNumberTable[0].CostCentreCode;
ReturnValue = true;
}
else
{
ReturnValue = false;
}
}
finally
{
if (NewTransaction)
{
ReadTransaction.Commit();
TLogging.LogAtLevel(7, "HasPartnerCostCentreLink: committed own transaction.");
}
}
return(ReturnValue);
}
/// <summary>
/// Loads all costcentres that are linked to a partner, with the partner key and partner class
/// </summary>
public static DataTable GetData(String ATableName, Int32 ALedgerNumber, TDBTransaction AReadTransaction)
{
return(DBAccess.GDBAccessObj.SelectDT(
String.Format(
"SELECT {0}, {3}.{1}, {3}.{5}, {2}, {8} FROM pub_{3} " +
"LEFT OUTER JOIN PUB_{7} ON PUB_{7}.{1} = PUB_{3}.{1}, pub_{4} " +
"WHERE pub_{3}.{1} = pub_{4}.{1} AND pub_{3}.{5} = {6}",
AValidLedgerNumberTable.GetCostCentreCodeDBName(),
AValidLedgerNumberTable.GetPartnerKeyDBName(),
PPartnerTable.GetPartnerClassDBName(),
AValidLedgerNumberTable.GetTableDBName(),
PPartnerTable.GetTableDBName(),
AValidLedgerNumberTable.GetLedgerNumberDBName(),
ALedgerNumber.ToString(),
PUnitTable.GetTableDBName(),
PUnitTable.GetUnitTypeCodeDBName()),
ATableName,
AReadTransaction));
}