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);
}
public FinancialAccountRows GetRowsFar(DateTime start, DateTime end) // selects lowerbound < x <= upperbound
{
BasicFinancialAccountRow[] basicRows = SwarmDb.GetDatabaseForReading()
.GetFinancialAccountRows(Identity, start, end, true);
return(FinancialAccountRows.FromArray(basicRows));
}
public FinancialAccountRows GetRows(DateTime start, DateTime end)
{
BasicFinancialAccountRow[] basicRows = SwarmDb.GetDatabaseForReading()
.GetFinancialAccountRows(Identity, start, end, false);
return(FinancialAccountRows.FromArray(basicRows));
}
public FinancialAccountRows GetLastRows(int rowCount)
{
BasicFinancialAccountRow[] basicRows = SwarmDb.GetDatabaseForReading()
.GetLastFinancialAccountRows(Identity, rowCount);
return(FinancialAccountRows.FromArray(basicRows));
}