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