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 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 AttachChild(int childId) { if (familyId == -1) { familyId = DBAccessStatic.InsertFamily(husbandId, wifeId, "", ""); } DBAccessStatic.InsertFamilyChild(familyId, childId); LoadFamilyByFamily(familyId); }
private void txtHusbandDiedDate_Leave(object sender, EventArgs e) { if (husbandId == -1) { MessageBox.Show("Please enter name first"); } else { DBAccessStatic.UpdateIndividualDiedDate(husbandId, txtHusbandDiedDate.Text); } }
private void txtWifeDiedPlace_Leave(object sender, EventArgs e) { if (wifeId == -1) { MessageBox.Show("Please enter name first"); } else { DBAccessStatic.UpdateIndividualDiedPlace(wifeId, txtWifeDiedPlace.Text); } }
private void txtMariedPlace_Leave(object sender, EventArgs e) { if (familyId == -1) { familyId = DBAccessStatic.InsertFamily(husbandId, wifeId, txtMarriedDate.Text, txtMariedPlace.Text); } else { DBAccessStatic.UpdateFamilyMarriagePlace(familyId, txtMariedPlace.Text); } }
private void LoadFamilyByFamily(int familyId) { ClearHusbandData(); ClearWifeData(); ClearMarriageData(); ClearChildrenData(); DataSet family = DBAccessStatic.GetFamily(familyId); if (family.Tables[0].Rows.Count > 0) { familyId = (int)(family.Tables[0].Rows[0]["ID"]); wifeId = (int)(family.Tables[0].Rows[0]["WifeId"]); husbandId = (int)(family.Tables[0].Rows[0]["HusbandId"]); if (husbandId != -1) { DataSet husband = DBAccessStatic.GetIndividual(husbandId); LoadHusbandData(husband); } if (wifeId != -1) { DataSet wife = DBAccessStatic.GetIndividual(wifeId); LoadWifeData(wife); } if (husbandId != -1) { history.Add(husbandId); } else { if (wifeId != -1) { history.Add(wifeId); } } if (!history.IsEmpty()) { tbrBack.Enabled = true; } LoadMarriageData(family, 0); DataSet children = DBAccessStatic.GetFamilyChildren(familyId); if (children.Tables[0].Rows.Count > 0) { LoadChildrenData(children); } } else { familyId = -1; wifeId = -1; husbandId = -1; } }
private void AttachSpouse(int spouseId) { if (activePerson == husbandId) { familyId = DBAccessStatic.InsertFamily(husbandId, spouseId, "", ""); } else { familyId = DBAccessStatic.InsertFamily(spouseId, wifeId, "", ""); } LoadFamilyByFamily(familyId); }
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 DetachSpouse() { if (activePerson == husbandId) { wifeId = -1; DBAccessStatic.UpdateFamilyWifeId(familyId, wifeId); } else { husbandId = -1; DBAccessStatic.UpdateFamilyHusbandId(familyId, husbandId); } LoadFamilyByFamily(familyId); }
private void grdChildren_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { if (grdChildren[0, e.RowIndex].Value == null) { MessageBox.Show("Please enter some information for the child before moving to their record"); } else { if (grdChildren[2, e.RowIndex].Value == null) { DBAccessStatic.UpdateIndividualGender((int)grdChildren[0, e.RowIndex].Value, "M"); } LoadFamily((int)grdChildren[0, e.RowIndex].Value); } }
public static int UpdateIndividualSurname(int individualId, string surname) { return(DBAccessStatic.UpdateTable("Individual", "Surname", surname, individualId)); }
private void DeleteIndividual(int individualId) { DBAccessStatic.DeleteIndividual(individualId); }
private void DetachChild(int childId) { DBAccessStatic.DeleteFamilyChild(childId); LoadFamilyByFamily(familyId); }
public static int UpdateIndividualBornPlace(int individualId, string bornPlace) { return(DBAccessStatic.UpdateTable("Individual", "BornPlace", bornPlace, individualId)); }
public static int UpdateIndividualDiedPlace(int individualId, string diedPlace) { return(DBAccessStatic.UpdateTable("Individual", "DiedPlace", diedPlace, individualId)); }
public static int UpdateIndividualGender(int individualId, string gender) { return(DBAccessStatic.UpdateTable("Individual", "Gender", gender, individualId)); }
public static int UpdateIndividualPArentFamilyId(int individualId, int parentFamilyId) { return(DBAccessStatic.UpdateTable("Individual", "ParentFamilyId", parentFamilyId.ToString(), individualId)); }
public static int UpdateFamilyHusbandId(int familyId, int husbandId) { return(DBAccessStatic.UpdateTable("Family", "HusbandId", husbandId.ToString(), familyId)); }
public static int UpdateFamilyWifeId(int familyId, int wifeId) { return(DBAccessStatic.UpdateTable("Family", "WifeId", wifeId.ToString(), familyId)); }
public static int UpdateIndividualFirstname(int individualId, string firstname) { return(DBAccessStatic.UpdateTable("Individual", "Firstname", firstname, individualId)); }
public static int UpdateFamilyMarriagePlace(int familyId, string marriagePlace) { return(DBAccessStatic.UpdateTable("Family", "MarriagePlace", marriagePlace, familyId)); }
private void LoadFamily(int individualId, int familyIndex) { ClearHusbandData(); ClearWifeData(); ClearMarriageData(); ClearChildrenData(); wifeParentId = -1; husbandParentId = -1; DataSet individual = DBAccessStatic.GetIndividual(individualId); if (individual.Tables[0].Rows[0]["Gender"].ToString() == "M") { husbandId = individualId; husbandParentId = (int)(individual.Tables[0].Rows[0]["ParentFamilyId"]); LoadHusbandData(individual); SetHusbandActive(); DataSet family = DBAccessStatic.GetFamilyForHusband(husbandId); if (family.Tables[0].Rows.Count > 0) { familyId = (int)(family.Tables[0].Rows[familyIndex]["ID"]); wifeId = (int)(family.Tables[0].Rows[familyIndex]["WifeId"]); if (wifeId != -1) { DataSet wife = DBAccessStatic.GetIndividual(wifeId); wifeParentId = (int)(wife.Tables[0].Rows[0]["ParentFamilyId"]); LoadWifeData(wife); } LoadMarriageData(family, familyIndex); } else { familyId = -1; wifeId = -1; } } else { wifeId = individualId; wifeParentId = (int)(individual.Tables[0].Rows[0]["ParentFamilyId"]); LoadWifeData(individual); SetWifeActive(); DataSet family = DBAccessStatic.GetFamilyForWife(wifeId); if (family.Tables[0].Rows.Count > 0) { familyId = (int)(family.Tables[0].Rows[familyIndex]["ID"]); husbandId = (int)(family.Tables[0].Rows[familyIndex]["HusbandId"]); if (husbandId != -1) { DataSet husband = DBAccessStatic.GetIndividual(husbandId); husbandParentId = (int)(husband.Tables[0].Rows[0]["ParentFamilyId"]); LoadHusbandData(husband); } LoadMarriageData(family, familyIndex); } else { familyId = -1; wifeId = -1; } } if (familyId != -1) { DataSet children = DBAccessStatic.GetFamilyChildren(familyId); LoadChildrenData(children); } history.Add(individualId); if (!history.IsEmpty()) { tbrBack.Enabled = true; } }