public void RemoveUserFromRole(string userName, string roleName)
{
userName = userName.ToLower();
Query q = UserRole.CreateQuery();
q.AndWhere(UserRole.Columns.UserId, (GraffitiUsers.GetUser(userName) as User).Id);
q.AndWhere(UserRole.Columns.RoleName, roleName);
UserRoleCollection urCol = new UserRoleCollection();
urCol.LoadAndCloseReader(q.ExecuteReader());
if (urCol.Count > 0)
{
UserRole.Destroy(urCol[0].Id);
}
}
public void AddUserToRole(string userName, string RoleName)
{
userName = userName.ToLower();
User user = (User)GraffitiUsers.GetUser(userName);
Query q = UserRole.CreateQuery();
q.AndWhere(UserRole.Columns.UserId, user.Id);
q.AndWhere(UserRole.Columns.RoleName, RoleName);
UserRoleCollection urCol = new UserRoleCollection();
urCol.LoadAndCloseReader(q.ExecuteReader());
if (urCol.Count == 0)
{
UserRole ur = new UserRole();
ur.UserId = user.Id;
ur.RoleName = RoleName;
ur.Save();
}
}
