using System;
using System.Collections.Generic;
using System.Collections;
using System.ComponentModel;
using System.Diagnostics;
using System.IO;
using System.Timers;
using Microsoft.Win32;
using System.Xml;
//using System.Drawing;
//using System.Drawing.Drawing2D;
//using System.Drawing.Imaging;
using System.Configuration;
using System.Data;
using System.Data.Sql;
using System.Linq;
using System.Text;
using System.Threading;
using System.Data.Common;
//using itextsharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.pdf.parser;
using System.Text.RegularExpressions;
using System.Net;


namespace FidePDFMerge
{
    class Program
    {


        public static int iError = 0;
        public static string LogPath = "";
        public static string lstCuit = "0";

        //static void Main(string[] args)
        static void Main()
        {

            int VDO3_Instance = Convert.ToInt16(System.Configuration.ConfigurationSettings.AppSettings.Get("VDO3_Instance"));
            string LogFilePath = System.Configuration.ConfigurationSettings.AppSettings.Get("LogFilePath");
            string DBFSourcePath = System.Configuration.ConfigurationSettings.AppSettings.Get("DBFSourcePath");
            string VDO3_DSN = System.Configuration.ConfigurationSettings.AppSettings.Get("VDO3_DSN");
            string VDO3_SkipIt = System.Configuration.ConfigurationSettings.AppSettings.Get("VDO3_SkipIt");
            string AFIPSourcePath = System.Configuration.ConfigurationSettings.AppSettings.Get("AFIPSourcePath");

            string AMXLogFilePath = System.Configuration.ConfigurationSettings.AppSettings.Get("AMXLogFilePath");
            string AMXSourcePath = System.Configuration.ConfigurationSettings.AppSettings.Get("AMXSourcePath");
            string AMXTargetCSVPath = System.Configuration.ConfigurationSettings.AppSettings.Get("AMXTargetCSVPath");
            string AMXTargetFolderPath = System.Configuration.ConfigurationSettings.AppSettings.Get("AMXTargetFolderPath");
            string VDO3_ProcessFrom = System.Configuration.ConfigurationSettings.AppSettings.Get("VDO3_ProcessFrom");
            string VDO3_ProcessTo = System.Configuration.ConfigurationSettings.AppSettings.Get("VDO3_ProcessTo");
            string AFIPSoloAltas = System.Configuration.ConfigurationSettings.AppSettings.Get("AFIPSoloAltas");

            string AMXTargetPath = System.Configuration.ConfigurationSettings.AppSettings.Get("AMXTargetPath");


            string strpath = "";
            Int64 idReg = 0;
            string strcuit = "";
            string strnombre = "";
            string strcontraparte = "";
            string strgestion = "";
            string strCountry = "";
            string stridreg = "";

            ///Argumento 0 el Path al PDF
            ///Argumento 1 el doc_id para escribir el .log de salida
            ///
            System.Configuration.AppSettingsReader appSettings = new System.Configuration.AppSettingsReader();
            //LogPath = appSettings.GetValue("LogFilePath", typeof(string)).ToString();
            string GetPDFText = "";

            System.Data.SqlClient.SqlDataReader CendeuReader = null;
            System.Data.SqlClient.SqlDataReader CendeuReaderUPD = null;
            System.Data.SqlClient.SqlConnection SQLPadron = null;
            System.Data.SqlClient.SqlConnection SQLUPD = null;
            SQLPadron = null;
            SQLUPD = null;
            SQLPadron = new System.Data.SqlClient.SqlConnection(VDO3_DSN);
            SQLUPD = new System.Data.SqlClient.SqlConnection(VDO3_DSN);

            System.Data.SqlClient.SqlCommand CMDPadron = null;
            CMDPadron = new System.Data.SqlClient.SqlCommand();
            SQLPadron.Open();
            SQLUPD.Open();
            /*
            string[] fileEntries = Directory.GetFiles(AFIPSourcePath, "*.pdf");
            //Console.WriteLine(AFIPSourcePath, archivoaprocesar);

            Console.WriteLine("Finalizada la lectura del directorio");

            //AMXTargetPath
            int ii = 0;
            */
            /*
            foreach (string fileName in fileEntries)
            {
                string strContratista = fileEntries[ii].ToString();
                string strTo, strFrom, strDirTo;
                string strNewFile = ""; //fileName.Replace("_contraparte", "");
                string[] strAMXDocParts = fileName.Split('/');


                Console.WriteLine("FILENAME: " + fileName);

                strNewFile = strAMXDocParts[strAMXDocParts.Length - 1].ToString();

                strFrom = strContratista;
                strDirTo = AMXTargetPath + "/" + strCountry + "/" + strnombre + " - " + strcuit + "/";
                //strDirTo = "/home/en4lo100to/compartido/LN_backup/AMX/PY/" + strnombre + " - " + strcuit + "/";

                // \\192.168.10.10\e$\storage\Fidelitas\produccion\LN_backup\AMX\
                // "/var/www/html/compartido/LN_backup/AMX/";

                strNewFile = strNewFile.Replace("ext2016", "IC_exterior");

                strTo = strDirTo + strNewFile;

                Console.WriteLine("Registro: " + stridreg + " -- PAIS:  " + strCountry + " - " + strnombre + " -- FILE FROM: " + strFrom + " FILE TO: " + strTo);

                /*
                if (!Directory.Exists(strDirTo))
                {
                    Directory.CreateDirectory(strDirTo);
                }

                try
                {
                    System.IO.File.Copy(strFrom, strTo);
                }
                catch
                {
                    Console.WriteLine("ERROR AL COPIAR " + strTo);
                }
                */
                /*ii++;
            }*/
/*

            f (@accion = 'DOCID')
BEGIN
	select  ln_docs.doc_id,ln_docs.contraparte,ln_docs.gestion,ln_docs.tipo_doc,ln_docs.estado_doc,
	padrones.nombre_persona,padrones.identificador,padrones.identificacion,
	LN_tipos_doc.nombre_tipo_doc,

	padrones.nombre_persona + ' ' + padrones.identificador + ' ' + padrones.identificacion + ' ' + LN_tipos_doc.nombre_tipo_doc + '_'+ convert(varchar(10),ln_docs.doc_id) + '.pdf' as nombre_archivo

	from ln_docs inner join LN_tipos_doc on ln_docs.tipo_doc=LN_tipos_doc.tipo_doc
	inner join ln_contrapartes on ln_docs.contraparte = ln_contrapartes.contraparte
	inner join padrones on ln_contrapartes.id_padron=padrones.id_padron

	where doc_id=@id

END
            Thread.Sleep(600000000);
            */

            /* AVERIGUAMOS LOS CUIT A PROCESAR SEGÚN LA FECHA DEL DÍA  */
            System.Data.SqlClient.SqlCommand CMDPadron2 = null;
            CMDPadron2 = new System.Data.SqlClient.SqlCommand("LN_BACKUP_gestiones_proceso");
            CMDPadron2.Connection = SQLPadron;
            CMDPadron2.CommandType = CommandType.StoredProcedure;
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@accion", "LISTAR")); //UPDLIST
            /*
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", "null")); //UPDLIST
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@procesado_ic", "null")); //UPDLIST
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@procesado_bkp", "null")); //UPDLIST
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@cliente", "5546348")); //UPDLIST
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@country", "UY")); //UPDLIST
            */
            //CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@id", denominacion));
            //CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@procesado_ic", denominacion));
            //CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@procesado_bkp", denominacion));

            //PARTE DE SERVER

            CendeuReader = CMDPadron2.ExecuteReader();
            while (CendeuReader.Read())
            {
                strcuit = CendeuReader["Cuit"].ToString();
                idReg = Convert.ToInt64(CendeuReader["idReg"].ToString());
                strnombre = CendeuReader["nombre"].ToString();
                strcontraparte = CendeuReader["ID"].ToString();
                strgestion = CendeuReader["gestion"].ToString();
                strCountry = CendeuReader["country_code"].ToString();
                stridreg = CendeuReader["idreg"].ToString();

                //Console.WriteLine("PROCESANDO CUIT: " + strcuit + " ID: " + idReg.ToString());
                // /home/kukulkan/Downloads/AMX-GESTION-2021-IC/
                // \\192.168.10.10\e$\storage\Fidelitas\produccion\legajos\5546348\
                // /var/www/html/compartido/legajos/5546348
                //                string[] fileEntries = Directory.GetFiles("/var/www/html/compartido/legajos/5546348/", strcontraparte + "/" + strgestion + "/" +"*.pdf", SearchOption.AllDirectories);

                try
                {
                    string[] fileEntries = Directory.GetFiles("/var/www/html/compartido/legajos/5546348/", strcontraparte + "/" + strgestion + "/" + "*.pdf");
                    //string[] fileEntries = Directory.GetFiles("/home/kukulkan/Downloads/AMX-GESTION-2021-IC/server/AR/DRD CONSTRUCCIONES S.R.L. - 30711743711/", "*.pdf");
                    int ii = 0;
                    //                Console.WriteLine("PROCESANDO CUIT: " + strcuit + " FILE: " + fileEntries.Length.ToString());

                    foreach (string fileName in fileEntries)
                    {
                        string strContratista = fileEntries[ii].ToString();
                        string strTo, strFrom, strDirTo;
                        string strNewFile = ""; //fileName.Replace("_contraparte", "");
                        string[] strAMXDocParts = fileName.Split('/');


                        //Console.WriteLine("FILENAME: " + fileName);

                        strNewFile = strAMXDocParts[strAMXDocParts.Length - 1].ToString();

                        strFrom = strContratista;
                        strDirTo = "/var/www/html/compartido/ln-backup/AMX2025/" + strCountry + "/" + strnombre + " - " + strcuit + "/";
                        //strDirTo = "/home/en4lo100to/compartido/LN_backup/AMX/PY/" + strnombre + " - " + strcuit + "/";

                        // \\192.168.10.10\e$\storage\Fidelitas\produccion\LN_backup\AMX\
                        // "/var/www/html/compartido/LN_backup/AMX/";

                        strNewFile = strNewFile.Replace("ext2016", "IC_exterior");

                        strTo = strDirTo + strNewFile;

                        Console.WriteLine("Registro: " + stridreg +  " -- PAIS:  " + strCountry + " - " + strnombre + " -- FILE FROM: " + strFrom + " FILE TO: " + strTo);


                        if (!Directory.Exists(strDirTo))
                        {
                            Directory.CreateDirectory(strDirTo);
                        }

                        try
                        {
                            System.IO.File.Copy(strFrom, strTo);
                        }
                        catch 
                        {
                            Console.WriteLine("ERROR AL COPIAR " + strTo);
                        }

                        ii++;
                    }
                }
                catch 
                {
                    Console.WriteLine("NO EXISTE " + "/var/www/html/compartido/legajos/5546348/" + strcontraparte + "/" + strgestion + "/");
                }

            }
            }
            
        }
    }