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);
}
// ----------------------- AcVisitorMaster.AddNewVisitor ---------------------------
// create a new AcVisitorMaster row.
public virtual AcVisitorMasterRow AddNewVisitor(Web.AcPage InPage, string InUserId)
{
SqlConnection conn = null;
SqlCommand cmd;
// build the row.
AcVisitorMasterRow row = NewVisitorMasterRow( );
row.VisitorId = System.Guid.NewGuid( ).ToString( );
row.UserId = InUserId;
try
{
conn = InPage.GetDatabaseConnection();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@VisitorId", row.VisitorId));
cmd.Parameters.Add(new SqlParameter("@UserId", row.UserId));
cmd.CommandText =
"INSERT " + TableName +
" ( VisitorId, UserId ) " +
"VALUES( @VisitorId, @UserId )";
cmd.ExecuteNonQuery();
}
catch (SqlException excp)
{
if (SqlCore.TableExists(conn, TableName) == false)
{
throw new AutoCoder.Sql.TableNotFound(TableName);
}
else
{
throw excp;
}
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(row);
}
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);
}
