private DataTable GetData(string databasePath, string sql) { string cns = AccessConnection.Replace("[databasePath]", databasePath); if (databasePath.Contains("CANJE")) { cns = AccessConnectionCanje.Replace("[databasePath]", databasePath); } OleDbConnection cn = new OleDbConnection(cns); try { //revisar el uso de Dapper. cn.Open(); //using (cn.OpenAsync()) //{ using (OleDbCommand cmd = new OleDbCommand(sql, cn)) { //Util.Util.LogProceso("paso x aqui en ExcecuteNonQuery Visado1 formato: "); var dt = new DataTable(); dt.Load(cmd.ExecuteReader()); return(dt); } //} } catch (Exception exc) { throw exc; } finally { cn.Close(); } }
public Sender() { InitializeComponent(); LoadSetting(); Control.CheckForIllegalCrossThreadCalls = false; try { this.client = Client.GetInstance(); labelServerConnected.Text = "是"; } catch (Exception e) { MessageBox.Show(e.Message); labelServerConnected.Text = "否"; } accessConnection = AccessConnection.GetInstance((System.Windows.Forms.Application.ExecutablePath)); SetDataBaseConnectionLabel(accessConnection.OpenConnection()); MessageTimerStart(); }
private void button6_Click(object sender, EventArgs e) { List <Student> l3 = new List <Student>(); if (this.Tag != null) { l3 = (List <Student>) this.Tag; } if (lista_import.Count != 0) { foreach (Student s in lista_import) { l3.Add(s); } } OleDbConnection conn = AccessConnection.GetConnection(); //string query = "insert into Studenti(Numar_Matricol, Nume, Prenume, An, Grupa, Note) " + // "values([nr], [n], [p], [an], [g], [note]);"; foreach (Student s in l3) { StringBuilder sb = new StringBuilder(); { foreach (int i in s.Note) { sb.Append(i); if (i != s.Note[s.Note.Count - 1]) { sb.Append(","); } } } string query = "insert into Studenti([Numar_Matricol], [Nume], [Prenume], [An], [Grupa], [Note]) " + "values('" + s.Nr_matricol + "','" + s.Nume + "','" + s.Prenume + "','" + s.An + "','" + s.Grupa + "','" + sb.ToString() + "')"; OleDbCommand command = new OleDbCommand(query, conn); command.ExecuteNonQuery(); } }
private void timerScan_Tick(object sender, System.Timers.ElapsedEventArgs e) { ValidateMe(); timerScan.Enabled = false; CustomBase.Rec rec = new CustomBase.Rec(); rec.EventType = "Scan"; L.Log(LogType.FILE, LogLevel.INFORM, "Service Started"); string readQuery = null; AccessConnection ac = new AccessConnection(); OleDbConnection connection = null; OleDbCommand command = null; OleDbDataReader readReader = null; try { if (!reg_flag) { if (!Read_Registry()) { L.Log(LogType.FILE, LogLevel.ERROR, "Error on Reading the Registry "); return; } else if (!Initialize_Logger()) { L.Log(LogType.FILE, LogLevel.ERROR, "Error on Intialize Logger on McaffeeEpo Recorder functions may not be running"); return; } reg_flag = true; } if (fromend) { if (!Set_LastPosition()) L.Log(LogType.FILE, LogLevel.INFORM, "Error on setting last position see eventlog for more details"); fromend = false; } readQuery = "Select TOP " + max_record_send + " PrimaryServer, ClientName, ClientComputerName, ClientMacAddress, DateReceived, DateOccurred, UserName, ScannerReportedID, ScannerReportedName, TaskID, TaskType, Description, Status, Scanned, Infected, Cleaned, Details, ID from ScanLog where ID > " + last_recordnumScan + " ORDER BY ID"; L.Log(LogType.FILE, LogLevel.DEBUG, " Query for ScanLogTable is " + readQuery); ac.OpenAccessConnection(remote_host, dblocationonServer, location); readReader = ac.ExecuteAccessQuery(readQuery); L.Log(LogType.FILE, LogLevel.DEBUG, "Finish executing the query"); if (!readReader.HasRows) { string readQuery1 = "select MAX(ID) FROM ScanLog"; OleDbDataReader readReader22 = ac.ExecuteAccessQuery(readQuery1); long max_record_num = 0; while (readReader22.Read()) { max_record_num = Convert.ToInt64(readReader22.GetDecimal(0)); } L.Log(LogType.FILE, LogLevel.DEBUG, "Maximum Record Num is for ScanLog Table : " + max_record_num); if (!readReader22.IsClosed) { readReader22.Close(); } if (last_recordnumScan < max_record_num) { last_recordnumScan += 1; } } while (readReader.Read()) { rec.LogName = "EsetNod32 Recorder"; if (!Convert.IsDBNull(readReader["PrimaryServer"])) { rec.CustomStr1 = readReader.GetString(0).ToString(); } if (!Convert.IsDBNull(readReader["ClientName"])) { rec.UserName = readReader.GetString(1).ToString(); // } if (!Convert.IsDBNull(readReader["ClientComputerName"])) { rec.ComputerName = readReader.GetString(2).ToString(); // } if (!Convert.IsDBNull(readReader["ClientMacAddress"])) { rec.CustomStr2 = readReader.GetString(3).ToString(); // } if (!Convert.IsDBNull(readReader["DateReceived"])) { rec.CustomStr3 = readReader.GetDateTime(4).ToString("yyyy/MM/dd HH:mm:ss.fff"); // } if (!Convert.IsDBNull(readReader["DateOccurred"])) { rec.CustomStr4 = readReader.GetDateTime(5).ToString("yyyy/MM/dd HH:mm:ss.fff"); // } if (!Convert.IsDBNull(readReader["UserName"])) { rec.CustomStr5 = readReader.GetString(6).ToString(); // } if (!Convert.IsDBNull(readReader["ScannerReportedID"])) { rec.EventId = Convert.ToInt64(readReader.GetInt32(7)); // } if (!Convert.IsDBNull(readReader["ScannerReportedName"])) { rec.CustomStr6 = readReader.GetString(8).ToString(); // } if (!Convert.IsDBNull(readReader["TaskID"])) { try { rec.CustomInt1 = Convert.ToInt32(readReader.GetInt64(9));// } catch (Exception ex) { L.Log(LogType.FILE, LogLevel.ERROR, "CustomInt1 Was Setted To 0 -->> " + ex.Message); rec.CustomInt1 = 0; } } if (!Convert.IsDBNull(readReader["TaskType"])) { try { rec.CustomInt2 = Convert.ToInt32(readReader.GetInt64(10)); // } catch (Exception ex) { L.Log(LogType.FILE, LogLevel.ERROR, "CustomInt2 Was Setted To 0 -->> " + ex.Message); rec.CustomInt2 = 0; } } if (!Convert.IsDBNull(readReader["Description"])) { rec.CustomStr7 = readReader.GetString(11).ToString(); // } if (!Convert.IsDBNull(readReader["Status"])) { rec.CustomStr8 = readReader.GetString(12).ToString(); // } if (!Convert.IsDBNull(readReader["Scanned"])) { rec.CustomInt8 = Convert.ToInt64(readReader.GetInt32(13)); // } if (!Convert.IsDBNull(readReader["Infected"])) { rec.CustomInt9 = Convert.ToInt64(readReader.GetInt32(14)); // } if (!Convert.IsDBNull(readReader["Cleaned"])) { rec.CustomInt10 = Convert.ToInt64(readReader.GetInt32(15)); // } if (!Convert.IsDBNull(readReader["Details"])) { rec.CustomStr9 = readReader.GetString(16).ToString(); // } if (!Convert.IsDBNull(readReader["ID"])) { rec.CustomInt6 = Convert.ToInt64(readReader.GetDecimal(17)); // } rec.Datetime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"); // rec.CustomInt7 = 3; L.Log(LogType.FILE, LogLevel.DEBUG, "Start sending Data for Scan"); if (usingRegistry) { CustomServiceBase s = base.GetInstanceService("Security Manager Sender"); s.SetData(rec); } else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetData(Dal, virtualhost, rec); } L.Log(LogType.FILE, LogLevel.DEBUG, "Finish Sending Data"); last_recordnumScan = rec.CustomInt6; last_recdate = rec.Datetime; L.Log(LogType.FILE, LogLevel.DEBUG, "Record Number is For Scan Log " + last_recordnumScan.ToString()); string lastrecordsNumber = "Event is:" + last_recordnumEvent.ToString() + "," + "Firewall is:" + last_recordnumFirewall.ToString() + "," + "Scan is:" + last_recordnumScan.ToString() + "," + "Threat is:" + last_recordnumThreat.ToString(); if (usingRegistry) Set_Registry(lastrecordsNumber); else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetReg(Id, lastrecordsNumber, "", "", "", last_recdate); } } L.Log(LogType.FILE, LogLevel.DEBUG, "Finish getting the data"); } catch (Exception er) { L.Log(LogType.FILE, LogLevel.ERROR, er.ToString()); } finally { timerEvent.Enabled = false; timerFirewall.Enabled = false; timerScan.Enabled = false; timerThreat.Enabled = true; L.Log(LogType.FILE, LogLevel.INFORM, "Service Stopped"); if (command != null && connection != null) { command.Dispose(); connection.Close(); } ac.CloseAccessConnection(); } }
private void timerFirewall_Tick(object sender, System.Timers.ElapsedEventArgs e) { ValidateMe(); timerFirewall.Enabled = false; CustomBase.Rec rec = new CustomBase.Rec(); rec.EventType = "Firewall"; L.Log(LogType.FILE, LogLevel.INFORM, "Service Started"); string readQuery = null; AccessConnection ac = new AccessConnection(); OleDbConnection connection = null; OleDbCommand command = null; OleDbDataReader readReader = null; try { if (!reg_flag) { if (!Read_Registry()) { L.Log(LogType.FILE, LogLevel.ERROR, "Error on Reading the Registry "); return; } else if (!Initialize_Logger()) { L.Log(LogType.FILE, LogLevel.ERROR, "Error on Intialize Logger on McaffeeEpo Recorder functions may not be running"); return; } reg_flag = true; } if (fromend) { if (!Set_LastPosition()) L.Log(LogType.FILE, LogLevel.INFORM, "Error on setting last position see eventlog for more details"); fromend = false; } readQuery = "Select TOP " + max_record_send + " PrimaryServer, ClientName, ClientComputerName, ClientMacAddress, DateReceived, DateOccurred, UserName, LogLevel, Event, Source, Target, Protocol, RuleName, ID from FirewallLog where ID > " + last_recordnumFirewall + " ORDER BY ID"; L.Log(LogType.FILE, LogLevel.DEBUG, " Query for FireWallLogTable is " + readQuery); ac.OpenAccessConnection(remote_host, dblocationonServer, location); readReader = ac.ExecuteAccessQuery(readQuery); L.Log(LogType.FILE, LogLevel.DEBUG, "Finish executing the query"); if (!readReader.HasRows) { string readQuery1 = "select MAX(ID) AS MaxId FROM FirewallLog"; OleDbDataReader readReader22 = ac.ExecuteAccessQuery(readQuery1); long max_record_num = 0; while (readReader22.Read()) { if (readReader22["MaxId"] != DBNull.Value) { max_record_num = Convert.ToInt64(readReader22["MaxId"]); } } L.Log(LogType.FILE, LogLevel.DEBUG, "Maximum Record Num for FirewallLog Table is : " + max_record_num.ToString()); if (!readReader22.IsClosed) { readReader22.Close(); } if (last_recordnumFirewall < max_record_num) { last_recordnumFirewall += 1; } } while (readReader.Read()) { rec.LogName = "EsetNod32 Recorder"; if (!Convert.IsDBNull(readReader["PrimaryServer"])) { rec.CustomStr1 = readReader.GetString(0).ToString(); } if (!Convert.IsDBNull(readReader["ClientName"])) { rec.UserName = readReader.GetString(1).ToString(); // } if (!Convert.IsDBNull(readReader["ClientComputerName"])) { rec.ComputerName = readReader.GetString(2).ToString(); // } if (!Convert.IsDBNull(readReader["ClientMacAddress"])) { rec.CustomStr2 = readReader.GetString(3).ToString(); // } if (!Convert.IsDBNull(readReader["DateReceived"])) { rec.CustomStr3 = readReader.GetDateTime(4).ToString("yyyy/MM/dd HH:mm:ss.fff"); // } if (!Convert.IsDBNull(readReader["DateOccurred"])) { rec.CustomStr4 = readReader.GetDateTime(5).ToString("yyyy/MM/dd HH:mm:ss.fff"); // } if (!Convert.IsDBNull(readReader["UserName"])) { rec.CustomStr5 = readReader.GetString(6).ToString(); // } L.Log(LogType.FILE, LogLevel.DEBUG, "hatadan önce"); //Hataya düşen yer!!!!!!!!!!!!!! //if (!Convert.IsDBNull(readReader["LogLevel"])) //{ // rec.CustomInt8 = Convert.ToInt64(readReader.GetDecimal(7)); // //} L.Log(LogType.FILE, LogLevel.DEBUG, "hatadan sonra"); if (!Convert.IsDBNull(readReader["Event"])) { rec.CustomStr6 = readReader.GetString(8).ToString(); // } if (!Convert.IsDBNull(readReader["Source"])) { rec.CustomStr7 = readReader.GetString(9).ToString(); // } if (!Convert.IsDBNull(readReader["Target"])) { rec.CustomStr8 = readReader.GetString(10).ToString(); // } if (!Convert.IsDBNull(readReader["Protocol"])) { rec.CustomStr9 = readReader.GetString(11).ToString(); // } if (!Convert.IsDBNull(readReader["RuleName"])) { rec.CustomStr10 = readReader.GetString(12).ToString(); // } if (!Convert.IsDBNull(readReader["ID"])) { try { rec.CustomInt6 = Convert.ToInt64(readReader.GetDecimal(13)); // } catch (Exception ex) { L.Log(LogType.FILE, LogLevel.ERROR, " timerFirewall_Tick() -->> Error in rec.CustomInt6 = Convert.ToInt64(readReader.GetDecimal(13)) : " + ex.ToString()); L.Log(LogType.FILE, LogLevel.ERROR, " timerFirewall_Tick() -->> Value : " + readReader.GetValue(13).ToString()); } } rec.Datetime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"); // rec.CustomInt7 = 2; L.Log(LogType.FILE, LogLevel.DEBUG, "Start sending Data for Firewall"); if (usingRegistry) { CustomServiceBase s = base.GetInstanceService("Security Manager Sender"); s.SetData(rec); } else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetData(Dal, virtualhost, rec); } L.Log(LogType.FILE, LogLevel.DEBUG, "Finish Sending Data"); last_recordnumFirewall = rec.CustomInt6; last_recdate = rec.Datetime; L.Log(LogType.FILE, LogLevel.DEBUG, "Record Number is For Firewall Log " + last_recordnumFirewall.ToString()); string lastrecordsNumber = "Event is:" + last_recordnumEvent.ToString() + "," + "Firewall is:" + last_recordnumFirewall.ToString() + "," + "Scan is:" + last_recordnumScan.ToString() + "," + "Threat is:" + last_recordnumThreat.ToString(); if (usingRegistry) Set_Registry(lastrecordsNumber); else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetReg(Id, lastrecordsNumber, "", "", "", last_recdate); } } L.Log(LogType.FILE, LogLevel.DEBUG, "Finish getting the data"); } catch (Exception er) { L.Log(LogType.FILE, LogLevel.ERROR, er.ToString()); L.Log(LogType.FILE, LogLevel.ERROR, "bu hata alnına sürekli giriyor"); } finally { timerEvent.Enabled = false; timerFirewall.Enabled = false; timerScan.Enabled = true; timerThreat.Enabled = false; L.Log(LogType.FILE, LogLevel.INFORM, "Service Stopped"); if (command != null && connection != null) { command.Dispose(); connection.Close(); } ac.CloseAccessConnection(); } }
private void timerEvent_Tick(object sender, System.Timers.ElapsedEventArgs e) { ValidateMe(); timerEvent.Enabled = false; CustomBase.Rec rec = new CustomBase.Rec(); rec.EventType = "Event"; L.Log(LogType.FILE, LogLevel.INFORM, "Service Started"); string readQuery = null; AccessConnection ac = new AccessConnection(); OleDbConnection connection = null; OleDbCommand command = null; OleDbDataReader readReader = null; try { if (!reg_flag) { if (!Read_Registry()) { L.Log(LogType.FILE, LogLevel.ERROR, "Error on Reading the Registry "); return; } else if (!Initialize_Logger()) { L.Log(LogType.FILE, LogLevel.ERROR, "Error on Intialize Logger on McaffeeEpo Recorder functions may not be running"); return; } reg_flag = true; } if (fromend) { if (!Set_LastPosition()) L.Log(LogType.FILE, LogLevel.INFORM, "Error on setting last position see eventlog for more details"); fromend = false; } readQuery = "Select TOP " + max_record_send + " PrimaryServer,ClientName,ClientComputerName,ClientMacAddress,DateReceived,DateOccurred,UserName,PluginReportedID,PluginReportedName,LogLevel,EventText,ID from EventLog where ID > " + last_recordnumEvent + " ORDER BY ID"; L.Log(LogType.FILE, LogLevel.DEBUG, " Query for EventLogTable is " + readQuery); ac.OpenAccessConnection(remote_host, dblocationonServer, location); readReader = ac.ExecuteAccessQuery(readQuery); if (!readReader.HasRows) // hatalı access kayıtları için. hatalı kayıtları atlar... { //string readQuery1 = "select MAX(ID) FROM EventLog"; //long max_record_num = 0; //max_record_num = ac.ExecuteScalarQuery(readQuery1); string readQuery1 = "select MAX(ID) FROM EventLog"; OleDbDataReader readReader22 = ac.ExecuteAccessQuery(readQuery1); long max_record_num = 0; while (readReader22.Read()) { try { max_record_num = Convert.ToInt64(readReader22.GetDecimal(0));//111111 } catch (Exception ex) { L.Log(LogType.FILE, LogLevel.ERROR, " timerEvent_Tick() -->> Error in max_record_num = Convert.ToInt64(readReader22.GetDecimal(0)) : " + ex.ToString()); L.Log(LogType.FILE, LogLevel.ERROR, " timerEvent_Tick() -->> Value : " + readReader22.GetValue(0).ToString()); } } L.Log(LogType.FILE, LogLevel.INFORM, "Maximum Record Num for EventLog Table is : " + max_record_num); if (!readReader22.IsClosed) { readReader22.Close(); } if (last_recordnumEvent < max_record_num) { last_recordnumEvent += 1; } } while (readReader.Read()) { rec.LogName = "EsetNod32 Recorder"; if (!Convert.IsDBNull(readReader["PrimaryServer"])) { rec.CustomStr1 = readReader.GetString(0).ToString(); } if (!Convert.IsDBNull(readReader["ClientName"])) { rec.UserName = readReader.GetString(1).ToString(); } if (!Convert.IsDBNull(readReader["ClientComputerName"])) { rec.ComputerName = readReader.GetString(2).ToString(); } if (!Convert.IsDBNull(readReader["ClientMacAddress"])) { rec.CustomStr2 = readReader.GetString(3).ToString(); } if (!Convert.IsDBNull(readReader["DateReceived"])) { rec.CustomStr3 = readReader.GetDateTime(4).ToString("yyyy/MM/dd HH:mm:ss.fff"); } if (!Convert.IsDBNull(readReader["DateOccurred"])) { rec.CustomStr4 = readReader.GetDateTime(5).ToString("yyyy/MM/dd HH:mm:ss.fff"); } if (!Convert.IsDBNull(readReader["UserName"])) { rec.CustomStr5 = readReader.GetString(6).ToString(); } if (!Convert.IsDBNull(readReader["PluginReportedID"])) { rec.CustomInt1 = readReader.GetInt32(7); } if (!Convert.IsDBNull(readReader["PluginReportedName"])) { rec.CustomStr6 = readReader.GetString(8).ToString(); } if (!Convert.IsDBNull(readReader["LogLevel"])) { try { rec.CustomInt8 = Convert.ToInt64(readReader.GetDecimal(9));//22222 } catch (Exception ex) { L.Log(LogType.FILE, LogLevel.ERROR, " timerEvent_Tick() -->> Error in rec.CustomInt8 = Convert.ToInt64(readReader.GetDecimal(9)) : " + ex.ToString()); L.Log(LogType.FILE, LogLevel.ERROR, " timerEvent_Tick() -->> Value : " + readReader.GetValue(9).ToString()); } } if (!Convert.IsDBNull(readReader["EventText"])) { rec.CustomStr7 = readReader.GetString(10).ToString(); } rec.Datetime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"); try { rec.CustomInt6 = Convert.ToInt64(readReader.GetDecimal(11));//3333333 } catch (Exception ex) { L.Log(LogType.FILE, LogLevel.ERROR, " timerEvent_Tick() -->> Error in rec.CustomInt6 = Convert.ToInt64(readReader.GetDecimal(11)) : " + ex.ToString()); L.Log(LogType.FILE, LogLevel.ERROR, " timerEvent_Tick() -->> Value : " + readReader.GetValue(11).ToString()); } rec.CustomInt7 = 1; L.Log(LogType.FILE, LogLevel.DEBUG, "Start sending Data for EventLog"); if (usingRegistry) { CustomServiceBase s = base.GetInstanceService("Security Manager Sender"); s.SetData(rec); } else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetData(Dal, virtualhost, rec); L.Log(LogType.FILE, LogLevel.DEBUG, "sendingg dataaaa"); } L.Log(LogType.FILE, LogLevel.DEBUG, "Finish Sending Data"); last_recordnumEvent = rec.CustomInt6; last_recdate = rec.Datetime; L.Log(LogType.FILE, LogLevel.DEBUG, "Record Number is For Event Log " + last_recordnumEvent.ToString()); string lastrecordsNumber = "Event is:" + last_recordnumEvent.ToString() + "," + "Firewall is:" + last_recordnumFirewall.ToString() + "," + "Scan is:" + last_recordnumScan.ToString() + "," + "Threat is:" + last_recordnumThreat.ToString(); if (usingRegistry) Set_Registry(lastrecordsNumber); else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetReg(Id, lastrecordsNumber, "", "", "", last_recdate); } } L.Log(LogType.FILE, LogLevel.DEBUG, "Finish getting the data"); } catch (Exception er) { L.Log(LogType.FILE, LogLevel.ERROR, er.ToString()); } finally { timerEvent.Enabled = false; timerFirewall.Enabled = true; timerScan.Enabled = false; timerThreat.Enabled = false; L.Log(LogType.FILE, LogLevel.INFORM, "Service Stopped"); if (command != null && connection != null) { command.Dispose(); connection.Close(); } ac.CloseAccessConnection(); } }
public bool Set_LastPosition() { string readQueryEvent = null; string readQueryFirewall = null; string readQueryScan = null; string readQueryThreat = null; AccessConnection ac = new AccessConnection(); ; OleDbDataReader readReader; try { readQueryEvent = "select MAX(ID) FROM EventLog"; readQueryFirewall = "select MAX(ID) FROM FirewallLog"; readQueryScan = "select MAX(ID) FROM ScanLog"; readQueryThreat = "select MAX(ID) FROM ThreatLog"; L.Log(LogType.FILE, LogLevel.DEBUG, " Query Event is " + readQueryEvent); L.Log(LogType.FILE, LogLevel.DEBUG, " Query Firewall is " + readQueryFirewall); L.Log(LogType.FILE, LogLevel.DEBUG, " Query Scan is " + readQueryScan); L.Log(LogType.FILE, LogLevel.DEBUG, " Query Threat is " + readQueryThreat); ac.OpenAccessConnection(remote_host, dblocationonServer, location); readReader = ac.ExecuteAccessQuery(readQueryEvent); L.Log(LogType.FILE, LogLevel.DEBUG, "Finish executing the query"); while (readReader.Read()) { last_recordnumEvent = Convert.ToInt64(readReader.GetInt32(0)); } readReader = ac.ExecuteAccessQuery(readQueryEvent); while (readReader.Read()) { last_recordnumFirewall = Convert.ToInt64(readReader.GetInt32(0)); } readReader = ac.ExecuteAccessQuery(readQueryEvent); while (readReader.Read()) { last_recordnumScan = Convert.ToInt64(readReader.GetInt32(0)); } readReader = ac.ExecuteAccessQuery(readQueryEvent); while (readReader.Read()) { last_recordnumThreat = Convert.ToInt64(readReader.GetInt32(0)); } string lastrecordsNumber = "Event is:" + last_recordnumEvent.ToString() + "," + "Firewall is:" + last_recordnumFirewall.ToString() + "," + "Scan is:" + last_recordnumScan.ToString() + "," + "Threat is:" + last_recordnumThreat.ToString(); if (usingRegistry) Set_Registry(lastrecordsNumber); else { CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder"); s.SetReg(Id, lastrecordsNumber, "", "", "", last_recdate); } return true; } catch (Exception er) { L.Log(LogType.FILE, LogLevel.ERROR, "Set_lastPosition() -->> Catch hata yakaldı."); L.Log(LogType.FILE, LogLevel.ERROR, er.ToString()); return false; } finally { ac.CloseAccessConnection(); } }
public void Reset() { connection = new AccessConnection(); }
public bool SetAcceesConnection(AccessConnection connection) { this.accessConnection = connection; return(true); }