public int parseAttaSuccR3GFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; //Console.WriteLine("{0} does not exist.", file_to_parse); if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); line_count = 0; while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); asr3GList.Add(new ASR3G_Model { attemptedTimesGPRSAttachProcedure = Convert.ToInt32(tokens[8]), successfulTimesGPRSAttachProcedure = Convert.ToInt32(tokens[9]), resultTime = oDate, nodeName = nodeName }); line_count++; } sr.Close(); } } string queryString = ""; foreach (var asr3g in asr3GList) { queryString += "INSERT into ps_sgsn_3g_attach_success_rate ( iu_mode_gprs_attach_request_times,iu_mode_gprs_attach_success_times,node_name,vendor,result_time) values ('" + asr3g.attemptedTimesGPRSAttachProcedure + "','" + asr3g.successfulTimesGPRSAttachProcedure + "','" + asr3g.nodeName + "','" + asr3g.vendor + "','" + asr3g.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } //Console.WriteLine(queryString); try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); int inserted_rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }
public int parsePdpActiSucRate2GFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); PdpActivationSuccessRate2G_Model data = new PdpActivationSuccessRate2G_Model(); data.timesOfPdpContextActivationRequestbyMS = Convert.ToInt32(tokens[24]); data.SuccessfulTimes = Convert.ToInt32(tokens[25]); data.resultTime = oDate; data.nodeName = nodeName; dataList.Add(data); line_count++; } sr.Close(); } } string queryString = ""; foreach (var data in dataList) { queryString += "INSERT into ps_sgsn_2g_pdp_activation_success_rate ( gb_mode_ms_init_pdp_context_act,gb_mode_ms_init_pdp_context_act_success,node_name,vendor,result_time) values ('" + data.timesOfPdpContextActivationRequestbyMS + "','" + data.SuccessfulTimes + "','" + data.nodeName + "','" + data.vendor + "','" + data.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); int inserted_rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }
public int parseGGSNTotalTrafficFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); GGSNTotalTraffic_Model data = new GGSNTotalTraffic_Model(); data.bdclTotalDataInByte = Convert.ToInt64(tokens[11]); data.resultTime = oDate; data.nodeName = nodeName; dataList.Add(data); line_count++; } sr.Close(); } } string queryString = ""; foreach (var data in dataList) { queryString += "INSERT into ps_ggsn_total_traffic ( bdcl_total_data_in_byte_zte,node_name,vendor,result_time) values ('" + data.bdclTotalDataInByte + "','" + data.nodeName + "','" + data.vendor + "','" + data.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); int inserted_rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }
public int parseTraffic2GFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; long gbSent, gbReceived; if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); line_count = 0; while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; gbReceived = Convert.ToInt64(tokens[12]); gbSent = Convert.ToInt64(tokens[13]); //Console.WriteLine((double)gbSent/1024); DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); traffic2GList.Add(new Traffic2G_Model { sentToGbOverIpInKB = Math.Round((double)gbSent / 1024, 2), rcvdFrmGbOverIpInKB = Math.Round((double)gbReceived / 1024, 2), resultTime = oDate, nodeName = nodeName }); line_count++; } sr.Close(); } } string queryString = ""; foreach (var traffic2g in traffic2GList) { queryString += "INSERT into ps_sgsn_2g_traffic ( gb_mode_downlink_kbytes,gb_mode_uplink_kbytes,node_name,vendor,result_time) values ('" + traffic2g.rcvdFrmGbOverIpInKB + "','" + traffic2g.sentToGbOverIpInKB + "','" + traffic2g.nodeName + "','" + traffic2g.vendor + "','" + traffic2g.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); int inserted_rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }
public int parseAttaSuccRFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; //Console.WriteLine("{0} does not exist.", file_to_parse); if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } //int j = 0; char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } /*if (!File.Exists(file_to_parse)) * { * Console.WriteLine("{0} does not exist.", file_to_parse); * return 0; * }*/ using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); line_count = 0; //int i = 0; while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); //Console.WriteLine(oDate.ToString()); /*EmailData data = new EmailData(); * data.FirstName = "JOhn"; * data.LastName = "Smith"; * data.Location = "Los Angeles"; * * lstemail.Add(data);*/ asr2GList.Add(new ASR2G_Model { attemptedTimesGPRSAttachProcedure = Convert.ToInt32(tokens[6]), successfulTimesGPRSAttachProcedure = Convert.ToInt32(tokens[7]), resultTime = oDate, nodeName = nodeName }); line_count++; } sr.Close(); } } string queryString = ""; foreach (var asr2g in asr2GList) { //Console.WriteLine(asr2g.resultTime.ToString("yyyy-MM-dd HH:mm:ss")); queryString += "INSERT into ps_sgsn_2g_attach_success_rate ( gb_mode_gprs_attach_request_times,gb_mode_gprs_attach_accept_times,node_name,vendor,result_time) values ('" + asr2g.attemptedTimesGPRSAttachProcedure + "','" + asr2g.successfulTimesGPRSAttachProcedure + "','" + asr2g.nodeName + "','" + asr2g.vendor + "','" + asr2g.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } //Console.WriteLine(queryString); try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); //MySqlDataReader rdr = cmd.ExecuteReader(); int inserted_rows = cmd.ExecuteNonQuery(); /*while (rdr.Read()) * { * Console.WriteLine(rdr[0] + " -- " + rdr[1]); * }*/ } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }
public int parseS1ModeIntraMMECombinedTauSucRate4GFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); S1ModeIntraMMECombinedTauSucRate_Model data = new S1ModeIntraMMECombinedTauSucRate_Model(); data.timesOfIntraMmeTauWithSgwChangeAttempt = Convert.ToInt32(tokens[32]); data.timesOfIntraMmeTauWithoutSgwChangeAttempt = Convert.ToInt32(tokens[33]); data.SuccessfulTimesOfIntraMmeTauWithSgwChangeAttempt = Convert.ToInt32(tokens[30]); data.SuccessfulTimesOfIntraMmeTauWithoutSgwChangeAttempt = Convert.ToInt32(tokens[31]); data.resultTime = oDate; data.nodeName = nodeName; dataList.Add(data); line_count++; } sr.Close(); } } string queryString = ""; foreach (var data in dataList) { queryString += "INSERT into ps_sgsn_4g_s1_intra_mme_com_tau_suc_rate ( tau_request_times_sgw_change,tau_request_times_sgw_not_change,tau_suc_times_for_eps_non_eps_sgw_change,tau_suc_times_for_eps_non_eps_sgw_not_change,tau_suc_times_for_eps_sms_sgw_change,tau_suc_times_for_eps_sms_sgw_not_change,node_name,vendor,result_time) values ('" + data.timesOfIntraMmeTauWithSgwChangeAttempt + "','" + data.timesOfIntraMmeTauWithoutSgwChangeAttempt + "',0,0,'" + data.SuccessfulTimesOfIntraMmeTauWithSgwChangeAttempt + "','" + data.SuccessfulTimesOfIntraMmeTauWithoutSgwChangeAttempt + "','" + data.nodeName + "','" + data.vendor + "','" + data.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); int inserted_rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }
public int parseSauFile() { int line_count = 0; FilesToParse.Add(file_to_parse_gz); FilesToParse.Add(file_to_parse_kt); foreach (string file_to_parse in FilesToParse) { string nodeName = "", st_time = ""; if (file_to_parse.Contains("_GZ_")) { nodeName = "GZ"; } else if (file_to_parse.Contains("_KT_")) { nodeName = "KT"; } char[] delimiterChars = new char[5]; try { if (!File.Exists(file_to_parse)) { throw new Exception(); } } catch (Exception e) { Console.WriteLine(e.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, e); return(0); } using (StreamReader sr = File.OpenText(@file_to_parse)) { String input; string[] tokens; sr.ReadLine(); line_count = 0; while ((input = sr.ReadLine()) != null) { delimiterChars[0] = ','; tokens = input.Split(delimiterChars[0]); st_time = tokens[1]; DateTime oDate = DateTime.ParseExact(st_time, "yyyy-MM-dd HH:mm:ss", null); sau2GList.Add(new SAU2G_Model { maximumAttachedSubscribers = Convert.ToInt32(tokens[11]), resultTime = oDate, nodeName = nodeName }); line_count++; } sr.Close(); } } string queryString = ""; foreach (var sau2g in sau2GList) { queryString += "INSERT into ps_sgsn_2g_sau ( gb_mode_maximum_attached_users,node_name,vendor,result_time) values ('" + sau2g.maximumAttachedSubscribers + "','" + sau2g.nodeName + "','" + sau2g.vendor + "','" + sau2g.resultTime.ToString("yyyy-MM-dd HH:mm:ss") + "');"; } try { MySqlConnection cn = DatabaseConnection.CreateConnection(); MySqlCommand cmd = new MySqlCommand(queryString, cn); int inserted_rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { DatabaseConnection.CloseConnection(); Console.WriteLine(ex.ToString()); Util.writeLog(new StackTrace(1).GetFrame(0).GetMethod().Name, ex); return(0); } DatabaseConnection.CloseConnection(); return(line_count); }