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