public void CreateLog(string record, bool toFile = false)
{
LogRec rec = new LogRec(record);
Add(rec);
if (toFile)
{
SaveLog(rec);
}
}
public void SaveLog(LogRec rec)
{
StreamWriter sw = null;
try
{
sw = new StreamWriter(Folder + @"\" + FileName, true);
sw.WriteLine(rec.ToString());
}
catch (Exception ex)
{
sw = null;
}
finally { sw.Close(); }
}
public static List <LogRec> GetLogEntries(DateTime from, DateTime to)
{
var l = new List <LogRec>();
DBOperations.OpenDBConnection();
MySqlCommand cmd = DBOperations.myConn.CreateCommand();
cmd.CommandText = "SELECT * FROM pck.log WHERE created >= @from AND created <= @to ORDER BY id DESC";
MySqlDataReader rdr = null;
try
{
cmd.Parameters.AddWithValue("@from", from);
cmd.Parameters.AddWithValue("@to", to);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var rec = new LogRec();
rec.created = rdr.GetDateTime(1);
rec.msg = rdr.GetString(2);
l.Add(rec);
}
rdr.Close();
}
catch (MySqlException ex)
{
MessageLogger.Add("Error reading log messages from DB " + ex.ToString(), MessageLogger.MsgLevel.critical);
return(null);
}
finally
{
if (rdr != null)
{
rdr.Close();
}
}
return(l);
}
