/// <summary>
/// Deletes all roles from a user in the UserRoles table
/// </summary>
/// <param name="userId">The user's id</param>
/// <returns></returns>
public int Delete(string userId)
{
try
{
ConnectionService.ThreadVanityUrl = ConnectionName;
AspNetUserRolesQuery q = new AspNetUserRolesQuery();
q.Where(q.UserId == userId);
AspNetUserRolesCollection coll = new AspNetUserRolesCollection();
SetConnection(coll);
if (coll.Load(q))
{
coll.MarkAllAsDeleted();
coll.Save();
}
}
catch { }
return(1);
}
/// <summary>
/// Returns a list of user's roles
/// </summary>
/// <param name="userId">The user's id</param>
/// <returns></returns>
public List <string> FindByUserId(string userId)
{
ConnectionService.ThreadVanityUrl = ConnectionName;
List <string> roles = new List <string>();
AspNetRolesQuery r = new AspNetRolesQuery("r");
AspNetUserRolesQuery ur = new AspNetUserRolesQuery("ur");
r.Select(r.Name);
r.InnerJoin(ur).On(ur.UserId == userId && ur.RoleId == r.Id);
AspNetRolesCollection coll = new AspNetRolesCollection();
if (coll.Load(r))
{
foreach (AspNetRoles role in coll)
{
roles.Add(role.Name);
}
}
return(roles);
}
