public ModifyInterfaceTracingResult ModifyInterfaceTracing(ModifyInterfaceTracingParameters parameters)
{
using (TransactionScope scope = new TransactionScope())
{
ModifyInterfaceTracingResult result = null;
using (IDbConnection connection = new DbConnection(ConnectionString))
{
connection.Open();
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = "SYSTEMCONFIG.MODIFY_LOGG";
((OracleCommand)command).BindByName = true;
foreach (IDbDataParameter parameter in ModifyInterfaceTracingTranslator.TranslateParameters(parameters))
{
command.Parameters.Add(parameter);
}
command.Prepare();
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
result = new ModifyInterfaceTracingResult();
}
}
scope.Complete();
return(result);
}
}
public void Execute(EnableInterfaceTracingParameters parameters)
{
ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[schemaName];
string connectionString = settings.ConnectionString;
ITracingDao tracingDao = PolicyInjection.Create <TracingDao, ITracingDao>(connectionString);
ModifyInterfaceTracingParameters startTracingParameters = new ModifyInterfaceTracingParameters();
startTracingParameters.LoggOn = parameters.IsTracingEnabled;
startTracingParameters.LoggInterval = parameters.DurationInSeconds;
tracingDao.ModifyInterfaceTracing(startTracingParameters);
}
public static IList <IDbDataParameter> TranslateParameters(ModifyInterfaceTracingParameters parameters)
{
IList <IDbDataParameter> parameterList = new List <IDbDataParameter>();
IDbDataParameter dbParameter;
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LOGG_ON_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(string));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LoggOn ? "1" : "0";
parameterList.Add(dbParameter);
dbParameter = new OracleParameter();
dbParameter.ParameterName = "LOGG_INTVL_I";
dbParameter.DbType = DbTypeConvertor.ConvertToDbType(typeof(int));
dbParameter.Direction = ParameterDirection.Input;
dbParameter.Value = parameters.LoggInterval;
parameterList.Add(dbParameter);
return(parameterList);
}
