public async Task <bool> UnbindRole(Guid userRoleId) { var result = false; var userRole = UserRoleDb.GetById(userRoleId); if (!userRole.IsNull()) { result = await UserRoleDb.AsDeleteable().ExecuteCommandAsync() > 0; } return(result); }
public async Task <List <SystemRole> > GetByUserId(Guid userid) { var roles = RoleDb.GetList(); var userRoles = UserRoleDb.AsQueryable().Where(ur => ur.UserId == userid).Select(ur => ur); foreach (var role in roles) { if (userRoles.Any(x => x.RoleId == role.RoleId)) { role.UserId = userid; } } return(roles); }
public async Task <bool> BindRoles(Guid userId, string[] roleIds) { bool result = false; await UserRoleDb.AsDeleteable().Where(ur => ur.UserId == userId).ExecuteCommandAsync(); foreach (var roleId in roleIds) { var userRole = new UserRole() { Id = Guid.NewGuid(), RoleId = roleId.ToGuid(), UserId = userId }; result = await UserRoleDb.AsInsertable(userRole).ExecuteCommandAsync() > 0; } return(result); }