/// <summary>
/// Inserts a new login in the UserLogins table
/// </summary>
/// <param name="user">User to have new login added</param>
/// <param name="login">Login to be added</param>
/// <returns></returns>
/*public int Insert(IdentityUser user, UserLoginInfo login)
* {
* const string commandText = @"INSERT INTO PEC2WEBUSERLOGINS (LOGINPROVIDER, PROVIDERKEY, USERID) VALUES (:LOGINPROVIDER, :PROVIDERKEY, :USERID)";
* var parameters = new List<OracleParameter>
* {
* new OracleParameter{ ParameterName = "USERID", Value = user.Id, OracleDbType = OracleDbType.Varchar2 },
* new OracleParameter{ ParameterName = "LOGINPROVIDER", Value = login.LoginProvider, OracleDbType = OracleDbType.Varchar2 },
* new OracleParameter{ ParameterName = "PROVIDERKEY", Value = login.ProviderKey, OracleDbType = OracleDbType.Varchar2 },
* };
*
* return _database.Execute(commandText, parameters);
* }*/
/// <summary>
/// Return a userId given a user's login
/// </summary>
/// <param name="login"></param>
/// <returns></returns>
public string FindUserNameFromProcess(string sProcessId)
{
// SELECT i.extern_name_id, n.extern_name, n.extern_id FROM INSTANCES i, extern_name N " + "WHERE ProcessInstanceID='" + strInstID + "' AND i.extern_name_id=n.extern_name_id
const string commandText = @"SELECT n.extern_name FROM INSTANCES i, extern_name N " + "WHERE ProcessInstanceID= :PROCESSID AND i.extern_name_id=n.extern_name_id";
var parameters = new List <OracleParameter>
{
new OracleParameter {
ParameterName = "PROCESSID", Value = sProcessId, OracleDbType = OracleDbType.Varchar2
},
};
return(_database.GetStrValue(commandText, parameters));
}