private void Load()
{
using (StandardBusinessLayer core = new StandardBusinessLayer(DataCache))
{
core.Connect();
SortOrder byDate = new SortOrder(Verification.fDate, OrderDirection.Ascending);
_verifications = core.GetVerifications(byDate);
byDate = new SortOrder(AccountTransaction.fTransactionTime, OrderDirection.Ascending);
_accountTransactions = core.GetAccountTransactions();
byDate = new SortOrder(CashBookTransaction.fTransactionTime, OrderDirection.Ascending);
_cashBookTransactions = core.GetCashBookTransactions();
}
}
// public int[] GetUnbalancedVerificationNumbers()
// {
// string sql = @"
// select No
// from
// Verifications
// where
// (
// select isnull(sum(Amount), 0)
// from AccountTransactionsView
// where
//Year([TransactionTime]) = Verifications.Year and
//VerificationSerialNo = Verifications.SerialNo
// )
// -
// (
// select isnull(sum(Amount), 0)
// from CashBookTransactionsView
// where
//Year([TransactionTime]) = Verifications.Year and
//VerificationSerialNo = Verifications.SerialNo
// ) <> 0";
// DataTable dataTable = new DataTable();
// Connection.GetTable(dataTable, sql);
// return (from DataRow row in dataTable.Rows
// select (int)row["No"]).ToList().ToArray();
// }
public VerificationCollection GetUnbalancedAndEmptyVerifications(int accountingYear)
{
string sql = string.Format(@"
select *
from
Verifications
where
Year = {0} and
(
(
select isnull(sum(Amount), 0)
from AccountTransactionsView
where
Year([TransactionTime]) = Verifications.Year and
VerificationSerialNo = Verifications.SerialNo
)
-
(
select isnull(sum(Amount), 0)
from CashBookTransactionsView
where
Year([TransactionTime]) = Verifications.Year and
VerificationSerialNo = Verifications.SerialNo
) <> 0 or
(
select count(*)
from AccountTransactionsView
where
Year([TransactionTime]) = Verifications.Year and
VerificationSerialNo = Verifications.SerialNo
)
+
(
select count(*)
from CashBookTransactionsView
where
Year([TransactionTime]) = Verifications.Year and
VerificationSerialNo = Verifications.SerialNo
) = 0
)", accountingYear);
VerificationTable verificationTable = new VerificationTable();
Connection.GetTable(verificationTable, sql);
return(VerificationCollection.CreateVerificationCollection(verificationTable));
}
