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();
}
}
private void FillVerification(Verification verification)
{
var accountTransactions = AccountTransactions.Where(t => t.VerificationNo == verification.No).ToList();
var cashbookTransactions = CashBookTransactions.Where(t => t.VerificationNo == verification.No).ToList();
var accountTransactionCollection = new AccountTransactionCollection();
foreach (var accountTransaction in accountTransactions)
{
accountTransactionCollection.Add(accountTransaction);
}
var cashbookTransactionCollection = new CashBookTransactionCollection();
foreach (var cashbookTransaction in cashbookTransactions)
{
cashbookTransactionCollection.Add(cashbookTransaction);
}
verification.AccountTransactions = accountTransactionCollection;
verification.CashBookTransactions = cashbookTransactionCollection;
}
private void createCashBookItemToolStripMenuItem_Click(object sender, EventArgs e)
{
int transactionNo = (int)transactionsDataGridView.SelectedRows[0].Cells[AccountTransaction.fNo].Value;
int verificationNo = (int)transactionsDataGridView.SelectedRows[0].Cells[AccountTransaction.fVerificationNo].Value;
CashBookTransactionForm form = new CashBookTransactionForm(DataCache, MainForm.Guesser, verificationNo: verificationNo);
using (var core = new StandardBusinessLayer(DataCache)) {
core.Connect();
//AccountTransaction accountTransaction = core.GetAccountTransaction(transactionNo);
AccountTransaction accountTransaction = DataCache.GetAccountTransaction(transactionNo);
if (accountTransaction != null)
{
CashBookTransactionCollection cashBookTransactions = core.GetCashBookTransactionsByVerificationNo(verificationNo);
AccountTransactionCollection accountTransactions = core.GetAccountTransactionsByVerificationNo(verificationNo);
decimal sum = accountTransactions.Sum(t => t.Amount) - cashBookTransactions.Sum(t => t.Amount);
form.Amount = sum;
}
}
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
using (var core = new StandardBusinessLayer(DataCache)) {
core.Connect();
core.AddCashBookTransaction(form.VerificationNo, form.VerificationDate, form.AccountingDate, form.UserNo,
form.CategoryNo, form.Amount, form.Note);
}
LoadTransactionGrid();
SelectGridTransaction(transactionNo);
}
}
