Esempio n. 1
0
        private void PopulateParalel(LogParser parser)
        {
            string id   = "";
            string info = string.Empty;

            List <string> listOfYear = new List <string>();

            if (!parser.UseExistData)
            {
                listOfYear = GetListOfYear(parser.LogParserId.ToString());
            }
            else
            {
                listOfYear.Add(IndihiangHelper.GetYearDataIndihiangFile(parser.FileName));
            }


            _totalControls = 9;
            info           = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on GENERAL...");
            AddLogStatus(info);
            id = LogFeature.GENERAL.ToString();
            GeneralControl uc1 = new GeneralControl();

            uc1.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc1.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc1.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            Attach(uc1, id, "General");


            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on USERAGENT...");
            AddLogStatus(info);
            id = LogFeature.USERAGENT.ToString();
            UserAgentControl uc2 = new UserAgentControl();

            uc2.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc2.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc2.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc2.ListOfYear = listOfYear;
            Attach(uc2, id, "User Agent");


            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on HITS...");
            AddLogStatus(info);
            id = LogFeature.HITS.ToString();
            HitsControl uc3 = new HitsControl();

            uc3.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc3.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc3.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc3.ListOfYear = listOfYear;
            Attach(uc3, id, "Hits");


            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on ACCESS...");
            AddLogStatus(info);
            id = LogFeature.ACCESS.ToString();
            AccessPageControl uc4 = new AccessPageControl();

            uc4.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc4.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc4.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc4.ListOfYear = listOfYear;
            Attach(uc4, id, "Access Page");


            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on IPADDRESS...");
            AddLogStatus(info);
            id = LogFeature.IPADDRESS.ToString();
            IPAddressControl uc5 = new IPAddressControl();

            uc5.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc5.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc5.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc5.ListOfYear = listOfYear;
            Attach(uc5, id, "IP Address");

            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on STATUS...");
            AddLogStatus(info);
            id = LogFeature.STATUS.ToString();
            AccessStatusControl uc6 = new AccessStatusControl();

            uc6.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc6.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc6.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc6.ListOfYear = listOfYear;
            Attach(uc6, id, "HTTP Status");


            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on BANDWIDTH...");
            AddLogStatus(info);
            id = LogFeature.BANDWIDTH.ToString();
            BandwidthControl uc7 = new BandwidthControl();

            uc7.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc7.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc7.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc7.ListOfYear = listOfYear;
            Attach(uc7, id, "Bandwidth");


            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on REQUEST...");
            AddLogStatus(info);
            id = LogFeature.REQUEST.ToString();
            RequestProcessingControl uc8 = new RequestProcessingControl();

            uc8.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc8.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc8.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc8.ListOfYear = listOfYear;
            Attach(uc8, id, "Processing Request");

            info = String.Format("{0:yyyy/MM/dd HH:mm:ss}[info]: {1}", DateTime.Now, "Populating data on REFERER...");
            AddLogStatus(info);
            id = LogFeature.REFERER.ToString();
            RefererControl uc9 = new RefererControl();

            uc9.FileName = parser.FileName;
            if (!parser.UseExistData)
            {
                uc9.FeatureGuid = parser.LogParserId.ToString();
            }
            else
            {
                uc9.FeatureGuid = string.Format("!!{0}", parser.FileName);
            }
            uc9.ListOfYear = listOfYear;
            Attach(uc9, id, "Referer");

            tabMainLog.SelectedTab = tabMainLog.TabPages[LogFeature.GENERAL.ToString()];
        }
Esempio n. 2
0
        protected override bool ExportData()
        {
            bool   success   = false;
            string year      = IndihiangHelper.GetYearDataIndihiangFile(_databaseFile);
            string conString = string.Format("server={0};database={1};uid={2};pwd={3}", _svr, _db, _uid, _pwd);

            if (!string.IsNullOrEmpty(year))
            {
                SQLiteConnection  con   = null;
                SQLiteDataReader  rd    = null;
                OracleConnection  con2  = null;
                OracleTransaction trans = null;

                con2 = new OracleConnection(conString);
                con2.Open();

                trans = con2.BeginTransaction();
                using (OracleCommand cmd2 = con2.CreateCommand())
                {
                    StringBuilder builder = new StringBuilder();
                    builder.Append("insert into [indihiang_data](fullfilename,a_day,a_month,a_year,server_ip,");
                    builder.Append("server_port,client_ip,page_access,query_page_access,access_username,");
                    builder.Append("user_agent,protocol_status,bytes_sent,bytes_received,referer,ip_country,time_taken,referer_class)");
                    builder.Append(" values(@par1,@par2,@par3,@par4,@par5,@par6,@par7,@par8,@par9,@par10,@par11,@par12,@par13,@par14,@par15,@par16,@par17,@par18)");

                    cmd2.CommandText = builder.ToString();
                    cmd2.Transaction = trans;

                    OracleParameter par1 = new OracleParameter("@par1", DbType.String);
                    cmd2.Parameters.Add(par1);
                    OracleParameter par2 = new OracleParameter("@par2", DbType.Int32);
                    cmd2.Parameters.Add(par2);
                    OracleParameter par3 = new OracleParameter("@par3", DbType.Int32);
                    cmd2.Parameters.Add(par3);
                    OracleParameter par4 = new OracleParameter("@par4", DbType.Int32);
                    cmd2.Parameters.Add(par4);
                    OracleParameter par5 = new OracleParameter("@par5", DbType.String);
                    cmd2.Parameters.Add(par5);
                    OracleParameter par6 = new OracleParameter("@par6", DbType.String);
                    cmd2.Parameters.Add(par6);
                    OracleParameter par7 = new OracleParameter("@par7", DbType.String);
                    cmd2.Parameters.Add(par7);
                    OracleParameter par8 = new OracleParameter("@par8", DbType.String);
                    cmd2.Parameters.Add(par8);
                    OracleParameter par9 = new OracleParameter("@par9", DbType.String);
                    cmd2.Parameters.Add(par9);
                    OracleParameter par10 = new OracleParameter("@par10", DbType.String);
                    cmd2.Parameters.Add(par10);
                    OracleParameter par11 = new OracleParameter("@par11", DbType.String);
                    cmd2.Parameters.Add(par11);
                    OracleParameter par12 = new OracleParameter("@par12", DbType.String);
                    cmd2.Parameters.Add(par12);
                    OracleParameter par13 = new OracleParameter("@par13", DbType.String);
                    cmd2.Parameters.Add(par13);
                    OracleParameter par14 = new OracleParameter("@par14", DbType.String);
                    cmd2.Parameters.Add(par14);
                    OracleParameter par15 = new OracleParameter("@par15", DbType.String);
                    cmd2.Parameters.Add(par15);
                    OracleParameter par16 = new OracleParameter("@par16", DbType.String);
                    cmd2.Parameters.Add(par16);
                    OracleParameter par17 = new OracleParameter("@par17", DbType.String);
                    cmd2.Parameters.Add(par17);
                    OracleParameter par18 = new OracleParameter("@par18", DbType.String);
                    cmd2.Parameters.Add(par18);

                    try
                    {
                        con = new SQLiteConnection(string.Format("Data Source={0}", _databaseFile));
                        con.Open();

                        string        query = "select * from log_data";
                        SQLiteCommand cmd   = new SQLiteCommand(query, con);
                        rd = cmd.ExecuteReader();
                        while (rd.Read())
                        {
                            par1.Value  = rd["fullfilename"];
                            par2.Value  = rd["a_day"];
                            par3.Value  = rd["a_month"];
                            par4.Value  = Convert.ToInt32(year);
                            par5.Value  = rd["server_ip"];
                            par6.Value  = rd["server_port"];
                            par7.Value  = rd["client_ip"];
                            par8.Value  = rd["page_access"];
                            par9.Value  = rd["query_page_access"];
                            par10.Value = rd["access_username"];
                            par11.Value = rd["user_agent"];
                            par12.Value = rd["protocol_status"];
                            par13.Value = rd["bytes_sent"];
                            par14.Value = rd["bytes_received"];
                            par15.Value = rd["referer"];
                            par16.Value = rd["ip_country"];
                            par17.Value = rd["time_taken"];
                            par18.Value = rd["referer_class"];

                            cmd2.ExecuteNonQuery();
                        }
                        trans.Commit();
                        con2.Close();
                        success = true;
                    }
                    catch (Exception err)
                    {
                        System.Diagnostics.Debug.WriteLine(err.StackTrace);
                    }
                    finally
                    {
                        if (rd != null)
                        {
                            rd.Close();
                        }
                        if (con != null)
                        {
                            con.Close();
                        }
                    }
                }
            }

            return(success);
        }