private static FinancialAccountRows RowsNotInVatReport(FinancialAccount account, DateTime endDateTime)
{
Organization organization = account.Organization;
SwarmDb dbRead = SwarmDb.GetDatabaseForReading();
FinancialAccountRows rowsIntermediate =
FinancialAccountRows.FromArray(
SwarmDb.GetDatabaseForReading().GetAccountRowsNotInVatReport(account.Identity, endDateTime));
FinancialAccountRows rowsFinal = new FinancialAccountRows();
foreach (FinancialAccountRow row in rowsIntermediate)
{
// Check if this row _closes_ an _existing_ VAT report, in which case it should _not_ be included
int vatReportOpenId = dbRead.GetVatReportIdFromCloseTransaction(row.FinancialTransactionId);
int vatReportCloseId = dbRead.GetVatReportIdFromOpenTransaction(row.FinancialTransactionId);
if (vatReportOpenId == 0 && vatReportCloseId == 0)
{
// This particular transaction doesn't close an existing VAT report
rowsFinal.Add(row);
}
}
return(rowsFinal);
}
