using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using iTextSharp.text;
using iTextSharp.text.pdf;
using System.IO;
using Image = iTextSharp.text.Image;
using System.Data.SQLite;
using System.Net;
using System.Text.RegularExpressions;

namespace CKUERA
{
    public partial class Vendedores : Form
    {
        public Vendedores()
        {
            InitializeComponent();
        }

        private void Vendedores_Load(object sender, EventArgs e)
        {
            //this.Width = 200;// haciendo en Activatet
            button5.Left = 3000;
            DataG1.Width = 586;
            DataG1.Height = 195;
            DataG1.Left = 27;
            DataG1.Top = TextBox1.Top + TextBox1.Height + 1;

            {
                string name = "iconos\\registrar.png";
                try { Button1.Image = System.Drawing.Image.FromFile(name); }
                catch (Exception) { }
            }

            {
                string name = "iconos\\modificar.png";
                try { button4.Image = System.Drawing.Image.FromFile(name); }
                catch (Exception) { }
            }

            {
                string name = "iconos\\limpiar.png";
                try { Button2.Image = System.Drawing.Image.FromFile(name); }
                catch (Exception) { }
            }

            {
                string name = "iconos\\eliminar.png";
                try { Button3.Image = System.Drawing.Image.FromFile(name); }
                catch (Exception) { }
            }
        }

        private void Vendedores_Resize(object sender, EventArgs e)
        {

            this.BackColor = Global.ColorSistema;
            Button1.BackColor = this.BackColor = Global.ColorSistema;//
            Button2.BackColor = this.BackColor = Global.ColorSistema;//
            Button3.BackColor = this.BackColor = Global.ColorSistema;//
            button4.BackColor = this.BackColor = Global.ColorSistema;//

            panel1.Left = this.Width / 2 - panel1.Width / 2;
            panel1.Top = this.Height / 2 - panel1.Height / 2;
            Btn_Cerrar.Top = 0;
            Btn_Cerrar.Left = panel1.Width - Btn_Cerrar.Width;

            Lb_Titulo.Top = 0; Lb_Titulo.Left = 0;
            Lb_Titulo.Text = this.Text;

        }

        public void REEMPLZAR()
        {
            TextBox1.Text = TextBox1.Text.ToUpper().Trim().Replace("'", "´");
            TextBox2.Text = TextBox2.Text.ToUpper().Trim().Replace("'", "´");
            TextBox3.Text = TextBox3.Text.ToUpper().Trim().Replace("'", "´");
            TextBox4.Text = TextBox4.Text.ToUpper().Trim().Replace("'", "´");
            TextBox5.Text = TextBox5.Text.ToUpper().Trim().Replace("'", "´");
            TextBox1.SelectionStart = TextBox1.Text.Length + 1;
            TextBox2.SelectionStart = TextBox2.Text.Length + 1;
            TextBox3.SelectionStart = TextBox3.Text.Length + 1;
            TextBox4.SelectionStart = TextBox4.Text.Length + 1;
            TextBox5.SelectionStart = TextBox5.Text.Length + 1;
        }


        public void LIMPIAR()
        {
            // LIMPIA TODO
            TextBox1.Text = "";
            TextBox2.Text = "";
            TextBox3.Text = "";
            TextBox4.Text = "";
            TextBox5.Text = "";
            Comi.Text = "";
            No_Buscar.Checked = false;
            TextBox1.Select();
        }

        private void TextBox1_TextChanged(object sender, EventArgs e)
        {
            if (RadioButton1.Checked == false)
            {
                if (RadioButton2.Checked == false)
                {
                    MessageBox.Show("Selecciones una opción de lo que desea hacer; ''Registrar nuevo'' o ''Modificar''", "!Atención!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    return;
                }
            }

            if (TextBox1.Text.Length > 20)
            {
                MessageBox.Show("La longitud de caracteres no puede ser más que 20.", "¡Atención!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                TextBox1.Text = TextBox1.Text.Substring(0, 20);
                TextBox1.Select();
                return;
            }

            if (TextBox1.Text == "") { LIMPIAR(); }

            TextBox1.ReadOnly = false;
            
            if (No_Buscar.Checked == true) return; // NO BUSCAR SI YA ENCONTRÓ

            if (RadioButton2.Checked == true) // SI ES MODIFICAR
            {
                if (No_Buscar.Checked == true)
                {
                    REEMPLZAR();
                }

                HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/vendedores_consultar.php");
                rq.Method = "POST";
                byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼", TextBox1.Text));
                rq.ContentType = "application/x-www-form-urlencoded";
                rq.ContentLength = byteArray.Length;
                Stream stream = rq.GetRequestStream();
                stream.Write(byteArray, 0, byteArray.Length);
                stream.Close();
                //
                WebResponse response = rq.GetResponse();
                stream = response.GetResponseStream();
                StreamReader reader = new StreamReader(stream);
                string devuelve = reader.ReadToEnd();
                reader.Close();
                stream.Close();
                response.Close();

                string resultado = devuelve.ToUpper();
                bool re;
                re = resultado.Contains("<BR");
                if (re == true)
                {
                    MessageBox.Show(devuelve);
                    return;
                }

                if (devuelve == "")
                {
                    DataG1.Visible = false;
                }
                else
                {
                    DataG1.Rows.Clear();
                    DataG1.Visible = true;

                    foreach (var line in devuelve.Trim().Split('↔'))//cada línea se separa por '↔'
                    {
                        if (line == "") continue;//si la última línea está vacía, continua al siguiente proceso
                        var v = line.Trim().Split('▲');//dentro de cada línea se separa por columna ('▲')
                        DataG1.Rows.Add(v[0], v[1]);
                    }
                }

                if (TextBox1.Text == "")
                {
                    DataG1.Visible = false;
                }
            }
        }

        private void RadioButton2_CheckedChanged(object sender, EventArgs e)
        {
            TextBox1.Select();
            if (RadioButton2.Checked == true)
            {
                this.AcceptButton = button4;
            }
        }

        private void RadioButton1_CheckedChanged(object sender, EventArgs e)
        {
            if (RadioButton1.Checked == true)
                DataG1.Visible = false;
                TextBox1.Select();
                AcceptButton=Button1;

        }

        private void Button1_Click(object sender, EventArgs e)
        {
            if (RadioButton1.Checked == false & RadioButton2.Checked == false)
            {
                MessageBox.Show("Marque una opción de lo que desea hacer; Registrar Nuevo o Modificar Registro", "¡ATENCIÓN!", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TextBox1.Select();
                return;
            }

            if (TextBox1.Text == "")//NOMBRE
            {
                TextBox1.Select();
                return;
            }

            TextBox1.Text = TextBox1.Text.Replace("&", "y");
            TextBox1.Text = TextBox1.Text.Replace("'", "`");
            TextBox1.Text = TextBox1.Text.Replace(";", ",");
            TextBox1.Text = TextBox1.Text.Replace("\\", ",");

            if (Regex.IsMatch(TextBox1.Text, "[^a-zA-Z0-9-/_() .,áéíóúÁÉÍÓÚñÑ`]"))
            {
                MessageBox.Show("En el campo escrito existe caracter especial no admitido. Reemplace y vuelva a presionar ENTER.", "ATENCIÓN", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TextBox1.Select();
                return;
            }

            if (TextBox2.Text == "")//CI
            {
                TextBox2.Select();
                return;
            }

            TextBox2.Text = TextBox2.Text.Replace("&", "y");
            TextBox2.Text = TextBox2.Text.Replace("'", "`");
            TextBox2.Text = TextBox2.Text.Replace(";", ",");
            TextBox2.Text = TextBox2.Text.Replace("\\", ",");

            if (Regex.IsMatch(TextBox2.Text, "[^a-zA-Z0-9-/_() .,áéíóúÁÉÍÓÚñÑ`]"))
            {
                MessageBox.Show("En el campo escrito existe caracter especial no admitido. Reemplace y vuelva a presionar ENTER.", "ATENCIÓN", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TextBox2.Select();
                return;
            }

            if (TextBox3.Text == "")//TELÉFONO
            {
                TextBox3.Select();
                return;
            }

            TextBox3.Text = TextBox3.Text.Replace("&", "y");
            TextBox3.Text = TextBox3.Text.Replace("'", "`");
            TextBox3.Text = TextBox3.Text.Replace(";", ",");
            TextBox3.Text = TextBox3.Text.Replace("\\", ",");

            if (Regex.IsMatch(TextBox3.Text, "[^a-zA-Z0-9-/_() .,áéíóúÁÉÍÓÚñÑ`]"))
            {
                MessageBox.Show("En el campo escrito existe caracter especial no admitido. Reemplace y vuelva a presionar ENTER.", "ATENCIÓN", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TextBox3.Select();
                return;
            }

            if (TextBox4.Text == "")//DIRECCIÓN
            {
                TextBox4.Select();
                return;
            }

            TextBox4.Text = TextBox4.Text.Replace("&", "y");
            TextBox4.Text = TextBox4.Text.Replace("'", "`");
            TextBox4.Text = TextBox4.Text.Replace(";", ",");
            TextBox4.Text = TextBox4.Text.Replace("\\", ",");

            if (Regex.IsMatch(TextBox4.Text, "[^a-zA-Z0-9-/_() .,áéíóúÁÉÍÓÚñÑ`]"))
            {
                MessageBox.Show("En el campo escrito existe caracter especial no admitido. Reemplace y vuelva a presionar ENTER.", "ATENCIÓN", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TextBox4.Select();
                return;
            }

            TextBox1.Text = TextBox1.Text.ToUpper().Trim();//NOMBRE
            TextBox4.Text = TextBox4.Text.ToUpper().Trim();//DIRECCIÓN

            if (Comi.Text == "")
            {
                Comi.Select();
                return;
            }

            if (TextBox5.Text == "")//CLAVE
            {
                TextBox5.Select();
                return;
            }

            TextBox5.Text = TextBox5.Text.Replace("&", "y");
            TextBox5.Text = TextBox5.Text.Replace("'", "`");
            TextBox5.Text = TextBox5.Text.Replace(";", ",");
            TextBox5.Text = TextBox5.Text.Replace("\\", ",");

            if (Regex.IsMatch(TextBox5.Text, "[^a-zA-Z0-9-/_() .,áéíóúÁÉÍÓÚñÑ`]"))
            {
                MessageBox.Show("En el campo escrito existe caracter especial no admitido. Reemplace y vuelva a presionar ENTER.", "ATENCIÓN", MessageBoxButtons.OK, MessageBoxIcon.Information);
                TextBox5.Select();
                return;
            }


            REEMPLZAR();

            //CONSULTA SI EL VENDEDOR YA EXISTE
            if (RadioButton1.Checked == true)
            {
                HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/vendedores_insert.php");
                rq.Method = "POST";
                byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼{1}▼{2}▼{3}▼{4}▼{5}",
                    TextBox5.Text.Trim(), TextBox1.Text.Trim(), Comi.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text));
                rq.ContentType = "application/x-www-form-urlencoded";
                rq.ContentLength = byteArray.Length;
                Stream stream = rq.GetRequestStream();
                stream.Write(byteArray, 0, byteArray.Length);
                stream.Close();
                //
                WebResponse response = rq.GetResponse();
                stream = response.GetResponseStream();
                StreamReader reader = new StreamReader(stream);
                string devuelve = reader.ReadToEnd();
                reader.Close();
                stream.Close();
                response.Close();

                string resultado = devuelve.ToUpper();
                bool re;
                re = resultado.Contains("<BR");
                if (re == true)
                {
                    MessageBox.Show(devuelve);
                    return;
                }

                MessageBox.Show(devuelve.Trim(), "¡ATENCIÓN!", MessageBoxButtons.OK, MessageBoxIcon.Information);

                if (devuelve.Trim().Substring(0, 6) != "...Est")
                {
                    LIMPIAR();
                    TextBox1.Select();
                }


                //{
                //    SQLiteDataReader RS = null;
                //    string SQL = "SELECT NOMBRE FROM Vendedores WHERE NOMBRE='" + TextBox1.Text + "' LIMIT 1;";
                //    SQLiteCommand CMD3 = new SQLiteCommand(SQL, Global.conexion);
                //    RS = CMD3.ExecuteReader();

                //    if (RS.HasRows == true)
                //    {
                //        while (RS.Read())
                //        MessageBox.Show("Este Vendedor ya está registrado como " + RS["NOMBRE"]);
                //        TextBox1.Select();
                //        //Conex.Close();
                //        RS.Close();
                //        //Conex.Close();
                //        return;
                //    }
                //    RS.Close();
                //    //Conex.Close();
                //}
            }

            //if (TextBox2.Text == "")
            //{
            //    TextBox2.Select();
            //    return;
            //}

            //if (TextBox3.Text == "")
            //{
            //    TextBox3.Select();
            //    return;
            //}

            //if (TextBox4.Text == "")
            //{
            //    TextBox4.Select();
            //    return;
            //}

            //if (Comi.Text == "")
            //{
            //    Comi.Select();
            //    return;
            //}

            //TextBox1.Text = TextBox1.Text.ToUpper().Trim();
            //TextBox4.Text = TextBox4.Text.ToUpper().Trim();

            //if (TextBox5.Text == "")
            //{
            //    TextBox5.Select();
            //    return;
            //}

            //REEMPLZAR();
            
            ////CONSULTA SI LA CLAVE EXISTE
            //if (RadioButton1.Checked == true)
            //{
            //    //using (MySqlConnection Conex = new MySqlConnection(string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4};", Global._host, Global._base, Global._usuario, Global._pass, Global._port)))
            //    {
            //        //Conex.Open();

            //        SQLiteDataReader RS = null;
            //        string SQL = "SELECT CLAVE,NOMBRE FROM Vendedores WHERE CLAVE='" + TextBox5.Text + "';";
            //        SQLiteCommand CMD3 = new SQLiteCommand(SQL, Global.conexion);
            //        RS = CMD3.ExecuteReader();

            //        if (RS.HasRows == true)
            //        {
            //            while (RS.Read())
            //                MessageBox.Show("Esta clave de acceso ya está en uso y pertenece a " + RS["NOMBRE"]);
            //            TextBox5.Text = "";
            //            TextBox5.Select();
            //            //Conex.Close();
            //            RS.Close();
            //            //Conex.Close();
            //            return;

            //        }
            //        RS.Close();

            //        string SQLin = "INSERT INTO Vendedores (NOMBRE,CLAVE,CI,TEL,DIR) VALUES('" + TextBox1.Text + "','" + TextBox5.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "');";
            //        SQLiteCommand CMD4 = new SQLiteCommand(SQLin, Global.conexion);
            //        CMD4.ExecuteNonQuery();
            //        //Conex.Close();
            //    }
            //    MessageBox.Show(TextBox1.Text + " se registró con éxito.", "¡Muy bien!", MessageBoxButtons.OK, MessageBoxIcon.Information);
            //    LIMPIAR();
            //    TextBox1.Select();
            //}
        }


        private void DataG1_Click(object sender, EventArgs e)
        {
            ID_LABEL.Text = DataG1.CurrentRow.Cells[0].Value.ToString();

            HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/vendedores_mostrar.php");
            rq.Method = "POST";
            byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼", ID_LABEL.Text));
            rq.ContentType = "application/x-www-form-urlencoded";
            rq.ContentLength = byteArray.Length;
            Stream stream = rq.GetRequestStream();
            stream.Write(byteArray, 0, byteArray.Length);
            stream.Close();
            //
            WebResponse response = rq.GetResponse();
            stream = response.GetResponseStream();
            StreamReader reader = new StreamReader(stream);
            string devuelve = reader.ReadToEnd();
            reader.Close();
            stream.Close();
            response.Close();

            string resultado = devuelve.ToUpper();
            bool re;
            re = resultado.Contains("<BR");
            if (re == true)
            {
                MessageBox.Show(devuelve);
                return;
            }

            if (devuelve.Trim() != "")
            {
                foreach (var line in devuelve.Trim().Split('↔'))//cada línea se separa por '↔'
                {
                    if (line == "") continue;//si la última línea está vacía, continua al siguiente proceso
                    var v = line.Trim().Split('▲');//dentro de cada línea se separa por columna ('▲')

                    TextBox1.Text = v[0];//NOMBRE
                    TextBox2.Text = v[1];//CI
                    TextBox3.Text = v[2];//TEL
                    TextBox4.Text = v[3];//DIR
                    TextBox5.Text = v[4];//CLAVE
                    Comi.Text = v[5];//COMI
                }
            }

            DataG1.Visible = false;
            No_Buscar.Checked = true;
            TextBox1.ReadOnly = true;
            TextBox1.Select();
        }

        private void Button3_Click(object sender, EventArgs e)
        {
            if (Global.USUARIO_SIST.Trim() == TextBox1.Text.Trim())
            {
                MessageBox.Show("No es posible eliminarse a sí mismo este Usuario.", "¡ATENCIÓN!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }

            DialogResult result = MessageBox.Show("¿Confirma que realmente desea eliminar?", "¿ESTÁ SEGURO/A?", MessageBoxButtons.YesNo);
            if (result == DialogResult.No)
                return;

            //using (MySqlConnection Conex = new MySqlConnection(string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4};", Global._host, Global._base, Global._usuario, Global._pass, Global._port)))
            {
                //Conex.Open();

                string SQLin = "DELETE FROM Vendedores WHERE ID='" + ID_LABEL.Text + "';";
                SQLiteCommand CMD4 = new SQLiteCommand(SQLin, Global.conexion);
                CMD4.ExecuteNonQuery();
                //Conex.Close();
            }
            MessageBox.Show(TextBox1.Text + " se eliminó.", "Hecho", MessageBoxButtons.OK, MessageBoxIcon.Information);
            LIMPIAR();
            TextBox1.Select();
        }

        private void Button2_Click(object sender, EventArgs e)
        {
            LIMPIAR();
            TextBox1.Select();
        }

        private void button5_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void DataG1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void button4_Click(object sender, EventArgs e)
        {
 
            if (TextBox1.Text == "")
            {
                TextBox1.Select();
                return;
            }

            if (TextBox2.Text == "")
            {
                TextBox2.Select();
                return;
            }

            if (TextBox3.Text == "")
            {
                TextBox3.Select();
                return;
            }

            if (TextBox4.Text == "")
            {
                TextBox4.Select();
                return;
            }

            TextBox1.Text = TextBox1.Text.ToUpper().Trim();
            TextBox4.Text = TextBox4.Text.ToUpper().Trim();


            if (TextBox5.Text == "")
            {
                TextBox5.Select();
                return;
            }


            HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/vendedores_update.php");
            rq.Method = "POST";
            byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼{1}▼{2}▼{3}▼{4}▼{5}▼{6}",
                TextBox5.Text.Trim(), TextBox1.Text.Trim(), Comi.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, ID_LABEL.Text));
            rq.ContentType = "application/x-www-form-urlencoded";
            rq.ContentLength = byteArray.Length;
            Stream stream = rq.GetRequestStream();
            stream.Write(byteArray, 0, byteArray.Length);
            stream.Close();
            //
            WebResponse response = rq.GetResponse();
            stream = response.GetResponseStream();
            StreamReader reader = new StreamReader(stream);
            string devuelve = reader.ReadToEnd();
            reader.Close();
            stream.Close();
            response.Close();

            string resultado = devuelve.ToUpper();
            bool re;
            re = resultado.Contains("<BR");
            if (re == true)
            {
                MessageBox.Show(devuelve);
                return;
            }

            MessageBox.Show(devuelve.Trim(), "¡ATENCIÓN!", MessageBoxButtons.OK, MessageBoxIcon.Information);

            if (devuelve.Trim().Substring(0, 6) != "...Est")
            {
                LIMPIAR();
                TextBox1.Select();
            }
        }

        private void Comi_TextChanged(object sender, EventArgs e)
        {
            try 
            {
              float comi = float.Parse(Comi.Text.ToString());
            }
            catch (Exception)
            {
              Comi.Text = "";
            }
            
        }

        private void label8_Click(object sender, EventArgs e)
        {

        }

        private void Fhasta_ValueChanged(object sender, EventArgs e)
        {

        }

        private void button6_Click(object sender, EventArgs e)
        {
            if (ID_LABEL.Text == "")
            {
              return;
            }

            Global.fecha_desdex = string.Format("{0:yyyy-MM-dd}", Fdesde.Value);
            Global.fecha_hastax = string.Format("{0:yyyy-MM-dd}", Fhasta.Value);
            Global.ID_vendedor = int.Parse(ID_LABEL.Text);
            Global.Vendedor = TextBox1.Text;
            Global.DOC = TextBox2.Text;
            Global.ComiVen = double.Parse(Comi.Text);
            Global.TotalRp = 0;
            Saldo.Text = "";

            if (Global.comision_sobre == 1)
            {
                Reporte_x_Margen();
            }
            else
            {
                pdf_ReportVEN pdf_repVEN = new pdf_ReportVEN();
                pdf_repVEN.Mostrar_ReportVEN_pdf();
            }

        }

        private void Btn_Cerrar_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void Reporte_x_Margen()
        {
            //CREAR PDF
            string pdfgenerate = "\\DOC_PDF\\REPORTES_PDF\\VENDEDORES\\" + DateTime.Now.ToString("dd-MM-yy") + "_" + DateTime.Now.ToString("HH-mm") + "_REPORTE.pdf";
            Document oDoc;
            PdfWriter pdfw;
            PdfContentByte cb;
            float top1;

            //PREPARA EL PDF
            oDoc = new Document(PageSize.A4, 30, 20, 20, 20);
            pdfw = PdfWriter.GetInstance(oDoc, new FileStream(pdfgenerate, FileMode.Create, FileAccess.Write, FileShare.None));
            pdfw.CompressionLevel = PdfStream.BEST_COMPRESSION;
            pdfw.SetFullCompression();
            oDoc.Open();
            oDoc.NewPage();
            top1 = oDoc.PageSize.Top;

            try
            {
                //ENCABEZADO LOGO (usado en reportes)
                Image logo = Image.GetInstance("logo.png", true);
                logo.CompressionLevel = PdfStream.NO_COMPRESSION;
                //logo.SetAbsolutePosition(60, top1 - 130);
                oDoc.Add(logo);
            }
            catch (Exception)
            {

            }

            cb = pdfw.DirectContent;//DEBE IR ANTES DE LAS LÍNEAS DE TEXTO

            //EL TÍTULO
            Paragraph title = new Paragraph();
            title.Font = FontFactory.GetFont(FontFactory.TIMES, 10f, BaseColor.BLACK);

            title.Add("REPORTE de Ventas, Vendedor: " + Global.Vendedor + ", DOC: " + Global.DOC + ", Comisión " + Global.ComiVen + "% sobre Margen.\nDesde el " + string.Format("{0:dd-MM-yyyy}", DateTime.Parse(Global.fecha_desdex)) + ", hasta el " + string.Format("{0:dd-MM-yyyy}", DateTime.Parse(Global.fecha_hastax)) +
            "\nGenerado por " + Global.USUARIO_SIST + " - Terminal " + Global.NUM_caja + " - Fecha: " + DateTime.Now.ToString());

            title.Alignment = Element.ALIGN_LEFT;
            oDoc.Add(title);

            PdfPTable table = new PdfPTable(9);//TABLA CON 9 CELDAS

            //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL ENCABEZADO
            Paragraph TEXTO_T0 = new Paragraph();
            TEXTO_T0.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
            TEXTO_T0.Add("COMPROBANTE");

            Paragraph TEXTO_T1 = new Paragraph();
            TEXTO_T1.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
            TEXTO_T1.Add("FECHA");

            Paragraph TEXTO_T2 = new Paragraph();
            TEXTO_T2.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
            TEXTO_T2.Add("HORA");

            Paragraph TEXTO_T3 = new Paragraph();
            TEXTO_T3.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
            TEXTO_T3.Add("DESCRIPCION");

            Paragraph TEXTO_CANT = new Paragraph();
            TEXTO_CANT.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
            TEXTO_CANT.Add("CANT");

            Phrase TEXTO_PRECIO = new Phrase("T. COSTO", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
            PdfPCell PRECIO = new PdfPCell(TEXTO_PRECIO);
            PRECIO.HorizontalAlignment = Element.ALIGN_RIGHT;
            PRECIO.BackgroundColor = new BaseColor(224, 255, 255);

            Phrase Titulo4 = new Phrase("T. MONTO", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T4 = new PdfPCell(Titulo4);
            TEXTO_T4.HorizontalAlignment = Element.ALIGN_RIGHT;
            TEXTO_T4.BackgroundColor = new BaseColor(224, 255, 255);

            Phrase Titulo5 = new Phrase("T. MARG", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T5 = new PdfPCell(Titulo5);
            TEXTO_T5.HorizontalAlignment = Element.ALIGN_RIGHT;
            TEXTO_T5.BackgroundColor = new BaseColor(224, 255, 255);

            Phrase Titulo6 = new Phrase("CLIENTE", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T6 = new PdfPCell(Titulo6);
            TEXTO_T6.HorizontalAlignment = Element.ALIGN_RIGHT;
            TEXTO_T6.BackgroundColor = new BaseColor(224, 255, 255);

            table.HorizontalAlignment = 0;
            table.TotalWidth = 545f;//MEDIDA TOTAL DE LA TABLA
            table.LockedWidth = true;
            float[] widths = new float[] { 75f, 50f, 30f, 150f, 30f, 55f, 55f, 50f, 50f };//MEDIDAS DE COLUMNAS
            table.SetWidths(widths);

            //table.WidthPercentage = 100;
            table.DefaultCell.BackgroundColor = new BaseColor(224, 255, 255);
            table.DefaultCell.BorderColor = new BaseColor(0, 0, 0);//125,125,255
            table.AddCell(TEXTO_T0); table.AddCell(TEXTO_T1); table.AddCell(TEXTO_T2);
            table.AddCell(TEXTO_T3); table.AddCell(TEXTO_CANT); table.AddCell(TEXTO_PRECIO); table.AddCell(TEXTO_T4); table.AddCell(TEXTO_T5); table.AddCell(TEXTO_T6);

            table.DefaultCell.BackgroundColor = new BaseColor(255, 255, 255);

            HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/vendedores_reportar.php");
            rq.Method = "POST";
            byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼{1}▼{2}", Global.fecha_desdex, Global.fecha_hastax, Global.ID_vendedor));
            rq.ContentType = "application/x-www-form-urlencoded";
            rq.ContentLength = byteArray.Length;
            Stream stream = rq.GetRequestStream();
            stream.Write(byteArray, 0, byteArray.Length);
            stream.Close();
            //
            WebResponse response = rq.GetResponse();
            stream = response.GetResponseStream();
            StreamReader reader = new StreamReader(stream);
            string devuelve = reader.ReadToEnd();
            reader.Close();
            stream.Close();
            response.Close();

            string resultado = devuelve.ToUpper();
            bool re;
            re = resultado.Contains("<BR");
            if (re == true)
            {
                MessageBox.Show(devuelve);
                //return;
            }

            double TOTAL_MARGEN = 0;

            if (devuelve != "")
            {
                //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL CUERPO
                foreach (var line in devuelve.Trim().Split('↔'))//cada línea se separa por '↔'
                {
                    if (line == "") continue;//si la última línea está vacía, continua al siguiente proceso
                    var v = line.Trim().Split('▲');//dentro de cada línea se separa por columna ('▲')
                                                    //DataG1.Rows.Add(v[0], v[1]);

                    // string fechas =
                    Paragraph factura = new Paragraph();
                    factura.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                    factura.Add(v[0]);

                    Paragraph fecha = new Paragraph();
                    fecha.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                    fecha.Add(string.Format("{0:dd-MM-yyyy}", DateTime.Parse(v[1])));

                    Paragraph hora = new Paragraph();
                    hora.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                    hora.Add(string.Format("{0:HH:mm}", DateTime.Parse(v[2])));

                    Paragraph descrip = new Paragraph();
                    descrip.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                    descrip.Add(v[3]);

                    if (v[6] == "") v[6] = "1";

                    Phrase CANTIDAD = new Phrase(string.Format("{0:0.##}", double.Parse(v[6])), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                    PdfPCell CANT = new PdfPCell(CANTIDAD);
                    CANT.HorizontalAlignment = Element.ALIGN_CENTER;
                    CANT.BackgroundColor = new BaseColor(255, 255, 255);
                    CANT.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                    double COSTOT = double.Parse(v[8]) * double.Parse(v[6]);//COSTO X CANTIDAD

                    Phrase COSTOS = new Phrase(string.Format("{0:#,##0.##}", COSTOT), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                    PdfPCell COS = new PdfPCell(COSTOS);
                    COS.HorizontalAlignment = Element.ALIGN_RIGHT;
                    COS.BackgroundColor = new BaseColor(255, 255, 255);
                    COS.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                    double MONTOT = double.Parse(v[4]) * double.Parse(v[6]);

                    Phrase Conte4 = new Phrase(string.Format("{0:#,##0.##}", MONTOT), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                    PdfPCell montoG = new PdfPCell(Conte4);
                    montoG.HorizontalAlignment = Element.ALIGN_RIGHT;
                    montoG.BackgroundColor = new BaseColor(255, 255, 255);
                    montoG.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                    double MARGENT = MONTOT - COSTOT;

                    Phrase Conte6 = new Phrase(MARGENT.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                    PdfPCell MARG = new PdfPCell(Conte6);
                    MARG.HorizontalAlignment = Element.ALIGN_RIGHT;
                    MARG.BackgroundColor = new BaseColor(255, 255, 255);
                    MARG.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                    Phrase Conte7 = new Phrase(v[7], FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                    PdfPCell cliente = new PdfPCell(Conte7);
                    cliente.HorizontalAlignment = Element.ALIGN_RIGHT;
                    cliente.BackgroundColor = new BaseColor(255, 255, 255);
                    cliente.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                    //table.WidthPercentage = 100;
                    table.DefaultCell.BorderColor = new BaseColor(211, 211, 211);//125,125,255
                    table.AddCell(factura); table.AddCell(fecha); table.AddCell(hora);
                    table.AddCell(descrip); table.AddCell(CANT); table.AddCell(COS); table.AddCell(montoG); table.AddCell(MARG); table.AddCell(cliente);

                    Global.TotalRp = Global.TotalRp + double.Parse(v[4]) * double.Parse(v[6]);
                    TOTAL_MARGEN = TOTAL_MARGEN + MARGENT;
                }
            }

            double TotalComi = TOTAL_MARGEN * Global.ComiVen / 100;

            //TOTAL DE VENTA QUE SALE EN LA CABECERA
            Paragraph title2 = new Paragraph();
            title2.Font = FontFactory.GetFont(FontFactory.COURIER_BOLD, 14f, BaseColor.BLUE);
            title2.Add("Total de venta " + Global.SIMB_ + " " + string.Format("{0:#,##0.##}", Global.TotalRp) + "\nTotal Margen: " + Global.SIMB_ + " " + TOTAL_MARGEN.ToString("#,##0.##") + "\nTotal Comisión: " + Global.SIMB_ + " " + string.Format("{0:#,##0.##}", TotalComi));
            title2.Alignment = Element.ALIGN_RIGHT;
            oDoc.Add(title2);

            //PARRAFO VACÍO COMO SEPARADOR
            Paragraph title3 = new Paragraph();
            title3.Font = FontFactory.GetFont(FontFactory.TIMES, 2, BaseColor.BLACK);
            title3.Add(".");
            title3.Alignment = Element.ALIGN_LEFT;
            oDoc.Add(title3);

            oDoc.Add(table);
            //RS.Close();

            pdfw.Flush();
            oDoc.Close();
            System.Diagnostics.Process.Start(@pdfgenerate);//MUESTRA EL REPORTE EN PDF
        }
    }

    


    public class pdf_ReportVEN
    {
        public object Mostrar_ReportVEN_pdf()
        {
            //using (MySqlConnection Conex = new MySqlConnection(string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4};", Global._host, Global._base, Global._usuario, Global._pass, Global._port)))
            {
                //Conex.Open();

                //CREAR PDF
                string pdfgenerate = "\\DOC_PDF\\REPORTES_PDF\\VENDEDORES\\" + DateTime.Now.ToString("dd-MM-yy") + "_" + DateTime.Now.ToString("HH-mm") + "_REPORTE.pdf";
                Document oDoc;
                PdfWriter pdfw;
                PdfContentByte cb;
                float top1;

                //PREPARA EL PDF
                oDoc = new Document(PageSize.A4, 30, 20, 20, 20);
                pdfw = PdfWriter.GetInstance(oDoc, new FileStream(pdfgenerate, FileMode.Create, FileAccess.Write, FileShare.None));
                pdfw.CompressionLevel = PdfStream.BEST_COMPRESSION;
                pdfw.SetFullCompression();
                oDoc.Open();
                oDoc.NewPage();
                top1 = oDoc.PageSize.Top;

                try
                {
                    //ENCABEZADO LOGO (usado en reportes)
                    Image logo = Image.GetInstance("logo.png", true);
                    logo.CompressionLevel = PdfStream.NO_COMPRESSION;
                    //logo.SetAbsolutePosition(60, top1 - 130);
                    oDoc.Add(logo);
                }
                catch (Exception)
                {

                }

                cb = pdfw.DirectContent;//DEBE IR ANTES DE LAS LÍNEAS DE TEXTO

                //EL TÍTULO
                Paragraph title = new Paragraph();
                title.Font = FontFactory.GetFont(FontFactory.TIMES, 10f, BaseColor.BLACK);

                title.Add("REPORTE Ventas, Vendedor: " + Global.Vendedor + ", DOC: " + Global.DOC + ", Comisión " + Global.ComiVen +  "%.\nDesde el " + string.Format("{0:dd-MM-yyyy}", DateTime.Parse(Global.fecha_desdex)) + ", hasta el " + string.Format("{0:dd-MM-yyyy}", DateTime.Parse(Global.fecha_hastax)) + 
                "\nGenerado por " + Global.USUARIO_SIST + " - Terminal " + Global.NUM_caja + " - Fecha: " + DateTime.Now.ToString()); 

                title.Alignment = Element.ALIGN_LEFT;
                oDoc.Add(title);

                PdfPTable table = new PdfPTable(9);//TABLA CON 9 CELDAS

                //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL ENCABEZADO
                Paragraph TEXTO_T0 = new Paragraph();
                TEXTO_T0.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                TEXTO_T0.Add("COMPROBANTE");

                Paragraph TEXTO_T1 = new Paragraph();
                TEXTO_T1.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                TEXTO_T1.Add("FECHA");

                Paragraph TEXTO_T2 = new Paragraph();
                TEXTO_T2.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                TEXTO_T2.Add("HORA");

                Paragraph TEXTO_T3 = new Paragraph();
                TEXTO_T3.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                TEXTO_T3.Add("DESCRIPCION");

                Paragraph TEXTO_CANT = new Paragraph();
                TEXTO_CANT.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                TEXTO_CANT.Add("CANT");

                Phrase TEXTO_PRECIO = new Phrase("PRECIO", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                PdfPCell PRECIO = new PdfPCell(TEXTO_PRECIO);
                PRECIO.HorizontalAlignment = Element.ALIGN_RIGHT;
                PRECIO.BackgroundColor = new BaseColor(224, 255, 255);

                Phrase Titulo4 = new Phrase("MONTO", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                PdfPCell TEXTO_T4 = new PdfPCell(Titulo4);
                TEXTO_T4.HorizontalAlignment = Element.ALIGN_RIGHT;
                TEXTO_T4.BackgroundColor = new BaseColor(224, 255, 255);

                Phrase Titulo5 = new Phrase("USUARIO", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                PdfPCell TEXTO_T5 = new PdfPCell(Titulo5);
                TEXTO_T5.HorizontalAlignment = Element.ALIGN_RIGHT;
                TEXTO_T5.BackgroundColor = new BaseColor(224, 255, 255);

                Phrase Titulo6 = new Phrase("CLIENTE", FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                PdfPCell TEXTO_T6 = new PdfPCell(Titulo6);
                TEXTO_T6.HorizontalAlignment = Element.ALIGN_RIGHT;
                TEXTO_T6.BackgroundColor = new BaseColor(224, 255, 255);

                table.HorizontalAlignment = 0;
                table.TotalWidth = 545f;//MEDIDA TOTAL DE LA TABLA
                table.LockedWidth = true;
                float[] widths = new float[] { 75f, 50f, 30f, 150f, 30f, 55f, 55f, 50f, 50f };//MEDIDAS DE COLUMNAS
                table.SetWidths(widths);

                //table.WidthPercentage = 100;
                table.DefaultCell.BackgroundColor = new BaseColor(224, 255, 255);
                table.DefaultCell.BorderColor = new BaseColor(0, 0, 0);//125,125,255
                table.AddCell(TEXTO_T0); table.AddCell(TEXTO_T1); table.AddCell(TEXTO_T2);
                table.AddCell(TEXTO_T3); table.AddCell(TEXTO_CANT); table.AddCell(TEXTO_PRECIO); table.AddCell(TEXTO_T4); table.AddCell(TEXTO_T5); table.AddCell(TEXTO_T6);

                table.DefaultCell.BackgroundColor = new BaseColor(255, 255, 255);

                //SQLiteDataReader RS = null;
                //string POR_OPER = "SELECT NUM_FACT,FECHA,HORA,DESCRIPCION,SUM(VENTA*CANT) MONTO,USUARIO FROM ventas WHERE FECHA>= '" + Global.fecha_desdex + "' AND FECHA<= '" + Global.fecha_hastax + "' AND id_vendedor= " + Global.ID_vendedor + " GROUP BY NUM_FACT,FECHA,HORA,DESCRIPCION,USUARIO;";
                //SQLiteCommand CMD_POR_OPER = new SQLiteCommand(POR_OPER, Global.conexion);
                //RS = CMD_POR_OPER.ExecuteReader();

                HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/vendedores_reportar.php");
                rq.Method = "POST";
                byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼{1}▼{2}", Global.fecha_desdex, Global.fecha_hastax, Global.ID_vendedor));
                rq.ContentType = "application/x-www-form-urlencoded";
                rq.ContentLength = byteArray.Length;
                Stream stream = rq.GetRequestStream();
                stream.Write(byteArray, 0, byteArray.Length);
                stream.Close();
                //
                WebResponse response = rq.GetResponse();
                stream = response.GetResponseStream();
                StreamReader reader = new StreamReader(stream);
                string devuelve = reader.ReadToEnd();
                reader.Close();
                stream.Close();
                response.Close();

                string resultado = devuelve.ToUpper();
                bool re;
                re = resultado.Contains("<BR");
                if (re == true)
                {
                    MessageBox.Show(devuelve);
                    //return;
                }

                if (devuelve != "")
                {
                    //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL CUERPO
                    foreach (var line in devuelve.Trim().Split('↔'))//cada línea se separa por '↔'
                    {
                        if (line == "") continue;//si la última línea está vacía, continua al siguiente proceso
                        var v = line.Trim().Split('▲');//dentro de cada línea se separa por columna ('▲')
                        //DataG1.Rows.Add(v[0], v[1]);

                        // string fechas =
                        Paragraph factura = new Paragraph();
                        factura.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                        factura.Add(v[0]);

                        Paragraph fecha = new Paragraph();
                        fecha.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                        fecha.Add(string.Format("{0:dd-MM-yyyy}", DateTime.Parse(v[1])));

                        Paragraph hora = new Paragraph();
                        hora.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                        hora.Add(string.Format("{0:HH:mm}", DateTime.Parse(v[2])));

                        Paragraph descrip = new Paragraph();
                        descrip.Font = FontFactory.GetFont(FontFactory.TIMES, 9f, BaseColor.BLACK);
                        descrip.Add(v[3]);

                        if (v[6] == "") v[6] = "1";

                        Phrase CANTIDAD = new Phrase(string.Format("{0:0.##}", double.Parse(v[6])), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                        PdfPCell CANT = new PdfPCell(CANTIDAD);
                        CANT.HorizontalAlignment = Element.ALIGN_RIGHT;
                        CANT.BackgroundColor = new BaseColor(255, 255, 255);
                        CANT.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                        Phrase PRECIOS = new Phrase(string.Format("{0:#,##0.##}", double.Parse(v[4])), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                        PdfPCell PRE = new PdfPCell(PRECIOS);
                        PRE.HorizontalAlignment = Element.ALIGN_RIGHT;
                        PRE.BackgroundColor = new BaseColor(255, 255, 255);
                        PRE.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                        double MONTOT = double.Parse(v[4]) * double.Parse(v[6]);

                        Phrase Conte4 = new Phrase(string.Format("{0:#,##0.##}", MONTOT), FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                        PdfPCell montoG = new PdfPCell(Conte4);
                        montoG.HorizontalAlignment = Element.ALIGN_RIGHT;
                        montoG.BackgroundColor = new BaseColor(255, 255, 255);
                        montoG.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                        Phrase Conte6 = new Phrase(v[5], FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                        PdfPCell oper = new PdfPCell(Conte6);
                        oper.HorizontalAlignment = Element.ALIGN_RIGHT;
                        oper.BackgroundColor = new BaseColor(255, 255, 255);
                        oper.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                        Phrase Conte7 = new Phrase(v[7], FontFactory.GetFont(FontFactory.TIMES, 9, BaseColor.BLACK));
                        PdfPCell cliente = new PdfPCell(Conte7);
                        cliente.HorizontalAlignment = Element.ALIGN_RIGHT;
                        cliente.BackgroundColor = new BaseColor(255, 255, 255);
                        cliente.BorderColor = new BaseColor(211, 211, 211);//125,125,255

                        //table.WidthPercentage = 100;
                        table.DefaultCell.BorderColor = new BaseColor(211, 211, 211);//125,125,255
                        table.AddCell(factura); table.AddCell(fecha); table.AddCell(hora);
                        table.AddCell(descrip); table.AddCell(CANT); table.AddCell(PRE); table.AddCell(montoG); table.AddCell(oper); table.AddCell(cliente);

                        Global.TotalRp = Global.TotalRp + double.Parse(v[4]) * double.Parse(v[6]);
                    }
                }

                double TotalComi = Global.TotalRp * Global.ComiVen/100;

                //TOTAL DE VENTA QUE SALE EN LA CABECERA
                Paragraph title2 = new Paragraph();
                title2.Font = FontFactory.GetFont(FontFactory.COURIER_BOLD, 14f, BaseColor.BLUE);
                title2.Add("Total de venta " + Global.SIMB_ + " " + string.Format("{0:#,##0.##}", Global.TotalRp) + "\nTotal Comisión: " + Global.SIMB_ + " " + string.Format("{0:#,##0.##}", TotalComi));
                title2.Alignment = Element.ALIGN_RIGHT;
                oDoc.Add(title2);

                //PARRAFO VACÍO COMO SEPARADOR
                Paragraph title3 = new Paragraph();
                title3.Font = FontFactory.GetFont(FontFactory.TIMES, 2, BaseColor.BLACK);
                title3.Add(".");
                title3.Alignment = Element.ALIGN_LEFT;
                oDoc.Add(title3);

                oDoc.Add(table);
                //RS.Close();

                pdfw.Flush();
                oDoc.Close();
                System.Diagnostics.Process.Start(@pdfgenerate);//MUESTRA EL REPORTE EN PDF
                //Conex.Close();
            }
            return (null);
        }
    }
}