public FileStreamResult GetFile() { List <Customer> list = new List <Customer>(); // collect data from database and store webgrid WebGrid grid = new WebGrid(source: db.Customers.ToList(), canPage: false, canSort: false); //serialige data to view formate. string gridhtml = grid.GetHtml( columns: grid.Columns( grid.Column("Id", "Id"), grid.Column("Name", "Name"), grid.Column("Address", "Address"), grid.Column("City", "City") ) ).ToString(); //add some style for pdf view string exportdata = string.Format("<html><head>{0}</head><body>{1}</body></html>", "<style>table{border-spacing:10px;border-collapse:separate;}</style>", gridhtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportdata); MemoryStream input = new MemoryStream(bytes); var output = new MemoryStream(); //declare page sige and page margin var document = new iTextSharp.text.Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xml = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xml.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(new FileStreamResult(output, "application/pdf")); }
public FileResult ExportData() { int userid = 0; userid = Convert.ToInt32(Session["UserID"]); List <TaskViewModel> allTasks = new List <TaskViewModel>(); allTasks = GetTask(userid); var grid = new WebGrid(source: allTasks, canPage: false, canSort: false); string exportData = grid.GetHtml( columns: grid.Columns( grid.Column("ContactID", "Contact ID"), grid.Column("FirstName", "First Name"), grid.Column("LastName", "Last Name"), grid.Column("ContactNo1", "Contact No1"), grid.Column("ContactNo2", "Contact No2"), grid.Column("EmailID", "Email ID") ) ).ToHtmlString(); return(File(new System.Text.UTF8Encoding().GetBytes(exportData), "application/vnd.ms-excel", "Tasks.xls")); }
public FileStreamResult ExportarPDF() { var autores = db.Autores.Include(a => a.Pais); WebGrid grid = new WebGrid(source: autores, canPage: false, canSort: false); string gridHtml = grid.GetHtml( columns: grid.Columns ( grid.Column("ID", header: "Codigo"), grid.Column("Apellido", header: "Apellido"), grid.Column("Nombre", header: "Nombre"), grid.Column("Nacionalidad", header: "CodPais"), grid.Column("Pais.Descripcion", header: "Pais"), grid.Column("FechaNacimiento", header: "Fecha Nacimiento", format: (item) => string.Format("{0:dd/MM/yyyy}", item.FechaNacimiento)) ) ).ToString(); string exportData = String.Format("<html><head>{0}</head><body>{1}</body></html>", "<p>Lista de Autores</p> <style>table{ border-spacing: 10px; border-collapse: separate; }</style>", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(new FileStreamResult(output, "application/pdf")); } }
public void GetExcel() { List <inseminacion> inseminacion = new List <inseminacion>(); List <inseminador> inseminador = new List <inseminador>(); List <animal> animal = new List <animal>(); List <procedencia_semen> procedencia_semen = new List <procedencia_semen>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { inseminacion = dc.inseminacion.ToList(); animal = dc.animal.ToList(); inseminador = dc.inseminador.ToList(); procedencia_semen = dc.procedencia_semen.ToList(); } WebGrid grid = new WebGrid(source: inseminacion, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("inseminador.nombre", "Inseminador"), grid.Column("animal.codigo_sag", "Animal"), grid.Column("procedencia_semen.nombre", "Procedencia S***n") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Inseminaciones.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel() { List <animal> animal = new List <animal>(); List <muerte> muerte = new List <muerte>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { muerte = dc.muerte.ToList(); animal = dc.animal.ToList(); } WebGrid grid = new WebGrid(source: muerte, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("causa", "Causa"), grid.Column("animal.codigo_sag", "Animal") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Muertes.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel() { List <venta> venta = new List <venta>(); List <animal> animal = new List <animal>(); List <comprador> comprador = new List <comprador>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { venta = dc.venta.ToList(); animal = dc.animal.ToList(); comprador = dc.comprador.ToList(); } WebGrid grid = new WebGrid(source: venta, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("pesaje", "Pesaje"), grid.Column("precio", "Precio"), grid.Column("animal.codigo_sag", "Animal"), grid.Column("comprador.nombre", "Comprador") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Ventas.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public FileStreamResult CreatePdf() //Export to PDF { List <UploadProduct> all = new List <UploadProduct>(); all = db.uploadproduct.ToList(); WebGrid grid = new WebGrid(source: all, canPage: false, canSort: false); string gridHtml = grid.GetHtml( columns: grid.Columns( grid.Column("ProductID", "ProductID"), grid.Column("ProductName", "ProductName"), grid.Column("ProductPrice", "ProductPrice"), grid.Column("SellingCategory", "SellingCategory") ) ).ToString(); string exportData = String.Format("{0}{1}", "", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(new FileStreamResult(output, "application/pdf")); } }
public void GetExcel() { List <alerta_mantencion> alerta_mantencion = new List <alerta_mantencion>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { alerta_mantencion = dc.alerta_mantencion.ToList(); } WebGrid grid = new WebGrid(source: alerta_mantencion, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("lecheria_id", "Lecheria") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=MantencionesLecheria.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void PrintWord() // Export to MS-Word { List <UploadProduct> exceldata = new List <UploadProduct>(); { exceldata = db.uploadproduct.ToList(); } //create object to webgrid WebGrid grid = new WebGrid(source: exceldata, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("ProductID", "ProductID"), grid.Column("ProductName", "ProductName"), grid.Column("ProductPrice", "ProductPrice"), grid.Column("SellingCategory", "SellingCategory") )).ToString(); Response.ClearContent(); //give name to excel sheet. Response.AddHeader("content-disposition", "attachment; filename=UserData.doc"); //specify content type Response.ContentType = "application/ms-word"; //write excel data using this method Response.Write(gridData); Response.End(); }
public override void Export() { WebGrid grid = new WebGrid(source: _list, canPage: false, canSort: false); string gridHtml = grid.GetHtml( columns: grid.Columns( grid.Column("Action", "Czynność"), grid.Column("Topic", "Temat"), grid.Column("Start", "Data rozpoczęcia"), grid.Column("End", "Data zakończenia"), grid.Column("ActualStatus", "Status"), grid.Column("ActualPriority", "Priorytet"), grid.Column("Progress", "%") ) ).ToString(); string exportData = String.Format("{0}{1}", "", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); Document document = new Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; _memory = output; } }
// GET: Inseminador public void GetExcel() { List <inseminador> inseminador = new List <inseminador>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { inseminador = dc.inseminador.ToList(); } WebGrid grid = new WebGrid(source: inseminador, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("nombre", "Nombre"), grid.Column("apellido", "Apellido"), grid.Column("numero", "Telefono") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Inseminadores.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel() { List <tratamiento> tratamiento = new List <tratamiento>(); List <tratador> tratador = new List <tratador>(); List <tipo_tratamiento> tipo_tratamiento = new List <tipo_tratamiento>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { tratamiento = dc.tratamiento.ToList(); tratador = dc.tratador.ToList(); tipo_tratamiento = dc.tipo_tratamiento.ToList(); } WebGrid grid = new WebGrid(source: tratamiento, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("tratador.nombre", "tratador"), grid.Column("tipo_tratamiento.nombre", "Tipo Tratamiento") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Tratamientos.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel() { List <medicamento> medicamento = new List <medicamento>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { medicamento = dc.medicamento.ToList(); } WebGrid grid = new WebGrid(source: medicamento, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("nombre", "Nombre"), grid.Column("descripcion", "Descripcion") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Medicamentos.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel() { List <Membrii> allCust = new List <Membrii>(); using (ArtClubContext dc = new ArtClubContext()) { allCust = dc.Membriis.ToList(); } WebGrid grid = new WebGrid(source: allCust, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("ID_Username", "Username"), grid.Column("Nume", "Nume"), grid.Column("Prenume", "Prenume"), grid.Column("Email", "Email"), grid.Column("Parola", "Parola"), grid.Column("ID_NumeFunctie", "NumeFunctie") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Membrii.xls"); Response.ContentType = "application/vnd.ms-excel"; //excel Response.Write(gridData); Response.End(); }
//public ActionResult BuscarFecha(DateTime Fecha_Ordena) //{ // var fecha = from s in db.ordena select s; // if (!DateTime(Fecha_Ordena)) //} public void GetExcel() { List <ordena> ordena = new List <ordena>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { ordena = dc.ordena.ToList(); } WebGrid grid = new WebGrid(source: ordena, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("litros", "Litros"), grid.Column("lecheria_id", "Lecheria"), grid.Column("jornada", "Jornada") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Ordeñas.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public FileStreamResult BaoCaoSanPham() { var sp = db.SanPhams.Where(s => s.BiXoa == 0).ToList <SanPham>(); WebGrid gird = new WebGrid(source: sp, canPage: false, canSort: false); string girdHtml = gird.GetHtml( columns: gird.Columns( gird.Column("MaSanPham", "STT"), gird.Column("TenSanPham", "Tên"), gird.Column("SoLuongTon", "SL") ) ).ToString(); string exportData = string.Format("<html><head><meta charset=" + "utf - 8" + "/>{0}</head><body>{1}</body></html>", "<style>table{border-spacing:10px; border-collapse:separate;}</style>", girdHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(new FileStreamResult(output, "application/pdf")); } }
public void GetExcel() { List <secamiento> secamiento = new List <secamiento>(); List <animal> animal = new List <animal>(); using (bdagricolaEntities dc = new bdagricolaEntities()) { secamiento = dc.secamiento.ToList(); animal = dc.animal.ToList(); } WebGrid grid = new WebGrid(source: secamiento, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("id", "ID"), grid.Column("fecha", "Fecha"), grid.Column("cantidad_ubres", "Tetas Secadas"), grid.Column("animal.codigo_sag", "Animal") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Secamientos.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel() { List <Agentii_Table> allCust = new List <Agentii_Table>(); using (Agentii2Entities25 dc = new Agentii2Entities25()) { allCust = dc.Agentii_Table.ToList(); } WebGrid grid = new WebGrid(source: allCust, canPage: false, canSort: false); string gridData = grid.GetHtml( columns: grid.Columns( grid.Column("Agentie", "Agentie"), grid.Column("Intrare", "Intrare"), grid.Column("Iesire", "Iesire"), grid.Column("Explicatii", "Expicatii"), grid.Column("Operator", "Operator"), grid.Column("DataOra", "Data_Ora"), grid.Column("Sold", "Sold"), grid.Column("UltimaOp", "UltimaOp"), grid.Column("Zile", "Zile") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Agentii.xls"); Response.ContentType = "application/vnd.ms-excel"; //excel Response.Write(gridData); Response.End(); }
public FileStreamResult CreatePdf() { //HINT: https://stackoverflow.com/questions/47651119/asp-net-mvc-exporting-webgrid-to-pdf List <Articulo> all = new List <Articulo>(); all = db.Articulos.ToList(); WebGrid grid = new WebGrid(source: all, canPage: false, canSort: false); string gridHtml = grid.GetHtml( columns: grid.Columns( grid.Column("Id", "Id"), grid.Column("NombreArticulo", "NombreArticulo"), grid.Column("DescArticulo", "DescArticulo"), grid.Column("PrecioArt", "PrecioArt"), grid.Column("UnidadesExistencia", "UnidadesExistencia") ) ).ToString(); string exportData = String.Format("{0}{1}", "", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(new FileStreamResult(output, "application/pdf")); } }
public void GetExcel(string solicitudId) { //traigo de la base de datos Solicitudes los registros var solicitudes = from s in db.Solicituds select s; //Valida que la variable no sea nula if (!String.IsNullOrEmpty(solicitudId)) { int solicitudIdTemp = int.Parse(solicitudId); solicitudes = solicitudes.Where(s => s.id.Equals(solicitudIdTemp)); } List <Solicitud> allCust = new List <Solicitud>(); allCust = solicitudes.ToList(); WebGrid grid = new WebGrid(source: allCust, canPage: false, canSort: false); List <WebGridColumn> gridColumns = new List <WebGridColumn>(); gridColumns.Add(grid.Column("folioSolicitud", "Folio de Solicitud")); gridColumns.Add(grid.Column("descripcion", "Proyecto")); gridColumns.Add(grid.Column("plazaId", "Residencia")); gridColumns.Add(grid.Column("fechaSolicitud", "Fecha Solicitud")); gridColumns.Add(grid.Column("esquemaId", "Esquema")); gridColumns.Add(grid.Column("sdiId", "SDI")); gridColumns.Add(grid.Column("contratoId", "Tipo de Contrato")); gridColumns.Add(grid.Column("tipoPersonalId", "Tipo de Personal")); gridColumns.Add(grid.Column("fechaInicial", "Fecha Inicial")); gridColumns.Add(grid.Column("fechaFinal", "Fecha Final")); gridColumns.Add(grid.Column("solicita", "Solicita")); gridColumns.Add(grid.Column("observaciones", "Observaciones")); gridColumns.Add(grid.Column("noTrabajadores", "N° Trabajadores")); gridColumns.Add(grid.Column("estatusSolicitud", "Estatus Solicitud")); gridColumns.Add(grid.Column("estatusNomina", "Estatus Nom.")); gridColumns.Add(grid.Column("estatusAfiliado", "Estatus Juri.")); gridColumns.Add(grid.Column("estatusJuridico", "Estatus Afil.")); gridColumns.Add(grid.Column("estatusTarjeta", "Estatus Tarj.")); string gridData = grid.GetHtml( columns: grid.Columns(gridColumns.ToArray()) ).ToString(); Response.ClearContent(); DateTime date = DateTime.Now; String fileName = "Solicitudes" + date.ToString("ddMMyyyyHHmm") + ".xls"; Response.AddHeader("content-disposition", "attachment; filename=" + fileName); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void GetExcel(String plazasId) { Usuario user = Session["UsuarioData"] as Usuario; var patronesAsignados = (from x in db.TopicosUsuarios where x.usuarioId.Equals(user.Id) && x.tipo.Equals("B") select x.topicoId); var patrones = from s in db.Patrones where patronesAsignados.Contains(s.Id) select s; if (!String.IsNullOrEmpty(plazasId)) { int plazaIdTemp = int.Parse(plazasId); patrones = patrones.Where(p => p.Plaza.id.Equals(plazaIdTemp)); } List <Patrone> allCust = new List <Patrone>(); allCust = patrones.ToList(); WebGrid grid = new WebGrid(source: allCust, canPage: false, canSort: false); List <WebGridColumn> gridColumns = new List <WebGridColumn>(); gridColumns.Add(grid.Column("registro", "Registro Patronal ")); gridColumns.Add(grid.Column("Plaza.cveCorta", "ID Plaza")); gridColumns.Add(grid.Column("rfc", "RFC")); gridColumns.Add(grid.Column("nombre", "Nombre")); gridColumns.Add(grid.Column("telefono", "Teléfono")); gridColumns.Add(grid.Column("domicilio", "Domicilio")); gridColumns.Add(grid.Column("zona", "Zona")); gridColumns.Add(grid.Column("inicioAfiliacion", "Ini.Afiliación")); gridColumns.Add(grid.Column("STyPS", "STyPS")); gridColumns.Add(grid.Column("carEnt", "Entidad")); gridColumns.Add(grid.Column("carDel", "Delegación")); gridColumns.Add(grid.Column("codigoPostal", "C. P.")); gridColumns.Add(grid.Column("direccionArchivo", "Carpeta")); string gridData = grid.GetHtml( columns: grid.Columns(gridColumns.ToArray()) ).ToString(); Response.ClearContent(); DateTime date = DateTime.Now; String fileName = "Patrones-" + date.ToString("ddMMyyyyHHmm") + ".xls"; Response.AddHeader("content-disposition", "attachment; filename=" + fileName); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public JsonResult GetSiteRandomizedStudies(string siteID) { var list = DbUtils.GetSiteRandomizedStudies(int.Parse(siteID)); var grid = new WebGrid(list, defaultSort: "Number", rowsPerPage: 50); var htmlString = grid.GetHtml(tableStyle: "webgrid", columns: grid.Columns( grid.Column("SiteName", header: "Site"), grid.Column("Number"), grid.Column("StudyID", header: "Study ID"), grid.Column("Arm"), grid.Column("DateRandomized", header: "Date Randomized", format: x => x.DateRandomized.ToString("MM/dd/yyyy hh:mm tt")))); return(Json(new { Data = htmlString.ToHtmlString(), Count = list.Count }, JsonRequestBehavior.AllowGet)); }
public FileResult Export(string GridHtml) { try { List <Employee> all = new List <Employee>(); using (var databaseContext = new MachineTest.EmployeeEntities1()) { var user = (databaseContext.Employees.FirstOrDefault()); // if (!string.IsNullOrEmpty(Convert.ToString(Session["UserID"])) && !string.IsNullOrEmpty(Convert.ToString(Session["Password"]))) //{ all = databaseContext.Employees.ToList(); //} } WebGrid webGrid1 = new WebGrid(source: all, canPage: false, canSort: false); string gridHtml = webGrid1.GetHtml( columns: webGrid1.Columns( webGrid1.Column("Name", "Name"), webGrid1.Column("BirthDate", "BirthDate"), webGrid1.Column("Qualification", "Qualification"), webGrid1.Column("Experience", "Experience"), webGrid1.Column("JoinningDate", "JoinningDate"), webGrid1.Column("Salary", "Salary"), webGrid1.Column("Designation", "Designation"), webGrid1.Column("Hobbies", "Hobbies") ) ).ToString(); string exportData = String.Format("<html><head>{0}</head><body>{1}</body></html>", "<style>table{ border-spacing: 1px; border-collapse: separate;border - collapse: collapse, border: 1px solid #ccc; }" + "th{backgroung-color:#BBDBFD;border:1px solid #ccc; border-width:1px}td{padding:8px;border-style:solid;border-color:#666666;background-color:#fffff;border:1px solid #ccc; border-width:1px}</style>", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.A4_LANDSCAPE, 10, 10, 100, 0); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(File(output, "application/pdf", "Grid.pdf")); } } catch (Exception ex) { } return(File("", "application/pdf", "Grid.pdf")); }
public static string ExportData(List <ContactModel> contactList) { var grid = new WebGrid(source: contactList, canPage: false, canSort: false); string exportData = @grid.GetHtml( columns: grid.Columns( grid.Column("FirstName", header: "First Name"), grid.Column("LastName", header: "Last Name"), grid.Column("EmailAddress", header: "Email Id"), grid.Column("Contact1", header: "Contact No.1"), grid.Column("Contact2", header: "Contact No.2"), grid.Column("Country", header: "Country"), grid.Column("State", header: "State") ) ).ToHtmlString(); return(exportData); }
// // GET: /UserInfo/Search/date public FileStreamResult Pdf() { List <CharmanderLaMeraPija> all = new List <CharmanderLaMeraPija>(); using (ReportSupEntities1 dc = new ReportSupEntities1()) { all = (from e in dc.sp_dateRange((string)(Session["inicio"]), (string)(Session["fin"]), (string)(Session["selectDept"])) select new CharmanderLaMeraPija { Nombre = e.Name, Horas = e.horaTrabajada, FechaEntrada = e.horaEntrada, FechaSalida = e.horasalida }).ToList(); } WebGrid grid = new WebGrid(source: all, canPage: false, canSort: false); string gridHtml = grid.GetHtml( columns: grid.Columns( grid.Column("Nombre", "Nombre"), grid.Column("FechaEntrada", "Fecha de Entrada "), grid.Column("FechaSalida", "Fecha de Salida "), grid.Column("Horas", "Horas Trabajadas") ) ).ToString(); string exportData = String.Format("<html><head>{0}</head><body><div><span>Reporte</span></div>{1}</body></html>", "<style>table{ border-spacing: 10px; border-collapse: separate; }</style>", gridHtml); var bytes = System.Text.Encoding.UTF8.GetBytes(exportData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); var document = new iTextSharp.text.Document(PageSize.LETTER, 150, 150, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; // string path = this.Server.MapPath(".") + "Libraries\\Documents\\doc.pdf"; // return new FileStreamResult(output, "C:\application.pdf"); return(new FileStreamResult(output, "aplication/pdf") { FileDownloadName = "Reporte" + Session["selecdate"].ToString() + ".pdf" }); } }
public void FixAssetReport(vwFixAssetList fixAsset) { ReportsProcess reportsProcess = new ReportsProcess(); List <vwFixAssetList> AssetLists = new List <vwFixAssetList>(); AssetLists = reportsProcess.GetFixAssetListByClassTypeStatus(fixAsset); WebGrid grid = new WebGrid(source: AssetLists, canPage: false, canSort: false); string gridHtml = grid.GetHtml( // tableStyle: "table table-striped table-hover", //mode: WebGridPagerModes.All, //firstText: "First", //previousText: "Prev", //nextText: "Next", //lastText: "Last", //htmlAttributes: new //{ // id = "grid" //}, columns: grid.Columns( grid.Column("FixAssetID", "Fix Asset ID"), grid.Column("Model", "Model"), grid.Column("SerialNumber", "Serial #"), grid.Column("AssetTag", "Asset Tag"), grid.Column("Brand", "Brand"), grid.Column("Remarks", "Remarks"), grid.Column("AcquisitionDate", "Acquisition Date"), grid.Column("ExpiryDate", "Expiry Date"), grid.Column("IssuerName", "Issuer Name"), grid.Column("IssuerType", "Issuer Type"), grid.Column("LocationName", "Location"), grid.Column("Country", "Country"), grid.Column("TypeDescription", "Type"), grid.Column("ClassDescription", "Class"), grid.Column("StatusDescription", "Asset Status") ) ).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=ListOfAssets.xls"); Response.ContentType = "application/xls"; Response.Write(gridHtml); Response.End(); }
/// <summary> /// generate webgrid columns. sensitive columns will be hidden if the user's access is readonly. /// </summary> /// <param name="htmlHelper">this is an extension emthod for any htmlHelper</param> /// <param name="grid">WebGrid</param> /// <param name="openColumns">Columns always shown. Columns will be ordered by the index in dictionary.</param> /// <param name="sensitiveColumns">Columns shown if user is allowed to edit/delete/etc. Columns will be ordered by the index in dictionary.</param> /// <returns></returns> public static WebGridColumn[] GridColumnsCustom( this WebGrid grid, Dictionary <int, WebGridColumn> openColumns, Dictionary <int, WebGridColumn> sensitiveColumns = null //Func<object, bool> additionalValidation = null ) { Session appSession = new Session(); if (appSession != null && appSession.User != null && sensitiveColumns != null) //TODO: Setup security check for rendering sensitive columns { foreach (KeyValuePair <int, WebGridColumn> pair in sensitiveColumns) { openColumns.Add(pair.Key, pair.Value); } //sensitiveColumns.ElementAt(n).Key, sensitiveColumns.ElementAt(n).Value); } return(grid.Columns(openColumns.OrderBy(item => item.Key).Select(item => item.Value).ToArray())); }
public FileResult ExportData() { List <ContactModel> allContacts = new List <ContactModel>(); using (MyAddressBookEntities dc = new MyAddressBookEntities()) { var v = (from a in dc.Contacts join b in dc.Countries on a.CountryID equals b.CountryID join c in dc.States on a.StateID equals c.StateID select new ContactModel { ContactID = a.ContactID, FirstName = a.ContactPersonFname, LastName = a.ContactPersonLname, ContactNo1 = a.ContactNo1, ContactNo2 = a.ContactNo2, EmailID = a.EmailID, Country = b.CountryName, State = c.StateName, Address = a.Address, ImagePath = a.ImagePath }).ToList(); allContacts = v; } var grid = new WebGrid(source: allContacts, canPage: false, canSort: false); string exportData = grid.GetHtml( tableStyle: "table table-responsive", columns: grid.Columns( grid.Column("ContactID", "Contact ID"), grid.Column("FirstName", "First Name"), grid.Column("LastName", "Last Name"), grid.Column("ContactNo1", "Contact No1"), grid.Column("ContactNo2", "Contact No2"), grid.Column("EmailID", "Email ID") ) ).ToHtmlString(); return(File(new System.Text.UTF8Encoding().GetBytes(exportData), "application/vnd.ms-excel", "Contacts.xls")); }
public FileStreamResult ExportaPDF() { var autores = db.Autores.ToList(); //Creamos un WebGrid WebGrid grid = new WebGrid(source: autores, canPage: false, canSort: false); string gridHTML = grid.GetHtml( columns: grid.Columns ( grid.Column("ID", header: "Codigo"), grid.Column("Apellido", header: "Apellido"), grid.Column("Nombre", header: "Nombre"), grid.Column("IdPais", header: "Cod.Pais"), grid.Column("Pais.Nombre", header: "Pais") ) ).ToString(); //-------------------- string exportaData = string.Format("<html><head>{0}</head><body>{1}</body></html>", "<p>Lista de Autores</p> <style>table{ borde-spacing:10px; border-collapse:separate;}</style>", gridHTML); var bytes = System.Text.Encoding.UTF8.GetBytes(exportaData); using (var input = new MemoryStream(bytes)) { var output = new MemoryStream(); //Setiamos el tamalo y margenes var document = new iTextSharp.text.Document(PageSize.A4, 50, 50, 50, 50); var writer = PdfWriter.GetInstance(document, output); writer.CloseStream = false; document.Open(); var xmlWorker = iTextSharp.tool.xml.XMLWorkerHelper.GetInstance(); xmlWorker.ParseXHtml(writer, document, input, System.Text.Encoding.UTF8); document.Close(); output.Position = 0; return(new FileStreamResult(output, "application/pdf")); } }
public JsonResult Events(int?page, string sort, string sortdir, string name) { XDocument xdoc4 = new XDocument(); DownLoadMethod dmArtisitEvents = new DownLoadMethod(); try { xdoc4 = dmArtisitEvents.GetData(MethodArtist.GetEvents(name)); XmlProcessing.Process("GetEvents", xdoc4, ca); } catch (Exception) { ca = new ClassArtist(); } var grid = new WebGrid(ca.Events, rowsPerPage: 5, selectionFieldName: "selectedRow"); IHtmlString html = grid.GetHtml(tableStyle: "webGrid", headerStyle: "header", alternatingRowStyle: "alt", selectedRowStyle: "webgrid-selected-row", columns: grid.Columns( grid.Column("StartDate", "Date"), grid.Column("Title", header: null, format: (item) => item.GetSelectLink(item.Title)), grid.Column("Venue", "Venue", format: (item) => item.Venue.Name), grid.Column("Address", "Address", format: (item) => item.Venue.Location.Country + ", " + item.Venue.Location.City + ", " + item.Venue.Location.Street) ), htmlAttributes: new { id = "EventsTable" }); //get selected row value ClassGeoPoint point = null; if (grid.SelectedRow != null) { point = Methods.GetGeopointFromEvent(ca.Events, grid.SelectedRow.Value.Id); } return(Json(new { Data = html.ToHtmlString(), GeoPoint = point }, JsonRequestBehavior.AllowGet)); }