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