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