public bool open(int HHID, bool loadHHmem, bool loadSvcTrans)
{
bool toReturn = clsHH.open(HHID);
if (loadHHmem == true)
{
clsHHmem.openHHID(HHID);
}
return(toReturn);
}
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();
}
private void addHHMember(int hhid)
{
if (newHHMID == 0)
{
clsHHM.openHHID(newHHID);
clsHHMItem = new HHMemberItem(clsHHM.addHHMember(hhid, "")
, clsHHM.DSet.Tables[0].Columns
, clsHHM.addHHMDemographics(0)
, clsHHM.DSet.Tables[1].Columns);
FillHHMemItem(ref clsHHMItem);
clsHHM.newHHMemberSave(clsHHMItem);
}
else
{
clsHHMItem.HouseholdID = hhid;
FillHHMemItem(ref clsHHMItem);
//DataRow drhhm = new DataRow() = clsHHMItem.DRowHhM;
//DataRow drdemog = new DataRow() = clsHHMItem.DRowDemographics;
clsHHM.DRowHhm = clsHHMItem.DRowHhM;
clsHHM.DRowDemograhics = clsHHMItem.DRowDemographics;
clsHHM.update(true);
}
}
