private void ViewAllMembers()
        {
            var db         = new FamilyMembersManagementEntities();
            var members    = db.members.ToArray();
            var memberView = new MemberView[members.Length];

            for (int i = 0; i < members.Length; i++)
            {
                memberView[i] = new MemberView(members[i]);
            }
            this.dataGridView1.DataSource = memberView;
        }
        public MemberView(member member)
        {
            this.id       = member.id;
            this.fullname = member.fullname;
            this.gender   = member.gender == true ? "Male" : "Female";
            if (member.birthday != null)
            {
                this.birthday = string.Format("{0}/{1}/{2}",
                                              member.birthday.Value.Day,
                                              member.birthday.Value.Month,
                                              member.birthday.Value.Year
                                              );
            }
            if (member.status.HasValue)
            {
                this.status = member.status.Value == true ? "Living" : "Deceased";
            }
            var db = new FamilyMembersManagementEntities();

            if (member.Father_id.HasValue)
            {
                var father = db.members.Find(member.Father_id.Value);
                this.Father_id = father.fullname;
            }

            if (member.Mother_id.HasValue)
            {
                var mother = db.members.Find(member.Mother_id.Value);
                this.Mother_id = mother.fullname;
            }

            if (member.spouse_id.HasValue)
            {
                var spouse = db.members.Find(member.spouse_id.Value);
                this.spouse_id = spouse.fullname;
            }
            this.hometown   = member.hometown;
            this.living     = member.living;
            this.occupation = member.occupation;
        }