public override bool DeleteUser(string username, bool deleteAllRelatedData)
{
if (!Initialized)
{
return(_prevProvider.DeleteUser(username, deleteAllRelatedData));
}
int userid = GetUserId(username);
if (userid < 0)
{
return(false);
}
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
if (deleteAllRelatedData)
{
return(dbConn.ExecuteInTransaction(
new List <Tuple <string, object[]> >()
{
new Tuple <string, object[]>(string.Format("delete from {0} where {1}=?;", UserTableName, UserIdColumn), new object [] { userid }),
new Tuple <string, object[]>(string.Format("delete from {0} where userid=?;", _oauthMembershipTable), new object [] { userid }),
new Tuple <string, object[]>(string.Format("delete from {0} where userid=?;", _membershipTable), new object [] { userid }),
new Tuple <string, object[]>(string.Format("delete from {0} where userid=?;", _userInRolesTable), new object [] { userid })
}));
}
else
{
return(dbConn.ExecuteNonQuery(string.Format("delete from {0} where {1}=?;", UserTableName, UserIdColumn), userid) > 0);
}
}
}
public override bool DeleteUser(string username, bool deleteAllRelatedData)
{
if (!Initialized)
return _prevProvider.DeleteUser(username, deleteAllRelatedData);
int userid = GetUserId(username);
if (userid < 0)
return false;
using (MySqlDatabaseWrapper dbConn = new MySqlDatabaseWrapper(GetConnectionString()))
{
if (deleteAllRelatedData)
{
return dbConn.ExecuteInTransaction(
new List<Tuple<string, object[]>>()
{
new Tuple<string, object[]>(string.Format("delete from {0} where {1}=?;", UserTableName, UserIdColumn), new object [] { userid }),
new Tuple<string, object[]>(string.Format("delete from {0} where userid=?;", _oauthMembershipTable), new object [] { userid }),
new Tuple<string, object[]>(string.Format("delete from {0} where userid=?;", _membershipTable), new object [] { userid }),
new Tuple<string, object[]>(string.Format("delete from {0} where userid=?;", _userInRolesTable), new object [] { userid })
});
}
else
{
return (dbConn.ExecuteNonQuery(string.Format("delete from {0} where {1}=?;", UserTableName, UserIdColumn), userid) > 0);
}
}
}