/// <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); }