private void tbBirthDate_Leave(object sender, EventArgs e) { try { DateTime tmp = Convert.ToDateTime(tbBirthDate.Text); if (tmp > CCFBGlobal.FBNullDateValue && tmp < DateTime.Today) { tbBirthDate.Text = tmp.ToShortDateString(); tbBirthDate.ForeColor = Color.Black; lblDateError.Visible = false; tbAge.Text = CCFBGlobal.calcAge(tmp, DateTime.Today).ToString(); FillBirthDateGrid(tbBirthDate.Text); btnSaveClient.Enabled = (lblDupHHError.Visible == false && lblDateError.Visible == false && lblDupHHMError.Visible == false); } else { tbBirthDate.ForeColor = Color.DarkRed; lblDateError.Visible = true; } } catch { tbBirthDate.ForeColor = Color.DarkRed; lblDateError.Visible = true; //if (MessageBox.Show("Invalid date entered", "Date Vailidation", // MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning) == DialogResult.Retry) //{ // tbBirthDate.Focus(); //} } showlvwControl(2); clearHelpText(); }
/// <summary> /// Calculates the Ages of each Household Member and sets those values in the form and in the database /// </summary> public bool calcAllHHMemAges(DateTime BaseDate) { int[] AgeGroupsTotals = new int[6] { 0, 0, 0, 0, 0, 0 }; DateTime BirthDay; if (clsHH.UseFamilyList == true) { for (int i = 0; i < clsHHmem.RowCount; i++) { HHMemberItem clsHHMemberItem = new HHMemberItem(clsHHmem.DSet.Tables[0].Rows[i], clsHHmem.DSet.Tables[0].Columns, null, null); int newAge = 0; if (clsHHMemberItem.Inactive == false && clsHHMemberItem.NotCounted == false) { newAge = clsHHMemberItem.Age; if (clsHHMemberItem.UseAge == false || (clsHHMemberItem.BirthDate.ToShortDateString() != CCFBGlobal.OURNULLDATE && clsHHMemberItem.BirthDate.ToShortDateString() != CCFBGlobal.OUROTHERNULLDATE)) { BirthDay = clsHHMemberItem.BirthDate; if (BirthDay != null && BirthDay.ToShortDateString() != "" && BirthDay != DateTime.MaxValue) { newAge = CCFBGlobal.calcAge(BirthDay, BaseDate); clsHHMemberItem.Age = newAge; } } clsHHMemberItem.AgeGroup = clsHHmem.GetEFAPAgeGroup(newAge); AgeGroupsTotals[clsHHMemberItem.AgeGroup]++; } } int totalFamily = AgeGroupsTotals[CCFBGlobal.ageGroup_Infant] + AgeGroupsTotals[CCFBGlobal.ageGroup_Youth] + AgeGroupsTotals[CCFBGlobal.ageGroup_Teen] + AgeGroupsTotals[CCFBGlobal.ageGroup_Eighteen] + AgeGroupsTotals[CCFBGlobal.ageGroup_Adult] + AgeGroupsTotals[CCFBGlobal.ageGroup_Senior]; if (clsHH.Infants != AgeGroupsTotals[CCFBGlobal.ageGroup_Infant] || clsHH.Youth != AgeGroupsTotals[CCFBGlobal.ageGroup_Youth] || clsHH.Teens != AgeGroupsTotals[CCFBGlobal.ageGroup_Teen] || clsHH.Eighteens != AgeGroupsTotals[CCFBGlobal.ageGroup_Eighteen] || clsHH.Adults != AgeGroupsTotals[CCFBGlobal.ageGroup_Adult] || clsHH.Seniors != AgeGroupsTotals[CCFBGlobal.ageGroup_Senior] || clsHH.TotalFamily != totalFamily) { clsHH.Infants = AgeGroupsTotals[CCFBGlobal.ageGroup_Infant]; clsHH.Youth = AgeGroupsTotals[CCFBGlobal.ageGroup_Youth]; clsHH.Teens = AgeGroupsTotals[CCFBGlobal.ageGroup_Teen]; clsHH.Eighteens = AgeGroupsTotals[CCFBGlobal.ageGroup_Eighteen]; clsHH.Adults = AgeGroupsTotals[CCFBGlobal.ageGroup_Adult]; clsHH.Seniors = AgeGroupsTotals[CCFBGlobal.ageGroup_Senior]; clsHH.TotalFamily = totalFamily; return(true); } } return(false); }
private void addHHMember(int hhid) { newRow = clsClient.clsHHmem.DSet.Tables[0].NewRow(); foreach (TextBox tb in Controls.OfType <TextBox>()) { if (tb.Enabled == true) { newRow[tb.Tag.ToString()] = tb.Text; } } if (chkEnterAge.Checked == true) { newRow["BirthDate"] = calcBirthdateFromAge(); newRow["UseAge"] = true; } else { newRow["Age"] = CCFBGlobal.calcAge(DateTime.Parse(tbBirthDate.Text), DateTime.Today); newRow["UseAge"] = false; } newRow["AgeGroup"] = clsClient.clsHHmem.GetEFAPAgeGroup(Convert.ToInt32(newRow["Age"])); newRow["HouseholdID"] = clsClient.clsHH.ID; newRow["HeadHH"] = false; newRow["NotIncludedInClientList"] = false; newRow["Inactive"] = false; newRow["SpecialDiet"] = 0; newRow["WorksInArea"] = 0; newRow["VolunteersAtFoodBank"] = false; newRow["SpecialDiet"] = false; newRow["UserFlag0"] = false; newRow["UserFlag1"] = false; newRow["CSFP"] = false; newRow["CSFPRoute"] = 0; newRow["IsDisabled"] = false; newRow["Inactive"] = false; newRow["Language"] = 0; newRow["UserFlag0"] = 0; newRow["UserFlag1"] = 0; newRow["CreatedBy"] = CCFBGlobal.currentUser_Name; newRow["Created"] = DateTime.Now; clsClient.clsHHmem.DSet.Tables[0].Rows.Add(newRow); if (clsClient.clsHHmem.insertMember() == true) { createNewHHMDemographics(); } }
/// <summary> /// Loads the Students Listview with the School Age Members /// </summary> private void loadHHMems(bool clearRows) { DateTime d; Color CellForeColor; DataGridViewRow dvr; if (clearRows == true) { dgvHHMembers.Rows.Clear(); } int rowCount = 0; int calculatedAge = 0; int bMonth = 0; int curMonth = DateTime.Today.Month; for (int i = 0; i < clsClient.clsHHmem.RowCount; i++) { clsClient.clsHHmem.SetRecord(i); if (clsClient.clsHHmem.Inactive == false) { calculatedAge = CCFBGlobal.calcAge(clsClient.clsHHmem.Birthdate, DateTime.Today); if (calculatedAge != clsClient.clsHHmem.Age) { clsClient.clsHHmem.Age = calculatedAge; } if (clsClient.clsHHmem.SchSupply == true | (clsClient.clsHHmem.Age >= 5 && clsClient.clsHHmem.Age <= 18)) { if (clsClient.clsHHmem.Grade < 0) { bMonth = clsClient.clsHHmem.Birthdate.Month; if (bMonth < curMonth || bMonth >= 9) { clsClient.clsHHmem.Grade = calculatedAge - 5; } else { clsClient.clsHHmem.Grade = calculatedAge - 4; } if (clsClient.clsHHmem.Grade > 12) { clsClient.clsHHmem.Grade = 12; } } dgvHHMembers.Rows.Add(); if ((bool)clsClient.clsHHmem.DSet.Tables[0].Rows[i]["SchSupply"]) { CellForeColor = Color.Maroon; } else { CellForeColor = Color.Black; } dvr = dgvHHMembers.Rows[rowCount]; dvr.Tag = clsClient.clsHHmem.ID.ToString(); FillGridMembersCell(dvr, "clmSchSupply", "SchSupply", true, CellForeColor, i, false); // FillGridMembersCell(dvr, "clmHeadHH", "HeadHH", true, CellForeColor, i); dvr.Cells["clmName"].Value = clsClient.clsHHmem.Name; FillGridMembersCell(dvr, "clmGrade", "Grade", false, CellForeColor, i, false); FillGridMembersCell(dvr, "clmAge", "Age", false, CellForeColor, i, true); FillGridMembersCell(dvr, "clmGender", "Sex", false, CellForeColor, i, true); dvr.Cells["clmSchool"].Value = clsClient.clsHHmem.SchSupplySchool.ToString(); //dvr.Cells["clmSchool"].Value = CCFBGlobal.LongNameFromId(CCFBGlobal.parmTbl_SchSupplySchool, clsClient.clsHHmem.SchSupplySchool); string tmp = ""; if (clsClient.clsHHmem.DSet.Tables[0].Rows[i]["SchSupplyDelivered"].ToString() != "") { d = (DateTime)clsClient.clsHHmem.DSet.Tables[0].Rows[i]["SchSupplyDelivered"]; if (d > CCFBGlobal.FBNullDateValue) { tmp = d.ToShortDateString(); } } dvr.Cells["clmDelivered"].Value = tmp; dvr.Cells["clmDelivered"].Tag = "SchSupplyDelivered"; FillGridMembersCell(dvr, "clmHMID", "ID", false, CellForeColor, i, true); rowCount++; } } } }