public async Task UpdateEstado(string connection)
{
var date = DateExtensions.GetDate();
using (var cn = new SqlConnection(connection))
{
cn.Open();
DynamicParameters parameter = new DynamicParameters();
parameter.Add("@TodayDate", date, DbType.DateTime, ParameterDirection.Input);
var result = await cn.ExecuteAsync("[UPDATE_ESTADO_EN_ESPERA_JOB]", parameter, null, null, CommandType.StoredProcedure);
}
}
