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);
}