public int parseS1ModeInterMMECombinedTauSucRate4GFile() { 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); S1ModeInterMMECombinedTauSucRate_Model data = new S1ModeInterMMECombinedTauSucRate_Model(); data.timesOfInterMmeTauWithSgwChangeAttempt = Convert.ToInt32(tokens[34]); data.timesOfInterMmeTauWithoutSgwChangeAttempt = Convert.ToInt32(tokens[35]); data.SuccessfulTimesOfInterMmeTauWithSgwChangeAttempt = Convert.ToInt32(tokens[36]); data.SuccessfulTimesOfInterMmeTauWithoutSgwChangeAttempt = Convert.ToInt32(tokens[37]); 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_inter_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.timesOfInterMmeTauWithSgwChangeAttempt + "','" + data.timesOfInterMmeTauWithoutSgwChangeAttempt + "',0,0,'" + data.SuccessfulTimesOfInterMmeTauWithSgwChangeAttempt + "','" + data.SuccessfulTimesOfInterMmeTauWithoutSgwChangeAttempt + "','" + 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 parseGgsnGiTrafficFile() { 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); GGSNGiTraffic_Model data = new GGSNGiTraffic_Model(); data.giDataInGB = Convert.ToInt32(tokens[5]); 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_2g_3g_gi_traffic ( zte_gi_data_in_GB,node_name,vendor,result_time) values ('" + data.giDataInGB + "','" + 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); }