public static List <UsersGroups> getList(int groupID)
{
var conn = new SqlConnection(Constants.SqlConnectionString);
conn.Open();
var query = $"SELECT u.* FROM USERS u JOIN GroupMembers gm ON u.UserID = gm.UserID WHERE gm.GroupID = '{groupID}'";
var sqlAdapter = new SqlDataAdapter(query, conn);
var table = new DataTable();
sqlAdapter.Fill(table);
sqlAdapter.Dispose();
conn.Close();
conn.Dispose();
List <UsersGroups> u = new List <UsersGroups>();
foreach (DataRow row in table.Rows)
{
var group = new UsersGroups();
group.UserID = int.Parse(row["UserID"].ToString());
group.Name = row["FName"].ToString() + " " + row["LName"].ToString();
u.Add(group);
}
return(u);
}
protected void Page_Load(object sender, EventArgs e)
{
this.Users = UsersGroups.getList(GroupID);
this.Messages = Message.LoadMessages(GroupID);
}
