//Find a Member by a given ID
        public Member FindMemberByID(int id)
        {
            SqlConnection conn = GetConnection();
            string queryStatment = "SELECT firstname,lastname,address, city, phone, email FROM Member WHERE Id = @id";
            Member member = new Member();
            SqlCommand sqlCmd = new SqlCommand(queryStatment, conn);
            SqlParameter param = new SqlParameter();
            param.ParameterName = "@id";
            param.Value = id;
            sqlCmd.Parameters.Add(param);
            try
            {
                conn.Open();
                SqlDataReader reader = sqlCmd.ExecuteReader();
                while (reader.Read())
                {
                    member.FirstName = reader[0].ToString();
                    member.LastName = reader[1].ToString();
                    member.Address = reader[2].ToString();
                    member.City = reader[3].ToString();
                    member.Phone = reader[4].ToString();
                    member.Email = reader[5].ToString();
                }
                reader.Close();
            }
            catch (SqlException ex)
            {
                throw ex;
            }

            finally
            {
                conn.Close();
            }
            return member;
        }
        //Get All Members fromm Database
        public List<Member> GetAllMembers()
        {
            List<Member> memberListToReturn = new List<Member>();
            SqlConnection conn = GetConnection();
            string queryStatment = "SELECT * FROM Member";
            SqlCommand sqlCmd = new SqlCommand(queryStatment, conn);
            try
            {
                conn.Open();
                SqlDataReader reader = sqlCmd.ExecuteReader();
                while (reader.Read())
                {
                    Member memberObj = new Member();
                    memberObj.MemberID = Convert.ToInt32(reader[0].ToString());
                    memberObj.FirstName = reader[1].ToString();
                    memberObj.LastName = reader[2].ToString();
                    memberObj.Address = reader[3].ToString();
                    memberObj.City = reader[4].ToString();
                    memberObj.Phone = reader[5].ToString();
                    memberObj.Email = reader[6].ToString();

                    memberListToReturn.Add(memberObj);
                }
                reader.Close();
            }
            catch (SqlException ex)
            {
                throw ex;
            }
            finally
            {
                conn.Close();
            }
            return memberListToReturn;
        }