public WorkingRecord UpdateWorking(WorkingRecord record, IDbTransaction transaction)
{
const string Sql =
@"UPDATE [BlueCollarWorking]
SET
[WorkerId] = @WorkerId,
[ScheduleId] = @ScheduleId,
[QueueName] = @QueueName,
[JobName] = @JobName,
[JobType] = @JobType,
[Data] = @Data,
[QueuedOn] = @QueuedOn,
[TryNumber] = @TryNumber,
[StartedOn] = @StartedOn,
[Signal] = @Signal
WHERE
[Id] = @Id;";
this.connection.Execute(
Sql,
record,
transaction,
null,
null);
return record;
}