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); }