public static void AddRelatedFamily(int familyId, int relatedPersonId)
{
var p = DbUtil.Db.LoadPersonById(relatedPersonId);
var rf = DbUtil.Db.RelatedFamilies.SingleOrDefault(r =>
(r.FamilyId == familyId && r.RelatedFamilyId == p.FamilyId) ||
(r.FamilyId == p.FamilyId && r.RelatedFamilyId == familyId)
);
if (rf == null)
{
rf = new RelatedFamily
{
FamilyId = familyId,
RelatedFamilyId = p.FamilyId,
FamilyRelationshipDesc = "Add Description",
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
};
DbUtil.Db.RelatedFamilies.InsertOnSubmit(rf);
DbUtil.Db.SubmitChanges();
}
}
public static string AddRelatedFamily(int peopleid, int relatedPersonId)
{
var p = DbUtil.Db.LoadPersonById(peopleid);
var p2 = DbUtil.Db.LoadPersonById(relatedPersonId);
var rf = DbUtil.Db.RelatedFamilies.SingleOrDefault(r =>
(r.FamilyId == p.FamilyId && r.RelatedFamilyId == p2.FamilyId) ||
(r.FamilyId == p2.FamilyId && r.RelatedFamilyId == p.FamilyId)
);
if (rf == null)
{
rf = new RelatedFamily
{
FamilyId = p.FamilyId,
RelatedFamilyId = p2.FamilyId,
FamilyRelationshipDesc = "",
CreatedBy = Util.UserId1,
CreatedDate = Util.Now,
};
DbUtil.Db.RelatedFamilies.InsertOnSubmit(rf);
DbUtil.Db.SubmitChanges();
}
return("#rf-{0}-{1}".Fmt(rf.FamilyId, rf.RelatedFamilyId));
}
