All pastes #193142 Raw Edit

Something

public text v1 · immutable
·published 2006-10-06 16:39 UTC
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;

		}