private void btnSelectPartner_Click(object sender, EventArgs e)
{
var list = new PersonRepository().FindAll();
var form = new SelectorUI<Person>(list);
form.ShowDialog();
var selectedItem = form.SelectedItem;
if (selectedItem != null)
this.PersonMarriage = new Marriage(this.Person, selectedItem);
UpdateRelationshipsView();
}
private Marriage FindMarriageData(Marriage marriage)
{
var father = DB.Database.GetDatabase().FetchBy<Person>(sql => sql.Where(x => x.id.Equals(marriage.husband_id))).FirstOrDefault();
var mother = DB.Database.GetDatabase().FetchBy<Person>(sql => sql.Where(x => x.id.Equals(marriage.wife_id))).FirstOrDefault();
var sonIds = (DB.Database.GetDatabase().FetchBy<MarriageSon>(sql => sql.Where(x => x.marriage_id.Equals(marriage.id)))).Select(x => x.son_id).ToList();
var sons = DB.Database.GetDatabase().FetchBy<Person>(sql => sql.Where(x => sonIds.Contains((long) x.id))).ToList();
marriage.Husband = father;
marriage.Wife = mother;
marriage.Sons = sons;
return marriage;
}
private void CustomitzedInitialization()
{
if (this.Person != null)
{
this.PersonMarriage = new MarriageRepository().FindByPerson(this.Person);
this.ParentsMarriage = new MarriageRepository().FindBySon(this.Person);
UpdateRelationshipsView();
this.MarriageSon = new MarriageSonRepository().FindBySon(this.Person);
}
SetPersonDataBindings();
}
private Marriage GetMarriageFromHusbandLine(string line, Person husband, Person wife)
{
var cells = line.Split(',');
var marriage = new Marriage()
{
date = GetDate(cells[7]),
place = cells[9],
husband_id = husband?.id,
wife_id = wife?.id
};
marriage.id = (long) _db.Insert(marriage);
return marriage;
}
public MarriageUI(Marriage marriage = null)
{
InitializeComponent();
}
