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; }