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