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"; } }