/// <summary> /// Gets the user's name, provided with an ID. /// </summary> /// <param name="userId"></param> /// <returns></returns> public string GetUserName(string userId) { string commandText = "SELECT UserName FROM " + _tableName + " WHERE Id = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>() { { "@id", userId } }; return(_database.GetStrValue(commandText, parameters)); }
/// <summary> /// Returns a role name given the roleId. /// </summary> /// <param name="roleId">The role Id.</param> /// <returns>Role name.</returns> public string GetRoleName(string roleId) { string commandText = "SELECT Name FROM AspNetRoles WHERE Id = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@id", roleId); return(_database.GetStrValue(commandText, parameters)); }
/// <summary> /// Return a user ID given a user's login. /// </summary> /// <param name="userLogin">The user's login info.</param> /// <returns></returns> public string FindUserIdByLogin(UserLoginInfo userLogin) { string commandText = "SELECT UserId FROM AspNetUserLogins WHERE LoginProvider = @loginProvider AND ProviderKey = @providerKey"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("loginProvider", userLogin.LoginProvider); parameters.Add("providerKey", userLogin.ProviderKey); return(_database.GetStrValue(commandText, parameters)); }