public bool DeletePassword(string password)
{
StringBuilder queryBuilder = new StringBuilder();
string pswd = password.Replace( "'", "''" );
queryBuilder.AppendFormat( "DELETE FROM ACCOUNT WHERE PASSWORD = '******'", pswd );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = sql.DoNonQuery( queryBuilder.ToString() );
sql.Close();
return num > 0;
}
public bool DeletePath( string path )
{
StringBuilder queryBuilder = new StringBuilder();
path = path.Replace( "'", "''" );
queryBuilder.AppendFormat( "DELETE FROM FILESYSTEM WHERE PATH = '{0}'", path );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = sql.DoNonQuery( queryBuilder.ToString() );
sql.Close();
return num > 0;
}
public bool ChangePassword(string oldPassword, string newPassword)
{
StringBuilder queryBuilder = new StringBuilder();
string oldPswd = oldPassword.Replace( "'", "''" );
string newPswd = newPassword.Replace( "'", "''" );
queryBuilder.AppendFormat( "UPDATE ACCOUNT SET PASSWORD = '******' WHERE PASSWORD = '******'", oldPswd, newPswd );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = sql.DoNonQuery( queryBuilder.ToString() );
sql.Close();
return num > 0;
}
public bool InsertPassword( string password )
{
StringBuilder queryBuilder = new StringBuilder();
string pswd = password.Replace( "'", "''" );
queryBuilder.AppendFormat( "INSERT INTO ACCOUNT (PASSWORD) VALUES ('{0}')", pswd );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = sql.DoNonQuery( queryBuilder.ToString() );
sql.Close();
return num > 0;
}
public bool InsertPath( string path, bool weakProtection )
{
StringBuilder queryBuilder = new StringBuilder();
path = path.Replace( "'", "''" );
int weakProtectionValue = weakProtection ? 1 : 0;
queryBuilder.AppendFormat( "INSERT INTO FILESYSTEM (PATH, WEAK_PROTECTION) VALUES ('{0}', {1})", path, weakProtectionValue );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = sql.DoNonQuery( queryBuilder.ToString() );
sql.Close();
return num > 0;
}
