private void menuNew_Click(object sender, System.EventArgs e)
{
Account rec = new Account();
AccountProperties dlg = new AccountProperties(rec);
if(DialogResult.OK == dlg.ShowDialog(this))
{
rec.Store(m_dbConnection);
m_accountRecs[rec.AccountNumber] = rec;
CheckRegister registerRec = new CheckRegister();
registerRec.AccountId = rec.Id;
registerRec.TransDate = DateTime.Now;
registerRec.TransType = "Archive";
registerRec.Amount = 0;
registerRec.TransCategory = "credit";
registerRec.Description = "account created";
registerRec.Cleared = 1;
registerRec.Store(m_dbConnection);
TreeNode accountNode = treeManagement.Nodes.Add(rec.AccountName);
accountNode.Tag = rec.AccountNumber;
TreeNode node = accountNode.Nodes.Add("Registry");
node.Tag = "registry";
node = accountNode.Nodes.Add("Reconcile");
node.Tag = "reconcile";
node = accountNode.Nodes.Add("Archived");
node.Tag = "archived";
}
}
public bool LoadCheckRegistry(string accountId, bool archived)
{
SaveRecord();
m_accountId = accountId;
m_archived = archived;
btnNew.Enabled = !m_archived;
UpdateBalances();
textDate.Text = "";
comboType.SelectedIndex = -1;
textCheckNumber.Text = "";
comboDescription.Text = "";
comboDescription.SelectedIndex = -1;
comboDescription.Items.Clear();
textAmount.Text = "";
checkCleared.Checked = false;
checkArchived.Checked = false;
textComments.Text = "";
string sql = string.Format("select description from vendor_names where account_id = '{0}'", accountId);
OleDbCommand selectCmd = new OleDbCommand(sql, m_dbConnection);
OleDbDataReader dataReader = selectCmd.ExecuteReader();
while(dataReader.Read())
{
comboDescription.Items.Add(dataReader[0].ToString());
}
dataReader.Close();
listTransactions.Items.Clear();
string archivedOperator = m_archived ? "=" : "<>";
sql = string.Format("select * from check_register where account_id = '{0}' and archived {1} 1 order by trans_date", accountId, archivedOperator);
selectCmd = new OleDbCommand(sql, m_dbConnection);
dataReader = selectCmd.ExecuteReader();
ListViewItem item = null;
while(dataReader.Read())
{
CheckRegister rec = new CheckRegister();
rec.Load(dataReader);
item = new ListViewItem();
item.Tag = rec;
rec.Tag = item;
if("Check" == rec.TransType)
{
item.Text = rec.CheckNumber;
}
else
{
item.Text = rec.TransType;
}
item.SubItems.Add(rec.Description);
item.SubItems.Add(rec.TransDate.ToShortDateString());
if("credit" == rec.TransCategory)
{
item.SubItems.Add(rec.Amount.ToString("C"));
}
else
{
item.SubItems.Add(string.Format("<{0:C}>", rec.Amount));
}
item.SubItems.Add((1 == rec.Cleared) ? "Yes" : "");
listTransactions.Items.Add(item);
}
dataReader.Close();
if(null != item)
{
item.Selected = true;
}
return true;
}
private void btnNew_Click(object sender, System.EventArgs e)
{
ListViewItem item = new ListViewItem();
item.SubItems.Add("");
item.SubItems.Add("");
item.SubItems.Add("");
item.SubItems.Add("");
CheckRegister rec = new CheckRegister();
rec.AccountId = m_accountId;
item.Tag = rec;
rec.Tag = item;
listTransactions.Items.Add(item);
item.Selected = true;
textDate.Focus();
}
public bool LoadCheckReconcile(string accountId)
{
SaveRecord();
m_registerRecs.Clear();
textDate.Text = "";
comboType.SelectedIndex = -1;
textCheckNumber.Text = "";
comboDescription.Text = "";
comboDescription.SelectedIndex = -1;
comboDescription.Items.Clear();
textAmount.Text = "";
checkCleared.Checked = false;
checkArchived.Checked = false;
m_accountId = accountId;
string sql = string.Format("select description from vendor_names where account_id = '{0}'", accountId);
OleDbCommand selectCmd = new OleDbCommand(sql, m_dbConnection);
OleDbDataReader dataReader = selectCmd.ExecuteReader();
while(dataReader.Read())
{
comboDescription.Items.Add(dataReader[0].ToString());
}
dataReader.Close();
sql = string.Format("select * from check_register where account_id = '{0}' and cleared = 0 order by trans_date", accountId);
selectCmd = new OleDbCommand(sql, m_dbConnection);
dataReader = selectCmd.ExecuteReader();
while(dataReader.Read())
{
CheckRegister rec = new CheckRegister();
rec.Load(dataReader);
m_registerRecs.Add(rec);
}
dataReader.Close();
sql = string.Format("select * from bank_transactions where account_id = '{0}' and check_register_id is null", accountId);
selectCmd = new OleDbCommand(sql, m_dbConnection);
dataReader = selectCmd.ExecuteReader();
listTransactions.Items.Clear();
while(dataReader.Read())
{
BankTransaction tran = new BankTransaction();
tran.Load(dataReader);
ListViewItem item = new ListViewItem();
item.Tag = tran;
tran.Tag = item;
item.Text = tran.TransType;
item.SubItems.Add(tran.CheckNumber);
if("" == tran.TransName)
{
item.SubItems.Add(tran.Description);
}
else
{
item.SubItems.Add(string.Format("{0} - {1}", tran.TransName, tran.Description));
}
item.SubItems.Add(tran.TransDate.ToShortDateString());
item.SubItems.Add(tran.TransAmount.ToString("C"));
listTransactions.Items.Add(item);
}
dataReader.Close();
UpdateBalances();
if(m_registerRecs.Count > 0)
{
CheckRegister rec = (CheckRegister)m_registerRecs[0];
DisplayRegisterRec(rec);
}
return true;
}
private bool DisplayRegisterRec(CheckRegister rec)
{
SaveRecord();
Tag = rec;
textDate.Text = rec.TransDateString;
comboType.SelectedIndex = comboType.FindStringExact(rec.TransType);
textCheckNumber.Text = rec.CheckNumber;
comboDescription.Text = rec.Description;
textAmount.Text = rec.Amount.ToString();
checkCleared.Checked = (1 == rec.Cleared);
checkArchived.Checked = (1 == rec.Archived);
int index = m_registerRecs.IndexOf(rec);
index++;
m_statusBar.Panels[0].Text = string.Format("Record {0} of {1}", index, m_registerRecs.Count);
FindMatches();
return true;
}
private void btnNew_Click(object sender, System.EventArgs e)
{
CheckRegister rec = new CheckRegister();
rec.AccountId = m_accountId;
DisplayRegisterRec(rec);
textDate.Focus();
m_registerRecs.Add(rec);
}
