private bool TestForHHMember() { string[] splitName = tbHHName.Text.Split(','); panel1.Visible = false; lvwPeople.Items.Clear(); HHMembers clsTmpHHM = new HHMembers(CCFBGlobal.connectionString); if (clsTmpHHM.openWhere("WHERE LastName = '" + splitName[0].Trim() + "' AND FirstName = '" + splitName[0].Trim() + "'", true) == true) { for (int i = 0; i < clsTmpHHM.RowCount; i++) { clsTmpHHM.SetRecord(i); ListViewItem lvItm = new ListViewItem(clsTmpHHM.LastName); lvItm.SubItems.Add(clsTmpHHM.FirstName); lvItm.SubItems.Add(clsTmpHHM.Birthdate.ToShortDateString()); lvItm.SubItems.Add(clsTmpHHM.Age.ToString()); lvItm.SubItems.Add(clsTmpHHM.HouseholdID.ToString()); if (i % 2 == 0) { lvItm.BackColor = Color.White; } else { lvItm.BackColor = Color.LightYellow; } lvwPeople.Items.Add(lvItm); //TestForHousehold(clsTmpHHM.HouseholdID); } panel1.Visible = true; return(true); } return(TestForHousehold(0)); }
public SignFamilyCard(Client clsClientIn) { InitializeComponent(); clsHH = clsClientIn.clsHH; clsHhM = clsClientIn.clsHHmem; idText = CCFBGlobal.formatNumberWithSixLeadingZeros(clsHH.ID); if (sigPadInputCtrl1.initSigPad() == true) { sigPadInputCtrl1.ClearPromptList(); SqlConnection conn = new SqlConnection(CCFBGlobal.connectionString); conn.Open(); SqlCommand sqlCmd = new SqlCommand("SELECT PromptText, RightButtonText FROM SignaturePrompts WHERE PromptGroup = 2 ORDER BY UID", conn); sqlCmd.CommandType = CommandType.Text; SqlDataReader reader = sqlCmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { sigPadInputCtrl1.AddPromptItem(reader.GetString(0), reader.GetString(1)); } } conn.Close(); } //btnSave.Enabled = false; }
public RptFoodMenu01(Household hhIN, HHMembers hhmemIN, TrxLogItem tlitmIN) { clsHH = hhIN; clsHHM = hhmemIN; clsTLItm = tlitmIN; rptDate = clsTLItm.TrxDate.ToShortDateString(); savePath = CCFBGlobal.pathLog + "Services" + rptDate.Substring(6, 4) + "\\" + rptDate.Substring(0, 2) + "\\" + rptDate.Substring(3, 2) + "\\"; CCFBGlobal.verifyPath(savePath); }
public Client() { connString = CCFBGlobal.connectionString; clsHH = new Household(connString); clsHHmem = new HHMembers(connString); clsHHSvcTrans = new TrxLog(connString, true, true, true, true); conn = new SqlConnection(); conn.ConnectionString = connString; dset = new DataSet(); dadAdpt = new SqlDataAdapter(); }
private void tsbPost_Click(object sender, EventArgs e) { clsTrxLog = new TrxLog(CCFBGlobal.connectionString, true, false, false, false); Household clsHH = new Household(CCFBGlobal.connectionString); HHMembers clsHHM = new HHMembers(CCFBGlobal.connectionString); int rsid = 0; foreach (ListViewItem item in lvwRouteStatus.Items) { if (item.Checked == true && Convert.ToInt32(item.Tag) == 2) { item.BackColor = Color.DarkOrchid; Application.DoEvents(); rsid = Convert.ToInt32(item.SubItems[4].Text); clsHDRouteSheet.find(rsid, true); for (int i = 0; i < clsHDRouteSheet.RSClients.RowCount; i++) { clsHDRouteSheet.RSClients.setDataRow(i); clsTrxLog.openForHH(clsHDRouteSheet.RSClients.HHID); clsHH.open(clsHDRouteSheet.RSClients.HHID); clsHHM.openHHID(clsHDRouteSheet.RSClients.HHID); clsHDItems.find(clsHDRouteSheet.RSClients.HDItem); clsTrxItem = new TrxLogItem(clsTrxLog.DSet.Tables[0].NewRow(), clsHH, clsHHM, clsHDRouteSheet.DriverName, TrxLogItem.SvcMethod.Pickup); clsTrxItem.TrxDate = currentServiceDate; clsTrxItem.LbsBabySvc = clsHDItems.LbsBabySvc; clsTrxItem.LbsCommodities = clsHDItems.LbsCommodity; clsTrxItem.LbsNonFood = clsHDItems.LbsNonFood; clsTrxItem.LbsOther = clsHDItems.LbsOther; clsTrxItem.LbsStandard = clsHDItems.LbsStd; clsTrxItem.LbsSupplemental = clsHDItems.LbsSupplemental; clsTrxItem.FoodSvcList = "HD-" + clsHDItems.Description; if (clsTrxItem.LbsCommodities > 0) { clsTrxItem.RcvdCommodity = true; } if (clsTrxItem.LbsSupplemental > 0) { clsTrxItem.RcvdSupplemental = true; } clsTrxItem.Created = DateTime.Now; clsTrxItem.CreatedBy = CCFBGlobal.dbUserName; clsTrxLog.DSet.Tables[0].Rows.Add(clsTrxItem.DRow); clsTrxLog.update(0, ""); clsTrxLog.updateServiceBits(clsHH.ID, currentServiceDate); clsHH.UpdateLatestServiceDates(currentServiceDate.ToShortDateString()); } clsHDRouteSheet.updateRouteStatus(HDRouteSheet.HDRSStatus.Posted); } } clsHDRouteSheet.refreshDataTable(); filllvwRouteStatus(); }
/// <summary> /// Constructor for the form that either adds a Household or a HosueholdMember /// </summary> /// <param name="clsIn">The client class</param> /// adds Household</param> public AddNewHousehold2(Client clsIn) { InitializeComponent(); clsHH = clsIn.clsHH; clsHHM = clsIn.clsHHmem; this.BackColor = CCFBGlobal.bkColorBaseEdit; lblHelp.BackColor = Color.Cornsilk; csdgdataaccess = new CSDGSqlDataAccess(CCFBGlobal.connectionString); lblPhoneNum.Visible = cboPhoneType.Visible = tbPhone.Visible = CCFBPrefs.EnableClientPhone; lblVerifyMethod.Visible = cboIDType.Visible = CCFBPrefs.EnableVerifyId; tbBabySvcDescr.Visible = chkBabyServices.Visible = CCFBPrefs.EnableBabyServices; chkNoCommodities.Visible = CCFBPrefs.EnableTEFAP; chkSupplOnly.Visible = CCFBPrefs.EnableSupplemental; this.Text = modedescription; lvwSameHouseNbr.Visible = true; pnl.Visible = true; tbLastName.Text = ""; tbeAddress.Text = ""; chkInCityLimits.Checked = false; chkHomeless.Checked = false; //tpgSameHouseNbr.Text = ""; //Fill Combos CCFBGlobal.InitCombo(cboSpecialLang, CCFBGlobal.parmTbl_Language); CCFBGlobal.InitCombo(cboClientType, CCFBGlobal.parmTbl_Client); CCFBGlobal.InitCombo(cboPhoneType, CCFBGlobal.parmTbl_Phone); CCFBGlobal.InitCombo(cboIDType, CCFBGlobal.parmTbl_AddressID); CCFBGlobal.InitCombo(cboMemIDType, CCFBGlobal.parmTbl_IdVerify); CCFBGlobal.InitCombo(cboRace, CCFBGlobal.parmTbl_Race); //Set selected value for combos to ID = 0 cboIDType.SelectedValue = "0"; cboPhoneType.SelectedValue = "0"; cboClientType.SelectedValue = "1"; cboSpecialLang.SelectedValue = "0"; cboMemIDType.SelectedValue = "0"; cboRace.SelectedValue = "0"; clsZipcodes = new Zipcodes(CCFBGlobal.connectionString); initTextboxes(); tbeCity.Text = CCFBPrefs.DefaultCity; tbeState.Text = CCFBPrefs.DefaultState; tbeZipCode.Text = CCFBPrefs.DefaultZipcode; btnSaveClient.Enabled = false; lvwHHMByBirthdate.Dock = DockStyle.Fill; lvwLastName.Dock = DockStyle.Fill; lvwPeople.Dock = DockStyle.Fill; lvwSameHouseNbr.Dock = DockStyle.Fill; showlvwControl(4); //spltcontMain.Panel2Collapsed = true; }
private bool TestForHHMember() { panel1.Visible = false; HHMembers clsTmpHHM = new HHMembers(CCFBGlobal.connectionString); lvwPeople.Items.Clear(); lvwHouseholds.Items.Clear(); if (clsTmpHHM.openWhere(" Where LastName = '" + tbLastName.Text + "' AND FirstName = '" + tbFirstName.Text + "'", true) == true) { for (int i = 0; i < clsTmpHHM.RowCount; i++) { clsTmpHHM.SetRecord(i); ListViewItem lvItm = new ListViewItem(clsTmpHHM.LastName); lvItm.SubItems.Add(clsTmpHHM.FirstName); lvItm.SubItems.Add(clsTmpHHM.Birthdate.ToShortDateString()); lvItm.SubItems.Add(clsTmpHHM.Age.ToString()); lvItm.SubItems.Add(clsTmpHHM.HouseholdID.ToString()); if (i % 2 == 0) { lvItm.BackColor = Color.White; } else { lvItm.BackColor = Color.LightYellow; } lvwPeople.Items.Add(lvItm); TestForHousehold(clsTmpHHM.HouseholdID); } panel1.Visible = true; return(true); } if (addMember == false) { return(TestForHousehold(0)); } else { return(false); } }