private List <DbParameter> zMapFromSequenceDetail(dataAccess.ParameterBuilder paramBuilder, SequenceDetail sequenceDetail, bool includeSequenceId)
{
List <DbParameter> parameters = zMapFromSequence(paramBuilder, sequenceDetail.Sequence, includeSequenceId);
parameters.Add(paramBuilder.CreateParameter("@sequence", Converter.ToBinary(sequenceDetail.SequenceSteps)));
return(parameters);
}
private List <DbParameter> zMapFromScheduledTaskRunStatistics(dataAccess.ParameterBuilder paramBuilder, long scheduledTaskId, ScheduledTaskRunStatistics scheduledTaskRunStatistics)
{
List <DbParameter> parameters = new List <DbParameter>();
parameters.Add(paramBuilder.CreateParameter("@scheduledTaskId", scheduledTaskId));
parameters.Add(paramBuilder.CreateParameter("@lastRunStartTimeUtc", scheduledTaskRunStatistics.StartTimeUtc));
parameters.Add(paramBuilder.CreateParameter("@lastRunEndTimeUtc", scheduledTaskRunStatistics.EndTimeUtc));
parameters.Add(paramBuilder.CreateParameter("@lastRunStatusId", scheduledTaskRunStatistics.Status.HasValue ? (long)scheduledTaskRunStatistics.Status.Value : new long?()));
parameters.Add(paramBuilder.CreateParameter("@lastRunError", scheduledTaskRunStatistics.Error));
return(parameters);
}
private List <DbParameter> zMapFromSequence(dataAccess.ParameterBuilder paramBuilder, Sequence sequence, bool includeSequenceId)
{
List <DbParameter> parameters = new List <DbParameter>();
if (includeSequenceId)
{
parameters.Add(paramBuilder.CreateParameter("@sequenceId", sequence.SequenceId));
}
parameters.Add(paramBuilder.CreateParameter("@sequenceName", sequence.Name));
parameters.Add(paramBuilder.CreateParameter("@sequenceTypeId", (long)sequence.SequenceType));
parameters.Add(paramBuilder.CreateParameter("@stepCount", sequence.StepCount));
parameters.Add(paramBuilder.CreateParameter("@isDeleted", sequence.IsDeleted));
return(parameters);
}
private List <DbParameter> zMapFromScheduledTask(dataAccess.ParameterBuilder paramBuilder, ScheduledTask scheduledTask, bool includeScheduledTaskId)
{
List <DbParameter> parameters = new List <DbParameter>();
if (includeScheduledTaskId)
{
parameters.Add(paramBuilder.CreateParameter("@scheduledTaskId", scheduledTask.ScheduledTaskId));
}
parameters.Add(paramBuilder.CreateParameter("@taskName", scheduledTask.TaskName));
parameters.Add(paramBuilder.CreateParameter("@sequenceId", scheduledTask.TaskSequence.SequenceId));
parameters.Add(paramBuilder.CreateParameter("@schedule", Converter.ToBinary(scheduledTask.RunSchedule)));
parameters.Add(paramBuilder.CreateParameter("@runDurationLimit", scheduledTask.RunDurationLimit));
parameters.Add(paramBuilder.CreateParameter("@enabled", scheduledTask.Enabled));
parameters.Add(paramBuilder.CreateParameter("@isDeleted", scheduledTask.IsDeleted));
//NextScheduledRunTimeUtc is not set by updating the scheduled task, instead it is set by calling SetScheduledTaskNextScheduledRunTime.
return(parameters);
}