BlueCollar.SQLiteRepository.UpdateWorker C# (CSharp) Method

UpdateWorker() public method

Updates the given worker.
public UpdateWorker ( WorkerRecord record, IDbTransaction transaction ) : WorkerRecord
record WorkerRecord The worker record to update.
transaction IDbTransaction The transaction to use, if applicable.
return WorkerRecord
        public WorkerRecord UpdateWorker(WorkerRecord record, IDbTransaction transaction)
        {
            const string Sql =
            @"UPDATE [BlueCollarWorker]
            SET
            [Name] = @Name,
            [MachineName] = @MachineName,
            [MachineAddress] = @MachineAddress,
            [QueueNames] = @QueueNames,
            [Status] = @StatusString,
            [Signal] = @SignalString,
            [Startup] = @StartupString,
            [UpdatedOn] = @UpdatedOn
            WHERE
            [Id] = @Id;";

            this.connection.Execute(
                Sql,
                record,
                transaction,
                null,
                null);

            return record;
        }