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; }