private void backgroundReportJob_DoWork(object sender, DoWorkEventArgs e) { try { string par = e.Argument.ToString(); LogDataFacade facade = new LogDataFacade(_guid); if (par.Contains("-")) { string[] items = par.Split(new char[] { '-' }); int month = IndihiangHelper.GetMonth(items[0]); _listAgentData = facade.GetTotalPerUserAgentByParams(Convert.ToInt32(items[1]), month); } else { _listAgentData = facade.GetTotalPerUserAgentByParams(Convert.ToInt32(par)); } } catch (Exception err) { Logger.Write(err.Message); Logger.Write(err.StackTrace); System.Diagnostics.Debug.WriteLine(err.Message); } }
private void backgroundJob_DoWork(object sender, DoWorkEventArgs e) { try { LogDataFacade facade = new LogDataFacade(_guid); _listPerAgent = facade.GetTotalPerUserAgent(); //_listYears = facade.GetListyearLogFile(); for (int i = 0; i < _listYears.Count; i++) { List <string> list = facade.GetMonthLogFileListByYear(_listYears[i]); for (int j = 0; j < list.Count; j++) { string monthYear = string.Format("{0}-{1}", IndihiangHelper.GetMonth(Convert.ToInt32(list[j])), _listYears[i]); _listYearMonth.Add(monthYear); } } } catch (Exception err) { Logger.Write(err.Message); Logger.Write(err.StackTrace); System.Diagnostics.Debug.WriteLine(err.Message); } }
private string zedGraphBytesInOut_PointValueEvent(ZedGraphControl sender, GraphPane pane, CurveItem curve, int iPt) { PointPair pt = curve[iPt]; DateTime date = DateTime.FromOADate(pt.X); return(String.Format("[{0:yyyy-MMM-dd} --> {1}]", date, IndihiangHelper.BytesFormat((long)pt.Y))); }
private void backgroundJob_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { try { LogDataFacade facade = new LogDataFacade(_guid); _listServers = facade.GetServerList(); _listFiles = facade.GetLogFileList(); _totalData = facade.GetTotalData(); _listTime = facade.GetTimeLogFileList(); _listFiles = IndihiangHelper.ParseFile(_fileName); } catch (Exception err) { Logger.Write(err.Message); Logger.Write(err.StackTrace); System.Diagnostics.Debug.WriteLine(err.Message); } }
private void backgroundJobGrid_DoWork(object sender, DoWorkEventArgs e) { try { string par = e.Argument.ToString(); string[] items = par.Split(new char[] { '-' }); int month = IndihiangHelper.GetMonth(items[0]); int year = Convert.ToInt32(items[1]); LogDataFacade facade = new LogDataFacade(_guid); _listAccessPage = new List <DumpData>(facade.GetAccessPageByYearMonth(year, month)); } catch (Exception err) { Logger.Write(err.Message); Logger.Write(err.StackTrace); System.Diagnostics.Debug.WriteLine(err.Message); } }
public bool InsertBulkDumpData(List <Indihiang.DomainObject.DumpData> dump) { bool success = false; SQLiteConnection con = null; DbTransaction trans = null; try { con = new SQLiteConnection(GetConnectionStrng()); con.Open(); trans = con.BeginTransaction(); using (SQLiteCommand cmd = con.CreateCommand()) { StringBuilder builder = new StringBuilder(); builder.Append("insert into [log_data](fullfilename,a_day,a_month,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)"); cmd.CommandText = builder.ToString(); SQLiteParameter par1 = cmd.Parameters.Add("@par1", DbType.String); SQLiteParameter par2 = cmd.Parameters.Add("@par2", DbType.Int32); SQLiteParameter par3 = cmd.Parameters.Add("@par3", DbType.Int32); SQLiteParameter par4 = cmd.Parameters.Add("@par4", DbType.String); SQLiteParameter par5 = cmd.Parameters.Add("@par5", DbType.String); SQLiteParameter par6 = cmd.Parameters.Add("@par6", DbType.String); SQLiteParameter par7 = cmd.Parameters.Add("@par7", DbType.String); SQLiteParameter par8 = cmd.Parameters.Add("@par8", DbType.String); SQLiteParameter par9 = cmd.Parameters.Add("@par9", DbType.String); SQLiteParameter par10 = cmd.Parameters.Add("@par10", DbType.String); SQLiteParameter par11 = cmd.Parameters.Add("@par11", DbType.String); SQLiteParameter par12 = cmd.Parameters.Add("@par12", DbType.String); SQLiteParameter par13 = cmd.Parameters.Add("@par13", DbType.String); SQLiteParameter par14 = cmd.Parameters.Add("@par14", DbType.String); SQLiteParameter par15 = cmd.Parameters.Add("@par15", DbType.String); SQLiteParameter par16 = cmd.Parameters.Add("@par16", DbType.String); SQLiteParameter par17 = cmd.Parameters.Add("@par17", DbType.String); for (int i = 0; i < dump.Count; i++) { par1.Value = dump[i].FullFileName; par2.Value = dump[i].Day; par3.Value = dump[i].Month; par4.Value = IndihiangHelper.GetStringLogItem(dump[i].Server_IP); par5.Value = IndihiangHelper.GetStringLogItem(dump[i].Server_Port); par6.Value = IndihiangHelper.GetStringLogItem(dump[i].Client_IP); par7.Value = IndihiangHelper.GetStringLogItem(dump[i].Page_Access); par8.Value = IndihiangHelper.GetStringLogItem(dump[i].Query_Page_Access); par9.Value = IndihiangHelper.GetStringLogItem(dump[i].Access_Username); par10.Value = IndihiangHelper.GetStringLogItem(dump[i].User_Agent); par11.Value = IndihiangHelper.GetStringLogItem(dump[i].Protocol_Status); par12.Value = dump[i].Bytes_Sent; par13.Value = dump[i].Bytes_Received; par14.Value = IndihiangHelper.GetStringLogItem(dump[i].Referer); par15.Value = IndihiangHelper.GetStringLogItem(dump[i].IPClientCountry); par16.Value = dump[i].TimeTaken; par17.Value = IndihiangHelper.GetStringLogItem(dump[i].RefererClass); cmd.ExecuteNonQuery(); } } trans.Commit(); success = true; } catch (Exception err) { System.Diagnostics.Debug.WriteLine(err.StackTrace); } finally { if (con != null) { con.Close(); con.Dispose(); } } return(success); }
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()]; }
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); }
private void PopulateGeneral() { lbBytesSent.Text = IndihiangHelper.BytesFormat(_totalBytesSent); lbBytesReceived.Text = IndihiangHelper.BytesFormat(_totalBytesReceived); lbTotal.Text = IndihiangHelper.BytesFormat(_totalBytesSent + _totalBytesReceived); }