Beispiel #1
0
        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;
        }
Beispiel #3
0
 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);
 }
Beispiel #4
0
 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();
 }
Beispiel #5
0
        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();
        }
Beispiel #6
0
        /// <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);
            }
        }