/// <summary>
/// Sets the value of the designated parameter using the given object.
/// </summary>
/// <param name="statementId">The statement id.</param>
/// <param name="parameterIndex">the first parameter is 1, the second is 2, ...</param>
/// <param name="value">the object containing the input parameter value</param>
/// <exception name="EPException">if the substitution parameter could not be located</exception>
public void SetObject(string statementId, int parameterIndex, Object value)
{
using (var wrapper = CreateControlManager())
{
WithExceptionHandling(
delegate
{
var controlManager = wrapper.Channel;
var preparedValueArgs = new PreparedValueArgs();
preparedValueArgs.DataType = value.GetType().FullName;
preparedValueArgs.Data = SerializationFabric.Serialize(value);
preparedValueArgs.ParameterIndex = parameterIndex;
controlManager.SetPreparedValue(
_instanceId,
statementId,
preparedValueArgs);
});
}
}
/// <summary>
/// Sets a value within the prepared statement.
/// </summary>
/// <param name="instanceId">The instance id.</param>
/// <param name="statementId">The statement id.</param>
/// <param name="preparedValueArgs">The prepared value args.</param>
public void SetPreparedValue(string instanceId, string statementId, PreparedValueArgs preparedValueArgs)
{
try
{
var instance = GetInstanceOrFault(instanceId);
var fabricator = instance.SchemaFabricator;
var fabricationValue = fabricator.Fabricate(
preparedValueArgs.Data,
preparedValueArgs.DataType);
instance.SetPreparedValue(
statementId,
preparedValueArgs.ParameterIndex,
fabricationValue);
}
catch (EPException e)
{
Log.Warn("Compile: BadRequest returned: {0}", e.Message);
throw new WebFaultException <string>(e.Message, HttpStatusCode.BadRequest);
}
}
/// <summary>
/// Sets a value within the prepared statement.
/// </summary>
/// <param name="instanceId">The instance id.</param>
/// <param name="statementId">The statement id.</param>
/// <param name="preparedValueArgs">The prepared value args.</param>
public void SetPreparedValue(string instanceId, string statementId, PreparedValueArgs preparedValueArgs)
{
try
{
var instance = GetInstanceOrFault(instanceId);
var fabricator = instance.SchemaFabricator;
var fabricationValue = fabricator.Fabricate(
preparedValueArgs.Data,
preparedValueArgs.DataType);
instance.SetPreparedValue(
statementId,
preparedValueArgs.ParameterIndex,
fabricationValue);
}
catch (EPException e)
{
Log.Warn("Compile: BadRequest returned: {0}", e.Message);
throw new WebFaultException<string>(e.Message, HttpStatusCode.BadRequest);
}
}
