// /// <summary>
// /// Test that the valid posting period code works
// /// </summary>
// [Test]
// public void TestIsValidPostingPeriod()
// {
// int DateEffectivePeriodNumber;
// int DateEffectiveYearNumber;
//
// bool NewTransaction = false;
//
// TDBTransaction Transaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.ReadCommitted, out NewTransaction);
//
// Assert.IsTrue(TFinancialYear.IsValidPostingPeriod(FLedgerNumber, Convert.ToDateTime("15-Sep-2011"), out DateEffectivePeriodNumber, out DateEffectiveYearNumber, Transaction),"Period is not valid");
//
// if (NewTransaction)
// {
// DBAccess.GDBAccessObj.RollbackTransaction();
// }
// }
/// <summary>
/// this function will import admin fees if there are no admin fees in the database yet
/// </summary>
private void ImportAdminFees()
{
AFeesPayableTable FeesPayableTable = null;
AFeesReceivableTable FeesReceivableTable = null;
TDBTransaction Transaction = null;
DBAccess.GDBAccessObj.GetNewOrExistingAutoReadTransaction(IsolationLevel.ReadCommitted, ref Transaction,
delegate
{
AFeesPayableRow template = new AFeesPayableTable().NewRowTyped(false);
template.LedgerNumber = FLedgerNumber;
template.FeeCode = MainFeesPayableCode;
FeesPayableTable = AFeesPayableAccess.LoadUsingTemplate(template, Transaction);
AFeesReceivableRow template1 = new AFeesReceivableTable().NewRowTyped(false);
template1.LedgerNumber = FLedgerNumber;
template1.FeeCode = MainFeesReceivableCode;
FeesReceivableTable = AFeesReceivableAccess.LoadUsingTemplate(template1, Transaction);
});
if (FeesPayableTable.Count == 0)
{
CommonNUnitFunctions.LoadTestDataBase("csharp\\ICT\\Testing\\lib\\MFinance\\GL\\" +
"test-sql\\gl-test-feespayable-data.sql", FLedgerNumber);
}
if (FeesReceivableTable.Count == 0)
{
CommonNUnitFunctions.LoadTestDataBase("csharp\\ICT\\Testing\\lib\\MFinance\\GL\\" +
"test-sql\\gl-test-feesreceivable-data.sql", FLedgerNumber);
}
}
public void TestProcessAdminFees()
{
bool NewTransaction = false;
TDBTransaction Transaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.ReadCommitted, out NewTransaction);
TVerificationResultCollection VerficationResults = null;
AFeesPayableTable FeesPayableTable = null;
AFeesReceivableTable FeesReceivableTable = null;
try
{
AFeesPayableRow template = new AFeesPayableTable().NewRowTyped(false);
template.LedgerNumber = FLedgerNumber;
template.FeeCode = MainFeesPayableCode;
FeesPayableTable = AFeesPayableAccess.LoadUsingTemplate(template, Transaction);
AFeesReceivableRow template1 = new AFeesReceivableTable().NewRowTyped(false);
template1.LedgerNumber = FLedgerNumber;
template1.FeeCode = MainFeesReceivableCode;
FeesReceivableTable = AFeesReceivableAccess.LoadUsingTemplate(template1, Transaction);
}
catch (Exception)
{
throw;
}
finally
{
if (NewTransaction)
{
DBAccess.GDBAccessObj.RollbackTransaction();
}
}
if (FeesPayableTable.Count == 0)
{
CommonNUnitFunctions.LoadTestDataBase("csharp\\ICT\\Testing\\lib\\MFinance\\GL\\" +
"test-sql\\gl-test-feespayable-data.sql", FLedgerNumber);
}
if (FeesReceivableTable.Count == 0)
{
CommonNUnitFunctions.LoadTestDataBase("csharp\\ICT\\Testing\\lib\\MFinance\\GL\\" +
"test-sql\\gl-test-feesreceivable-data.sql", FLedgerNumber);
}
GiftBatchTDS MainDS = new GiftBatchTDS();
//Reset
NewTransaction = false;
Transaction = DBAccess.GDBAccessObj.GetNewOrExistingTransaction(IsolationLevel.Serializable, out NewTransaction);
try
{
AFeesPayableAccess.LoadViaALedger(MainDS, FLedgerNumber, Transaction);
AFeesReceivableAccess.LoadViaALedger(MainDS, FLedgerNumber, Transaction);
}
catch (Exception)
{
throw;
}
finally
{
if (NewTransaction)
{
DBAccess.GDBAccessObj.RollbackTransaction();
}
}
//TODO If this first one works, try different permatations for Assert.AreEqual
// Test also for exception handling
Assert.AreEqual(12m, TGiftTransactionWebConnector.CalculateAdminFee(MainDS,
FLedgerNumber,
MainFeesPayableCode,
100m,
out VerficationResults), "admin fee fixed 12% of 100 expect 12");
}