rendered paste body public void Insert(Dictionary<string,EventLogEntryCollection> entries) {
this.cmd = connection.CreateCommand();
string sql = "Insert into eventlogs(id,Machinename,Log,Category,Entrytype,"+
"EventId,Message,Source,Generated,Username) Values(null,@Machinename,@Log,"+
"@Category,@Entrytype,@EventId,@Message,@Source,@Generated,@Username);";
this.cmd.CommandText = sql;
SqliteParameter machinename = new SqliteParameter();
machinename.ParameterName = "Machinename";
SqliteParameter category = new SqliteParameter();
category.ParameterName = "Category";
SqliteParameter entrytype = new SqliteParameter();
entrytype.ParameterName = "Entrytype";
SqliteParameter eventid = new SqliteParameter();
eventid.ParameterName = "EventId";
SqliteParameter message = new SqliteParameter();
message.ParameterName = "Message";
SqliteParameter source = new SqliteParameter();
source.ParameterName = "Source";
SqliteParameter generated = new SqliteParameter();
generated.ParameterName = "Generated";
SqliteParameter username = new SqliteParameter();
username.ParameterName = "Username";
SqliteParameter log = new SqliteParameter();
log.ParameterName = "Log";
this.cmd.Parameters.Add(machinename);
this.cmd.Parameters.Add(category);
this.cmd.Parameters.Add(entrytype);
this.cmd.Parameters.Add(eventid);
this.cmd.Parameters.Add(message);
this.cmd.Parameters.Add(source);
this.cmd.Parameters.Add(generated);
this.cmd.Parameters.Add(username);
this.cmd.Parameters.Add(log);
foreach(KeyValuePair<string,EventLogEntryCollection> key_value in entries) {
string Log = key_value.Key;
EventLogEntryCollection entrycollection = key_value.Value;
foreach(EventLogEntry entry in entrycollection) {
machinename.Value = entry.MachineName;
log.Value = Log;
category.Value = entry.Category;
entrytype.Value = entry.EntryType.ToString();
eventid.Value = entry.EventID;
message.Value = entry.Message;
source.Value = entry.Source;
generated.Value = entry.TimeGenerated;
username.Value = entry.UserName;
try {
this.cmd.ExecuteNonQuery();
}
catch(Exception e) { }
}
}
this.cmd = null;
}