/// <summary> /// Returns board roles separated by semicolon. /// </summary> private string GetRoles() { // Load the roles into the ListBox DataSet roles = BoardRoleInfoProvider.GetBoardRoles(BoardID, "RoleID,RoleDisplayName"); return(TextHelper.Join(";", DataHelper.GetStringValues(roles.Tables[0], "RoleID"))); }
private ObjectQuery <RoleInfo> GetBoardRoles(params string[] columns) { var roles = RoleInfoProvider.GetRoles() .Columns(columns) .WhereIn("RoleID", BoardRoleInfoProvider.GetBoardRoles() .Column("RoleID") .WhereEquals("BoardID", BoardID)); return(roles); }
/// <summary> /// Reloads the listbox with roles. /// </summary> private void ReloadRoles() { // Load the roles into the ListBox DataSet roles = BoardRoleInfoProvider.GetBoardRoles(BoardID, "RoleID,RoleDisplayName,SiteID"); lstRoles.Items.Clear(); foreach (DataRow dr in roles.Tables[0].Rows) { string name = Convert.ToString(dr["RoleDisplayName"]); if (ValidationHelper.GetInteger(dr["SiteID"], 0) == 0) { name += " " + GetString("general.global"); } lstRoles.Items.Add(new ListItem(name, Convert.ToString(dr["RoleID"]))); } addRoles.CurrentSelector.Value = TextHelper.Join(";", DataHelper.GetStringValues(roles.Tables[0], "RoleID")); }