private bool TestForHousehold(int TestHHId)
{
Household clsTmpHH = new Household(CCFBGlobal.connectionString);
string sqlWhere = "Name = '" + tbHHName.Text + "'";
if (TestHHId > 0)
{
sqlWhere += " OR ID = " + TestHHId.ToString();
}
clsTmpHH.openWhere(sqlWhere);
if (clsTmpHH.RowCount > 0)
{
lvwHouseholds.Items.Clear();
for (int i = 0; i < clsTmpHH.RowCount; i++)
{
clsTmpHH.SetRecord(i);
ListViewItem lvItm = new ListViewItem(clsTmpHH.Name);
lvItm.SubItems.Add(clsTmpHH.Inactive.ToString());
lvItm.SubItems.Add(clsTmpHH.Address.ToString());
lvItm.SubItems.Add(clsTmpHH.City.ToString() + ", " + clsTmpHH.State.ToString() + " " + clsTmpHH.Zipcode.ToString());
lvItm.SubItems.Add(clsTmpHH.HHMembersCount(clsTmpHH.ID).ToString());
lvItm.SubItems.Add(clsTmpHH.ID.ToString());
if (i % 2 == 0)
{
lvItm.BackColor = Color.White;
}
else
{
lvItm.BackColor = Color.LightYellow;
}
lvwHouseholds.Items.Add(lvItm);
}
panel1.Visible = true;
return(true);
}
return(false);
}
