/// <summary>
/// modify QuartzSetting
/// </summary>
/// <param name="quartzSetting"></param>
/// <returns></returns>
public bool ModifyQuartzSetting(QuartzSetting quartzSetting)
{
var sql = @"UPDATE quartzsettings
SET keyname=@keyname, typename=@typename, cronexpression=@cronexpression, validate=@validate
WHERE id=@id;" ;
using (var con = new SqlConnection(_connectionString))
{
return(con.Execute(sql, quartzSetting) > 0);
}
}
/// <summary>
/// add QuartzSetting
/// </summary>
/// <param name="quartzSetting">QuartzSetting</param>
/// <returns></returns>
public bool AddQuartzSetting(QuartzSetting quartzSetting)
{
var sql = @"INSERT INTO quartzsettings(
keyname, typename, cronexpression, validate,createon)
VALUES (@keyname, @typename, @cronexpression, @validate,@createon);" ;
using (var con = new SqlConnection(_connectionString))
{
quartzSetting.CreateOn = DateTime.Now;
return(con.Execute(sql, quartzSetting) > 0);
}
}
public IActionResult ModifyQuartzSetting([FromBody] QuartzSetting QuartzSetting)
{
try
{
_logger.LogInformation($"modify Quartzsetting,keyname={QuartzSetting.KeyName}");
return(new JsonResult(new { result = true, data = _quartzProvider.ModifyQuartzSetting(QuartzSetting) }));
}
catch (Exception exc)
{
_logger.LogCritical(exc, exc.Message);
return(new JsonResult(new { result = false, message = exc.Message }));
}
}
