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 = '" + CCFBGlobal.SQLApostrophe(tbLastName.Text) + ", " + CCFBGlobal.SQLApostrophe(tbFirstName.Text) + "'"; if (TestHHId > 0) { sqlWhere += " OR ID = " + TestHHId.ToString(); } clsTmpHH.openWhere(sqlWhere); return(clsTmpHH.RowCount > 0); }
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); }
private void btnSaveClient_Click(object sender, EventArgs e) { if (tbAge.Text.Trim() == "" && tbBirthDate.Text.Trim() == "") { MessageBox.Show("Cannot Save When Both Age And Birthdate Are Blank", modedescription); } else if (lblDateError.Visible == true && chkEnterAge.Checked == false) { MessageBox.Show("Cannot Save With Invalid Birthdate", modedescription); tbBirthDate.Focus(); } else { string hhName = tbLastName.Text.Trim() + ", " + tbFirstName.Text.Trim(); newHHID = 0; clsHH.openWhere("Name='" + CCFBGlobal.SQLApostrophe(tbLastName.Text.Trim()) + ", " + CCFBGlobal.SQLApostrophe(tbFirstName.Text.Trim()) + "'"); if (clsHH.ISValid == true && CCFBPrefs.AllowDuplicateHHNames == false) { MessageBox.Show("Name " + hhName + "\r\nAlready Exists In Household Table as ID = " + clsHH.ID.ToString(), modedescription, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { if (clsHHM.nameExists(CCFBGlobal.SQLApostrophe(tbFirstName.Text.Trim()), CCFBGlobal.SQLApostrophe(tbLastName.Text.Trim()), tbBirthDate.Text, true) == false || CCFBPrefs.AllowDuplicateHHNames == true || newHHMID > 0) { newRow = clsHH.DSet.Tables[0].NewRow(); newRow["Name"] = hhName; newRow["Inactive"] = 0; if (cboIDType.SelectedValue != null) { newRow["IdType"] = cboIDType.SelectedValue; } else { newRow["IdType"] = 0; } newRow["ClientType"] = cboClientType.SelectedValue; if (cboPhoneType.SelectedValue == null) { newRow["PhoneType"] = 0; } else { newRow["PhoneType"] = cboPhoneType.SelectedValue; } newRow["Phone"] = tbPhone.Text; newRow["EthnicSpeaking"] = cboSpecialLang.SelectedValue; switch (CCFBPrefs.UseFamilyList) { case CCFBPrefs.UseFamilyListCode.Normally: newRow["UseFamilyList"] = true; break; case CCFBPrefs.UseFamilyListCode.Sometimes: newRow["UseFamilyList"] = false; break; case CCFBPrefs.UseFamilyListCode.Always: newRow["UseFamilyList"] = true; break; case CCFBPrefs.UseFamilyListCode.Never: newRow["UseFamilyList"] = false; break; default: break; } newRow["Inactive"] = false; newRow["UserFlag0"] = false; newRow["UserFlag1"] = false; newRow["UserFlag2"] = false; newRow["UserFlag3"] = false; newRow["UserFlag4"] = false; newRow["UserFlag5"] = false; newRow["UserFlag6"] = false; newRow["UserFlag7"] = false; newRow["UserFlag8"] = false; newRow["UserFlag9"] = false; newRow["UserNum0"] = 0; newRow["UserNum1"] = 0; newRow["Infants"] = 0; newRow["Youth"] = 0; newRow["Teens"] = 0; newRow["Eighteen"] = 0; newRow["Adults"] = 0; newRow["Seniors"] = 0; switch (clsHHM.GetEFAPAgeGroup(Convert.ToInt32(tbAge.Text))) { case 0: { newRow["Infants"] = 1; break; } case 1: { newRow["Youth"] = 1; break; } case 2: { newRow["Teens"] = 1; break; } case 3: { newRow["Eighteen"] = 1; break; } case 4: { newRow["Adults"] = 1; break; } case 5: { newRow["Seniors"] = 1; break; } } newRow["TotalFamily"] = 1; if (cboIDType.SelectedIndex < 0) { newRow["NeedToVerifyId"] = true; } else { if (cboIDType.SelectedValue.ToString() == "0") { newRow["NeedToVerifyId"] = true; } else { newRow["NeedToVerifyId"] = false; } newRow["DateIDVerified"] = dateIdVerified; } newRow["SupplOnly"] = false; newRow["IncludeOnLog"] = true; newRow["Disabled"] = 0; newRow["SpecialDiet"] = false; newRow["NoCommodities"] = chkNoCommodities.Checked; newRow["NeedCommoditySignature"] = false; newRow["IncludeOnLog"] = false; newRow["AutoAlert"] = false; newRow["FirstSvcThisYear"] = CCFBGlobal.FBNullDateValue; newRow["SecondServiceThisMonth"] = false; newRow["InCityLimits"] = chkInCityLimits.Checked; newRow["Homeless"] = chkHomeless.Checked; newRow["LatestService"] = "01/01/1900"; newRow["AnnualIncome"] = 0; newRow["BabyServices"] = chkBabyServices.Checked; newRow["BabySvcDescr"] = tbBabySvcDescr.Text; newRow["SurveyComplete"] = 0; newRow["NbrCSFP"] = 0; newRow["Address"] = tbeAddress.Text; newRow["AptNbr"] = tbeApt.Text; newRow["City"] = tbeCity.Text; newRow["State"] = tbeState.Text; newRow["Zipcode"] = tbeZipCode.Text; newRow["CreatedBy"] = CCFBGlobal.dbUserName; newRow["Created"] = DateTime.Now; newRow["BarCode"] = 0; newRow["TEFAPSignDate"] = DateTime.Now.ToShortDateString(); newRow["SingleHeadHH"] = chkSingleHeadHH.Checked; newRow["NeedIncomeVerification"] = true; newRow["IncomeVerifiedDate"] = CCFBGlobal.FBNullDateValue; newRow["ServiceMethod"] = 0; newRow["HDRoute"] = 0; newRow["HDBuilding"] = 0; newRow["HDProgram"] = 0; newRow["HUDCategory"] = 0; newRow["HDItem"] = 0; newRow["DriverNotes"] = ""; newRow["AlertText"] = ""; newRow["Transportation"] = 0; newRow["SchSupplyPickupPerson"] = ""; newRow["SchSupplyRegDate"] = CCFBGlobal.FBNullDateValue; newRow["SchSupplyFlag"] = 0; newRow["SchSupplyRegistration"] = 0; clsHH.DSet.Tables[0].Rows.Add(newRow); clsHH.insert(); clsHH.openWhere("Name='" + CCFBGlobal.SQLApostrophe(hhName) + "' AND CREATED >='" + DateTime.Today.ToShortDateString() + "'"); newHHID = clsHH.ID; addHHMember(newHHID); this.Visible = false; } else { MessageBox.Show(tbFirstName.Text + " " + tbLastName.Text + "\r\nAlready Exists In Household Members Table", modedescription, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); tbFirstName.Focus(); } } } }