//static WS_PreluareDate()
        //{
        //}

        static public void InitializareHale()
        {
            string sStream = null;
            const string sSeparatori1 = "@";
            const string sSeparatori2 = "#";
            WebService.PreluareDate ws;

            try
            {
                ws = new WebService.PreluareDate();
                ws.Proxy = System.Net.GlobalProxySelection.GetEmptyWebProxy();
                sStream = ws.GetHale();
                Debug.WriteLine("sStream= " + sStream);
                if ((sStream == null) || (sStream.Trim().Length == 0)) { return; }
            }
            catch
            {
                //TODO create exception EXC_DBRemoteServerConnectionError();
                //throw new EXC_DBRemoteServerConnectionError();
            }
            finally
            {
                ws = null;
            }


            try
            {
                Database.Connect();
                //TODO isolate common code and create stream decode method
                string[] sAtomi1 = sStream.Split(sSeparatori1.ToCharArray());

                int index1;
                for (index1 = 0; index1 < sAtomi1.Length; index1 = index1 + 1)
                {
                    if (sAtomi1[index1].Length <= 0) continue;

                    string[] sAtomi2 = sAtomi1[index1].Split(sSeparatori2.ToCharArray());
                    string idHala = sAtomi2[0];
                    string denumire = sAtomi2[1];
                    //Debug.WriteLine("str1= " + str1);//listBox1.Items.Add(str2);
                    //Debug.WriteLine("str2= " + str2);

                    Database.Connect();
                    TabelHale.InsertTableHale(idHala, denumire);
                    Database.Close();
                }




            }
            catch
            {
                //TODO create exception EXC_FormatIncorect();
                //throw new EXC_FormatIncorect();
            }
            finally
            {
                Database.Close();
            }


        }