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; }