Exemple #1
0
        public DataTable sp_ins_personasDAL(PersonasBO persona)
        {
            DataTable dt = new DataTable();

            try
            {
                parametros                   = new SqlParameter[5];
                parametros[numParam]         = new SqlParameter("@rut_persona", SqlDbType.Int);
                parametros[numParam++].Value = persona.Rut_persona;
                parametros[numParam]         = new SqlParameter("@gls_nombre_pers", SqlDbType.VarChar);
                parametros[numParam++].Value = persona.Nom_persona;
                parametros[numParam]         = new SqlParameter("@cod_funcion", SqlDbType.Int);
                parametros[numParam++].Value = persona.Fun_cod;
                parametros[numParam]         = new SqlParameter("@cod_terminal", SqlDbType.Int);
                parametros[numParam++].Value = persona.Age_cod;
                parametros[numParam]         = new SqlParameter("@gls_password", SqlDbType.VarChar);
                parametros[numParam++].Value = persona.Pass_persona;

                dt = new AccesoBDDAL().mtdEjecutaProcedimientoAlmacenadoSel("sp_add_personas", parametros);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(dt);
        }
Exemple #2
0
        public DataTable sp_updt_personasBLL(PersonasBO persona)
        {
            DataTable dt = new DataTable();

            try
            {
                dt = new PersonasDAL().sp_updt_personasDAL(persona);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(dt);
        }
Exemple #3
0
        public DataTable sp_del_personasDAL(PersonasBO persona)
        {
            DataTable dt = new DataTable();

            try
            {
                parametros                   = new SqlParameter[1];
                parametros[numParam]         = new SqlParameter("@RUT", SqlDbType.Int);
                parametros[numParam++].Value = persona.Rut_persona;

                dt = new AccesoBDDAL().mtdEjecutaProcedimientoAlmacenadoSel("sp_del_persona", parametros);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(dt);
        }
Exemple #4
0
    public static string eliminarPersonas(string rut)
    {
        DataTable  dt;
        int        rutPersona = Convert.ToInt32(rut);
        PersonasBO persona    = new PersonasBO();

        persona.Rut_persona = rutPersona;
        try
        {
            dt = new PersonasBLL().sp_del_personasBLL(persona);
        }
        catch (Exception ex)
        {
            throw ex;
        }
        string codstring = dt.Rows[0].ItemArray[0].ToString();

        return(codstring);
    }
Exemple #5
0
        public static void EliminarPersona(ref GlobalResponse globalResponse, string rut)
        {
            PersonasBO persona = new PersonasBO();

            string rut_persona = rut.Remove(rut.Length - 2, 2);

            persona.Rut_persona = Convert.ToInt32(rut_persona);

            DataTable dt = new DataTable();

            try
            {
                dt = new PersonasBLL().sp_del_personasBLL(persona);
            }
            catch (Exception ex)
            {
                globalResponse.Message  = ex.Message;
                globalResponse.HasError = true;
            }
        }
Exemple #6
0
    protected void btnModificar_Click(object sender, EventArgs e)
    {
        if (!ValidarCamposMod())
        {
            return;
        }

        int       rut, funcion, agencia;
        string    nombre, pass;
        DataTable dt = new DataTable();

        rut     = Convert.ToInt32(txtModRut.Text);
        nombre  = txtModNombre.Text;
        funcion = Convert.ToInt32(ddlModFun.SelectedValue);
        agencia = Convert.ToInt32(ddlModTerm.SelectedValue);
        pass    = txtModPass.Text;

        PersonasBO persona = new PersonasBO();

        persona.Rut_persona  = rut;
        persona.Nom_persona  = nombre;
        persona.Fun_cod      = funcion;
        persona.Age_cod      = agencia;
        persona.Pass_persona = pass;

        try
        {
            dt = new PersonasBLL().sp_updt_personasBLL(persona);
        }
        catch (Exception ex)
        {
            var visibilityClass = "alert alert-danger";
            var style           = "display:block;";
            mensajeError.Attributes["class"] = visibilityClass;
            mensajeError.Attributes["style"] = style;
            cv_Resultado.Text = "Ocurrio un error al cargar los datos: " + ex.Message;
        }

        Response.Redirect("PersonasDesc.aspx");
    }
Exemple #7
0
        public static void GuardarPersona(ref GlobalResponse globalresponse, string rut, string nombre, string password, string terminal, string funcion)
        {
            PersonasBO persona = new PersonasBO();

            persona.Rut_persona  = Convert.ToInt32(rut);
            persona.Nom_persona  = nombre;
            persona.Pass_persona = password;
            persona.Age_cod      = terminal;
            persona.Fun_cod      = funcion;

            DataTable dt = new DataTable();

            try
            {
                dt = new PersonasBLL().sp_ins_personasBLL(persona);
            }
            catch (Exception ex)
            {
                globalresponse.Message  = ex.Message;
                globalresponse.HasError = true;
            }
        }
Exemple #8
0
        public Document BindingData(Document doc, PlanificacionDescBO planDesc, TarjaDescDetBO tarja)
        {
            string       jsonCliente = JsonConvert.SerializeObject(new ForwardersBLL().sp_selPlanDesc_forwarderBLL(planDesc.Rut_cliente));
            ForwardersBO cliente     = JsonConvert.DeserializeObject <ForwardersBO>(jsonCliente.Trim(new char[] { '[', ']' }));

            string  jsonNave = JsonConvert.SerializeObject(new NavesBLL().sp_sel_naveIDBLL(planDesc.Cod_nave));
            NavesBO nave     = JsonConvert.DeserializeObject <NavesBO>(jsonNave.Trim(new char[] { '[', ']' }));

            string    jsonPuertoO = JsonConvert.SerializeObject(new PuertoBLL().sp_sel_puertoIDBLL(planDesc.Pue_codO));
            PuertosBO puerto_or   = JsonConvert.DeserializeObject <PuertosBO>(jsonPuertoO.Trim(new char[] { '[', ']' }));

            string    jsonPuertoD = JsonConvert.SerializeObject(new PuertoBLL().sp_sel_puertoIDBLL(planDesc.Pue_codD));
            PuertosBO puerto_dest = JsonConvert.DeserializeObject <PuertosBO>(jsonPuertoD.Trim(new char[] { '[', ']' }));

            string     jsonTarjador = JsonConvert.SerializeObject(new PersonasBLL().sp_sel_personasIDBLL(planDesc.Rut_tarjador));
            PersonasBO tarjador     = JsonConvert.DeserializeObject <PersonasBO>(jsonTarjador.Trim(new char[] { '[', ']' }));

            DataTable personasT = new PersonasBLL().sp_sel_personasTarjaBLL(tarja.Nro_tarja);

            string movilizadores = string.Empty;
            string horquillero   = string.Empty;

            foreach (DataRow row in personasT.Rows)
            {
                if (row["FUNCION"].ToString() == "Movilizador")
                {
                    movilizadores += row["nom_persona"].ToString() + "\n";
                }
                else
                {
                    horquillero = row["nom_persona"].ToString();
                }
            }

            var settings = new BarCodeSettings
            {
                Type = BarCodeType.Code128,
                Data = tarja.Nro_tarja.ToString()
            };

            var   generator = new BarCodeGenerator(settings);
            Image imgbarcode;

            using (var barcodeImage = generator.GenerateImage())
            {
                ImageFormat format = ImageFormat.Bmp;
                imgbarcode = Image.GetInstance(barcodeImage, format);
                imgbarcode.ScalePercent(100f);
            }

            Font   arialHeading = FontFactory.GetFont("Arial", 15, 1);
            Font   arialText    = FontFactory.GetFont("Arial", 10, 1);
            string logoPath     = HostingEnvironment.MapPath("~/assets/custom/images");

            //Añadir encabezado
            PdfPTable tableHeader = new PdfPTable(3);
            PdfPCell  subheader   = new PdfPCell(imgbarcode);

            subheader.HorizontalAlignment = 1;
            subheader.VerticalAlignment   = 5;
            subheader.Border               = 0;
            tableHeader.WidthPercentage    = 100;
            tableHeader.DefaultCell.Border = 0;
            tableHeader.DefaultCell.HorizontalAlignment = 1;
            tableHeader.DefaultCell.VerticalAlignment   = 5;

            Image logo = Image.GetInstance(logoPath + "/logo.png");

            tableHeader.AddCell(logo);
            Paragraph titulo = new Paragraph("Documento de Desconsolidado", arialHeading);

            tableHeader.AddCell(titulo);
            tableHeader.AddCell(subheader);

            //Añadir Tabla de detalles
            PdfPTable detailTable = new PdfPTable(6);

            detailTable.WidthPercentage                 = 100;
            detailTable.DefaultCell.Padding             = 4.5f;
            detailTable.DefaultCell.Border              = 15;
            detailTable.DefaultCell.HorizontalAlignment = 1;
            detailTable.DefaultCell.VerticalAlignment   = 5;

            //row1 inicializacion
            PdfPCell TitleCliente = new PdfPCell(new Paragraph("Cliente", arialText));

            TitleCliente.BackgroundColor     = BaseColor.LIGHT_GRAY;
            TitleCliente.HorizontalAlignment = 1;
            TitleCliente.VerticalAlignment   = 5;
            PdfPCell cellrutCliente = new PdfPCell(new Paragraph(cliente.Rut_cliente + "-" + cliente.Dv_cliente, arialText));

            cellrutCliente.HorizontalAlignment = 1;
            cellrutCliente.VerticalAlignment   = 5;
            PdfPCell cellcliente = new PdfPCell(new Paragraph(cliente.Nombre_cliente, arialText));

            cellcliente.HorizontalAlignment = 1;
            cellcliente.VerticalAlignment   = 5;
            PdfPCell vacio1             = new PdfPCell(new Paragraph(""));
            PdfPCell celltitlecontainer = new PdfPCell(new Paragraph("Contenedor", arialText));

            celltitlecontainer.HorizontalAlignment = 1;
            celltitlecontainer.VerticalAlignment   = 5;
            celltitlecontainer.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell cellcontainer = new PdfPCell(new Paragraph(planDesc.Cod_contenedor.Substring(0, 4) + "-" + planDesc.Cod_contenedor.Substring(4, 6) + "-" + planDesc.Cod_contenedor.Substring(10, 1), arialText));

            cellcontainer.HorizontalAlignment = 1;
            cellcontainer.VerticalAlignment   = 5;
            //row2 inicializacion
            PdfPCell celltitlenave = new PdfPCell(new Paragraph("Nave", arialText));

            celltitlenave.BackgroundColor     = BaseColor.LIGHT_GRAY;
            celltitlenave.HorizontalAlignment = 1;
            celltitlenave.VerticalAlignment   = 5;
            PdfPCell cellnave = new PdfPCell(new Paragraph(nave.Nav_nom, arialText));

            cellnave.HorizontalAlignment = 1;
            cellnave.VerticalAlignment   = 5;
            PdfPCell celltitleFechaI = new PdfPCell(new Paragraph("Fecha Inicio", arialText));

            celltitleFechaI.BackgroundColor     = BaseColor.LIGHT_GRAY;
            celltitleFechaI.HorizontalAlignment = 1;
            celltitleFechaI.VerticalAlignment   = 5;
            PdfPCell cellFechaI = new PdfPCell(new Paragraph(planDesc.Fecha.ToString("dd-MM-yyyy").Substring(0, 10), arialText));

            cellFechaI.HorizontalAlignment = 1;
            cellFechaI.VerticalAlignment   = 5;
            PdfPCell celltitleiso = new PdfPCell(new Paragraph("Codigo Iso", arialText));

            celltitleiso.BackgroundColor     = BaseColor.LIGHT_GRAY;
            celltitleiso.HorizontalAlignment = 1;
            celltitleiso.VerticalAlignment   = 5;
            PdfPCell celliso = new PdfPCell(new Paragraph(planDesc.Cod_iso, arialText));

            celliso.HorizontalAlignment = 1;
            celliso.VerticalAlignment   = 5;
            //row3 inicializacion
            PdfPCell titleviaje = new PdfPCell(new Paragraph("Viaje/Etapa", arialText));

            titleviaje.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titleviaje.HorizontalAlignment = 1;
            titleviaje.VerticalAlignment   = 5;
            PdfPCell cellviaje = new PdfPCell(new Paragraph(planDesc.Cod_viaje.ToString(), arialText));

            cellviaje.HorizontalAlignment = 1;
            cellviaje.VerticalAlignment   = 5;
            PdfPCell celltitlefecha = new PdfPCell(new Paragraph("Fecha Termino", arialText));

            celltitlefecha.BackgroundColor     = BaseColor.LIGHT_GRAY;
            celltitlefecha.HorizontalAlignment = 1;
            celltitlefecha.VerticalAlignment   = 5;
            PdfPCell cellfecha = new PdfPCell(new Paragraph(planDesc.FechaT.ToString("dd-MM-yyyy").Substring(0, 10), arialText));

            cellfecha.HorizontalAlignment = 1;
            cellfecha.VerticalAlignment   = 5;
            PdfPCell celltitletara = new PdfPCell(new Paragraph("Tara (Kg.)", arialText));

            celltitletara.HorizontalAlignment = 1;
            celltitletara.VerticalAlignment   = 5;
            celltitletara.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell celltara = new PdfPCell(new Paragraph(planDesc.Tara.ToString(), arialText));

            celltara.HorizontalAlignment = 1;
            celltara.VerticalAlignment   = 5;
            //row4 inicializacion
            PdfPCell titlemanifiesto = new PdfPCell(new Paragraph("Duración Faena", arialText));

            titlemanifiesto.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlemanifiesto.HorizontalAlignment = 1;
            titlemanifiesto.VerticalAlignment   = 5;
            PdfPCell cellmanifiesto = new PdfPCell(new Paragraph(Convert.ToInt32(planDesc.Duracion * 60) + " Min.", arialText));

            cellmanifiesto.HorizontalAlignment = 1;
            cellmanifiesto.VerticalAlignment   = 5;
            PdfPCell titleturno = new PdfPCell(new Paragraph("Mano de Trabajo", arialText));

            titleturno.BackgroundColor       = BaseColor.LIGHT_GRAY;
            titleturno.HorizontalAlignment   = 1;
            celltitlefecha.VerticalAlignment = 5;
            PdfPCell cellturno = new PdfPCell(new Paragraph(planDesc.Mddt, arialText));

            cellturno.HorizontalAlignment = 1;
            cellturno.VerticalAlignment   = 5;
            PdfPCell titlesello1 = new PdfPCell(new Paragraph("Sello 1 (Manifestado/Fisico)", arialText));

            titlesello1.HorizontalAlignment = 1;
            titlesello1.VerticalAlignment   = 5;
            titlesello1.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell cellsello1 = new PdfPCell(new Paragraph(planDesc.Sello1 + " / " + planDesc.SelloFis1, arialText));

            cellsello1.HorizontalAlignment = 1;
            cellsello1.VerticalAlignment   = 5;
            //row5 inicializacion
            PdfPCell titleorigen = new PdfPCell(new Paragraph("Origen", arialText));

            titleorigen.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titleorigen.HorizontalAlignment = 1;
            titleorigen.VerticalAlignment   = 5;
            PdfPCell cellorigen = new PdfPCell(new Paragraph(puerto_or.Gls_nombre_puerto, arialText));

            cellorigen.HorizontalAlignment = 1;
            cellorigen.VerticalAlignment   = 5;
            PdfPCell titlehorai = new PdfPCell(new Paragraph("Hora Inicio", arialText));

            titlehorai.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlehorai.HorizontalAlignment = 1;
            titlehorai.VerticalAlignment   = 5;
            PdfPCell cellhorai = new PdfPCell(new Paragraph(planDesc.HoraIR.ToString(), arialText));

            cellhorai.HorizontalAlignment = 1;
            cellhorai.VerticalAlignment   = 5;
            PdfPCell titlesello2 = new PdfPCell(new Paragraph("Sello 2 (Manifestado/Fisico)", arialText));

            titlesello2.HorizontalAlignment = 1;
            titlesello2.VerticalAlignment   = 5;
            titlesello2.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell cellsello2 = new PdfPCell(new Paragraph(planDesc.Sello2 + " / " + planDesc.SelloFis2, arialText));

            cellsello2.HorizontalAlignment = 1;
            cellsello2.VerticalAlignment   = 5;
            //row6 inicializacion
            PdfPCell titledestino = new PdfPCell(new Paragraph("Destino", arialText));

            titledestino.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titledestino.HorizontalAlignment = 1;
            titledestino.VerticalAlignment   = 5;
            PdfPCell celldestino = new PdfPCell(new Paragraph(puerto_dest.Gls_nombre_puerto, arialText));

            celldestino.HorizontalAlignment = 1;
            celldestino.VerticalAlignment   = 5;
            PdfPCell titlehorat = new PdfPCell(new Paragraph("Hora Termino", arialText));

            titlehorat.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlehorat.HorizontalAlignment = 1;
            titlehorat.VerticalAlignment   = 5;
            PdfPCell cellhorat = new PdfPCell(new Paragraph(planDesc.HoraTR.ToString(), arialText));

            cellhorat.HorizontalAlignment = 1;
            cellhorat.VerticalAlignment   = 5;
            PdfPCell titlesello3 = new PdfPCell(new Paragraph("Sello 3 (Manifestado/Fisico)", arialText));

            titlesello3.HorizontalAlignment = 1;
            titlesello3.VerticalAlignment   = 5;
            titlesello3.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell cellsello3 = new PdfPCell(new Paragraph(planDesc.Sello3 + " / " + planDesc.SelloFis3, arialText));

            cellsello3.HorizontalAlignment = 1;
            cellsello3.VerticalAlignment   = 5;


            //row1
            detailTable.AddCell(TitleCliente);
            detailTable.AddCell(cellrutCliente);
            detailTable.AddCell(cellcliente);
            detailTable.AddCell(vacio1);
            detailTable.AddCell(celltitlecontainer);
            detailTable.AddCell(cellcontainer);
            //row2
            detailTable.AddCell(celltitlenave);
            detailTable.AddCell(cellnave);
            detailTable.AddCell(celltitleFechaI);
            detailTable.AddCell(cellFechaI);
            detailTable.AddCell(celltitleiso);
            detailTable.AddCell(celliso);
            //row3
            detailTable.AddCell(titleviaje);
            detailTable.AddCell(cellviaje);
            detailTable.AddCell(celltitlefecha);
            detailTable.AddCell(cellfecha);
            detailTable.AddCell(celltitletara);
            detailTable.AddCell(celltara);
            //row4
            detailTable.AddCell(titlemanifiesto);
            detailTable.AddCell(cellmanifiesto);
            detailTable.AddCell(titleturno);
            detailTable.AddCell(cellturno);
            detailTable.AddCell(titlesello1);
            detailTable.AddCell(cellsello1);
            //row5
            detailTable.AddCell(titleorigen);
            detailTable.AddCell(cellorigen);
            detailTable.AddCell(titlehorai);
            detailTable.AddCell(cellhorai);
            detailTable.AddCell(titlesello2);
            detailTable.AddCell(cellsello2);
            //row6
            detailTable.AddCell(titledestino);
            detailTable.AddCell(celldestino);
            detailTable.AddCell(titlehorat);
            detailTable.AddCell(cellhorat);
            detailTable.AddCell(titlesello3);
            detailTable.AddCell(cellsello3);

            ////tabla contenedor
            PdfPTable detailConte = new PdfPTable(3);

            detailConte.WidthPercentage = 100;
            detailConte.DefaultCell.HorizontalAlignment = 1;
            detailConte.DefaultCell.VerticalAlignment   = 5;

            ////row 1
            Image vector = Image.GetInstance(logoPath + "/vector.png");

            vector.ScalePercent(52f);
            PdfPCell cellFotoCont = new PdfPCell(vector);

            cellFotoCont.HorizontalAlignment = 1;
            cellFotoCont.VerticalAlignment   = 5;
            PdfPTable             tableSecVec = new PdfPTable(2);
            List <SectorVectorBO> listSector = JsonConvert.DeserializeObject <List <SectorVectorBO> >(new SectorVectorBLL().sp_sel_sectorVectorIDDAL(tarja.Nro_tarja));
            string codEstado, nroSector, estado;

#pragma warning disable CS0219 // La variable 'j' está asignada pero su valor nunca se usa
            int j = 1;
#pragma warning restore CS0219 // La variable 'j' está asignada pero su valor nunca se usa
            foreach (SectorVectorBO sector in listSector)
            {
                codEstado = sector.Cod_estado.ToString();
                nroSector = sector.Nro_sector.ToString();
                PdfPCell estadoSec = new PdfPCell();
                estado = sector.Gls_nombre_estado.ToString();

                estadoSec.AddElement(new Paragraph(nroSector + " " + estado, arialText));
                estadoSec.BackgroundColor     = BaseColor.YELLOW;
                estadoSec.HorizontalAlignment = 1;
                estadoSec.VerticalAlignment   = 5;
                if (codEstado.Equals("S"))
                {
                    estadoSec.BackgroundColor = BaseColor.WHITE;
                }

                tableSecVec.AddCell(estadoSec);
            }

            tableSecVec.AddCell("");

            PdfPCell cellEstadosSec = new PdfPCell(tableSecVec);

            PdfPTable tableObs = new PdfPTable(1);
            PdfPCell  titleObs = new PdfPCell(new Paragraph("OBSERVACIONES GENERALES", arialText));
            titleObs.HorizontalAlignment = 1;
            titleObs.VerticalAlignment   = 5;
            titleObs.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell cellObs = new PdfPCell(new Paragraph(tarja.Observacion, arialText));
            tableObs.AddCell(titleObs);
            tableObs.AddCell(cellObs);

            PdfPCell obs = new PdfPCell(tableObs);

            detailConte.AddCell(cellFotoCont);
            detailConte.AddCell(cellEstadosSec);
            detailConte.AddCell(obs);

            //tabla detalles personas
            PdfPTable tablapersonas = new PdfPTable(4);
            tablapersonas.WidthPercentage = 100;
            //row1
            PdfPCell titlegrua = new PdfPCell(new Paragraph("GRUA", arialText));
            titlegrua.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlegrua.HorizontalAlignment = 1;
            titlegrua.VerticalAlignment   = 5;
            PdfPCell cellgrua = new PdfPCell(new Paragraph(tarja.Grua_cod, arialText));
            cellgrua.HorizontalAlignment = 1;
            cellgrua.VerticalAlignment   = 5;
            PdfPCell titlemovilizadores = new PdfPCell(new Paragraph("MOVILIZADORES", arialText));
            titlemovilizadores.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlemovilizadores.HorizontalAlignment = 1;
            titlemovilizadores.VerticalAlignment   = 5;
            PdfPCell titletarjador = new PdfPCell(new Paragraph("TARJADOR", arialText));
            titletarjador.HorizontalAlignment = 1;
            titletarjador.VerticalAlignment   = 5;
            titletarjador.BackgroundColor     = BaseColor.LIGHT_GRAY;
            //row2
            PdfPCell titlehorquillero = new PdfPCell(new Paragraph("HORQUILLERO", arialText));
            titlehorquillero.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlehorquillero.HorizontalAlignment = 1;
            titlehorquillero.VerticalAlignment   = 5;
            PdfPCell cellhorquillero = new PdfPCell(new Paragraph(horquillero, arialText));
            cellhorquillero.HorizontalAlignment = 1;
            cellhorquillero.VerticalAlignment   = 5;
            PdfPCell cellmovilizadeores = new PdfPCell(new Paragraph(movilizadores, arialText));
            titlemovilizadores.HorizontalAlignment = 1;
            titlemovilizadores.VerticalAlignment   = 5;
            PdfPCell celltarjador = new PdfPCell(new Paragraph(tarjador.Nom_persona, arialText));
            titletarjador.HorizontalAlignment = 1;
            titletarjador.VerticalAlignment   = 5;

            tablapersonas.AddCell(titlegrua);
            tablapersonas.AddCell(cellgrua);
            tablapersonas.AddCell(titlemovilizadores);
            tablapersonas.AddCell(titletarjador);
            tablapersonas.AddCell(titlehorquillero);
            tablapersonas.AddCell(cellhorquillero);
            tablapersonas.AddCell(cellmovilizadeores);
            tablapersonas.AddCell(celltarjador);

            ////Tabla Merc
            Int64[]  codigosMerc             = null;
            string[] marcas                  = null;
            List <MercanciasDescBO> listMerc = null;
            PdfPTable detalleMerc            = new PdfPTable(6);
            detalleMerc.WidthPercentage = 100;
            PdfPCell titlemarca = new PdfPCell(new Paragraph("MARCAS/NUMEROS", arialText));
            titlemarca.HorizontalAlignment = 1;
            titlemarca.VerticalAlignment   = 5;
            titlemarca.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlemarca.Border = 15;
            detalleMerc.AddCell(titlemarca);
            PdfPCell titlebulto = new PdfPCell(new Paragraph("TIPO BULTO", arialText));
            titlebulto.HorizontalAlignment = 1;
            titlebulto.VerticalAlignment   = 5;
            titlebulto.Border          = 15;
            titlebulto.BackgroundColor = BaseColor.LIGHT_GRAY;
            detalleMerc.AddCell(titlebulto);
            PdfPCell titleretiro = new PdfPCell(new Paragraph("TIPO DE RETIRO", arialText));
            titleretiro.HorizontalAlignment = 1;
            titleretiro.VerticalAlignment   = 5;
            titleretiro.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlebulto.Border = 15;
            detalleMerc.AddCell(titleretiro);
            PdfPCell titlecantidad = new PdfPCell(new Paragraph("CANTIDAD", arialText));
            titlecantidad.HorizontalAlignment = 1;
            titlecantidad.VerticalAlignment   = 5;
            titlecantidad.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titlecantidad.Border = 15;
            detalleMerc.AddCell(titlecantidad);
            PdfPCell titleTotalmarca = new PdfPCell(new Paragraph("TOTAL", arialText));
            titleTotalmarca.HorizontalAlignment = 1;
            titleTotalmarca.VerticalAlignment   = 5;
            titleTotalmarca.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titleTotalmarca.Border = 15;
            detalleMerc.AddCell(titleTotalmarca);
            PdfPCell titleobs = new PdfPCell(new Paragraph("OBSERVACIONES", arialText));
            titleobs.HorizontalAlignment = 1;
            titleobs.VerticalAlignment   = 5;
            titleobs.BackgroundColor     = BaseColor.LIGHT_GRAY;
            titleobs.Border = 15;
            detalleMerc.AddCell(titleobs);
            PdfPCell cellmarca, cellbultos, cellretiro, cellcantidad, celltotalM, cellobs, celltotal;
            string   nomBulto = "";
            int      suma     = 0;
            try
            {
                listMerc = new MercanciasDescBll().sp_sel_mercDescBLL(tarja.Nro_tarja);
                int i = 0;
                codigosMerc = new Int64[listMerc.Count];
                marcas      = new string[listMerc.Count];
                foreach (MercanciasDescBO mercs in listMerc)
                {
                    int    cantidadB      = 0;
                    string cantidad       = string.Empty;
                    string observacioMerc = string.Empty;
                    codigosMerc[i] = mercs.Cod_mercancia;
                    if (!verificarMarca(marcas, mercs.Gls_marca))
                    {
                        marcas[i] = mercs.Gls_marca;
                        foreach (MercanciasDescBO mercAux in listMerc)
                        {
                            if (mercAux.Gls_marca.Equals(mercs.Gls_marca))
                            {
                                cantidad       += mercAux.N_cantidad.ToString() + " + ";
                                observacioMerc += " " + mercAux.Observacion;
                                cantidadB      += mercAux.N_cantidad;
                                nomBulto        = mercAux.Desc_bulto;
                            }
                        }
                        cantidad  = cantidad.Substring(0, cantidad.Length - 2);
                        suma     += cantidadB;
                        cellmarca = new PdfPCell(new Paragraph(mercs.Gls_marca, arialText));
                        cellmarca.HorizontalAlignment = 1;
                        cellmarca.VerticalAlignment   = 5;
                        cellmarca.Border = 15;
                        detalleMerc.AddCell(cellmarca);
                        cellbultos = new PdfPCell(new Paragraph(nomBulto, arialText));
                        cellbultos.HorizontalAlignment = 1;
                        cellbultos.VerticalAlignment   = 5;
                        cellbultos.Border = 15;
                        detalleMerc.AddCell(cellbultos);
                        cellretiro = new PdfPCell(new Paragraph(mercs.Gls_retiro, arialText));
                        cellretiro.HorizontalAlignment = 1;
                        cellretiro.VerticalAlignment   = 5;
                        cellretiro.Border = 15;
                        detalleMerc.AddCell(cellretiro);
                        cellcantidad = new PdfPCell(new Paragraph(cantidad.ToString(), arialText));
                        cellcantidad.HorizontalAlignment = 1;
                        cellcantidad.VerticalAlignment   = 5;
                        cellcantidad.Border = 15;
                        detalleMerc.AddCell(cellcantidad);
                        celltotalM = new PdfPCell(new Paragraph(cantidadB.ToString(), arialText));
                        celltotalM.HorizontalAlignment = 1;
                        celltotalM.VerticalAlignment   = 5;
                        celltotalM.Border = 15;
                        detalleMerc.AddCell(celltotalM);
                        cellobs = new PdfPCell(new Paragraph(observacioMerc, arialText));
                        cellobs.HorizontalAlignment = 1;
                        cellobs.VerticalAlignment   = 5;
                        cellobs.Border = 15;
                        detalleMerc.AddCell(cellobs);
                    }

                    i++;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Ha ocurrido un error: " + ex.ToString());
            }
            PdfPCell titletotal = new PdfPCell(new Paragraph("TOTAL", arialText));
            titletotal.Border = 15;
            titletotal.HorizontalAlignment = 1;
            titletotal.VerticalAlignment   = 5;
            titletotal.BackgroundColor     = BaseColor.LIGHT_GRAY;
            detalleMerc.AddCell(titletotal);

            celltotal = new PdfPCell(new Paragraph(suma.ToString(), arialText));
            celltotal.HorizontalAlignment = 1;
            celltotal.VerticalAlignment   = 5;
            celltotal.Border = 15;
            detalleMerc.AddCell(celltotal);
            PdfPCell cellnada = new PdfPCell(new Paragraph(""));
            cellnada.Border = 0;
            detalleMerc.AddCell(cellnada);
            detalleMerc.AddCell(cellnada);
            detalleMerc.AddCell(cellnada);
            detalleMerc.AddCell(cellnada);

            PdfPTable tablefotos = new PdfPTable(3);
            tablefotos.WidthPercentage = 100;
            PdfPCell titletable = new PdfPCell(new Paragraph("FOTOGRAFIAS DESCONSOLIDADO", arialText));
            titletable.Border = 15;
            titletable.HorizontalAlignment = 1;
            titletable.VerticalAlignment   = 5;
            titletable.BackgroundColor     = BaseColor.LIGHT_GRAY;
            PdfPCell  cellnombrefoto;
            PdfPTable subtabla = new PdfPTable(1);
            PdfPCell  cellfotografias;

#pragma warning disable CS0168 // La variable 'cellfoto' se ha declarado pero nunca se usa
            PdfPCell cellfoto;
#pragma warning restore CS0168 // La variable 'cellfoto' se ha declarado pero nunca se usa
            String base64Img = "";

            var doctypeDesCnt  = ConfigurationManager.AppSettings["FDM:DocTypeDescCnt"].ToString();
            var fechaLimiteStr = ConfigurationManager.AppSettings["FechaLimite"].ToString().Split('-');

            DateTime fechaLimite = new DateTime(Convert.ToInt32(fechaLimiteStr[0]), Convert.ToInt32(fechaLimiteStr[1]), Convert.ToInt32(fechaLimiteStr[2]));

            if (planDesc.Fecha < fechaLimite)
            {
                try
                {
                    byte[] imageBytes;
                    List <FotoContenedorBO> listFotos = new FotoContenedorBLL().sp_sel_fotoContDescBLL(tarja.Nro_tarja);
                    string nombreImagen = string.Empty;
                    foreach (FotoContenedorBO fotoCl in listFotos)
                    {
                        if (!nombreImagen.Equals(fotoCl.Gls_nombreImg))
                        {
                            if (string.IsNullOrEmpty(nombreImagen))
                            {
                                nombreImagen = fotoCl.Gls_nombreImg;
                                base64Img    = fotoCl.Gls_imagen;
                            }
                            else
                            {
                                if (base64Img.Length % 4 != 0)
                                {
                                    string len = (base64Img.Length % 4).ToString();
                                }
                                else
                                {
                                    imageBytes = Convert.FromBase64String(base64Img);
                                    Image foto = Image.GetInstance(imageBytes);
                                    foto.ScaleAbsolute(159f, 235f);
                                    cellnombrefoto = new PdfPCell(new Paragraph(nombreImagen, arialText));
                                    cellnombrefoto.HorizontalAlignment = 1;
                                    cellnombrefoto.VerticalAlignment   = 5;
                                    subtabla = new PdfPTable(1);
                                    subtabla.AddCell(new PdfPCell(foto)
                                    {
                                        HorizontalAlignment = 1, VerticalAlignment = 5
                                    });
                                    subtabla.AddCell(cellnombrefoto);
                                    cellfotografias = new PdfPCell(subtabla);
                                    cellfotografias.HorizontalAlignment = 1;
                                    cellfotografias.VerticalAlignment   = 5;
                                    tablefotos.AddCell(cellfotografias);
                                }

                                nombreImagen = fotoCl.Gls_nombreImg;
                                base64Img    = fotoCl.Gls_imagen;
                            }
                        }
                        else
                        {
                            if (!string.IsNullOrEmpty(nombreImagen))
                            {
                                var parte = fotoCl.Gls_imagen;
                                var largo = parte.Length;
                                base64Img += "" + parte;
                            }
                        }
                    }
                    if (!string.IsNullOrEmpty(base64Img))
                    {
                        imageBytes = Convert.FromBase64String(base64Img);
                        Image foto2 = Image.GetInstance(imageBytes);
                        foto2.ScaleAbsolute(159f, 235f);
                        cellnombrefoto = new PdfPCell(new Paragraph(nombreImagen, arialText));
                        cellnombrefoto.HorizontalAlignment = 1;
                        cellnombrefoto.VerticalAlignment   = 5;
                        subtabla = new PdfPTable(1);
                        subtabla.AddCell(new PdfPCell(foto2)
                        {
                            HorizontalAlignment = 1, VerticalAlignment = 5
                        });
                        subtabla.AddCell(cellnombrefoto);
                        cellfotografias = new PdfPCell(subtabla);
                        cellfotografias.HorizontalAlignment = 1;
                        cellfotografias.VerticalAlignment   = 5;
                        tablefotos.AddCell(cellfotografias);
                    }
                    base64Img    = "";
                    nombreImagen = "";
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Ha ocurrido un error: " + ex.ToString());
                }

                foreach (Int64 codigo in codigosMerc)
                {
                    try
                    {
                        byte[] imageBytes;
                        string marcaMerc    = "";
                        string nombreImagen = string.Empty;
                        List <FotoMercanciaBO> listFotoMerc = new FotoMercanciaBLL().sp_sel_fotoMercDescBLL(codigo);
                        marcaMerc = new MercanciasDescBll().sp_sel_marcaMercBLL(codigo);
                        foreach (FotoMercanciaBO fotoMerc in listFotoMerc)
                        {
                            if (!nombreImagen.Equals(fotoMerc.Gls_nombreImg))
                            {
                                if (string.IsNullOrEmpty(nombreImagen))
                                {
                                    nombreImagen = fotoMerc.Gls_nombreImg;
                                    base64Img    = fotoMerc.Gls_imagen;
                                }
                                else
                                {
                                    if (base64Img.Length % 4 != 0)
                                    {
                                        string len = (base64Img.Length % 4).ToString();
                                    }
                                    else
                                    {
                                        imageBytes = Convert.FromBase64String(base64Img);
                                        Image foto = Image.GetInstance(imageBytes);
                                        foto.ScaleAbsolute(159f, 235f);
                                        cellnombrefoto = new PdfPCell(new Paragraph(marcaMerc, arialText));
                                        cellnombrefoto.HorizontalAlignment = 1;
                                        cellnombrefoto.VerticalAlignment   = 5;
                                        subtabla = new PdfPTable(1);
                                        subtabla.AddCell(new PdfPCell(foto)
                                        {
                                            HorizontalAlignment = 1, VerticalAlignment = 5
                                        });
                                        subtabla.AddCell(cellnombrefoto);
                                        cellfotografias = new PdfPCell(subtabla);
                                        cellfotografias.HorizontalAlignment = 1;
                                        cellfotografias.VerticalAlignment   = 5;
                                        tablefotos.AddCell(cellfotografias);
                                    }
                                    nombreImagen = fotoMerc.Gls_nombreImg;
                                    base64Img    = fotoMerc.Gls_imagen;
                                }
                            }
                            else
                            {
                                if (!string.IsNullOrEmpty(nombreImagen))
                                {
                                    var parte = fotoMerc.Gls_imagen;
                                    var largo = parte.Length;
                                    base64Img += "" + parte;
                                }
                            }
                        }
                        if (!string.IsNullOrEmpty(nombreImagen))
                        {
                            imageBytes = Convert.FromBase64String(base64Img);
                            Image foto2 = Image.GetInstance(imageBytes);
                            foto2.ScaleAbsolute(159f, 235f);
                            cellnombrefoto = new PdfPCell(new Paragraph(marcaMerc, arialText));
                            cellnombrefoto.HorizontalAlignment = 1;
                            cellnombrefoto.VerticalAlignment   = 5;
                            subtabla = new PdfPTable(1);
                            subtabla.AddCell(new PdfPCell(foto2)
                            {
                                HorizontalAlignment = 1, VerticalAlignment = 5
                            });
                            subtabla.AddCell(cellnombrefoto);
                            cellfotografias = new PdfPCell(subtabla);
                            cellfotografias.HorizontalAlignment = 1;
                            cellfotografias.VerticalAlignment   = 5;
                            tablefotos.AddCell(cellfotografias);

                            nombreImagen = "";
                            base64Img    = "";
                        }
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("Ha ocurrido un error: " + ex.ToString());
                    }
                }
                try
                {
                    byte[] imageBytes;
                    string nombreImagen = string.Empty;
                    List <FotoContenedorBO> listFotosFin = new FotoContenedorBLL().sp_sel_fotoContFinBLL(tarja.Nro_tarja);
                    foreach (FotoContenedorBO fotoFin in listFotosFin)
                    {
                        if (!nombreImagen.Equals(fotoFin.Gls_nombreImg))
                        {
                            if (string.IsNullOrEmpty(nombreImagen))
                            {
                                nombreImagen = fotoFin.Gls_nombreImg;
                                base64Img    = fotoFin.Gls_imagen;
                            }
                            else
                            {
                                if (base64Img.Length % 4 != 0)
                                {
                                    string len = (base64Img.Length % 4).ToString();
                                }
                                else
                                {
                                    imageBytes = Convert.FromBase64String(base64Img);
                                    Image foto = Image.GetInstance(imageBytes);
                                    foto.ScaleAbsolute(159f, 235f);
                                    cellnombrefoto = new PdfPCell(new Paragraph(nombreImagen, arialText));
                                    cellnombrefoto.HorizontalAlignment = 1;
                                    cellnombrefoto.VerticalAlignment   = 5;
                                    subtabla = new PdfPTable(1);
                                    subtabla.AddCell(new PdfPCell(foto)
                                    {
                                        HorizontalAlignment = 1, VerticalAlignment = 5
                                    });
                                    subtabla.AddCell(cellnombrefoto);
                                    cellfotografias = new PdfPCell(subtabla);
                                    cellfotografias.HorizontalAlignment = 1;
                                    cellfotografias.VerticalAlignment   = 5;
                                    tablefotos.AddCell(cellfotografias);
                                }

                                nombreImagen = fotoFin.Gls_nombreImg;
                                base64Img    = fotoFin.Gls_imagen;
                            }
                        }
                        else
                        {
                            if (!string.IsNullOrEmpty(nombreImagen))
                            {
                                var parte = fotoFin.Gls_imagen;
                                var largo = parte.Length;
                                base64Img += "" + parte;
                            }
                        }
                    }
                    if (!string.IsNullOrEmpty(nombreImagen))
                    {
                        imageBytes = Convert.FromBase64String(base64Img);
                        base64Img  = Convert.ToBase64String(imageBytes);
                        Image foto2 = Image.GetInstance(imageBytes);
                        foto2.ScaleAbsolute(159f, 235f);
                        cellnombrefoto = new PdfPCell(new Paragraph(nombreImagen, arialText));
                        cellnombrefoto.HorizontalAlignment = 1;
                        cellnombrefoto.VerticalAlignment   = 5;
                        subtabla = new PdfPTable(1);
                        subtabla.AddCell(new PdfPCell(foto2)
                        {
                            HorizontalAlignment = 1, VerticalAlignment = 5
                        });
                        subtabla.AddCell(cellnombrefoto);
                        cellfotografias = new PdfPCell(subtabla);
                        cellfotografias.HorizontalAlignment = 1;
                        cellfotografias.VerticalAlignment   = 5;
                        tablefotos.AddCell(cellfotografias);
                    }

                    nombreImagen = "";
                    base64Img    = "";
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Ha ocurrido un error: " + ex.ToString());
                }
            }
            else
            {
                try
                {
                    List <FotografiasFDM> listFotos = new FotografiasFDM().obtenerFotografias(doctypeDesCnt, tarja.Nro_tarja.ToString());
                    string nombreImagen             = string.Empty;
                    foreach (FotografiasFDM fotoCl in listFotos)
                    {
                        Image foto = Image.GetInstance(new Uri(fotoCl.url_foto));
                        foto.ScaleAbsolute(159f, 235f);
                        cellnombrefoto = new PdfPCell(new Paragraph(fotoCl.nombre_foto, arialText));
                        cellnombrefoto.HorizontalAlignment = 1;
                        cellnombrefoto.VerticalAlignment   = 5;
                        subtabla = new PdfPTable(1);
                        subtabla.AddCell(new PdfPCell(foto)
                        {
                            HorizontalAlignment = 1, VerticalAlignment = 5
                        });
                        subtabla.AddCell(cellnombrefoto);
                        cellfotografias = new PdfPCell(subtabla);
                        cellfotografias.HorizontalAlignment = 1;
                        cellfotografias.VerticalAlignment   = 5;
                        tablefotos.AddCell(cellfotografias);
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("Ha ocurrido un error: " + ex.ToString());
                }

                var docTypeMercDes = ConfigurationManager.AppSettings["FDM:DocTypeMercDesc"].ToString();

                foreach (Int64 codigo in codigosMerc)
                {
                    try
                    {
                        string marcaMerc    = "";
                        string nombreImagen = string.Empty;
                        List <FotografiasFDM> listFotoMerc = new FotografiasFDM().obtenerFotografias(docTypeMercDes, codigo.ToString());

                        marcaMerc = new MercanciasDescBll().sp_sel_marcaMercBLL(codigo);
                        foreach (FotografiasFDM fotoMerc in listFotoMerc)
                        {
                            Image foto2 = Image.GetInstance(new Uri(fotoMerc.url_foto));
                            foto2.ScaleAbsolute(159f, 235f);
                            cellnombrefoto = new PdfPCell(new Paragraph(marcaMerc, arialText));
                            cellnombrefoto.HorizontalAlignment = 1;
                            cellnombrefoto.VerticalAlignment   = 5;
                            subtabla = new PdfPTable(1);
                            subtabla.AddCell(new PdfPCell(foto2)
                            {
                                HorizontalAlignment = 1, VerticalAlignment = 5
                            });
                            subtabla.AddCell(cellnombrefoto);
                            cellfotografias = new PdfPCell(subtabla);
                            cellfotografias.HorizontalAlignment = 1;
                            cellfotografias.VerticalAlignment   = 5;
                            tablefotos.AddCell(cellfotografias);
                        }
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("Ha ocurrido un error: " + ex.ToString());
                    }
                }
            }

            tablefotos.AddCell(vacio1);
            tablefotos.AddCell(vacio1);

            Paragraph vacio = new Paragraph();
            vacio.Add("\n");
            Paragraph p1 = new Paragraph();
            p1.Add(tableHeader);
            Paragraph p2 = new Paragraph();
            p2.Add(detailTable);
            Paragraph p3 = new Paragraph();
            p3.Add(detailConte);
            Paragraph p4 = new Paragraph();
            p4.Add(tablapersonas);
            Paragraph p5 = new Paragraph();
            p5.Add(detalleMerc);
            Paragraph p6 = new Paragraph();
            p6.Add(tablefotos);

            doc.Add(p1);
            doc.Add(vacio);
            doc.Add(p2);
            doc.Add(p3);
            doc.Add(p4);
            doc.NewPage();
            doc.Add(p5);
            doc.NewPage();
            doc.Add(p6);
            return(doc);
        }