BlueCollar.SQLiteRepository.UpdateSchedule C# (CSharp) Method

UpdateSchedule() public method

Updates the given schedule.
public UpdateSchedule ( ScheduleRecord record, IDbTransaction transaction ) : ScheduleRecord
record ScheduleRecord The schedule record to update.
transaction IDbTransaction The transaction to use, if applicable.
return ScheduleRecord
        public ScheduleRecord UpdateSchedule(ScheduleRecord record, IDbTransaction transaction)
        {
            const string Sql =
            @"UPDATE [BlueCollarSchedule]
            SET
            [QueueName] = @QueueName,
            [Name] = @Name,
            [StartOn] = @StartOn,
            [EndOn] = @EndOn,
            [RepeatType] = @RepeatTypeString,
            [Repeatvalue] = @RepeatValue,
            [Enabled] = @Enabled,
            [Enqueueing] = @Enqueueing,
            [EnqueueingUpdatedOn] = @EnqueueingUpdatedOn
            WHERE
            [Id] = @Id;";

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

            return record;
        }