Example #1
0
        public int parseMaxBearerNumber4GFile()
        {
            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;
                    //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);

                        MaxBearerNumber4G_Model data = new MaxBearerNumber4G_Model();
                        data.maxDefaultBearerActive = Convert.ToInt32(tokens[54]);
                        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_max_bearer_number ( max_bearer_number,node_name,vendor,result_time) values ('" + data.maxDefaultBearerActive + "','" + 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 parseS1CombAttachSucRate4GFile()
        {
            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;
                    //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);

                        S1ModeCombinedAttachSuccessRate4G_Model data = new S1ModeCombinedAttachSuccessRate4G_Model();
                        data.timesOfCombinedAttachRequest = Convert.ToInt32(tokens[29]);
                        data.timesOfSuccess = Convert.ToInt32(tokens[28]);
                        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_mode_combined_attach_success_rate ( s1_mode_combined_attach_request_times,s1_mode_combined_att_succ_times_for_eps_and_non_eps_services,s1_mode_combined_att_succ_times_for_eps_srvces_and_sms_only,node_name,vendor,result_time) values ('" + data.timesOfCombinedAttachRequest + "','" + data.timesOfSuccess + "',0,'" + 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);
        }