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