A reporting service using SOAP calls passing XML to a Data Extension

using System;
using System.Xml;
using System.Diagnostics;
using System.Collections;

using Microsoft.ReportingServices.DataProcessing;

namespace CustomDataExtension
{
	/// <summary>
	/// </summary>
	public class DataSetCommand : IDbCommand 
	{
		private string _commandText;
		private DataSetParameterCollection _parameters = new DataSetParameterCollection();

		/// <summary>
		/// Default Constructor
		/// </summary>
		public DataSetCommand() {}

		/// <summary>
		/// Attempts to cancel the current command
		/// </summary>
		public void Cancel () 
		{
			throw (new NotSupportedException ("Command cancellation is not currently supported"));
		}

		/// <summary>
		/// Gets/sets the current command type
		/// </summary>
		/// <remarks>
		/// Only the Text command type is supported for this extension
		/// </remarks>
		public CommandType CommandType 
		{
			get { return (CommandType.Text); }
			set 
			{
				if (value != CommandType.Text)
					throw (new NotSupportedException ("Only the Text command type is supported for this extension"));
			}
		}

		/// <summary>
		/// Retrieves an interface used to retrieve data and schema information
		/// </summary>
		/// <param name="behavior">The requested behavior</param>
		/// <returns>An interface to a data reader object</returns>
		public IDataReader ExecuteReader(CommandBehavior behavior) 
		{
			XmlDocument doc = new XmlDocument();
			try
			{
				// load the CommandText XML and append dataset parameters
				doc.LoadXml(CommandText);

				// Append all the dataset parameter
				// example: WebMethod contains which web service method to execute.				
				DataSetParameter parameter = null;
				IEnumerator enumerator = _parameters.GetEnumerator();
				while (enumerator.MoveNext())
				{
					parameter = (DataSetParameter) enumerator.Current;
					XmlElement elem = doc.CreateElement(parameter.ParameterName);
					elem.AppendChild(doc.CreateTextNode(parameter.Value.ToString()));
					doc.DocumentElement.AppendChild(elem);
				}
			}
			catch (Exception ex)
			{
				throw new Exception("Invalid Xml command Text: " + CommandText, ex);
			}

			return new DataSetDataReader(doc.InnerXml);
		}

		/// <summary>
		/// Gets/sets the command timeout.
		/// </summary>
		/// <remarks>
		/// A CommandTimeout other than 0 is not supported by this extension.
		/// </remarks>
		public Int32 CommandTimeout 
		{
			get {return (0);}
			set {} //Do nothing
		}

		/// <summary>
		/// Gets/sets the current command text
		/// </summary>
		/// <remarks>
		/// This CommandText will be an XML string containing filter information etc.
		/// </remarks>
			public String CommandText 
			{
				get { return (this._commandText); }
				set { this._commandText = value; }
			}

		/// <summary>
		/// Gets/sets an object that allows action on the transaction
		/// </summary>
		/// <returns>null since we do not support transactions</returns>
		public IDbTransaction Transaction 
		{
			get { return null; }
			set { throw (new NotSupportedException());	}
		}


		IDataParameterCollection IDbCommand.Parameters
		{
			get  { return _parameters; }
		}


		/// <summary>
		/// Creates a new data parameter (not used)
		/// </summary>
		public IDataParameter CreateParameter() 
		{
			return (IDataParameter)(new DataSetParameter()) ;
		}

		/// <summary>
		/// Retreives the current parameters list (not used)
		/// </summary>
		public IDataParameterCollection Parameters 
		{
			get { return _parameters; }
		}

		/// <summary>
		/// Dispose of any held resources
		/// </summary>
		public void Dispose() 
		{
			if (_parameters != null)
			{
				_parameters.Dispose();
			}
		}
	}
}