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(); }
        }
Example #2
0
 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();
 }
Example #3
0
        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();
 }
Example #9
0
 public bool SetAcceesConnection(AccessConnection connection)
 {
     this.accessConnection = connection;
     return(true);
 }