public override string GeneratePasswordResetToken(string userName, int tokenExpirationInMinutesFromNow)
{
IsValidOperation(true);
if (string.IsNullOrEmpty(userName))
{
NullArgumentException("username");
}
int userid = GetUserId(userName);
if (userid <= 0)
{
InvalidUserException(userName);
}
if (UserConfirmed(userid))
{
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
string token = dbConn.ExecuteScalar(string.Format("select PasswordVerificationToken from {0} where userid=? and PasswordVerificationTokenExpirationDate > ?;", _membershipTable), userid, DateTime.Now) as string;
if (token != null)
{
token = GenerateToken();
if (dbConn.ExecuteNonQuery(string.Format("update {0} set PasswordVerificationToken=?, PasswordVerificationTokenExpirationDate=? where userid=?;", _membershipTable), token, DateTime.Now.AddMinutes(tokenExpirationInMinutesFromNow), userid) <= 0)
{
throw new ProviderException(Resources.GeneratePassVerificationTokenFailed);
}
}
return(token);
}
}
return(null);
}
private bool UserConfirmed(int userId)
{
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
return(((long)dbConn.ExecuteScalar(string.Format("select count(*) from {0} where userid=? and isconfirmed=1;", _membershipTable), userId)) > 0);
}
}
public override string GetUserNameFromId(int userId)
{
IsValidOperation(true);
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
return(dbConn.ExecuteScalar(string.Format("select {0} from {1} where {2}=?;", UserNameColumn, UserTableName, UserIdColumn), userId) as string);
}
}
public override string GetOAuthTokenSecret(string token)
{
IsValidOperation(true);
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
return(dbConn.ExecuteScalar(string.Format("select secret from {0} where token=?;", _oauthTokenTable), token) as string);
}
}
private int GetPasswordFailuresSinceLastSuccess(int userId)
{
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
var failures = dbConn.ExecuteScalar(string.Format("select PasswordFailuresSinceLastSuccess from {0} where userid=?;", _membershipTable), userId);
if (failures != null)
{
return((int)failures);
}
return(-1);
}
}
public override DateTime GetPasswordChangedDate(string userName)
{
int userid = GetUserId(userName);
if (userid < 0)
{
InvalidUserException(userName);
}
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
var changedDate = dbConn.ExecuteScalar(string.Format("select PasswordChangedDate from {0} where userid=?;", _membershipTable), userid);
if (changedDate != null)
{
return((DateTime)changedDate);
}
return(DateTime.MinValue);
}
}
public override string GetUserNameFromId(int userId)
{
IsValidOperation(true);
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
return dbConn.ExecuteScalar(string.Format("select {0} from {1} where {2}=?;", UserNameColumn, UserTableName, UserIdColumn), userId) as string;
}
}
public override string GetOAuthTokenSecret(string token)
{
IsValidOperation(true);
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
return dbConn.ExecuteScalar(string.Format("select secret from {0} where token=?;", _oauthTokenTable), token) as string;
}
}
private int GetPasswordFailuresSinceLastSuccess(int userId)
{
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
var failures = dbConn.ExecuteScalar(string.Format("select PasswordFailuresSinceLastSuccess from {0} where userid=?;", _membershipTable), userId);
if (failures != null)
return (int)failures;
return -1;
}
}
public override DateTime GetPasswordChangedDate(string userName)
{
int userid = GetUserId(userName);
if (userid < 0)
InvalidUserException(userName);
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
var changedDate = dbConn.ExecuteScalar(string.Format("select PasswordChangedDate from {0} where userid=?;", _membershipTable), userid);
if (changedDate != null)
return (DateTime)changedDate;
return DateTime.MinValue;
}
}
public override string GeneratePasswordResetToken(string userName, int tokenExpirationInMinutesFromNow)
{
IsValidOperation(true);
if (string.IsNullOrEmpty(userName))
NullArgumentException("username");
int userid = GetUserId(userName);
if (userid <= 0)
InvalidUserException(userName);
if (UserConfirmed(userid))
{
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
string token = dbConn.ExecuteScalar(string.Format("select PasswordVerificationToken from {0} where userid=? and PasswordVerificationTokenExpirationDate > ?;", _membershipTable), userid, DateTime.Now) as string;
if (token != null)
{
token = GenerateToken();
if (dbConn.ExecuteNonQuery(string.Format("update {0} set PasswordVerificationToken=?, PasswordVerificationTokenExpirationDate=? where userid=?;", _membershipTable), token, DateTime.Now.AddMinutes(tokenExpirationInMinutesFromNow), userid) <= 0)
{
throw new ProviderException(Resources.GeneratePassVerificationTokenFailed);
}
}
return token;
}
}
return null;
}
private bool UserConfirmed(int userId)
{
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
return ((long)dbConn.ExecuteScalar(string.Format("select count(*) from {0} where userid=? and isconfirmed=1;", _membershipTable), userId)) > 0;
}
}
