/// <summary>
/// Returns the user's name given a user id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public string GetUserName(string userId)
{
const string commandText = @"SELECT NAME FROM ANID2USERS WHERE ID = :USERID";
var parameters = new List <OracleParameter>
{
new OracleParameter {
ParameterName = "USERID", Value = userId, OracleDbType = OracleDbType.Varchar2
}
};
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)
{
const string commandText = @"SELECT NAME FROM ANID2ROLES WHERE ID = :ID";
var parameters = new List <OracleParameter>
{
new OracleParameter {
ParameterName = "ID", Value = roleId, OracleDbType = OracleDbType.Varchar2
},
};
return(_database.GetStrValue(commandText, parameters));
}
/// <summary>
/// Return a userId given a user's login
/// </summary>
/// <param name="login"></param>
/// <returns></returns>
public string FindUserIdByLogin(UserLoginInfo login)
{
const string commandText = @"SELECT USERID FROM ANID2USERLOGINS WHERE LOGINPROVIDER = :LOGINPROVIDER AND PROVIDERKEY = :PROVIDERKEY";
var parameters = new List <OracleParameter>
{
new OracleParameter {
ParameterName = "LOGINPROVIDER", Value = login.LoginProvider, OracleDbType = OracleDbType.Varchar2
},
new OracleParameter {
ParameterName = "PROVIDERKEY", Value = login.ProviderKey, OracleDbType = OracleDbType.Varchar2
},
};
return(_database.GetStrValue(commandText, parameters));
}