using CKUERA;
using iTextSharp.text.pdf;
using iTextSharp.text;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Font = iTextSharp.text.Font;
using Image = iTextSharp.text.Image;
using static System.Windows.Forms.VisualStyles.VisualStyleElement;
using System.Xml.Linq;
using iTextSharp.text.pdf.parser;
using System.Text.RegularExpressions;

namespace ECV
{
    public partial class compras_reg : Form
    {
        public compras_reg()
        {
            InitializeComponent();
        }

        private void Btn_Compras_Click(object sender, EventArgs e)
        {

        }

        private void compras_reg_Load(object sender, EventArgs e)
        {
            cargar_prov();
            Btn_buscar.BackColor = Global.ColorSistema;//
            //BackColor = Global.ColorSistema;//
            Productos productos = new Productos();

            this.Top= productos.button6.Top+100;
        }

        private void compras_reg_Resize(object sender, EventArgs e)
        {

        }

        private void cargar_prov()
        {

            this.Cursor = Cursors.WaitCursor;
            HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/compras_cargar_prov.php");
            rq.Method = "POST";
            byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼", ""));
            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[] c = devuelve.Split('▲');
            this.Cursor = Cursors.Default;

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

            if (devuelve != "")
            {
                foreach (var line in devuelve.Split('▲'))
                {
                    var valores = line.Split('▲');
                    if (valores[0] != "")
                    {
                        com_prov.Items.Add(valores[0]);
                    }
                }
            }
        }

        private void buscar_compra()
        {
            if (Txt_Fact.Text.Length > 0)
            {
                string pattern = @"^\d{3}-\d{3}-\d{7}$";
                string input = Txt_Fact.Text;

                try
                {
                    if (!Regex.IsMatch(input, pattern))
                    {//0010010000001
                        string serie = Txt_Fact.Text.Substring(0, 3);
                        string subSerie = Txt_Fact.Text.Substring(3, 3);
                        string numero = Txt_Fact.Text.Substring(6, 7);

                        Txt_Fact.Text = $"{serie:D3}-{subSerie:D3}-{numero:D7}";
                    }
                }
                catch { }

            }

            // CREAR PDF 
            string Provee = com_prov.Text.Replace("|","_");
            string pdfgenerate = "\\DOC_PDF\\REPORTES_PDF\\COMPRAS_" + Provee.Trim() + "_" + Txt_Fact.Text.Trim() + "_" + Txt_Timbrado.Text + "_" + DateTime.Now.ToString("dd-MM-yy") + "_" + DateTime.Now.ToString("HH-mm") + "_.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.NO_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 - 80);
                oDoc.Add(logo);
            }
            catch (Exception)
            {

            }

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


            //Colores
            BaseColor FondoCab = new BaseColor(100, 200, 200);
            BaseColor BordeCab = new BaseColor(200, 200, 200);
            BaseColor FondoCuer = new BaseColor(255, 255, 255);
            BaseColor FondoDiv = new BaseColor(180, 180, 180); ;//BaseColor(200, 150, 200);
            BaseColor BordeDiv = new BaseColor(125, 125, 125);

            BaseColor FondoTotal = new BaseColor(255, 255, 255);
            BaseColor BordeDivTotal = new BaseColor(255, 255, 255);


            //Espacio de cabecera
            PdfPTable TablaEspa4 = new PdfPTable(1);
            TablaEspa4.WidthPercentage = 100;
            PdfPCell CelEspa4 = new PdfPCell(new Phrase("", FontFactory.GetFont(FontFactory.HELVETICA, 11, BaseColor.BLACK)));
            CelEspa4.Border = 0;
            CelEspa4.HorizontalAlignment = Element.ALIGN_LEFT;
            TablaEspa4.AddCell(CelEspa4);
            oDoc.Add(TablaEspa4);

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

            //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL ENCABEZADO
            Phrase Titulo0 = new Phrase("CÓDIGO", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T0 = new PdfPCell(Titulo0);
            TEXTO_T0.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T0.BackgroundColor = FondoCab;

            //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL ENCABEZADO
            Phrase Titulo1 = new Phrase("CANT", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T1 = new PdfPCell(Titulo1);
            TEXTO_T1.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T1.BackgroundColor = FondoCab;

            Phrase Titulo2 = new Phrase("DESCRIPCIÓN", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T2 = new PdfPCell(Titulo2);
            TEXTO_T2.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T2.BackgroundColor = FondoCab;

            Phrase Titulo3 = new Phrase("PRECIO/U", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T3 = new PdfPCell(Titulo3);
            TEXTO_T3.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T3.BackgroundColor = FondoCab;

            Phrase Titulo4 = new Phrase("EXENTA", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T4 = new PdfPCell(Titulo4);
            TEXTO_T4.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T4.BackgroundColor = FondoCab;

            Phrase Titulo5 = new Phrase("IVA 5%", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T5 = new PdfPCell(Titulo5);
            TEXTO_T5.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T5.BackgroundColor = FondoCab;

            Phrase Titulo6 = new Phrase("IVA 10%", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell TEXTO_T6 = new PdfPCell(Titulo6);
            TEXTO_T6.HorizontalAlignment = Element.ALIGN_CENTER;
            TEXTO_T6.BackgroundColor = FondoCab;

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

            //table.AddCell(TEXTO_T0); table.AddCell(TEXTO_T1); table.AddCell(TEXTO_T2); table.AddCell(TEXTO_T3);
            //table.AddCell(TEXTO_T4); table.AddCell(TEXTO_T5); table.AddCell(TEXTO_T6);

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

            this.Cursor = Cursors.WaitCursor;
            var div = com_prov.Text.Trim().Split('|');
            string prov= div[0].Trim();
            string ruc = div[1].Trim();
            HttpWebRequest rq = (HttpWebRequest)WebRequest.Create("http://" + Global._host + "/ecv/compras_buscar_compra.php");
            rq.Method = "POST";
            byte[] byteArray = Encoding.UTF8.GetBytes(string.Format("nu={0}▼{1}▼{2}▼{3}▼", prov, ruc, Txt_Fact.Text.Trim(), Txt_Timbrado.Text.Trim()));
            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[] c = devuelve.Split('▲');
            this.Cursor = Cursors.Default;

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

            var val = devuelve.Split('▲');
            if (val[0] != "")
            {
                //EL TÍTULO
                var val2 = val[12].Split('↔');
                string oper = val2[0];
                Paragraph title = new Paragraph();
                title.Font = FontFactory.GetFont(FontFactory.DefaultEncoding, 12, BaseColor.BLACK);
                title.Add("\n" + "REPORTE DE REGISTRO DE COMPRA" +
                    "\nCompra registrada por: " + oper + ", en Fecha: " + DateTime.Parse(val[0]).ToString("dd-MM-yy") + ", Hora: " + DateTime.Parse(val[1]).ToString("HH:mm:ss"));
                title.Alignment = Element.ALIGN_CENTER;
                oDoc.Add(title);

                //Espacio de cabecera
                PdfPTable TablaEspa0 = new PdfPTable(1);
                TablaEspa0.WidthPercentage = 100;
                PdfPCell CelEspa0 = new PdfPCell(new Phrase("aaaaa", FontFactory.GetFont(FontFactory.HELVETICA, 2, BaseColor.WHITE)));
                CelEspa0.Border = 0;
                TablaEspa0.AddCell(CelEspa0);
                oDoc.Add(TablaEspa0);

                //Proveedor
                PdfPTable TablaProv = new PdfPTable(1);
                TablaProv.WidthPercentage = 100;
                PdfPCell CelTablaProv = new PdfPCell(new Phrase("PROVEEDOR: " + prov + ", RUC: " + ruc + "   -   Factura: " + Txt_Fact.Text + ", Timbrado: " + Txt_Timbrado.Text , FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK)));
                CelTablaProv.BackgroundColor = FondoCab;
                TablaProv.AddCell(CelTablaProv);
                oDoc.Add(TablaProv);

                //Espacio de cabecera
                PdfPTable TablaEspa = new PdfPTable(1);
                TablaEspa.WidthPercentage = 100;
                PdfPCell CelEspa = new PdfPCell(new Phrase("aaaaa", FontFactory.GetFont(FontFactory.HELVETICA, 2, BaseColor.WHITE)));
                CelEspa.Border = 0;
                TablaEspa.AddCell(CelEspa);
                oDoc.Add(TablaEspa);
            }

            table.AddCell(TEXTO_T0); table.AddCell(TEXTO_T1); table.AddCell(TEXTO_T2); table.AddCell(TEXTO_T3);
            table.AddCell(TEXTO_T4); table.AddCell(TEXTO_T5); table.AddCell(TEXTO_T6);

            double TotalExenta = 0;
            double TotalCincox = 0;
            double TotalDiezx = 0;

            //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL CUERPO
            if (devuelve != "")
            {
                foreach (var line in devuelve.Split('↔'))
                {
                    var valores = line.Split('▲');
                    if (valores[0] != "")
                    {
                        //CÓDIGO
                        string codigo = valores[2];
                        PdfPCell Conte0 = new PdfPCell();
                        Conte0.Phrase = new Phrase(codigo, FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte0.HorizontalAlignment = Element.ALIGN_CENTER;
                        Conte0.BackgroundColor = FondoCuer;
                        Conte0.BorderColor = BordeDiv;

                        //CANT
                        string cant = valores[4];
                        PdfPCell Conte1 = new PdfPCell();
                        Conte1.Phrase = new Phrase(cant, FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte1.HorizontalAlignment = Element.ALIGN_CENTER;
                        Conte1.BackgroundColor = FondoCuer;
                        Conte1.BorderColor = BordeDiv;

                        //DESCRIPCIÓN
                        string descr = valores[3];
                        PdfPCell Conte2 = new PdfPCell();
                        Conte2.Phrase = new Phrase(descr, FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte2.HorizontalAlignment = Element.ALIGN_LEFT;
                        Conte2.BackgroundColor = FondoCuer;
                        Conte2.BorderColor = BordeDiv;

                        //PRECIO/U
                        double precio = double.Parse(valores[6]);
                        PdfPCell Conte3 = new PdfPCell();
                        Conte3.Phrase = new Phrase(precio.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte3.HorizontalAlignment = Element.ALIGN_RIGHT;
                        Conte3.BackgroundColor = FondoCuer;
                        Conte3.BorderColor = BordeDiv;

                        //Define tipo de IVA
                        double exenta =0;
                        double cincox = 0;
                        double diezx = 0;

                        if (double.Parse(valores[7]) == 0) { exenta = double.Parse(valores[6]) * double.Parse(valores[4]); }
                        if (double.Parse(valores[7]) == 5) { cincox = double.Parse(valores[6]) * double.Parse(valores[4]); }
                        if (double.Parse(valores[7]) == 10) { diezx = double.Parse(valores[6]) * double.Parse(valores[4]); }

                        //EXENTA
                        PdfPCell Conte4 = new PdfPCell();
                        Conte4.Phrase = new Phrase(exenta.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte4.HorizontalAlignment = Element.ALIGN_RIGHT;
                        Conte4.BackgroundColor = FondoCuer;
                        Conte4.BorderColor = BordeDiv;

                        //IVA 5%
                        PdfPCell Conte5 = new PdfPCell();
                        Conte5.Phrase = new Phrase(cincox.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte5.HorizontalAlignment = Element.ALIGN_RIGHT;
                        Conte5.BackgroundColor = FondoCuer;
                        Conte5.BorderColor = BordeDiv;

                        //IVA 10%
                        PdfPCell Conte6 = new PdfPCell();
                        Conte6.Phrase = new Phrase(diezx.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK));
                        Conte6.HorizontalAlignment = Element.ALIGN_RIGHT;
                        Conte6.BackgroundColor = FondoCuer;
                        Conte6.BorderColor = BordeDiv;

                        //table.WidthPercentage = 100;
                        //table.DefaultCell.BorderColor = new BaseColor(0, 0, 0);//211, 211, 211
                        table.AddCell(Conte0); table.AddCell(Conte1); table.AddCell(Conte2); table.AddCell(Conte3);
                        table.AddCell(Conte4); table.AddCell(Conte5); table.AddCell(Conte6);

                        TotalExenta = TotalExenta + exenta;
                        TotalCincox = TotalCincox + cincox;
                        TotalDiezx = TotalDiezx + diezx;
                    }
                }
            }
            oDoc.Add(table);

            //Separador
            PdfPTable TablaEspa40 = new PdfPTable(1);
            TablaEspa40.WidthPercentage = 100;
            PdfPCell CelEspa40 = new PdfPCell(new Phrase("_", FontFactory.GetFont(FontFactory.HELVETICA, 1 / 2, BaseColor.WHITE)));
            CelEspa40.Border = 3;
            CelEspa40.HorizontalAlignment = Element.ALIGN_LEFT;
            TablaEspa40.AddCell(CelEspa40);
            oDoc.Add(TablaEspa40);

            //Tabla de suma total
            PdfPTable tablaTotal = new PdfPTable(7);//TABLA CON 7 CELDAS

            //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL ENCABEZADO
            Phrase tablaTotalTitulo0 = new Phrase("", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T0 = new PdfPCell(tablaTotalTitulo0);
            tablaTotalTEXTO_T0.HorizontalAlignment = Element.ALIGN_CENTER;
            //tablaTotalTEXTO_T0.BackgroundColor = FondoTotal;
            tablaTotalTEXTO_T0.BorderColor = BordeDivTotal;
            //tablaTotalTEXTO_T0.Border = 1;

            //TEXTO QUE IRÁ DENTRO DE LA TABLA DEL ENCABEZADO
            Phrase tablaTotalTitulo1 = new Phrase("", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T1 = new PdfPCell(tablaTotalTitulo1);
            tablaTotalTEXTO_T1.HorizontalAlignment = Element.ALIGN_CENTER;
            //tablaTotalTEXTO_T1.BackgroundColor = FondoTotal;
            tablaTotalTEXTO_T1.BorderColor = BordeDivTotal;

            Phrase tablaTotalTitulo2 = new Phrase("", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T2 = new PdfPCell(tablaTotalTitulo2);
            tablaTotalTEXTO_T2.HorizontalAlignment = Element.ALIGN_CENTER;
            //tablaTotalTEXTO_T2.BackgroundColor = FondoTotal;
            tablaTotalTEXTO_T2.BorderColor = BordeDivTotal;

            Phrase tablaTotalTitulo3 = new Phrase("Subtotales", FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T3 = new PdfPCell(tablaTotalTitulo3);
            tablaTotalTEXTO_T3.HorizontalAlignment = Element.ALIGN_CENTER;
            //tablaTotalTEXTO_T3.BackgroundColor = FondoTotal;
            tablaTotalTEXTO_T3.BorderColor = BordeDivTotal;

            Phrase tablaTotalTitulo4 = new Phrase(TotalExenta.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T4 = new PdfPCell(tablaTotalTitulo4);
            tablaTotalTEXTO_T4.HorizontalAlignment = Element.ALIGN_CENTER;
            tablaTotalTEXTO_T4.BackgroundColor = FondoCab;

            Phrase tablaTotalTitulo5 = new Phrase(TotalCincox.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T5 = new PdfPCell(tablaTotalTitulo5);
            tablaTotalTEXTO_T5.HorizontalAlignment = Element.ALIGN_CENTER;
            tablaTotalTEXTO_T5.BackgroundColor = FondoCab;

            Phrase tablaTotalTitulo6 = new Phrase(TotalDiezx.ToString("#,##0.##"), FontFactory.GetFont(FontFactory.DefaultEncoding, 9, BaseColor.BLACK));
            PdfPCell tablaTotalTEXTO_T6 = new PdfPCell(tablaTotalTitulo6);
            tablaTotalTEXTO_T6.HorizontalAlignment = Element.ALIGN_CENTER;
            tablaTotalTEXTO_T6.BackgroundColor = FondoCab;

            tablaTotal.HorizontalAlignment = 0;
            tablaTotal.TotalWidth = 545f;//MEDIDA TOTAL DE LA TABLA
            tablaTotal.LockedWidth = true;
            float[] widthstablaTotal = new float[] { 70f, 30f, 245f, 50f, 50f, 50f, 50f };//MEDIDAS DE COLUMNAS
            tablaTotal.SetWidths(widthstablaTotal);

            tablaTotal.AddCell(tablaTotalTEXTO_T0); tablaTotal.AddCell(tablaTotalTEXTO_T1); tablaTotal.AddCell(tablaTotalTEXTO_T2); tablaTotal.AddCell(tablaTotalTEXTO_T3);
            tablaTotal.AddCell(tablaTotalTEXTO_T4); tablaTotal.AddCell(tablaTotalTEXTO_T5); tablaTotal.AddCell(tablaTotalTEXTO_T6);
            oDoc.Add(tablaTotal);

            NumLet NumLet = new NumLet();
            string enletras = NumLet.enletras((TotalExenta+TotalCincox+TotalDiezx).ToString());

            //Tabla TablatotalGral
            PdfPTable TablatotalGral = new PdfPTable(1);
            TablatotalGral.WidthPercentage = 100;
            PdfPCell CelTablatotalGral = new PdfPCell(new Phrase("Son " + Global.SIMB_ + " " + enletras +  "  |  TOTAL: " + Global.SIMB_ + " " + (TotalExenta+TotalCincox+TotalDiezx).ToString("#,##0.##"), FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK)));
            CelTablatotalGral.Border = 3;
            CelTablatotalGral.BackgroundColor= FondoCab;
            CelTablatotalGral.HorizontalAlignment = Element.ALIGN_RIGHT;
            TablatotalGral.AddCell(CelTablatotalGral);
            oDoc.Add(TablatotalGral);

            //Tabla TablatotalGral
            PdfPTable TablaIVA = new PdfPTable(1);
            TablaIVA.WidthPercentage = 100;
            PdfPCell CelTablaIVA = new PdfPCell(new Phrase("LIQUIDACIÓN DEL IVA: IVA 5%: " + (TotalCincox/21).ToString("#,##0.##") + "   |   IVA 10%: " + (TotalDiezx / 11).ToString("#,##0.##") + "   |   TOTAL DEL IVA: " + ((TotalCincox/21)+(TotalDiezx/11)).ToString("#,##0.##"), FontFactory.GetFont(FontFactory.HELVETICA, 9, BaseColor.BLACK)));
            CelTablaIVA.Border = 3;
            CelTablaIVA.BackgroundColor = FondoCab;
            CelTablaIVA.HorizontalAlignment = Element.ALIGN_LEFT;
            TablaIVA.AddCell(CelTablaIVA);
            oDoc.Add(TablaIVA);

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

            //this.Close();
        }

        private void Btn_buscar_Click_1(object sender, EventArgs e)
        {
            if(com_prov.Text.Length>0 & Txt_Fact.Text.Length>0 & Txt_Timbrado.Text.Length > 0)
            {
                mensaje_lab.Visible = true;
                buscar_compra();
                mensaje_lab.Visible = false;
            }
        }
    }
}