private void LoadCheckbook()
{
treeManagement.Nodes.Clear();
TreeNode summaryNode = treeManagement.Nodes.Add("Accounts Summary");
summaryNode.Tag = "all_summary";
string sql = "select * from accounts order by account_name";
OleDbCommand selectCmd = new OleDbCommand(sql, m_dbConnection);
OleDbDataReader dataReader = selectCmd.ExecuteReader();
while(dataReader.Read())
{
Account rec = new Account();
rec.Load(dataReader);
m_accountRecs[rec.AccountNumber] = rec;
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";
}
dataReader.Close();
sql = "select * from businesses order by business_name";
selectCmd = new OleDbCommand(sql, m_dbConnection);
dataReader = selectCmd.ExecuteReader();
while (dataReader.Read())
{
Business rec = new Business();
rec.Load(dataReader);
m_businessRecs[rec.BusinessName] = rec;
TreeNode businessNode = treeManagement.Nodes.Add(rec.BusinessName);
businessNode.Tag = "business";
TreeNode node = businessNode.Nodes.Add("Ledger");
node.Tag = "ledger";
node = businessNode.Nodes.Add("Mileage");
node.Tag = "mileage";
}
dataReader.Close();
treeManagement.SelectedNode = summaryNode;
}
private void menuNewBusiness_Click(object sender, EventArgs e)
{
Business rec = new Business();
BusinessProperties dlg = new BusinessProperties(rec);
if (DialogResult.OK == dlg.ShowDialog(this))
{
rec.Store(m_dbConnection);
m_businessRecs[rec.BusinessName] = rec;
TreeNode businessNode = treeManagement.Nodes.Add(rec.BusinessName);
businessNode.Tag = "business";
TreeNode node = businessNode.Nodes.Add("Ledger");
node.Tag = "ledger";
node = businessNode.Nodes.Add("Mileage");
node.Tag = "mileage";
}
}
