public Member LoadByID(int ID)
{
DataTable dt = DataTier.GetDataTable("SELECT TOP 1 * FROM MemberDirectory_Members WHERE MemberID = {0}", ID);
if (dt.Rows.Count > 0)
{
return(new Member((int)dt.Rows[0]["MemberID"],
dt.Rows[0]["MemberFirstName"].ToString(),
dt.Rows[0]["MemberLastName"].ToString(),
dt.Rows[0]["MemberTitle"].ToString(),
dt.Rows[0]["MemberEmail"].ToString()
));
}
return(new Member());
}
public List <Member> GetAll()
{
List <Member> members = new List <Member>();
foreach (DataRow row in DataTier.GetDataTable("SELECT * FROM MemberDirectory_Members").Rows)
{
members.Add(new Member(
(int)row["MemberID"],
row["MemberFirstName"].ToString(),
row["MemberLastName"].ToString(),
row["MemberTitle"].ToString(),
row["MemberEmail"].ToString()
));
}
return(members);
}
