public string GetProperty(string propertyName, string defaultValue) { try { var sql = $"SELECT Value FROM Properties WHERE Property='{propertyName}'"; string result = _database.FillSingleValue(sql); // Return result if no default specified if (string.IsNullOrWhiteSpace(defaultValue)) { return(result); } // Return result if a value was found if (string.IsNullOrWhiteSpace(result) == false) { return(result); } // add the default value (if property not found) SaveProperty(propertyName, defaultValue); return(defaultValue); } catch (Exception ex) { Log.Error(ex); return(defaultValue); } }
public void FillSingleValueTest() { var p = new CMSProperties(_database); p.SaveProperty(Test01Name, "String Value"); var s = _database.FillSingleValue($"SELECT Value FROM Properties WHERE Property='{Test01Name}'"); Assert.AreEqual(s, "String Value"); }