C#

while ((line = file.ReadLine()) != null)
{
    if (line.Substring(0, 2) == "CL")
    {
        try
        {
            string[] strArray = line.Split("=".ToCharArray());
            string key = strArray[0];
            string str = strArray[1];

public static void letsdoit(SqlConnection con)
{
    string[] files;
    string line;
    int counter = 0;

    using (UNCAccessWithCredentials unc = new UNCAccessWithCredentials())
    {
        if (unc.NetUseWithCredentials(@"\\ql1telutil1\c$\inetpub\wwwroot", "xxxxxxxxxx", "xx", "xxxxxx"))
        {
            files = Directory.GetFiles(@"\\ql1telutil1\c$\inetpub\wwwroot\backup96XX");

            foreach (string f in files)
            {
                sqlString = null;
                int myCounter = 0;

                List<Int32> myCountList = new List<Int32>();
                List<Int32> UniqueCallNumber = new List<Int32>();

                System.IO.StreamReader file = new System.IO.StreamReader(f);

                string[] array2 = f.Split("\\".ToCharArray());

                string myStat = array2[7].ToString().Substring(0, 5);

                log.Info("Getting history for extension: " + myStat);

                while ((line = file.ReadLine()) != null)
                {
                    if (line.Substring(0, 2) == "CL")
                    {
                        try
                        {
                            string[] strArray = line.Split("=".ToCharArray());
                            string key = strArray[0];
                            string str = strArray[1];

                            sqlString = sqlString + MinifyB(str.Trim()) + "','";

                            myCounter = myCounter + 1;

                            if(myCounter == 9)
                            {
                                try
                                {
                                    addSQL =
                                        "INSERT INTO tblStationCallHistory(CLSTATION, CLNAME, CLNUMBER, CLTYPE, CLDATE, CLTIME, CLDURATION, CLBRIDGEDFLAG, CLMISSEDCNTR, CLBCALBL) " +
                                        "VALUES('" + myStat + "','" + sqlString.Substring(0,sqlString.Length - 2) + ")";

                                    SqlCommand updateCMD = new SqlCommand(addSQL, con);

                                    try
                                    {
                                        updateCMD.ExecuteNonQuery();
                                    }
                                    catch (Exception ex)
                                    {
                                        log.Error("There was a problem executing the command. " + ex.Message);
                                    }
                                }
                                catch (Exception ex)
                                {
                                    log.Error("There was a problem inserting the coverage path into the table. " + ex.Message);
                                }

                                sqlString = null;
                                myCounter = 0;
                            }
                        }
                        catch (Exception ex)
                        {
                            string myError = ex.Message.ToString();
                        }
                    }
                    counter++;
                }

                file.Close();
            }
        }
    }
}

public class Service191 : IService191
{
    public string data;
    public static NpgsqlConnection conn;

    /*
     * Connection à la base de donnée
     */
    public void connection()
    {
        try
        {
                Mails mail = new Mails();
                string strConnString = "Server=194.206.X.XXX; Port=5432; Database=XXXXX; User Id=XXXX; Password=XXXXX";
                DAL.DAL dal = new DAL.DAL(strConnString);

                //TestSelectCommand(mail, dal);
                //TestXMLSerialization();


                GenerateGetRequest();
                //GeneratePostRequest();


        }
        catch (Exception e)
        {
            MessageBox.Show(e.ToString());
        } 
    }

private static void GenerateGetRequest()
    {
        string url = "http://localhost:49761/Service191.svc/mails?id=14";
        HttpWebRequest GETRequest = (HttpWebRequest)WebRequest.Create(url);
        GETRequest.Method = WebRequestMethods.Http.Get;

       HttpWebResponse GETResponse = (HttpWebResponse)GETRequest.GetResponse();
        Stream GetResponseStream = GETResponse.GetResponseStream();
        StreamReader sr = new StreamReader(GetResponseStream);

        MessageBox.Show(sr.ReadToEnd());
    }

public class Handler : IHttpHandler
{
    private DAL.DAL dal;
    private string connString;
    private Mails mail;
    private ErrorHandler.ErrorHandler errHandler;

    #region HANDLER

    public bool IsReusable
    {
        get
        {
            throw new NotImplementedException();
        }
    }

    public void ProcessRequest(HttpContext context)
    {
        try
        {
            string url = Convert.ToString(context.Request.Url);
            connString = "Server = 194.206.X.XXX; Port = 5432; Database = XXXX; User Id = XXXX; Password = XXXXX";
            dal = new DAL.DAL(connString);
            errHandler = new ErrorHandler.ErrorHandler();

            switch (context.Request.HttpMethod)
            {
                case "GET":
                    READ(context);
                    break;
                case "POST":
                    CREATE(context);
                    break;
                case "PUT":
                    UPDATE(context);
                    break;
                case "DELETE":
                    DELETE(context);
                    break;
                default:
                    break;
            }
        }
        catch (Exception ex)
        {
            errHandler.ErrorMessage = ex.Message.ToString();
            context.Response.Write(errHandler.ErrorMessage);
            //MessageBox.Show(ex.ToString());
        }
    }

    #endregion

    #region CRUD

    private void READ(HttpContext context)
    {
        try
        {
            int id = Convert.ToInt16(context.Request["id"]);
            mail = dal.GetMail(id);
            if (mail == null)
                context.Response.Write(id + "No mail found");

            string serialized = Serialize(mail);
            context.Response.ContentType = "text/xml";
            WriteResponse(serialized);
            MessageBox.Show("mail READ");
        }
        catch (Exception ex)
        {
            errHandler.ErrorMessage = dal.GetException();
            errHandler.ErrorMessage = ex.Message.ToString();
            //MessageBox.Show(ex.ToString());
        }
    }

    private void CREATE(HttpContext context)
    {
        try
        {
            byte[] PostData = context.Request.BinaryRead(context.Request.ContentLength);
            string str = Encoding.UTF8.GetString(PostData);
            Mails mail = Deserialize(PostData);
            dal.AddMail(mail);
            MessageBox.Show("mail CREATE");
        }
        catch (Exception ex)
        {
            errHandler.ErrorMessage = dal.GetException();
            errHandler.ErrorMessage = ex.Message.ToString();
            //MessageBox.Show(ex.ToString());
        }

    }

    private void UPDATE(HttpContext context)
    {
        try
        {
            byte[] PUTRequestByte = context.Request.BinaryRead(context.Request.ContentLength);
            context.Response.Write(PUTRequestByte);

            Mails mail = Deserialize(PUTRequestByte);
            dal.UpdateMail(mail);
            MessageBox.Show("mail UPDATE");
        }
        catch (Exception ex)
        {
            errHandler.ErrorMessage = dal.GetException();
            errHandler.ErrorMessage = ex.Message.ToString();
            //MessageBox.Show(ex.ToString());
        }
    }

    private void DELETE(HttpContext context)
    {
        try
        {
            int id = Convert.ToInt16(context.Request["id"]);
            dal.DeleteMail(id);
            MessageBox.Show("mail DELETE");
        }
        catch (Exception ex)
        {
            errHandler.ErrorMessage = dal.GetException();
            errHandler.ErrorMessage = ex.Message.ToString();
        }
    }

    #endregion

    private Mails Deserialize (byte[] xmlByteData)
    {
        try
        {
            XmlSerializer ds = new XmlSerializer(typeof(Mails));
            MemoryStream memoryStream = new MemoryStream(xmlByteData);
            Mails mail = new Mails();
            mail = (Mails)ds.Deserialize(memoryStream);
            return mail;
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
            throw;
        }
    }

    private static void WriteResponse(string strMessage)
    {
        HttpContext.Current.Response.Write(strMessage);
    }

    private String Serialize(Mails mail)
    {
        try
        {
            String XmlizedString = null;
            XmlSerializer xs = new XmlSerializer(typeof(Mails));
            MemoryStream memoryStream = new MemoryStream();
            XmlTextWriter xmlTextWriter = new XmlTextWriter(memoryStream, Encoding.UTF8);
            xs.Serialize(xmlTextWriter, mail);
            memoryStream = (MemoryStream)xmlTextWriter.BaseStream;
            XmlizedString = UTF8ByteArrayToString(memoryStream.ToArray());
            return XmlizedString;
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
            throw;
        }
    }

    private String UTF8ByteArrayToString(Byte[] characters)
    {
        UTF8Encoding encoding = new UTF8Encoding();
        String constructedString = encoding.GetString(characters);
        return (constructedString);
    }
}

public class DAL
{
    private NpgsqlConnection conn;
    private NpgsqlCommand command;
    private static string connString;
    private static List<Mails> mailList;
    private ErrorHandler.ErrorHandler err;

    public DAL(string _connString)
    {
        err = new ErrorHandler.ErrorHandler();
        connString = _connString;
    }

    public void AddMail (Mails mail)
    {
        try
        {
            using (conn)
            {
                string npgsqlInsertString = "INSERT INTO mails (id_entete, emmetteur, destinataires, objet, contenu, date_envoi, heure_envoi) VALUES (@id_entete, @emmetteur, @destinataires, @objet, @contenu, @date_envoi, @heure_envoi)";

                conn = new NpgsqlConnection(connString);

                command = new NpgsqlCommand();
                command.Connection = conn;
                command.Connection.Open();
                command.CommandText = npgsqlInsertString;

                NpgsqlParameter idParam = new NpgsqlParameter("@id_entete", mail.Id_entete);
                NpgsqlParameter emmParam = new NpgsqlParameter("@id_entete", mail.Emmetteur);
                NpgsqlParameter destParam = new NpgsqlParameter("@id_entete", mail.Destinataires);
                NpgsqlParameter objParam = new NpgsqlParameter("@id_entete", mail.Objet);
                NpgsqlParameter contParam = new NpgsqlParameter("@id_entete", mail.Contenu);
                NpgsqlParameter dateParam = new NpgsqlParameter("@id_entete", mail.Date_envoi);
                NpgsqlParameter heureParam = new NpgsqlParameter("@id_entete", mail.Heure_envoi);

                command.Parameters.AddRange(new NpgsqlParameter[] { idParam, emmParam, destParam, objParam, contParam, dateParam, heureParam });
                command.ExecuteNonQuery();
                command.Connection.Close();

            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }
    }

    public void UpdateMail (Mails mail)
    {
        try
        {
            using (conn)
            {
                string npgsqlUpdateString = "UPDATE mails SET id_entete=@id_entete, emmetteur=@emmetteur, destinataires=@destinataires, objet=@objet, contenu=@contenu, date_envoi=@date_envoi, heure_envoi=@heure_envoi WHERE id=@id";

                conn = new NpgsqlConnection(connString);

                command = new NpgsqlCommand();
                command.Connection = conn;
                command.Connection.Open();
                command.CommandText = npgsqlUpdateString;

                NpgsqlParameter idParam = new NpgsqlParameter("@id_entete", mail.Id_entete);
                NpgsqlParameter emmParam = new NpgsqlParameter("@id_entete", mail.Emmetteur);
                NpgsqlParameter destParam = new NpgsqlParameter("@id_entete", mail.Destinataires);
                NpgsqlParameter objParam = new NpgsqlParameter("@id_entete", mail.Objet);
                NpgsqlParameter contParam = new NpgsqlParameter("@id_entete", mail.Contenu);
                NpgsqlParameter dateParam = new NpgsqlParameter("@id_entete", mail.Date_envoi);
                NpgsqlParameter heureParam = new NpgsqlParameter("@id_entete", mail.Heure_envoi);

                command.Parameters.AddRange(new NpgsqlParameter[] { idParam, emmParam, destParam, objParam, contParam, dateParam, heureParam });
                command.ExecuteNonQuery();
                command.Connection.Close();
            }
        }
        catch (Exception ex)
        {
            err.ErrorMessage = ex.Message.ToString();
            throw;
        }
    }

    public void DeleteMail (int id)
    {
        try
        {
            using (conn)
            {
                string npgsqlDeleteString = "DELETE FROM mails WHERE id=@id";

                conn = new NpgsqlConnection(connString);

                command = new NpgsqlCommand();
                command.Connection = conn;
                command.Connection.Open();
                command.CommandText = npgsqlDeleteString;

                NpgsqlParameter idParam = new NpgsqlParameter("@id", id);
                command.Parameters.Add(idParam);
                command.ExecuteNonQuery();
                command.Connection.Close();
            }
        }
        catch (Exception ex)
        {
            err.ErrorMessage = ex.Message.ToString();
            throw;
        }
    }

    public Mails GetMail(int ID)
    {
        try
        {
            if (mailList == null)
            {
                mailList = GetMails();
            }
            foreach (Mails mail in mailList)
            {
                if (mail.Id == ID)
                {
                    return mail;
                }
            }
            return null;
        }
        catch (Exception ex)
        {
            //MessageBox.Show(ex.ToString());
            err.ErrorMessage = ex.Message.ToString();
            throw;
        }
    }

    private List<Mails> GetMails()
    {
        try
        {
            using (conn)
            {
                mailList = new List<Mails>();

                conn = new NpgsqlConnection(connString);
                string npgsqlSelectString = "SELECT * FROM mails";
                command = new NpgsqlCommand(npgsqlSelectString, conn);
                command.Connection.Open();

                NpgsqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    Mails mail = new Mails();
                    mail.Id = (int)reader[0];
                    mail.Id_entete = (int)reader[1];
                    mail.Emmetteur = reader[2].ToString().Replace(" ", "");
                    mail.Destinataires = reader[3].ToString().Replace(" ", "");
                    mail.Objet = reader[4].ToString().Replace(" ", "");
                    mail.Contenu = reader[5].ToString().Replace(" ", "");
                    mail.Date_envoi = reader[6].ToString().Replace(" ", "");
                    mail.Heure_envoi = reader[7].ToString().Replace(" ", "");
                    mailList.Add(mail);
                }
                command.Connection.Close();
                return mailList;
            }
        }
        catch (Exception ex)
        {
            //MessageBox.Show(ex.ToString());
            err.ErrorMessage = ex.Message.ToString();
            throw;
        }
    }

    public string GetException()
    {
        return err.ErrorMessage.ToString();
    }
}

public static class FTPQueue
{
    /// <summary>
    /// The maximum number of concurrent file uploads
    /// </summary>
    private const int MAX_FILE_UPLOADS = 3;
    /// <summary>
    /// The number of files being currently uploaded
    /// </summary>
    private static int _filesBeingUploaded = 0;
    /// <summary>
    /// Maintains a FIFO list of files to be uploaded
    /// </summary>
    private static Queue _fileQueue = new Queue();
    /// <summary>
    /// Maintains a list of the names of the files currently being
    /// uploaded. This prevents the process from attempting to upload
    /// the same multiple times
    /// </summary>
    private static List<string> _filesInProgress = new List<string>();
    /// <summary>
    /// Called from the FileSystemWatcher when file(s) are received in the ap's target folder
    /// </summary>
    /// <param name="fileName">Name of the received file.</param>
    public static void FileReceived(string fileName)
    {
        Console.WriteLine("Received file {0}", fileName);

        // Add the file recieved to the queue of files
        _fileQueue.Enqueue(fileName);

        UploadNextFile();
    }
    /// <summary>
    /// Uploads the next file.
    /// </summary>
    private static async void UploadNextFile()
    {
        // Get the next file from the list
        if (_fileQueue.Count == 0)
        {
            return;
        }
        string fileName = (string)_fileQueue.Peek();

        if (!string.IsNullOrEmpty(fileName))
        {
            // If we've reached the max number of uploads tyhen return
            if (_filesBeingUploaded >= MAX_FILE_UPLOADS)
            {
                return;
            }

            // See if the file is a already being transferred, and if so, exit
            if (_filesInProgress.Any(x => x == fileName))
            {
                return;
            }

            // Keep track of the number of files being uploaded
            _filesBeingUploaded++;
            Console.WriteLine("Files being uploaded {0}", _filesBeingUploaded);

            // Create the upload task
            Task<bool> upload = TransferFile(fileName);

            // Wait for the file upload to complete
            bool result = await upload;

            // Call the completed method
            Console.WriteLine("Files {0} upload complete", _filesBeingUploaded);

            FileUploadComplete(fileName, result);
        }
    }
    /// <summary>
    /// Performs a file transfer operation
    /// </summary>
    /// <param name="fileName">Name of the file to transfer.</param>
    /// <returns></returns>
    private static async Task<bool> TransferFile(string fileName)
    {
        Console.WriteLine("Tranfering file {0}", fileName);

        // 10 second delay to simulate a long running FTP operation
        await Task.Delay(10000);

        // Set return value from FTP process
        bool result = true;

        return result;
    }
    /// <summary>
    /// Called when a file upload is complete.
    /// </summary>
    /// <param name="fileName">Name of the file uploaded.</param>
    /// <param name="result">True if the file upload was sucesseful, otherwise false.</param>
    private static void FileUploadComplete(string fileName, bool result)
    {
        // If the file was FTP'd ok, the remove it from the list
        if (result)
        {
            Console.WriteLine(string.Format("File {0} upload complete", fileName));

            if (_fileQueue.Count > 0)
            {
                // Remove the file name from the queue and InProgress list
                Console.WriteLine("Removing file {0} from the queue", fileName);

                _fileQueue.Dequeue();
                _filesInProgress.Remove(fileName);
            }

            // Decrement the number of files being uploaded
            _filesBeingUploaded--;
            Console.WriteLine("Files being uploaded {0}", _filesBeingUploaded);
        }
        else
        {
            Console.WriteLine(string.Format("File {0} upload failed", fileName));
        }

        // Start the next file
        UploadNextFile();
    }
}

class Program
{
    private static Timer _timer;

    static void Main(string[] args)
    {
        _timer = new Timer();
        _timer.Interval = 3000;
        _timer.Elapsed += _timer_Elapsed;
        _timer.Enabled = true;

        Console.ReadLine();
    }

    // The timer creates a dummy file to mock a file being dropped into the target folder. In
    // the real app a FileSystemWatcher would handle this
    private static void _timer_Elapsed(object sender, ElapsedEventArgs e)
    {
        var fileName = Path.GetRandomFileName();
        Console.WriteLine("Created new file {0}", fileName);

        FTPQueue.FileReceived(fileName);
    }
}