BlueCollar.SQLiteRepository.ReleaseScheduleEnqueueingLock C# (CSharp) Method

ReleaseScheduleEnqueueingLock() public method

Releases the enqueueing lock for the schedule with the given ID.
public ReleaseScheduleEnqueueingLock ( long scheduleId, IDbTransaction transaction ) : void
scheduleId long The ID of the schedule to release the enqueueing lock for.
transaction IDbTransaction The transaction to use, if applicable.
return void
        public void ReleaseScheduleEnqueueingLock(long scheduleId, IDbTransaction transaction)
        {
            const string Sql =
            @"UPDATE [BlueCollarSchedule]
            SET
            [Enqueueing] = @Enqueueing,
            [EnqueueingUpdatedOn] = @EnqueueingUpdatedOn
            WHERE
            [Id] = @Id;";

            this.connection.Execute(
                Sql,
                new { Id = scheduleId, Enqueueing = false, EnqueueingUpdatedOn = DateTime.UtcNow },
                transaction,
                null,
                null);
        }