public Dictionary<string, bool> GetAllPaths()
{
StringBuilder queryBuilder = new StringBuilder();
queryBuilder.AppendFormat( "SELECT PATH, WEAK_PROTECTION FROM FILESYSTEM" );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
var reader = sql.DoQuery( queryBuilder.ToString() );
var dictionary = new Dictionary<string, bool>();
while ( reader.Read() )
{
string path = reader[ "PATH" ].ToString();
bool weakProtection = Convert.ToInt32( reader[ "WEAK_PROTECTION" ].ToString() ) > 0;
dictionary.Add( path, weakProtection );
}
sql.Close();
return dictionary;
}
public bool HasPasswords()
{
StringBuilder queryBuilder = new StringBuilder();
queryBuilder.AppendFormat( "SELECT COUNT(*) FROM ACCOUNT" );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = Convert.ToInt32( sql.DoScalarQuery( queryBuilder.ToString() ) );
sql.Close();
return num > 0;
}
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 CheckPassword( string password )
{
StringBuilder queryBuilder = new StringBuilder();
string pswd = password.Replace( "'", "''" );
queryBuilder.AppendFormat( "SELECT COUNT(*) FROM ACCOUNT WHERE PASSWORD = '******'", pswd );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = Convert.ToInt32(sql.DoScalarQuery( queryBuilder.ToString() ));
sql.Close();
return num > 0;
}
public bool ExistsPath( string path )
{
StringBuilder queryBuilder = new StringBuilder();
path = path.Replace( "'", "''" );
queryBuilder.AppendFormat( "SELECT COUNT(*) FROM FILESYSTEM WHERE PATH = '{0}'", path );
SqlCore sql = new SqlCore( DataUtils.GetConnectionString() );
sql.Open();
int num = Convert.ToInt32( sql.DoScalarQuery( 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;
}
