private void transactionsDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
int no = (int)transactionsDataGridView.Rows[e.RowIndex].Cells[CashBookTransaction.fNo].Value;
int userNo = (int)transactionsDataGridView.Rows[e.RowIndex].Cells[CashBookTransaction.fUserNo].Value;
int categoryNo = (int)transactionsDataGridView.Rows[e.RowIndex].Cells[CashBookTransaction.fCategoryNo].Value;
int verificationNo = (int)transactionsDataGridView.Rows[e.RowIndex].Cells[CashBookTransaction.fVerificationNo].Value;
var form = new CashBookTransactionForm(DataCache, MainForm.Guesser, no, verificationNo);
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
CashBookTransaction transaction;
using (var core = new StandardBusinessLayer(DataCache))
{
core.Connect();
transaction = core.UpdateCashBookTransaction(no, form.VerificationDate, form.AccountingDate, form.UserNo, form.CategoryNo, form.Amount, form.Note);
}
LoadTransactionGrid();
SelectGridTransaction(no);
ApplicationEvents.OnCashBookTransactionUpdated(no, transaction.VerificationNo);
}
}
}
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);
}
}
private void newCashBookItemButton_Click(object sender, EventArgs e)
{
CashBookTransactionForm form = new CashBookTransactionForm(DataCache, MainForm.Guesser);
using (var core = new StandardBusinessLayer(DataCache)) {
core.Connect();
int accountingYear = core.GetCashBoxSettings(CashBoxSettingsNo.CurrentApplicationNo).AccountingYear;
Verification verification = core.GetFirstUnbalancedVerification(accountingYear);
if (verification != null)
{
decimal sum = core.GetVerificationBalance(verification.No);
form.Amount = sum;
}
}
// Show dialog
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
CashBookTransaction transaction;
using (var core = new StandardBusinessLayer(DataCache)) {
core.Connect();
transaction = core.AddCashBookTransaction(form.VerificationNo, form.VerificationDate, form.AccountingDate, form.UserNo,
form.CategoryNo, form.Amount, form.Note);
}
LoadTransactionGrid();
SelectGridTransaction(transaction.No);
}
}
