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);
}
}
