private void grdChildren_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (familyId == -1) { familyId = DBAccessStatic.InsertFamily(husbandId, wifeId, txtMarriedDate.Text, txtMariedPlace.Text); } if (grdChildren[0, e.RowIndex].Value == null) { int childID = DBAccessStatic.InsertIndividual("", "", "", "", "", "", familyId, ""); grdChildren[0, e.RowIndex].Value = childID; DBAccessStatic.InsertFamilyChild(familyId, childID); } if (e.ColumnIndex == 1) { string surname = GenValidation.GetSurname(grdChildren["ChildName", e.RowIndex].Value.ToString()); string firstname = GenValidation.GetFirstname(grdChildren["ChildName", e.RowIndex].Value.ToString()); DBAccessStatic.UpdateIndividualFirstname((int)grdChildren[0, e.RowIndex].Value, firstname); DBAccessStatic.UpdateIndividualSurname((int)grdChildren[0, e.RowIndex].Value, surname); } else if (e.ColumnIndex == 2) { DBAccessStatic.UpdateIndividualGender((int)grdChildren[0, e.RowIndex].Value, grdChildren[2, e.RowIndex].Value.ToString()); } else if (e.ColumnIndex == 3) { DBAccessStatic.UpdateIndividualBornDate((int)grdChildren[0, e.RowIndex].Value, grdChildren[3, e.RowIndex].Value.ToString()); } else if (e.ColumnIndex == 4) { DBAccessStatic.UpdateIndividualDiedDate((int)grdChildren[0, e.RowIndex].Value, grdChildren[4, e.RowIndex].Value.ToString()); } }
private void AncestryReportForm_Activated(object sender, EventArgs e) { ancestorCalculation = new AncestorCalc(MaxDepth); ancestorCalculation.CalculateAncestors(IndividualId, UniqueAncestors); report.Clear(); Individualg individual = new Individualg(); StringBuilder reportText = new StringBuilder(); for (int i = 0; i <= ancestorCalculation.GenerationCount; i++) { reportText.AppendLine("Generation " + (i + 1).ToString()); reportText.AppendLine("----------------"); for (int j = 0; j < ancestorCalculation.ancestryList[i].Count; j++) { individual = (Individualg)(ancestorCalculation.ancestryList[i][j]); reportText.AppendLine(GenValidation.GetNameWithDates(individual.Surname, individual.Firstname, individual.BirthDate, individual.DiedDate)); } reportText.AppendLine(""); } reportText.AppendLine("Number of ancestors: " + ancestorCalculation.IndividualCount.ToString()); report.Text = reportText.ToString(); }
private void txtWifeName_Leave(object sender, EventArgs e) { if (txtWifeName.Text.Trim().Length > 0) { string surname = GenValidation.GetSurname(txtWifeName.Text.Trim()); string firstname = GenValidation.GetFirstname(txtWifeName.Text.Trim()); if (wifeId == -1) { wifeId = DBAccessStatic.InsertIndividual(surname, firstname, "", "", "", "", -1, "F"); } else { DBAccessStatic.UpdateIndividualSurname(wifeId, surname); DBAccessStatic.UpdateIndividualFirstname(wifeId, firstname); } if ((familyId == -1) && (husbandId != -1)) { familyId = DBAccessStatic.InsertFamily(husbandId, wifeId, txtMarriedDate.Text, txtMariedPlace.Text); } } else { MessageBox.Show("Name field cannot be left empty."); } }
private void LoadIndividuals() { lstIndividuals.Items.Clear(); DataSet individuals = DBAccessStatic.GetAllIndividuals(); for (int i = 0; i < individuals.Tables[0].Rows.Count; i++) { lstIndividuals.Items.Add(GenValidation.GetNameWithDates(individuals.Tables[0].Rows[i]["Surname"].ToString(), individuals.Tables[0].Rows[i]["Firstname"].ToString(), individuals.Tables[0].Rows[i]["BornDate"].ToString(), individuals.Tables[0].Rows[i]["DiedDate"].ToString())); individualIds.Add((int)(individuals.Tables[0].Rows[i]["ID"])); } }
private void DescendantReportForm_Activated(object sender, EventArgs e) { descendantCalc = new DescendantCalc(MaxDepth); descendantCalc.CalculateDescendants(IndividualId, UniqueDescendants); report.Clear(); Individualg individual = new Individualg(); StringBuilder reportText = new StringBuilder(); string birthDate, diedDate; for (int i = 0; i <= descendantCalc.GenerationCount; i++) { reportText.AppendLine("Generation " + (i + 1).ToString()); reportText.AppendLine("----------------"); for (int j = 0; j < descendantCalc.descendantList[i].Count; j++) { individual = (Individualg)(descendantCalc.descendantList[i][j]); if (individual.BirthDate == "") { birthDate = "?"; } else { birthDate = individual.BirthDate; } if (individual.DiedDate == "") { diedDate = "?"; } else { diedDate = individual.DiedDate; } reportText.AppendLine(GenValidation.GetNameWithDates(individual.Surname, individual.Firstname, individual.BirthDate, individual.DiedDate)); } reportText.AppendLine(""); } reportText.AppendLine("Number of descendants: " + descendantCalc.IndividualCount.ToString()); report.Text = reportText.ToString(); }