public IEnumerable <MemberWithContactDetails> GetAllMembersGroupedAsFamilyFlatStructure()
{
List <MemberWithContactDetails> l_returnAddressWithContactDetails = new List <MemberWithContactDetails>();
using (CNSConnection l_connection = new CNSConnection())
{
foreach (Contact l_familyHead in l_connection.Relationships.Where(r => r.RelationshipType.relationshiptype_id == 1).Select(r => r.Contact1).OrderBy(c => c.first_name).ThenBy(c => c.last_name))
{
MemberWithContactDetails l_memberWithContactDetails = new MemberWithContactDetails();
l_memberWithContactDetails.Contact = l_familyHead;
l_memberWithContactDetails.ContactAddress = l_familyHead.Address;
l_memberWithContactDetails.ContactPhones = l_familyHead.Phones;
l_returnAddressWithContactDetails.Add(l_memberWithContactDetails);
foreach (Relationship l_relationship in l_familyHead.Relationships)
{
MemberWithContactDetails l_relatedMemberWithContactDetails = new MemberWithContactDetails();
l_relatedMemberWithContactDetails.Contact = l_relationship.Contact1;
l_relatedMemberWithContactDetails.ContactAddress = l_relationship.Contact1.Address;
l_relatedMemberWithContactDetails.ContactPhones = l_relationship.Contact1.Phones;
l_returnAddressWithContactDetails.Add(l_relatedMemberWithContactDetails);
}
}
}
return(l_returnAddressWithContactDetails);
}
public IEnumerable <IEnumerable <Tuple <MemberWithContactDetails, string> > > GetAllMemberswithContactDetailsGroupedAsFamily()
{
List <List <Tuple <MemberWithContactDetails, string> > > l_returnAddressWithContactDetails = new List <List <Tuple <MemberWithContactDetails, string> > >();
using (CNSConnection l_connection = new CNSConnection())
{
foreach (Contact l_familyHead in l_connection.Relationships.Where(r => r.RelationshipType.relationshiptype_id == 1).Select(r => r.Contact1).OrderBy(c => c.first_name).ThenBy(c => c.last_name))
{
List <Tuple <MemberWithContactDetails, string> > l_familyMembersContactDetails = new List <Tuple <MemberWithContactDetails, string> >();
MemberWithContactDetails l_memberWithContactDetails = new MemberWithContactDetails();
l_memberWithContactDetails.Contact = l_familyHead;
l_memberWithContactDetails.ContactAddress = l_familyHead.Address;
l_memberWithContactDetails.ContactPhones = l_familyHead.Phones;
l_familyMembersContactDetails.Add(new Tuple <MemberWithContactDetails, string>(l_memberWithContactDetails, "Head"));
foreach (Relationship l_relationship in l_familyHead.Relationships.OrderBy(r => r.RelationshipType.relationshiptype_id))
{
MemberWithContactDetails l_relatedMemberWithContactDetails = new MemberWithContactDetails();
l_relatedMemberWithContactDetails.Contact = l_relationship.Contact1;
l_relatedMemberWithContactDetails.ContactAddress = l_relationship.Contact1.Address;
l_relatedMemberWithContactDetails.ContactPhones = l_relationship.Contact1.Phones;
string l_relationshipType = l_relationship.RelationshipType.relationshiptype1;
l_familyMembersContactDetails.Add(new Tuple <MemberWithContactDetails, string>(l_relatedMemberWithContactDetails, l_relationshipType));
}
l_returnAddressWithContactDetails.Add(l_familyMembersContactDetails);
}
}
return(l_returnAddressWithContactDetails);
}
public IEnumerable <MemberWithContactDetails> GetAllMemberswithContactDetailsSortedAlphabetically()
{
List <MemberWithContactDetails> l_returnAddressWithContactDetails = new List <MemberWithContactDetails>();
using (CNSConnection l_connection = new CNSConnection())
{
foreach (Contact l_contact in l_connection.Contacts.OrderBy(c => c.first_name).ThenBy(c => c.last_name))
{
MemberWithContactDetails l_AddressWithContactDetails = new MemberWithContactDetails();
l_AddressWithContactDetails.Contact = l_contact;
l_AddressWithContactDetails.ContactAddress = l_contact.Address;
l_AddressWithContactDetails.ContactPhones = l_contact.Phones;
l_returnAddressWithContactDetails.Add(l_AddressWithContactDetails);
}
}
return(l_returnAddressWithContactDetails);
}
public List <KidsWithParentContactDetails> GetAllKidsWIthParentContactInformation()
{
List <KidsWithParentContactDetails> l_KidsWithParentContactDetails = new List <KidsWithParentContactDetails>();
using (CNSConnection l_connection = new CNSConnection())
{
foreach (
Contact l_child in
l_connection.Relationships.Where(r => r.RelationshipType.relationshiptype_id == 3 || r.RelationshipType.relationshiptype_id == 4).Select(r => r.Contact1).OrderBy(c => c.last_name).ThenBy(c => c.first_name))
{
var l_firstParent = l_child.Relationships1.First().Contact;
var l_firstParentWithContactDetails = new MemberWithContactDetails()
{
Contact = l_firstParent, ContactAddress = l_firstParent.Address, ContactPhones = l_firstParent.Phones
};
var l_secondParent = l_firstParent.Relationships.Where(r => r.RelationshipType.relationshiptype_id == 2).Select(c => c.Contact1).FirstOrDefault();
List <MemberWithContactDetails> l_parents = new List <MemberWithContactDetails> {
l_firstParentWithContactDetails
};
if (l_secondParent != null)
{
var l_secondParentWithContactDetails = new MemberWithContactDetails()
{
Contact = l_secondParent, ContactAddress = l_secondParent.Address, ContactPhones = l_secondParent.Phones
};
l_parents.Add(l_secondParentWithContactDetails);
}
KidsWithParentContactDetails l_KidsWithParent = new KidsWithParentContactDetails()
{
Child = l_child,
Parents = l_parents
};
l_KidsWithParentContactDetails.Add(l_KidsWithParent);
}
}
return(l_KidsWithParentContactDetails);
}
