/// <summary> /// Inserts a entry in the UserRoles table /// </summary> /// <param name="user">User to have role added</param> /// <param name="roleName">Name of the role to be added to user</param> /// <returns></returns> public Task AddToRoleAsync(TUser user, string roleName) { if (user == null) { throw new ArgumentNullException("user"); } if (string.IsNullOrEmpty(roleName)) { throw new ArgumentException("Argument cannot be null or empty: roleName."); } string roleId = roleTable.GetRoleId(roleName); if (!string.IsNullOrEmpty(roleId)) { userRolesTable.Insert(user, roleId); } return(Task.FromResult <object>(null)); }
/// <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, string role) { RoleTable roleTable = new RoleTable(_database); string roleId = roleTable.GetRoleId(role); string commandText = "Delete from UserRoles where UserId = @userId AND RoleId = @roleId"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("UserId", userId); parameters.Add("RoleId", roleId); return(_database.Execute(commandText, parameters)); }