public static AuthorizedMemberList GetListByAccountID(int accountID)
{
AuthorizedMemberList aMemberList = null;
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
SqlDataReader dr;
SqlCommand cmd = null;
string sql = "Select * from AquaOne.dbo.AuthorizedMember where AccountID = @AccountID";
// Open the connection
conn = myConn.OpenDB();
cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@AccountID", SqlDbType.Int).Value = accountID;
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
aMemberList = new AuthorizedMemberList();
while (dr.Read())
{
aMemberList.Add(FillDataRecord(dr));
}
}
cmd.Dispose();
myConn.CloseDB(conn);
return(aMemberList);
}
private void DisplayAuthorizedMembers(Account accountToView)
{
//Get the members list and then display them in the gridview
AuthorizedMemberList aMemberList = new AuthorizedMemberList();
aMemberList = AuthorizedMemberManager.GetListByAccountID(accountToView.AccountID);
//diplay the members in the gridview
gViewMembers.DataSource = aMemberList;
gViewMembers.DataBind();
}
