/// <summary>
/// Write interval
/// </summary>
/// <param name="interval"></param>
public bool Save(Interval interval)
{
bool ok = false;
if (interval == null)
{
throw new ArgumentNullException(nameof(interval));
}
interval.Guid = GuidUtility.GetNewIfNullOrEmpty(interval.Guid);
var dlColumns = ColumnHelper.GetModelDBColumnNames("IT_Interval", typeof(Interval), null);
sqlService.OpenConnection((connection) =>
{
string setDLStatement = $"INSERT INTO IT_Interval ({string.Join(", ", dlColumns.Select(item => item.Key))}) ON EXISTING UPDATE VALUES "
+ $" ({string.Join(", ", dlColumns.Select(k => ":" + (string.IsNullOrWhiteSpace(k.Value) ? k.Key : k.Value)))});";
return(connection.Execute(setDLStatement, interval));
});
ok = true;
return(ok);
}