/// <summary>
/// Inserts a parameter into the job parameters table.
/// </summary>
/// <param name="executionId">the id of the job execution</param>
/// <param name="type">the type of the parameter</param>
/// <param name="key">the key of the parameter</param>
/// <param name="value">the value of the parameter</param>
/// <param name="identifying">whether the parameter is part of the job instance identification</param>
private void InsertParameter(long?executionId, ParameterType type, string key, object value, bool identifying)
{
var stringValue = type == ParameterType.String ? value : "";
var dateValue = type == ParameterType.Date ? value : DBNull.Value;
var longValue = type == ParameterType.Long ? value : 0L;
var doubleValue = type == ParameterType.Double ? value : 0D;
var parameters = new Dictionary <string, object>
{
{ "id", executionId }, { "key", key }, { "type", type.ToString() }, { "stringValue", stringValue },
{ "dateValue", dateValue }, { "longValue", longValue }, { "doubleValue", doubleValue },
{ "identifying", identifying ? "Y" : "N" }
};
DbOperator.Update(InsertTablePrefix(CreateJobParametersQuery), parameters);
}
/// <summary>
/// Inserts a parameter into the job parameters table.
/// </summary>
/// <param name="executionId">the id of the job execution</param>
/// <param name="type">the type of the parameter</param>
/// <param name="key">the key of the parameter</param>
/// <param name="value">the value of the parameter</param>
/// <param name="identifying">whether the parameter is part of the job instance identification</param>
private void InsertParameter(long? executionId, ParameterType type, string key, object value, bool identifying)
{
var stringValue = type == ParameterType.String ? value : "";
var dateValue = type == ParameterType.Date ? value : DBNull.Value;
var longValue = type == ParameterType.Long ? value : 0L;
var doubleValue = type == ParameterType.Double ? value : 0D;
var parameters = new Dictionary<string, object>
{
{"id", executionId}, {"key", key}, {"type", type.ToString()}, {"stringValue", stringValue},
{"dateValue", dateValue}, { "longValue", longValue}, {"doubleValue", doubleValue},
{"identifying", identifying ? "Y" : "N"}
};
DbOperator.Update(InsertTablePrefix(CreateJobParametersQuery), parameters);
}
