/// <summary>
/// Deletes a login from a user in the UserLogins table
/// </summary>
/// <param name="user">User to have login deleted</param>
/// <param name="login">Login to be deleted from user</param>
/// <returns></returns>
/*public int Delete(IdentityUser user, UserLoginInfo login)
* {
* const string commandText = @"DELETE FROM PEC2WEBUSERLOGINS WHERE USERID = :USERID AND LOGINPROVIDER = :LOGINPROVIDER AND PROVIDERKEY = :PROVIDERKEY";
* 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>
/// Deletes all Logins from a user in the UserLogins table
/// </summary>
/// <param name="userId">The user's id</param>
/// <returns></returns>
public int Delete(string userId)
{
const string commandText = @"DELETE FROM PEC2WEBUSERLOGINS WHERE USERID = :USERID";
var parameters = new List <OracleParameter>
{
new OracleParameter {
ParameterName = "USERID", Value = userId, OracleDbType = OracleDbType.Varchar2
},
};
return(_database.Execute(commandText, parameters));
}