using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.IO;
using System.Net;
using System.Threading;
//using Newtonsoft.Json;
//using System.Json;
//using System.Json.Microsoft;
//using Newtonsoft.Json;
//using Newtonsoft.Json.Linq;

namespace AfipInscripciones
{
    class Program
    {
        public string fechaNacimiento { get; set; }
        //public string claveInactivaAsociada { get; set; }

        private static string LimpiaStrings(string strAlimpiar)
        {
            string strLimpiado = "";

            strLimpiado = strAlimpiar.Replace("'", " ");
            strLimpiado = strLimpiado.Replace(",", " ");
            strLimpiado = strLimpiado.Replace(";", " ");
            strLimpiado = strLimpiado.Replace("'", " ");
            strLimpiado = strLimpiado.Replace("/", "-");
            strLimpiado = strLimpiado.Replace(@"""", @"\""");
            strLimpiado = strLimpiado.Replace("\\", "");

            strLimpiado = strLimpiado.Replace("\\", "");
            strLimpiado = strLimpiado.Replace("\"", "");
            strLimpiado = strLimpiado.Replace(@"""", "");
            strLimpiado = strLimpiado.Replace("?", "");

            return strLimpiado;
        }


        static void Main(string[] args)
        {
            //DataTable YourResultSet = new DataTable();
            int count1 = 0, count2 = 0;

            count1++;
            try
            {
                while (1 == 1)
                {
                    Console.WriteLine("INICIO ");

                    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 vIDTaken = System.Configuration.ConfigurationSettings.AppSettings.Get("IDTaken");
                    string strcontraparte = "";
                    int idReg = 0;

                    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("FIDECHECK_MASIVO_");
                    CMDPadron2.Connection = SQLPadron;
                    CMDPadron2.CommandType = CommandType.StoredProcedure;
                    CMDPadron2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@paction", "LISTAR"));

                    count2 = 0;
                    CendeuReader = CMDPadron2.ExecuteReader();
                    while (CendeuReader.Read())
                    {
                        count2++;
                        strcontraparte = CendeuReader["contraparte"].ToString();
                        idReg = Convert.ToInt32(CendeuReader["idreg"].ToString());
                        try
                        {
                            //strcontraparte = "145709";

                            // If required by the server, set the credentials.  
                            //request.Credentials = CredentialCache.DefaultCredentials;
                            // Get the response.  
                            //WebRequest request = WebRequest.Create("https://backend.fidelitas.com.ar/led/obtener-pep-cliente?contraparte=" + strcontraparte);
                            //WebRequest request = WebRequest.Create("https://backend.fidelitas.com.ar/obtener-pep-cuit?fecha=2024-03-28");
                            WebRequest request = WebRequest.Create("https://produccion.fidelitas.com.ar/blue/servicios-contratados-contrapartes/fidecheck/automatico?cliente=323510573&contraparte=" + strcontraparte);
                            //     request.ServerCertificateCustomValidationCallback = delegate { return true; }

                            //ServicePointManager.ServerCertificateValidationCallback = MyRemoteCertificateValidationCallback;
                            //System.Diagnostics.Process.Start("mozroots", "--import --quiet");
                            ServicePointManager.ServerCertificateValidationCallback += (p1, p2, p3, p4) => true;
                            //request.Timeout = 160000;
                            request.Timeout = 14400000;

                            WebResponse response = request.GetResponse();
                            // Display the status.  
                            Console.WriteLine(((HttpWebResponse)response).StatusDescription);
                            // Get the stream containing content returned by the server.  
                            Stream dataStream = response.GetResponseStream();
                            // Open the stream using a StreamReader for easy access.  
                            StreamReader reader = new StreamReader(dataStream);
                            // Read the content.  
                            string responseFromServer = reader.ReadToEnd();
                            // Display the content.  
                            Console.WriteLine("Ciclo: " + count1.ToString() + " Registro: " + count2.ToString() + " -- " + responseFromServer);

                            // Clean up the streams and the response.  
                            reader.Close();
                            response.Close();

                            if (responseFromServer != "" && !responseFromServer.ToUpper().Contains("FAILURE"))
                            {
                                System.Data.SqlClient.SqlCommand CMDPadronUPD = null;
                                CMDPadronUPD = new System.Data.SqlClient.SqlCommand("FIDECHECK_MASIVO_");
                                CMDPadronUPD.Connection = SQLUPD;
                                CMDPadronUPD.CommandType = CommandType.StoredProcedure;
                                CMDPadronUPD.Parameters.Add(new System.Data.SqlClient.SqlParameter("@paction", "UPDATELOTE"));
                                CMDPadronUPD.Parameters.Add(new System.Data.SqlClient.SqlParameter("@idReg", idReg));
                              //  CendeuReaderUPD = CMDPadronUPD.ExecuteReader();
                                CendeuReaderUPD.Close();
                                CMDPadronUPD = null;
                            }
                            else /*@paction varchar(50) = 'LISTAR',UPDATELOTE
@idReg int = null
*/
                            {
                                System.Data.SqlClient.SqlCommand CMDPadronUPD = null;
                                CMDPadronUPD = new System.Data.SqlClient.SqlCommand("FIDECHECK_MASIVO_");
                                CMDPadronUPD.Connection = SQLUPD;
                                CMDPadronUPD.CommandType = CommandType.StoredProcedure;
                                CMDPadronUPD.Parameters.Add(new System.Data.SqlClient.SqlParameter("@paction", "UPDATELOTE"));
                                CMDPadronUPD.Parameters.Add(new System.Data.SqlClient.SqlParameter("@idReg", idReg));
                              //  CendeuReaderUPD = CMDPadronUPD.ExecuteReader();
                                CendeuReaderUPD.Close();
                                CMDPadronUPD = null;
                            }

                            Thread.Sleep(2000);
                        }
                        catch (Exception BNBN)
                        {
                            Console.WriteLine("ERROR: " + BNBN.Message.ToString());
                            Thread.Sleep(1000);
                        }
                    }

                    CendeuReader.Close();
                    CMDPadron2.Dispose();
                    CMDPadron2 = null;
                    Random rnd = new Random();
                    Console.WriteLine("FIN " + Convert.ToString(rnd.NextDouble()));
                }

            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message.ToString());

            }
            Thread.Sleep(1000);
        }
    }
}