public GetMessageXMLResult GetErrorWarningXML(GetMessageXMLParameters parameters)
{
using (TransactionScope scope = new TransactionScope())
{
GetMessageXMLResult result = null;
using (IDbConnection connection = new DbConnection(ConnectionString))
{
connection.Open();
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = "UIMessageHandler.GetErrorWarningXML";
((OracleCommand)command).BindByName = true;
foreach (IDbDataParameter parameter in GetMessageXMLTranslator.TranslateParameters(parameters))
{
command.Parameters.Add(parameter);
}
command.Prepare();
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
result = GetMessageXMLTranslator.TranslateResult(command.Parameters);
}
}
scope.Complete();
return(result);
}
}
public static GetMessageXMLResult TranslateResult(IDataParameterCollection resultParameters)
{
GetMessageXMLResult result = new GetMessageXMLResult();
object data;
data = ((IDbDataParameter)resultParameters["XML_O"]).Value;
if (data != null && !((OracleClob)data).IsNull)
{
result.MessageXML = ((OracleClob)data).Value;
}
return(result);
}