private void FillSameHouseNbrGrid() { Household clsTmpHH = new Household(CCFBGlobal.connectionString); TrxLog clsTmpTL = new TrxLog(CCFBGlobal.connectionString, true, true, true, true); string[] tmp = tbeAddress.Text.Split(' '); //tpgSameHouseNbr.Text = "Loading ..."; lvwSameHouseNbr.Items.Clear(); Application.DoEvents(); if (tmp.Length > 0) { clsTmpHH.openWhere("Left(Address," + tmp[0].Length.ToString() + ") = '" + tmp[0] + "'", "Address, Name"); for (int i = 0; i < clsTmpHH.RowCount; i++) { clsTmpHH.SetRecord(i); ListViewItem lvi = new ListViewItem(clsTmpHH.Name); lvi.SubItems.Add(clsTmpHH.Inactive.ToString()); lvi.SubItems.Add(clsTmpHH.Address); lvi.SubItems.Add(clsTmpHH.AptNbr); lvi.SubItems.Add(clsTmpHH.City + ", " + clsTmpHH.State + " " + clsTmpHH.Zipcode); lvi.SubItems.Add(clsTmpTL.GetNBrTrxByHH(clsTmpHH.ID).ToString()); lvi.SubItems.Add(clsTmpHH.ID.ToString()); lvwSameHouseNbr.Items.Add(lvi); } //tpgSameHouseNbr.Text = "[" + lvwSameHouseNbr.Items.Count.ToString() + "] " + tpgSameHouseNbr.Tag.ToString(); lvwSameHouseNbr.Visible = true; //tabControl1.SelectedIndex = 1; } else { //tpgSameHouseNbr.Text = ""; lvwSameHouseNbr.Visible = false; } }
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); }