public int CurrentMontlyRunInDb()
{
EnsureMontlyStatsTableExists();
var notExportetYet = _dynaSql.SqlExecuteScalar($"Select month from {MONTHLY_STATS_TABLE_NAME} limit 1");
if (!int.TryParse(notExportetYet, out int ret))
{
ret = -1;
}
return(ret);
}
public string ReadSettings(string key)
{
string cmd = null;
try
{
cmd = $"select value from {TABLE_NAME} where key = @key";
return(_dynaSql.SqlExecuteScalar(cmd, new List <DynaSql.DynaParameter>
{
new DynaSql.DynaParameter {
Name = "key", Value = key
}
}));
}
catch (Exception e)
{
Log.To.Main.AddException($"Failed saving settings data. {cmd}", e);
throw;
}
}
