public static void InsertRDPHistory(RDPUser rdpUser)
{
try
{
var commandText = $"insert into SYS_RDP_LOG(eventid, rdp_ip, rdp_user, rdp_date, rdp_type) values(:{nameof(rdpUser.EventId)}, :{nameof(rdpUser.RDP_IP)}, :{nameof(rdpUser.RDP_USER)}, :{nameof(rdpUser.RDP_DATE)}, :{nameof(rdpUser.RDP_TYPE)})";
using (OracleConnection connection = new OracleConnection(ConnString))
using (OracleCommand command = new OracleCommand(commandText, connection))
{
command.Parameters.Add(new OracleParameter(nameof(rdpUser.EventId), rdpUser.EventId));
command.Parameters.Add(new OracleParameter(nameof(rdpUser.RDP_IP), rdpUser.RDP_IP));
command.Parameters.Add(new OracleParameter(nameof(rdpUser.RDP_USER), rdpUser.RDP_USER));
command.Parameters.Add(new OracleParameter(nameof(rdpUser.RDP_DATE), rdpUser.RDP_DATE));
command.Parameters.Add(new OracleParameter(nameof(rdpUser.RDP_TYPE), rdpUser.RDP_TYPE.ToString()));
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
}
catch (Exception ex)
{
StreamWriterExtention.WriteToFile(ex.Message, forceToWrite: true);
}
}
public static void Subscribe(EventLogQuery eventLogQuery = null)
{
StreamWriterExtention.WriteToFile("Subscribe " + DateTime.Now.ToString("hh:mm:ss"));
EventLogWatcher watcher = null;
try
{
if (eventLogQuery == null)
{
//EventLogQuery subscriptionQuery = new EventLogQuery("Security", PathType.LogName, "*[System/EventID=4624]"); "*[System/EventID=0 or System/EventID=21 or System/EventID=23 or System/EventID=24 or System/EventID=25]");
string queryString = "*[System/EventID=0 or System/EventID=21 or System/EventID=23 or System/EventID=23 or System/EventID=24 or System/EventID=25]";//"<QueryList><QueryId=\"0\"Path=\"Application\"><SelectPath=\"Application\">*[System[(EventID=21 or EventID=22 or EventID=23)]]</Select></Query></QueryList>";
eventLogQuery = new EventLogQuery("Application", PathType.LogName, queryString);
}
watcher = new EventLogWatcher(eventLogQuery);
// Make the watcher listen to the EventRecordWritten
// events. When this event happens, the callback method
// (EventLogEventRead) is called.
watcher.EventRecordWritten += new EventHandler <EventRecordWrittenEventArgs>(EventLogReaderExtention.EventLogEventRead);
// Activate the subscription
watcher.Enabled = true;
Console.ReadLine();
//for (int i = 0; i < 5; i++)
//{
// // Wait for events to occur.
// System.Threading.Thread.Sleep(100000);
//}
}
catch (EventLogReadingException e)
{
Console.WriteLine("Error reading the log: {0}", e.Message);
}
finally
{
// Stop listening to events
watcher.Enabled = false;
if (watcher != null)
{
watcher.Dispose();
}
}
StreamWriterExtention.WriteToFile("Close " + DateTime.Now.ToString("hh:mm:ss"));
Console.WriteLine("NoEvent triggered");
//WindowsService de hata VERIYOR.
//TaskSchedular da hata vermiyor.
//Console.ReadKey();
}
public static void GetRDPHistory()
{
try
{
//string constr = "user id=MASSDENEME;password=123456_tT;data source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SID_NAME)))";
OracleConnection conn = new OracleConnection(ConnString);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
OracleParameter parm = new OracleParameter();
parm.OracleDbType = OracleDbType.Int16;
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM SYS_RDP_LOG";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
var rdpHistoryList = new List <RDPUser>();
while (dr.Read())
{
var oUser = new RDPUser();
RDPType enumResult;
Enum.TryParse <RDPType>(dr["RDP_TYPE"].ToString(), out enumResult);
oUser.EventId = Convert.ToInt32(dr["eventid"]);
oUser.RDP_IP = Convert.ToString(dr["RDP_IP"]);
oUser.RDP_USER = Convert.ToString(dr["RDP_USER"]);
oUser.RDP_TYPE = enumResult.ToString();
rdpHistoryList.Add(oUser);
}
dr.Close();
dr.Dispose();
// Close connection
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch (Exception ex)
{
StreamWriterExtention.WriteToFile(ex.Message, forceToWrite: true);
}
}
