private void LoadMember(int ID)
        {
            try
            {
                MembershipTableAdapters.MembersTableAdapter daMember = new MembershipTableAdapters.MembersTableAdapter();
                Membership.MembersDataTable dtMember = new Membership.MembersDataTable();

                daMember.Fill(dtMember);
                Membership.MembersRow row = dtMember.FindByID(ID);

                _ID           = row.ID;
                _LastName     = (row.Last_Name == null ? string.Empty : row.Last_Name);
                _FirstName    = (row.First_Name == null ? string.Empty : row.First_Name);
                _Address      = (row.Address == null ? string.Empty : row.Address);
                _CityProv     = (row.City__Prov == null ? string.Empty : row.City__Prov);
                _Postal       = (row.Postal == null ? string.Empty : row.Postal);
                _Phone        = (row.Phone == null ? string.Empty : row.Phone);
                _Email        = (row.Email_Address == null ? string.Empty : row.Email_Address);
                _MemberTypeID = row.MemberTypeID;
                _JoinedDate   = row.Date_Joined;
                _BirthDate    = row.Birth_Date;
                _Walk         = (row.Walk == null ? string.Empty : row.Walk);
                _Pal          = row.Pal;
                _PalExpDate   = row.Pal_Exp_Date;
                _UserName     = (row.Website_Usernames == null ? string.Empty : row.Website_Usernames);
                _NoBackTrack  = row.NoBackTrack;
                _NoEmail      = row.NoEmailing;
                _MasterRecord = row.MasterRecord;
                if (_MasterRecord > 0)
                {
                    MasterRecordName = getMasterRecordName(row.MasterRecord);
                }
                _SectionFlag   = row.SectionFlag;
                _Card          = row.Card;
                _paidHistory   = getPaidHistory();
                _ExtraCards    = getExtraCards();
                _Active        = row.Active;
                _Notes         = (row.Notes == null ? string.Empty : row.Notes);
                _SwipeCard     = row.Swipe;
                _Cell          = (row.Cell == null ? string.Empty : row.Cell);
                _Participation = row.Participation;
                _pOther        = (row.pOther == null ? string.Empty : row.pOther);
                BadgeImage     = row.Image;
                _CardMade      = row.CardMade;
                _Sponsor       = row.Sponsor;
            }
            catch (Exception ex)
            {
                ErrorLogger.Log("Error loading member information", ex, true);
            }
        }
        private void PromoteMember()
        {
            try
            {
                MembershipTableAdapters.MembersTableAdapter daMember = new MembershipTableAdapters.MembersTableAdapter();
                Membership.MembersDataTable dtMember = new Membership.MembersDataTable();

                daMember.Fill(dtMember);
                Membership.MembersRow row = dtMember.FindByID(this.MasterRecord);

                SectionFlag  = row.SectionFlag;
                MemberTypeID = 5;
                MasterRecord = -1;

                setDefaultPaid();
            }
            catch (Exception ex)
            {
                ErrorLogger.Log("Error trying to promot extra card", ex, true);
            }
        }