/// <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); }