public async Task <ActionResult <QueueBroker> > Post(QueueBroker queueBroker) { if (queueBroker == null) { return(BadRequest()); } // QueueOperations qo = new QueueOperations(db); // qo.AddQueueObject(queueBroker); var jobId = BackgroundJob.Enqueue(() => qo.ExecuteProcedure(queueBroker)); return(Ok($"Job Id {jobId} Completed. SP Executed!")); //return Ok(queueBroker); }
public void ExecuteProcedure(QueueBroker queueBroker) { db.Database.ExecuteSqlCommand("SP_DMS_UPDATE_DOCUMENT_AUTHORS_FP @p0", parameters: new[] { "12740" }); Console.WriteLine($"Unsubscribed {queueBroker.Function_Name}"); }