public virtual SystemProcessThread UpdateSystemProcessThread(SystemProcessThread entity)
{
if (entity.IsTransient())
{
return(entity);
}
SystemProcessThread other = GetSystemProcessThread(entity.SystemProcessThreadId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update SystemProcessThread set [SystemProcessID]=@SystemProcessID
, [Name]=@Name
, [SpringEntryName]=@SpringEntryName
, [Description]=@Description
, [Enabled]=@Enabled
, [Continuous]=@Continuous
, [SleepTime]=@SleepTime
, [AutoStart]=@AutoStart
, [Status]=@Status
, [Message]=@Message
, [ScheduledTime]=@ScheduledTime
, [StartRange]=@StartRange
, [EndRange]=@EndRange
, [LastSuccessfullyExecuted]=@LastSuccessfullyExecuted
, [ContinuousDelay]=@ContinuousDelay
, [IsDeleted]=@IsDeleted
, [DisplayOrder]=@DisplayOrder
, [Argument]=@Argument
, [LastUpdateDate]=@LastUpdateDate
, [ExecutionTime]=@ExecutionTime
, [EstimatedExecutionTime]=@EstimatedExecutionTime
, [ShowUpdateInLog]=@ShowUpdateInLog
, [TenantId]=@TenantId
where SystemProcessThreadID=@SystemProcessThreadID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@SystemProcessID", entity.SystemProcessId)
, new SqlParameter("@Name", entity.Name)
, new SqlParameter("@SpringEntryName", entity.SpringEntryName ?? (object)DBNull.Value)
, new SqlParameter("@Description", entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Enabled", entity.Enabled)
, new SqlParameter("@Continuous", entity.Continuous)
, new SqlParameter("@SleepTime", entity.SleepTime)
, new SqlParameter("@AutoStart", entity.AutoStart)
, new SqlParameter("@Status", entity.Status ?? (object)DBNull.Value)
, new SqlParameter("@Message", entity.Message ?? (object)DBNull.Value)
, new SqlParameter("@ScheduledTime", entity.ScheduledTime ?? (object)DBNull.Value)
, new SqlParameter("@StartRange", entity.StartRange ?? (object)DBNull.Value)
, new SqlParameter("@EndRange", entity.EndRange ?? (object)DBNull.Value)
, new SqlParameter("@LastSuccessfullyExecuted", entity.LastSuccessfullyExecuted ?? (object)DBNull.Value)
, new SqlParameter("@ContinuousDelay", entity.ContinuousDelay)
, new SqlParameter("@IsDeleted", entity.IsDeleted)
, new SqlParameter("@DisplayOrder", entity.DisplayOrder)
, new SqlParameter("@Argument", entity.Argument ?? (object)DBNull.Value)
, new SqlParameter("@LastUpdateDate", entity.LastUpdateDate ?? (object)DBNull.Value)
, new SqlParameter("@ExecutionTime", entity.ExecutionTime ?? (object)DBNull.Value)
, new SqlParameter("@EstimatedExecutionTime", entity.EstimatedExecutionTime ?? (object)DBNull.Value)
, new SqlParameter("@ShowUpdateInLog", entity.ShowUpdateInLog ?? (object)DBNull.Value)
, new SqlParameter("@TenantId", entity.TenantId ?? (object)DBNull.Value)
, new SqlParameter("@SystemProcessThreadID", entity.SystemProcessThreadId)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetSystemProcessThread(entity.SystemProcessThreadId));
}
public virtual SystemProcessThread InsertSystemProcessThread(SystemProcessThread entity)
{
SystemProcessThread other = new SystemProcessThread();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into SystemProcessThread ( [SystemProcessID]
,[Name]
,[SpringEntryName]
,[Description]
,[Enabled]
,[Continuous]
,[SleepTime]
,[AutoStart]
,[Status]
,[Message]
,[ScheduledTime]
,[StartRange]
,[EndRange]
,[LastSuccessfullyExecuted]
,[ContinuousDelay]
,[IsDeleted]
,[DisplayOrder]
,[Argument]
,[LastUpdateDate]
,[ExecutionTime]
,[EstimatedExecutionTime]
,[ShowUpdateInLog]
,[TenantId] )
Values
( @SystemProcessID
, @Name
, @SpringEntryName
, @Description
, @Enabled
, @Continuous
, @SleepTime
, @AutoStart
, @Status
, @Message
, @ScheduledTime
, @StartRange
, @EndRange
, @LastSuccessfullyExecuted
, @ContinuousDelay
, @IsDeleted
, @DisplayOrder
, @Argument
, @LastUpdateDate
, @ExecutionTime
, @EstimatedExecutionTime
, @ShowUpdateInLog
, @TenantId );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@SystemProcessID", entity.SystemProcessId)
, new SqlParameter("@Name", entity.Name)
, new SqlParameter("@SpringEntryName", entity.SpringEntryName ?? (object)DBNull.Value)
, new SqlParameter("@Description", entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Enabled", entity.Enabled)
, new SqlParameter("@Continuous", entity.Continuous)
, new SqlParameter("@SleepTime", entity.SleepTime)
, new SqlParameter("@AutoStart", entity.AutoStart)
, new SqlParameter("@Status", entity.Status ?? (object)DBNull.Value)
, new SqlParameter("@Message", entity.Message ?? (object)DBNull.Value)
, new SqlParameter("@ScheduledTime", entity.ScheduledTime ?? (object)DBNull.Value)
, new SqlParameter("@StartRange", entity.StartRange ?? (object)DBNull.Value)
, new SqlParameter("@EndRange", entity.EndRange ?? (object)DBNull.Value)
, new SqlParameter("@LastSuccessfullyExecuted", entity.LastSuccessfullyExecuted ?? (object)DBNull.Value)
, new SqlParameter("@ContinuousDelay", entity.ContinuousDelay)
, new SqlParameter("@IsDeleted", entity.IsDeleted)
, new SqlParameter("@DisplayOrder", entity.DisplayOrder)
, new SqlParameter("@Argument", entity.Argument ?? (object)DBNull.Value)
, new SqlParameter("@LastUpdateDate", entity.LastUpdateDate ?? (object)DBNull.Value)
, new SqlParameter("@ExecutionTime", entity.ExecutionTime ?? (object)DBNull.Value)
, new SqlParameter("@EstimatedExecutionTime", entity.EstimatedExecutionTime ?? (object)DBNull.Value)
, new SqlParameter("@ShowUpdateInLog", entity.ShowUpdateInLog ?? (object)DBNull.Value)
, new SqlParameter("@TenantId", entity.TenantId ?? (object)DBNull.Value)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetSystemProcessThread(Convert.ToInt32(identity)));
}
return(entity);
}