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