public override void Update(ScopeRule r)
{
try
{
string sql = String.Format("update {0}.SCOPE_RULE set "
+ " SCOPE_RULE = :SCOPE_RULE "
+ " ,DESCR = :DESCR "
+ " where "
+ " SCOPE_RULE = :SCOPE_RULE"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":SCOPE_RULE", CheckNull(r.SCOPE_RULE), OracleType.VarChar, ParameterDirection.Input));
parameters.Add(OracleHelper.CreateParameter(":DESCR", CheckNull(r.DESCR), OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
r.Modified = false;
}
catch (OracleException ex)
{
throw ex;
}
catch (Exception x)
{
throw x;
}
}
protected override void RowConverter(ScopeRule r, DataRow record)
{
try
{
r.SCOPE_RULE = CastDbValueRow(record, "SCOPE_RULE");
r.DESCR = CastDbValueRow(record, "DESCR");
r.Modified = false;
}
catch (Exception ex)
{
throw ex;
}
}
public override void Remove(ScopeRule package)
{
string sql;
try
{
sql = String.Format("DELETE FROM {0}.SCOPE_RULE WHERE "
+ " SCOPE_RULE = :SCOPE_RULE"
, SchemaName);
List <OracleParameter> parameters = new List <OracleParameter>();
parameters.Add(OracleHelper.CreateParameter(":SCOPE_RULE", package.SCOPE_RULE, OracleType.VarChar, ParameterDirection.Input));
OracleParameterCollection outParams = OracleHelper.ExecuteNonQuery(base.ConnectionString.Value, sql, parameters.ToArray <OracleParameter>());
package.Modified = false;
}
catch (OracleException ex)
{
throw ex;
}
}
public override ScopeRule Get(ScopeRule entity)
{
throw new NotImplementedException();
}
