/// <summary>
/// Loads a collection of Role objects for the given user
/// </summary>
/// <param name="userId">Id of the user to load the roles for</param>
/// <returns>A collection of Role objects for the given user</returns>
public static RoleCollection LoadForUser(Int32 userId)
{
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT " + Role.GetColumnNames("R"));
selectQuery.Append(" FROM (ac_Roles R INNER JOIN ac_GroupRoles GR ON R.RoleId = GR.RoleId)");
selectQuery.Append(" INNER JOIN ac_UserGroups UG ON GR.GroupId = UG.GroupId");
selectQuery.Append(" WHERE UG.UserId = @userId");
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@userId", System.Data.DbType.Int32, userId);
//EXECUTE THE COMMAND
RoleCollection results = new RoleCollection();
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read())
{
Role role = new Role();
Role.LoadDataReader(role, dr);
results.Add(role);
}
dr.Close();
}
return(results);
}
private void InternalReload()
{
roleIdLookup = new Dictionary <string, int>();
RoleCollection allRoles = RoleDataSource.LoadAll();
foreach (Role role in allRoles)
{
roleIdLookup[role.LoweredName] = role.RoleId;
}
}
/// <summary>
/// Gets a list of all the roles for the configured applicationName.
/// </summary>
/// <returns>A string array containing the names of all the roles stored in the data source for the configured applicationName.</returns>
public override string[] GetAllRoles()
{
RoleCollection roleCollection = RoleDataSource.LoadAll();
string[] allRoles = new string[roleCollection.Count];
for (int index = 0; index < roleCollection.Count; index++)
{
allRoles[index] = roleCollection[index].Name;
}
return(allRoles);
}
public static RoleCollection LoadForGroup(Int32 groupId, int maximumRows, int startRowIndex, string sortExpression)
{
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT");
if (maximumRows > 0)
{
selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString());
}
selectQuery.Append(" " + Role.GetColumnNames("ac_Roles"));
selectQuery.Append(" FROM ac_Roles, ac_GroupRoles");
selectQuery.Append(" WHERE ac_Roles.RoleId = ac_GroupRoles.RoleId");
selectQuery.Append(" AND ac_GroupRoles.GroupId = @groupId");
if (!string.IsNullOrEmpty(sortExpression))
{
selectQuery.Append(" ORDER BY " + sortExpression);
}
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@groupId", System.Data.DbType.Int32, groupId);
//EXECUTE THE COMMAND
RoleCollection results = new RoleCollection();
int thisIndex = 0;
int rowCount = 0;
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows)))
{
if (thisIndex >= startRowIndex)
{
Role role = new Role();
Role.LoadDataReader(role, dr);
results.Add(role);
rowCount++;
}
thisIndex++;
}
dr.Close();
}
return(results);
}
public static RoleCollection LoadForCriteria(string sqlCriteria, int maximumRows, int startRowIndex, string sortExpression)
{
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT");
if (maximumRows > 0)
{
selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString());
}
selectQuery.Append(" " + Role.GetColumnNames(string.Empty));
selectQuery.Append(" FROM ac_Roles");
string whereClause = string.IsNullOrEmpty(sqlCriteria) ? string.Empty : " WHERE " + sqlCriteria;
selectQuery.Append(whereClause);
if (!string.IsNullOrEmpty(sortExpression))
{
selectQuery.Append(" ORDER BY " + sortExpression);
}
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
//EXECUTE THE COMMAND
RoleCollection results = new RoleCollection();
int thisIndex = 0;
int rowCount = 0;
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows)))
{
if (thisIndex >= startRowIndex)
{
Role role = new Role();
Role.LoadDataReader(role, dr);
results.Add(role);
rowCount++;
}
thisIndex++;
}
dr.Close();
}
return(results);
}
/// <summary>
/// Gets a list of the roles that a specified user is in for the configured applicationName.
/// </summary>
/// <param name="username">The user to return a list of roles for.</param>
/// <returns>A string array containing the names of all the roles that the specified user is in for the configured applicationName.</returns>
public override string[] GetRolesForUser(string username)
{
string[] userRoles = new string[0];
User user = UserDataSource.LoadForUserName(username);
if (user != null)
{
RoleCollection roles = RoleDataSource.LoadForUser(user.UserId);
if (roles.Count > 0)
{
userRoles = new string[roles.Count];
for (int i = 0; i < roles.Count; i++)
{
userRoles[i] = roles[i].Name;
}
}
}
return(userRoles);
}
){kind=link}
){kind=link}
){kind=link}
){kind=link}