public string[] GetEventLogReport()
{
var logEntries = new List <string>();
using (var dbReader = dbBackupConnection.SelectFromTable("System_Log", "*"))
{
while (dbReader.Read())
{
var entry = "ID: " + dbReader.GetString(0) + " Date: "
+ dbReader.GetDateTime(1) + " Type: " +
dbReader.GetString(2) + " Description: " + dbReader.GetString(3);
logEntries.Add(entry);
}
}
return(logEntries.ToArray());
}
private static string[] GetAllLogsIds()
{
var ids = new List <string>();
using (var dbReader = _dbConnection.SelectFromTable("System_Log", "LogID"))
{
while (dbReader != null && dbReader.Read())
{
if (dbReader.GetValue(0) != null)
{
ids.Add(dbReader.GetString(0));
}
}
}
return(ids.ToArray());
}
