public AccountProperties(Account account)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
m_account = account;
textAccountName.Text = account.AccountName;
textRoutingNumber.Text = account.RoutingNumber;
textAccountNumber.Text = account.AccountNumber;
textComments.Text = account.Comments;
}
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 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";
}
}
