public bool LoadLedgerEntry(int businessId) { SaveRecord(); m_businessId = businessId; UpdateBalances(); textDate.Text = ""; comboType.SelectedIndex = -1; comboAccount.Text = ""; comboAccount.SelectedIndex = -1; comboAccount.Items.Clear(); comboDescription.Text = ""; comboDescription.SelectedIndex = -1; comboDescription.Items.Clear(); textAmount.Text = ""; textComments.Text = ""; string sql = string.Format("select account from ledger_accounts where business_id = {0}", businessId); OleDbCommand selectCmd = new OleDbCommand(sql, m_dbConnection); OleDbDataReader dataReader = selectCmd.ExecuteReader(); while(dataReader.Read()) { comboAccount.Items.Add(dataReader[0].ToString()); } dataReader.Close(); //@ need a query for this sql = string.Format("select distinct description from ledger where business_id = {0}", businessId); selectCmd = new OleDbCommand(sql, m_dbConnection); dataReader = selectCmd.ExecuteReader(); while (dataReader.Read()) { comboDescription.Items.Add(dataReader[0].ToString()); } dataReader.Close(); listEntries.Items.Clear(); sql = string.Format("select * from ledger where business_id = {0} order by entry_date", businessId); selectCmd = new OleDbCommand(sql, m_dbConnection); dataReader = selectCmd.ExecuteReader(); ListViewItem item = null; while(dataReader.Read()) { Ledger rec = new Ledger(); rec.Load(dataReader); item = new ListViewItem(rec.EntryDateString); item.Tag = rec; rec.Tag = item; item.SubItems.Add(rec.Description); item.SubItems.Add(rec.EntryAccount); if(rec.EntryType == "C") { item.SubItems.Add(rec.EntryAmount.ToString("C")); } else { item.SubItems.Add(string.Format("<{0:C}>", rec.EntryAmount)); } listEntries.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(""); Ledger rec = new Ledger(); rec.BusinessId = m_businessId; item.Tag = rec; rec.Tag = item; listEntries.Items.Add(item); item.Selected = true; textDate.Focus(); }