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