//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; }