public Marriage FindByPerson(Person person)
{
var marriage = DB.Database.GetDatabase().FetchBy<Marriage>(sql => sql.Where(x => x.husband_id.Equals(person.id) || x.wife_id.Equals(person.id))).FirstOrDefault();
if (marriage != null)
return FindMarriageData(marriage);
else
return null;
}
public PersonUI(Person person = null)
{
InitializeComponent();
// custom:
this.Person = person;
CustomitzedInitialization();
}
public MarriageSon FindBySon(Person person)
{
var marriageSon = DB.Database.GetDatabase().FetchBy<MarriageSon>(sql => sql.Where(x => x.son_id.Equals(person.id))).FirstOrDefault();
if(marriageSon != null)
{
marriageSon.Son = person;
return marriageSon;
}
else
{
return null;
}
}
public Person FindPartner(Person person)
{
var marriage = new MarriageRepository().FindByPerson(person);
if(marriage != null)
{
var partnerId = marriage.husband_id;
if (partnerId == person.id)
partnerId = marriage.wife_id;
var partner = DB.Database.GetDatabase().FetchBy<Person>(sql => sql.Where(x => x.id.Equals(partnerId))).FirstOrDefault();
return partner;
}
else
{
return null;
}
}
public Marriage FindBySon(Person son)
{
var marriageSon = new MarriageSonRepository().FindBySon(son);
if (marriageSon != null)
{
var marriage = DB.Database.GetDatabase().FetchBy<Marriage>(sql => sql.Where(x => x.id.Equals(marriageSon.marriage_id))).FirstOrDefault();
if (marriage != null)
return FindMarriageData(marriage);
else
return null;
}
else
{
return null;
}
}
public Marriage(Person person1, Person person2)
{
if(person1.isFemale)
{
this.Husband = person2;
this.Wife = person1;
}
else
{
this.Husband = person1;
this.Wife = person2;
}
this.husband_id = (long) this.Husband.id;
this.wife_id = (long) this.Wife.id;
}
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;
}
private Person GetPersonFromLine(string line)
{
var cells = line.Split(',');
var name = GetString( cells[2]);
if (name == null)
return null;
string numberOfSons = GetString(cells[10]);
if (numberOfSons == null)
numberOfSons = "(?)";
var person = new Person()
{
name = GetString(cells[2]),
fathersSurname = GetString(cells[3]),
mothersSurname = GetString(cells[4]),
dateOfBirth = GetDate(cells[5]),
placeOfBirth = GetString(cells[6]),
dateOfDeath = GetDate(cells[11]),
placeOfDeath = GetString(cells[13]),
info = string.Format("{0} fills. {1}.", numberOfSons, GetString(cells[14])),
isFemale = int.Parse(cells[15]) == 1 ? true : false
};
person.id = (long)_db.Insert(person);
// !!!
int generationNumber = int.Parse(cells[0]);
int customId = int.Parse(Regex.Match(cells[1], @"\d+").Value);
if (_personsDict == null)
_personsDict = new Dictionary< Person, Tuple < int, int>>();
_personsDict.Add( person, new Tuple<int, int>(generationNumber, customId));
return person;
}
