public OrgMember getOrgMemberByStudID(int studID, ref bool GPABoard, ref bool GPAOrg)
        {
            OrgMember member = new OrgMember();
            var       mem    = dataContext.sp_GetStudentByStudID(studID).First();

            member.Student_ID = studID;
            member.LastName   = mem.LastName;
            member.FirstName  = mem.FirstName;
            member.CarrollID  = Convert.ToInt32(mem.Carroll_ID);
            if (mem.GPABoard == true)
            {
                GPABoard = true;
            }
            else
            {
                GPABoard = false;
            }
            if (mem.GPAOrg == true)
            {
                GPAOrg = true;
            }
            else
            {
                GPAOrg = false;
            }
            return(member);
        }
        public bool updateOrganizationMembers(int orgID, List <OrgMember> newMemberList)
        {
            try
            {
                List <OrgMember> oldMemberList = new List <OrgMember>();
                var advis = dataContext.sp_GetMembersByOrgID(orgID);
                foreach (var x in advis)
                {
                    OrgMember member = new OrgMember();
                    member.Student_ID = x.Student_ID;
                    member.LastName   = x.LastName;
                    member.FirstName  = x.FirstName;
                    oldMemberList.Add(member);
                }

                for (int i = 0; i < oldMemberList.Count; ++i)
                {
                    for (int j = 0; j < newMemberList.Count; ++j)
                    {
                        if (oldMemberList[i].Student_ID == newMemberList[j].Student_ID)
                        {
                            oldMemberList[i].FirstName = "Please Delete";
                        }
                    }
                }

                for (int i = 0; i < oldMemberList.Count; ++i)
                {
                    if (oldMemberList[i].FirstName != "Please Delete")
                    {
                        dataContext.sp_UpdateStudentRosterRow(oldMemberList[i].Student_ID, orgID);
                    }
                }
                for (int i = 0; i < newMemberList.Count; ++i)
                {
                    dataContext.sp_NewStudentRosterRow(orgID, newMemberList[i].Student_ID);
                }
            }
            catch (Exception)
            {
                return(false);
            }

            return(true);
        }
        public List <OrgMember> getMembersByOrgID(int orgID)
        {
            List <OrgMember> members = new List <OrgMember>();
            var mem = dataContext.sp_GetMembersByOrgID(orgID);

            foreach (var x in mem)
            {
                OrgMember member = new OrgMember();
                member.Position         = x.MemberName;
                member.MemberID         = x.Member_ID;
                member.LastName         = x.LastName;
                member.FirstName        = x.FirstName;
                member.CarrollID        = Convert.ToInt32(x.Carroll_ID);
                member.IsPrimaryContact = Convert.ToBoolean(x.PrimaryContact);
                member.AddDate          = Convert.ToDateTime(x.BeginDate).ToShortDateString();
                member.Student_ID       = x.Student_ID;
                //member.Status = x.StatusName;

                members.Add(member);
            }
            return(members);
        }