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 strFilePath = "";
            Int64 idReg = 0;
            Int64 DocID = 0;
            string strarchivo = "";

            ///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();
            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();




            /* AVERIGUAMOS LOS CUIT A PROCESAR SEGÚN LA FECHA DEL DÍA  */
            System.Data.SqlClient.SqlCommand CMDPadron2 = null;
            CMDPadron2 = new System.Data.SqlClient.SqlCommand("Imperium_migrado_Renombrado_files");
            CMDPadron2.Connection = SQLPadron;
            CMDPadron2.CommandType = CommandType.StoredProcedure;
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@action", "PROCESAR")); //ACTUALIZAR
            CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@periodo", 202202)); //ACTUALIZAR

            //PARTE DE SERVER
            string strTo, strFrom, strDirTo, strDirToDup, periodo,contratista;

            CendeuReader = CMDPadron2.ExecuteReader();
            while (CendeuReader.Read())
            {
                strFilePath = CendeuReader["Ubicacion"].ToString();
                idReg = Convert.ToInt64(CendeuReader["idReg"].ToString());
                periodo = CendeuReader["periodo"].ToString();
                contratista = CendeuReader["contratista"].ToString();
                strarchivo = CendeuReader["archivo"].ToString();

                strDirTo = "/home/kukulkan/Downloads/BBVA-AON/" + periodo + "/" + contratista;

                strFilePath = strFilePath.Replace("Verificadas_2022", "/home/kukulkan/Downloads/BBVA-AON");

                strFilePath = strFilePath.Replace("\\", "/");
                strFilePath = strFilePath.Replace("//", "/");
                strFilePath = strFilePath.Replace("//", "/");

                strarchivo = strarchivo.Replace("\\\\storage\\Imperium\\", "/home/en4lo100to/fide.imperium/AMX2022/Imperium/");// "/home/kukulkan/Downloads/fide.imperium/Imperium/");
                strarchivo = strarchivo.Replace("\\", "/");
                strarchivo = strarchivo.Replace("//", "/");

                /* / home / en4lo100to / fide.imperium / 202008 / 5546348 */
                strDirToDup = strDirTo + "/DUP_" + strarchivo;
                /* / home / kukulkan / Downloads / fide.imperium / */
                try
                {

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

                    try
                    {
                        System.IO.File.Copy(strFilePath, strDirTo + "/" +strarchivo);
                    }
                    catch (Exception SH)
                    {
                        Console.WriteLine("ERROR AL COPIAR " + strarchivo);
                        System.IO.File.Copy(strFilePath, strDirToDup); 
                    }

                    /*
                    string[] fileEntries = Directory.GetFiles(strFilePath , "*" + DocID.ToString() + "*.pdf");

                    int ii = 0;

                    foreach (string fileName in fileEntries)
                    {

                        string strFilename;

                        string[] strImperiumDocParts = strarchivo.Split('/');
                        strFilename = strImperiumDocParts[strImperiumDocParts.Length - 1].ToString();
                        strDirTo = strarchivo.Replace(strFilename, "");

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

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


                        ii++;
                    }
                    */
                }
                catch
                {
                    //Console.WriteLine("NO EXISTE " + "/home/en4lo100to/compartido/legajos/5546348/" + strFilePath + "/");
                }
                Console.WriteLine(idReg.ToString());
            }
        }
    }
}