public FileResult CargFamCsv()
{
using (CargFam = new EmpleadosEntities())
{
var ListCargFam = CargFam.Sp_Mues_CargFam().ToList();
List <object> customers = (from customer in ListCargFam
select new[] {
customer.Rut_Carga, customer.Nombre, customer.Paterno, customer.Materno,
customer.Fono_Movil, customer.Fono_Fijo, customer.Fecha_Nacimiento, customer.Sexo,
customer.Direccion, customer.Villa, customer.Comuna, customer.Ciudad,
customer.Email, customer.Nombre_Empleado, customer.Comentarios
}).ToList <object>();
//Insert the Column Names.
customers.Insert(0, new string[15] {
"Rut", "Nombre", "Ap. Paterno", "Ap. Materno", "Fono Movil", "Fono Fijo",
"Fech. Nacimiento", "Sexo", "Dirección", "Villa", "Comuna", "Ciudad",
"Correo", "Nombre Empleado", "Comentarios"
});
StringBuilder sb = new StringBuilder();
for (int i = 0; i < customers.Count; i++)
{
string[] customer = (string[])customers[i];
for (int j = 0; j < customer.Length; j++)
{
//Append data with separator.
sb.Append(customer[j] + ',');
}
//Append new line character.
sb.Append("\r\n");
}
return(File(Encoding.UTF8.GetBytes(sb.ToString()), "text/csv", "ListaEmpleados.csv"));
}
}
// GET: CargFam
#region Carg_CargFam
public ActionResult Index()
{
try
{
using (CargFam = new EmpleadosEntities())
{
var ListCargFam = CargFam.Sp_Mues_CargFam().ToList();
var ListCom = Comun.Sp_Mues_Comunas().ToList();
ViewBag.ListComu = new SelectList(ListCom, "Comuna_Id", "Comuna");
var LisSex = Sexo.Sexo.ToList();
ViewBag.ListSexos = new SelectList(LisSex, "Id_Sexo", "Descripcion");
var LisNac = Nacion.Nacionalidad.ToList();
ViewBag.ListNacion = new SelectList(LisNac, "Id_Nac", "Descripcion");
return(View(ListCargFam));
}
}catch (Exception ex)
{
Logger.Error("Error On:", ex);
Response.StatusCode = 500;
Response.StatusDescription = ex.Message;
return(Json(Response));
}
}
public ActionResult CargFamDocx()
{
try
{
using (CargFam = new EmpleadosEntities())
{
var ListCargFam = CargFam.Sp_Mues_CargFam().ToList();
//Ubicacion de Archivo
string filename = @"C:\Users\Rodrigo_Menares\Downloads\ListaCargFam.docx";
var doc = DocX.Create(filename);
//cambia la orientacion de la pagina
doc.PageLayout.Orientation = Orientation.Landscape;
//Carga una imagen en formato JPG
var image = doc.AddImage(Server.MapPath("/Imagenes/bg.jpg"));
// Set Picture Height and Width.
var picture = image.CreatePicture(50, 50);
picture.Width = 50;
picture.Height = 50;
//Titulo Del Documento
string title = "Lista De Cargas Familiares";
//Formato del Titulo
Formatting titleFormat = new Formatting();
//Specify font family
titleFormat.FontFamily = new Xceed.Document.NET.Font("Arial Black");
//Specify font size y color del texto
titleFormat.Size = 14D;
titleFormat.Position = 40;
titleFormat.FontColor = System.Drawing.Color.Orange;
titleFormat.UnderlineColor = System.Drawing.Color.Gray;
titleFormat.Italic = true;
//combina el titulo con el formato definido
Xceed.Document.NET.Paragraph paragraphTitle = doc.InsertParagraph(title, false, titleFormat);
// alinea el titulo al centro
paragraphTitle.Alignment = Alignment.center;
//define las dimensiones de la tabla (tbl(f,c))
Table tbl = doc.AddTable(ListCargFam.Count + 1, 11);
//hace que la tabla este al centro de la pagina
tbl.Alignment = Alignment.center;
tbl.Design = TableDesign.ColorfulList;
tbl.AutoFit = AutoFit.Contents;
//agrega los titulos de la tabla
tbl.Rows[0].Cells[0].Paragraphs.First().Append("Rut").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[1].Paragraphs.First().Append("Nombre").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[2].Paragraphs.First().Append("Ap. Paterno").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[3].Paragraphs.First().Append("Fono Movil").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[4].Paragraphs.First().Append("Fecha Nacimiento").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[5].Paragraphs.First().Append("Sexo").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[6].Paragraphs.First().Append("Dirección").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[7].Paragraphs.First().Append("Comuna").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[8].Paragraphs.First().Append("Correo").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[9].Paragraphs.First().Append("Nombre Empleado").FontSize(8D).Alignment = Alignment.center;
tbl.Rows[0].Cells[10].Paragraphs.First().Append("Comentarios").FontSize(8D).Alignment = Alignment.center;
//llena las celdas con los datos
int fila = 1;
int columna = 0;
foreach (var item in ListCargFam)
{
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Rut_Carga)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Nombre)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Paterno)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Fono_Movil)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Fecha_Nacimiento)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Sexo)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Direccion)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Comuna)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Email)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Nombre_Empleado)).FontSize(8D).Alignment = Alignment.left;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Comentarios)).FontSize(8D).Alignment = Alignment.left;
fila++;
columna = 0;
}
//inserta la tabla dentro del documento
doc.InsertTable(tbl);
//Genera el Pie de Pagina del Documento
doc.AddFooters();
//Indica que que la primera página tendrá pies de página independientes
doc.DifferentFirstPage = true;
//Indica que que la página par e impar tendrá pies de página separados
doc.DifferentOddAndEvenPages = true;
Footer footer_main = doc.Footers.First;
Paragraph pFooter = footer_main.Paragraphs.First();
pFooter.Alignment = Alignment.center;
pFooter.Append("Página ").Bold();
pFooter.AppendPageNumber(PageNumberFormat.normal).Bold();
pFooter.Append("/").Bold();
pFooter.AppendPageCount(PageNumberFormat.normal).Bold();
//graba el documento
doc.Save();
//abre word y el documento
Process.Start("WINWORD", filename);
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
Logger.Error("Error On:", ex);
Response.StatusCode = 500;
Response.StatusDescription = ex.Message;
return(Json(Response));
}
}
public void CargFamXls()
{
try{
using (CargFam = new EmpleadosEntities())
{
var ListCargFam = CargFam.Sp_Mues_CargFam().ToList();
ExcelPackage excel = new ExcelPackage();
//agrega 1 hoja al libro y le da un nombre
excel.Workbook.Worksheets.Add("Lista_Cargas_familiares");
// crea la cabecera
var headerRow = new System.Collections.Generic.List <string[]>()
{
new string[] { "Rut", "Nombre", "Ap. Paterno", "Ap. Materno", "Fono Movil", "Fono Fijo",
"Fech. Nacimiento", "Sexo", "Dirección", "Villa", "Comuna", "Ciudad", "Correo",
"Nombre Empleado", "Comentarios" }
};
// Le da un Nombre a la Hoja
var worksheet = excel.Workbook.Worksheets["Lista_Cargas_familiares"];
// asigna el rango de despliegue de la cabecera
//string headerRange = "A1:" + Char.ConvertFromUtf32(headerRow[0].Length + 64) + "1";
string headerRange = "A2:O2";
// Agrega la Cabecera a la hoja de trabajo
worksheet.Cells[headerRange].LoadFromArrays(headerRow);
//le da estilo a la cabecera
worksheet.Cells[headerRange].Style.Font.Bold = true;
worksheet.Cells[headerRange].Style.Font.Size = 15;
worksheet.Cells[headerRange].Style.Font.Color.SetColor(System.Drawing.Color.Black);
worksheet.Cells[headerRange].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
int rowStart = 3; // fila (de inicio) en la que se empiezan a dejar los datos
// carga los datos a las filas y les da format
foreach (var item in ListCargFam)
{
worksheet.Cells[string.Format("A{0}", rowStart)].Value = item.Rut_Carga;
worksheet.Cells[string.Format("A{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("A{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("A{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("B{0}", rowStart)].Value = item.Nombre;
worksheet.Cells[string.Format("B{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("B{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("B{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("C{0}", rowStart)].Value = item.Paterno;
worksheet.Cells[string.Format("C{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("C{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("C{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("D{0}", rowStart)].Value = item.Materno;
worksheet.Cells[string.Format("D{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("D{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("D{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("E{0}", rowStart)].Value = item.Fono_Movil;
worksheet.Cells[string.Format("E{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("E{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("E{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("F{0}", rowStart)].Value = item.Fono_Fijo;
worksheet.Cells[string.Format("F{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("F{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("F{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("G{0}", rowStart)].Value = item.Fecha_Nacimiento;
worksheet.Cells[string.Format("G{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("G{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("G{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("H{0}", rowStart)].Value = item.Sexo;
worksheet.Cells[string.Format("H{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("H{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("H{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("I{0}", rowStart)].Value = item.Direccion;
worksheet.Cells[string.Format("I{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("I{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("I{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("J{0}", rowStart)].Value = item.Villa;
worksheet.Cells[string.Format("J{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("J{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("J{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("K{0}", rowStart)].Value = item.Comuna;
worksheet.Cells[string.Format("K{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("K{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("K{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("L{0}", rowStart)].Value = item.Ciudad;
worksheet.Cells[string.Format("L{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("L{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("L{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("M{0}", rowStart)].Value = item.Email;
worksheet.Cells[string.Format("M{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("M{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("M{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("N{0}", rowStart)].Value = item.Nombre_Empleado;
worksheet.Cells[string.Format("N{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("N{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("N{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
worksheet.Cells[string.Format("O{0}", rowStart)].Value = item.Comentarios;
worksheet.Cells[string.Format("O{0}", rowStart)].Style.Font.Size = 12;
worksheet.Cells[string.Format("O{0}", rowStart)].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[string.Format("O{0}", rowStart)].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
rowStart++;
}
// Auto Ajusta el tamaño de Las Columnas
worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();
// Graba la planilla
Response.Clear();
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=\"ListaCargFam.xlsx\"");
Response.BinaryWrite(excel.GetAsByteArray());
Response.End();
}
}
catch (Exception ex) {
Logger.Error("Error On:", ex);
Response.StatusCode = 500;
Response.StatusDescription = ex.Message;
//return Json(Response);
}
}
//Exportaciones
#region Crea_PDF
public ActionResult CargFamPDF()
{
try
{
using (CargFam = new EmpleadosEntities())
{
var ListCargFam = CargFam.Sp_Mues_CargFam().ToList();
MemoryStream ms = new MemoryStream();
iTextSharp.text.Document document = new iTextSharp.text.Document();
document.SetPageSize(PageSize.A4.Rotate());
document.SetMargins(14.2f, 14.2f, 29f, 31f);
PdfWriter pdf = PdfWriter.GetInstance(document, ms);
//hace la insercion del pie de pagina
pdf.PageEvent = new HeadFooter();
document.Open();
//insercion de imagenes
url = Server.MapPath("/Imagenes/bg.jpg");
iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(url);
image.ScaleToFit(140f, 120f);
image.Alignment = Element.ALIGN_LEFT;
document.Add(image);
// fin de insercion de imagenes
//fuente, tamaño y color de cabecera
BaseFont bf = BaseFont.CreateFont(BaseFont.HELVETICA_BOLD, BaseFont.CP1250, BaseFont.EMBEDDED);
iTextSharp.text.Font fontText2 = new iTextSharp.text.Font(bf, 10, 4, BaseColor.BLUE);
//creacion e insercion de titulos al documento
iTextSharp.text.Paragraph titulo = new iTextSharp.text.Paragraph(string.Format("Listado de Cargas Familiares"), fontText2);
//titulo.SpacingBefore = 200;
//titulo.SpacingAfter = 0;
titulo.Alignment = 1; //0-Left, 1 middle,2 Right
//inserta al documento
document.Add(titulo);
//inserta nueva linea al texto
document.Add(Chunk.NEWLINE);
//esto es para estilo de letra de la tabla
BaseFont bf2 = BaseFont.CreateFont(BaseFont.TIMES_BOLD, BaseFont.CP1250, BaseFont.EMBEDDED);
//tamaño y color
iTextSharp.text.Font fontText = new iTextSharp.text.Font(bf2, 8, 0, BaseColor.BLACK);
iTextSharp.text.Font fontText3 = new iTextSharp.text.Font(bf2, 8, 0, BaseColor.WHITE);
// instancia la tabla y le indica la cantidad de columnas
PdfPTable table = new PdfPTable(15);
//indica q ancho de la hoja va a ocupar la tabla
table.WidthPercentage = 95;
// instancia para la generacion de celdas en la tabla
PdfPCell _cell = new PdfPCell();
//genera la cabecera de la tabla
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Rut", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Nombre", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Ap. Paterno", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Ap. Materno", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Fono Movil", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Fono Fijo", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Fecha Nacimiento", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Sexo", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Dirección", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Villa", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Comuna", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Ciudad", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Correo", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Nombre Empleado", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Comentario", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
//llena la tabla y ademas le da la alineacion a los datos
foreach (var item in ListCargFam)
{
PdfPCell _cell2 = new PdfPCell();
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Rut_Carga, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Nombre, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Paterno, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Materno, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Fono_Movil, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Fono_Fijo, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Fecha_Nacimiento, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Sexo, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Direccion, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Villa, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Comuna, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Ciudad, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Email, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Nombre_Empleado, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Comentarios, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_LEFT;
table.AddCell(_cell2);
}
//agrega la tabla al documento
document.Add(table);
//cierra el documento
document.Close();
//vacia la memoria(documento) hacia memory stream
byte[] byteStream = ms.ToArray();
ms = new MemoryStream();
ms.Write(byteStream, 0, byteStream.Length);
ms.Position = 0;
//esto permite que el archivo pdf se muestre por pantalla en el explorador y a su vez sea guardado en el disco
return(File(ms, "application/pdf", "ListaCargFam.pdf"));
}
}
catch (Exception ex)
{
Logger.Error("Error On:", ex);
Response.StatusCode = 500;
Response.StatusDescription = ex.Message;
return(Json(Response));
}
}