public FileResult GetCsv()
{
using (var ManEmp = new EmpleadosEntities())
{
var ListEmp = ManEmp.Sp_Mues_Empresas().ToList();
List <object> customers = (from customer in ListEmp
select new[] { customer.Rut_Empresa, customer.Nombre_Empresa,
customer.Calle_Pje_Avda, customer.Numero,
customer.Vill_Pobl, customer.Comuna,
customer.Provincia_Nombre, customer.fono,
customer.emailemp }).ToList <object>();
//Insert the Column Names.
customers.Insert(0, new string[9] {
"Rut", "Nombre", "Dirección", "Número", "Villa", "Comuna", "Ciudad", "Fono", "Email"
});
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", "ListaEmpresas.csv"));
}
}
public ActionResult Index()
{
using (ManEmp = new EmpleadosEntities())
{
try
{
var ListEmp = ManEmp.Sp_Mues_Empresas().ToList();
var ListCom = Comun.Sp_Mues_Comunas().ToList();
ViewBag.ListComu = new SelectList(ListCom, "Comuna_Id", "Comuna");
return(View(ListEmp));
}catch (Exception ex) {
Logger.Error("Error On:", ex);
Response.StatusCode = 500;
Response.StatusDescription = ex.Message;
return(Json(Response));
}
}
}
public ActionResult GetDocx()
{
try
{
using (var ManEmp = new EmpleadosEntities())
{
var ListEmp = ManEmp.Sp_Mues_Empresas().ToList();
//Ubicacion de Archivo
string filename = @"C:\Users\Rodrigo_Menares\Downloads\ListaEmpresas.docx";
var doc = DocX.Create(filename);
//cambia la orientación 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 Empresas";
//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 que muestra los datos(filas, columna)
Xceed.Document.NET.Table tbl = doc.AddTable(ListEmp.Count + 1, 9);
//hace que la tabla este al centro de la pagina
tbl.Alignment = Alignment.center;
tbl.Design = TableDesign.ColorfulList;
//agrega los titulos de la tabla
tbl.Rows[0].Cells[0].Paragraphs.First().Append("Rut").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[1].Paragraphs.First().Append("Nombre").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[2].Paragraphs.First().Append("Dirección").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[3].Paragraphs.First().Append("Número").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[4].Paragraphs.First().Append("Villa").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[5].Paragraphs.First().Append("Comuna").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[6].Paragraphs.First().Append("Ciudad").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[7].Paragraphs.First().Append("Fono").FontSize(12D).Alignment = Alignment.center;
tbl.Rows[0].Cells[8].Paragraphs.First().Append("Email").FontSize(12D).Alignment = Alignment.center;
//llena las celdas con los datos
int fila = 1;
int columna = 0;
foreach (var item in ListEmp)
{
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Rut_Empresa)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Nombre_Empresa)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Calle_Pje_Avda)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Numero)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Vill_Pobl)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Comuna)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.Provincia_Nombre)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.fono)).FontSize(10D).Alignment = Alignment.center;
columna++;
tbl.Rows[fila].Cells[columna].Paragraphs.First().Append(Convert.ToString(item.emailemp)).FontSize(10D).Alignment = Alignment.center;
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 GetXls()
{
try
{
using (var ManEmp = new EmpleadosEntities())
{
var ListEmp = ManEmp.Sp_Mues_Empresas().ToList();
ExcelPackage excel = new ExcelPackage();
//agrega 1 hoja al libro y le da un nombre
excel.Workbook.Worksheets.Add("Lista_Empresas");
// crea la cabecera
var headerRow = new System.Collections.Generic.List <string[]>()
{
new string[] { "Rut", "Nombre", "Dirección", "Número", "Villa", "Comuna", "Ciudad", "Fono", "Email" }
};
// Le da un Nombre a la Hoja
var worksheet = excel.Workbook.Worksheets["Lista_Empresas"];
// asigna el rango de despliegue de la cabecera
//string headerRange = "A1:" + Char.ConvertFromUtf32(headerRow[0].Length + 64) + "1";
string headerRange = "A2:I2";
// 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 = 14;
worksheet.Cells[headerRange].Style.Font.Color.SetColor(System.Drawing.Color.Blue);
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 ListEmp)
{
worksheet.Cells[string.Format("A{0}", rowStart)].Value = item.Rut_Empresa;
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_Empresa;
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.Calle_Pje_Avda;
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.Numero;
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.Vill_Pobl;
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.Comuna;
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.Provincia_Nombre;
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.fono;
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.emailemp;
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);
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=\"ListaEmpresas.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 GetPdf()
{
try
{
using (var ManEmp = new EmpleadosEntities())
{
var ListEmp = ManEmp.Sp_Mues_Empresas().ToList();
MemoryStream ms = new MemoryStream();
iTextSharp.text.Document document = new iTextSharp.text.Document();
document.SetPageSize(PageSize.A4.Rotate());
document.SetMargins(50, 50, 50, 50);
PdfWriter pdf = PdfWriter.GetInstance(document, ms);
//agrega el autor del documento
document.AddAuthor("Rodrigo Menares Guzman");
// document.AddTitle("Listado_de_Cargos");
//hace la insercion del pie de pagina
pdf.PageEvent = new HeadFooter();
document.Open();
//insercion de imagenes
string 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, 12, 4, BaseColor.BLUE);
//creacion e insercion de titulos al documento
iTextSharp.text.Paragraph titulo = new iTextSharp.text.Paragraph(string.Format("Listado de Empresas"), fontText2);
titulo.Alignment = 1; //0-Left, 1 middle,2 Right
//inserta al documento
document.Add(titulo);
//inserta nueva linea al texto
document.Add(iTextSharp.text.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, 10, 0, BaseColor.WHITE);
// instancia la tabla y le indica la cantidad de columnas
PdfPTable table = new PdfPTable(9);
//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 Empresa", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Nombre Empresa", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Calle", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Numero", 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("Telefono", fontText3));
_cell.BackgroundColor = iTextSharp.text.BaseColor.DARK_GRAY;
_cell.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell);
_cell = new PdfPCell(new iTextSharp.text.Paragraph("Email", 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 ListEmp)
{
PdfPCell _cell2 = new PdfPCell();
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Rut_Empresa.ToString(), fontText));
_cell2.HorizontalAlignment = Element.ALIGN_RIGHT;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Nombre_Empresa, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Calle_Pje_Avda, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Numero, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Vill_Pobl, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Comuna, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.Provincia_Nombre, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.fono, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(_cell2);
_cell2 = new PdfPCell(new iTextSharp.text.Paragraph(item.emailemp, fontText));
_cell2.HorizontalAlignment = Element.ALIGN_CENTER;
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", "Empresas.pdf"));
}
}catch (Exception ex) {
Logger.Error("Error On:", ex);
Response.StatusCode = 500;
Response.StatusDescription = ex.Message;
return(Json(Response));
}
}