﻿From main.cs

  #region Test

        /**********************************************TEST ......................
        /// <summary>
        /// Test lecture xml imbriqué
        /// </summary>
        private void tt()
        {

            //XElement xEle = new XElement("tb_prestas", "content");//XElement.Load(Program.folder + @"\employees.xml");
            //IEnumerable<XElement> employees = xelement.Elements();
            //// Read the entire XML
            //foreach (var employee in employees)
            //{
            //    Console.WriteLine("***********");
            //    Console.WriteLine(employee);
            //}

            //XElement xEle = XElement.Load("..\\..\\Employees.xml");
            XElement sxEle = new XElement("Employee",
            new XElement("EmpId", 6),
            new XElement("Name", "George"),
            new XElement("Sex", "Male"),
            new XElement("Phone", "423-555-4224", new XAttribute("Type", "Home")),
            new XElement("Phone", "424-555-0545", new XAttribute("Type", "Work")),
            new XElement("Address",
                new XElement("Street", "Fred Park, East Bay"),
                new XElement("City", "Acampo"),
                new XElement("State", "CA"),
                new XElement("Zip", "95220"),
                new XElement("Country", "USA")));

            XElement xEle = new XElement("tb_prestas", sxEle);
            xEle.Save(Program.folder + @"\employees2.xml");
            Console.WriteLine(xEle);
        }
        **********************************************************/

        #endregion Test



        /*
         *
           List<string> linesGlob = lines.FindAll(
                delegate(string sr)
                {
                    return sr.ToUpper().Contains(".GLOBAL.");
                }
                );
            List<string> linesUnik = lines.FindAll(
                delegate(string sr)
                {
                    return !sr.ToUpper().Contains(".GLOBAL.");
                }
                );
            foreach (string line in linesGlob)
                readHttp_Glob(line);
            foreach (string line in linesUnik)
                readHttp_Unik(line);
         *
        private void readHttp_Glob(string url_txt)
        {
            Uri url = new Uri(url_txt);
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
            request.MaximumAutomaticRedirections = 4;
            request.MaximumResponseHeadersLength = 4;
            request.Credentials = CredentialCache.DefaultCredentials;
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            Stream receiveStream = response.GetResponseStream();
            StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);

            streamtolist_glob(readStream);

            readStream.Close();
            response.Close();
        }
        private void readHttp_Unik(string url_txt)
        {
            Uri url = new Uri(url_txt);
            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
            request.MaximumAutomaticRedirections = 4;
            request.MaximumResponseHeadersLength = 4;
            request.Credentials = CredentialCache.DefaultCredentials;
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            Stream receiveStream = response.GetResponseStream();
            StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
            streamtolist_uniq(readStream);
            response.Close();
            readStream.Close();
        }
        //Make Images
        private void makePnpFromDB()
        {
            //the index number to write bytes to
            long CurrentIndex = 0;

            //the number of bytes to store in the array
            int BufferSize = 4096;

            //The Number of bytes returned from GetBytes() method
            long BytesReturned;

            //A byte array to hold the buffer
            byte[] Blob = new byte[BufferSize];

            string strCnx="server=localhost;user id=Patrick;password=xvtu92+2;persist security info=True;database=carbu";
            MySql.Data.MySqlClient.MySqlConnection myCnx = new MySql.Data.MySqlClient.MySqlConnection(strCnx);
            myCnx.Open();
            string strCmd = "select * from pays";
            MySql.Data.MySqlClient.MySqlCommand myCmd = new MySqlCommand(strCmd,myCnx);
            MySqlDataReader myReader = myCmd.ExecuteReader();
            while ( myReader.Read())
            {
                listBox1.Items.Add(myReader.GetString(0));

                FileStream fs = new FileStream("D:\\temp\\" + myReader.GetString(0)+"_"+ myReader.GetString(1)+"_"+ myReader.GetString(2).Replace(" ","")+".png", FileMode.OpenOrCreate, FileAccess.Write);
                BinaryWriter writer = new BinaryWriter(fs);
                CurrentIndex = 0;
                BytesReturned = myReader.GetBytes(3, CurrentIndex, Blob, 0, BufferSize);

                while (BytesReturned == BufferSize)
                {
                    writer.Write(Blob);
                    writer.Flush();
                    CurrentIndex += BufferSize;
                    BytesReturned = myReader.GetBytes(3, CurrentIndex, Blob, 0, BufferSize);
                }

                writer.Write(Blob, 0, (int)BytesReturned);
                writer.Flush();
                writer.Close();
                fs.Close();
            }
            myReader.Close();
            myCnx.Close();
        }
        */

