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