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