public static bool TrainBankStatement(Int32 ALedgerNumber, DateTime ADateOfStatement, string ABankAccountCode)
{
// get the statement keys
TDBTransaction ReadTransaction = DBAccess.GDBAccessObj.BeginTransaction(IsolationLevel.ReadCommitted);
AEpStatementTable Statements = new AEpStatementTable();
AEpStatementRow row = Statements.NewRowTyped(false);
row.LedgerNumber = ALedgerNumber;
row.Date = ADateOfStatement;
row.BankAccountCode = ABankAccountCode;
Statements = AEpStatementAccess.LoadUsingTemplate(row, ReadTransaction);
DBAccess.GDBAccessObj.RollbackTransaction();
if (Statements.Rows.Count == 0)
{
return(false);
}
// search for already posted gift batches, and do the matching for these imported statements
TBankImportMatching.Train(Statements);
return(true);
}
public static AEpStatementTable GetImportedBankStatements(Int32 ALedgerNumber, DateTime AStartDate)
{
TDBTransaction ReadTransaction = DBAccess.GDBAccessObj.BeginTransaction(IsolationLevel.ReadCommitted);
AEpStatementTable localTable = new AEpStatementTable();
AEpStatementRow row = localTable.NewRowTyped(false);
row.LedgerNumber = ALedgerNumber;
row.Date = AStartDate;
StringCollection operators = new StringCollection();
operators.Add("=");
operators.Add(">=");
localTable = AEpStatementAccess.LoadUsingTemplate(row, operators, null, ReadTransaction);
DBAccess.GDBAccessObj.RollbackTransaction();
return(localTable);
}
public static bool TrainBankStatement(Int32 ALedgerNumber, DateTime ADateOfStatement, string ABankAccountCode)
{
// get the statement keys
TDBTransaction ReadTransaction = DBAccess.GDBAccessObj.BeginTransaction(IsolationLevel.ReadCommitted);
AEpStatementTable Statements = new AEpStatementTable();
AEpStatementRow row = Statements.NewRowTyped(false);
row.LedgerNumber = ALedgerNumber;
row.Date = ADateOfStatement;
row.BankAccountCode = ABankAccountCode;
Statements = AEpStatementAccess.LoadUsingTemplate(row, ReadTransaction);
DBAccess.GDBAccessObj.RollbackTransaction();
if (Statements.Rows.Count == 0)
{
return false;
}
// search for already posted gift batches, and do the matching for these imported statements
TBankImportMatching.Train(Statements);
return true;
}
public static AEpStatementTable GetImportedBankStatements(Int32 ALedgerNumber, DateTime AStartDate)
{
TDBTransaction ReadTransaction = DBAccess.GDBAccessObj.BeginTransaction(IsolationLevel.ReadCommitted);
AEpStatementTable localTable = new AEpStatementTable();
AEpStatementRow row = localTable.NewRowTyped(false);
row.LedgerNumber = ALedgerNumber;
row.Date = AStartDate;
StringCollection operators = new StringCollection();
operators.Add("=");
operators.Add(">=");
localTable = AEpStatementAccess.LoadUsingTemplate(row, operators, null, ReadTransaction);
DBAccess.GDBAccessObj.RollbackTransaction();
return localTable;
}
