public AccessPolicy AddNewPolicy(string strPolicyName, string strPolicy)
{
// Quick error checks
if (strPolicy == null || strPolicy.Length == 0)
{
throw new ArgumentException("Invalid policy", "strPolicy");
}
if (strPolicyName == null || strPolicyName.Length == 0)
{
throw new ArgumentException("Invalid policy name", "strPolicyName");
}
AccessPolicy policy = null;
string strPolicyID = Guid.NewGuid().ToString();
try
{
StringBuilder strQueryBuilder = new StringBuilder();
strQueryBuilder.Append(" INSERT INTO ");
strQueryBuilder.Append(Constants.ACCESS_POLICIES_TABLENAME);
strQueryBuilder.Append("(");
strQueryBuilder.Append(Constants.ACCPOL_ID);
strQueryBuilder.Append(",");
strQueryBuilder.Append(Constants.ACCPOL_NAME);
strQueryBuilder.Append(",");
strQueryBuilder.Append(Constants.ACCPOL_DOC);
strQueryBuilder.Append(")");
strQueryBuilder.Append(" VALUES ");
strQueryBuilder.Append("(");
strQueryBuilder.Append("'" + QueryService.MakeQuotesafe(strPolicyID) + "'");
strQueryBuilder.Append(",");
strQueryBuilder.Append("'" + QueryService.MakeQuotesafe(strPolicyName) + "'");
strQueryBuilder.Append(",");
strQueryBuilder.Append("'" + QueryService.MakeQuotesafe(strPolicy) + "'");
strQueryBuilder.Append(")");
int nRowsAffected = QueryService.ExecuteNonQuery(this.DBConnect, strQueryBuilder.ToString());
if (nRowsAffected == 1)
{
policy = new AccessPolicy();
policy.Name = strPolicyName;
policy.Id = strPolicyID;
policy.Document = strPolicy;
}
}
catch (Exception /*e*/)
{
}
finally
{
}
return(policy);
}
public AccessPolicy GetPolicy(string strPolicyID)
{
// Quick error checks
if (strPolicyID == null || strPolicyID.Length == 0)
{
throw new ArgumentException("Invalid policy ID", "strPolicyID");
}
OdbcDataReader dr = null;
AccessPolicy policy = null;
try
{
StringBuilder strQueryBuilder = new StringBuilder();
strQueryBuilder.Append(" SELECT ");
strQueryBuilder.Append("*");
strQueryBuilder.Append(" FROM ");
strQueryBuilder.Append(Constants.ACCESS_POLICIES_TABLENAME);
strQueryBuilder.Append(" WHERE ");
strQueryBuilder.Append(Constants.ACCPOL_ID);
strQueryBuilder.Append("=");
strQueryBuilder.Append("'" + QueryService.MakeQuotesafe(strPolicyID) + "'");
dr = QueryService.ExecuteReader(this.DBConnect, strQueryBuilder.ToString());
if (dr == null)
{
throw new Exception("Null data reader returned from query");
}
// Take first entry returned
if (dr.Read())
{
policy = new AccessPolicy();
policy.Name = (string)dr[Constants.ACCPOL_NAME];
policy.Id = (string)dr[Constants.ACCPOL_ID];
policy.Document = (string)dr[Constants.ACCPOL_DOC];
}
}
catch (Exception /*e*/)
{
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(policy);
}
public ArrayList GetAllPolicies()
{
OdbcDataReader dr = null;
AccessPolicy policy = null;
ArrayList policies = new ArrayList();
try
{
StringBuilder strQueryBuilder = new StringBuilder();
strQueryBuilder.Append(" SELECT ");
strQueryBuilder.Append("*");
strQueryBuilder.Append(" FROM ");
strQueryBuilder.Append(Constants.ACCESS_POLICIES_TABLENAME);
dr = QueryService.ExecuteReader(this.DBConnect, strQueryBuilder.ToString());
if (dr == null)
{
throw new Exception("Null data reader returned from query");
}
while (dr.Read())
{
policy = new AccessPolicy();
policy.Name = (string)dr[Constants.ACCPOL_NAME];
policy.Id = (string)dr[Constants.ACCPOL_ID];
policy.Document = (string)dr[Constants.ACCPOL_DOC];
policies.Add(policy);
}
}
catch (Exception e)
{
Console.WriteLine("Exception in GetAllPolicies(): " + e);
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return(policies);
}