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(); }
// 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 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 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 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 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")); }
/// <summary> /// Small Util function, that adds columns and plain formatting for /// the column values resulting in a huge performance gain /// </summary> /// <param name="data">The web grid data</param> /// <returns></returns> public static IHtmlString GridHtmlFromExpandoList(IEnumerable <ExpandoObject> data) { WebGrid grid = new WebGrid( source: data ); var cols = new List <WebGridColumn>(); if (data.Count() > 0) { IEnumerable <KeyValuePair <string, Object> > example = data.First(); foreach (var pair in example) { cols.Add(grid.Column( columnName: pair.Key, //Seems that specifying a formatter saves the web grid ridiculous amounts of time format: (item => ((IDictionary <String, Object>)item.Value)[pair.Key]) )); } } return(grid.GetHtml( tableStyle: "table", columns: cols )); }
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 ProductModel() { PageSize = 20; TotalCount = 4; Products = new List <Product>(); Columns = new List <string>() { "Id", "Email", "CSV" }; GridColumns = new WebGridColumn[Columns.Count]; Grid = new WebGrid(null, rowsPerPage: PageSize); for (int i = 0; i < Columns.Count; i++) { var col = Grid.Column(Columns[i], Columns[i]); GridColumns[Columns.Count - 1 - i] = col; } Grid.Bind(Products, autoSortAndPage: true, rowCount: PageSize); Grid.GetHtml(tableStyle: "table table-bordered", mode: WebGridPagerModes.All, firstText: "<< First", previousText: "< Prev", nextText: "Next >", lastText: "Last >>", columns: GridColumns); }
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; } }
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 <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 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 <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 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 <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 <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 <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 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 JsonResult GetNonradomizedStudies(string siteId) { var list = DbUtils.GetStudyIDsNotRandomized(int.Parse(siteId)); var grid = new WebGrid(list, defaultSort: "StudyID", rowsPerPage: 50); var htmlString = grid.GetHtml(); return(Json(new { Data = htmlString.ToHtmlString() }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Partial view used for lazy loading of web grid with no columns/formatting /// </summary> /// <param name="totalColumns">The columns for the grid</param> /// <param name="totalRows">The rows for the grid</param> /// <returns></returns> public PartialViewResult NoColumnsGrid(int totalColumns, int totalRows) { var data = generateData(totalColumns, totalRows); var noColumnsGrid = new WebGrid( source: data ); return(PartialView("BaseGrid", noColumnsGrid.GetHtml("table"))); }
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 static IHtmlString GetHtmlWithExtraHeader(this WebGrid webGrid, string tableStyle = null, string headerStyle = null, string footerStyle = null, string rowStyle = null, string alternatingRowStyle = null, string selectedRowStyle = null, string caption = null, bool displayHeader = true, bool fillEmptyRows = false, string emptyRowCellValue = null, IEnumerable <WebGridColumn> columns = null, IEnumerable <string> exclusions = null, WebGridPagerModes mode = WebGridPagerModes.All, string firstText = null, string previousText = null, string nextText = null, string lastText = null, int numericLinksCount = 5, object htmlAttributes = null, string checkBoxValue = "ID", IEnumerable <ExtraHeader> extraHeaders = null, bool displayInChinese = false, bool hideIdColumn = false, string hideColumnName = null) { StringBuilder sb = new StringBuilder(); if (extraHeaders != null) { var headerlevels = extraHeaders.Select(h => h.HeaderLevel).Distinct().OrderBy(h => h); sb.Append("<thead>"); foreach (var headerlevel in headerlevels) { sb.Append("<tr class='hr'>"); sb.Append("<th></th>"); //the first column is always the row name column. foreach (var header in extraHeaders.Where(h => h.HeaderLevel == headerlevel)) { sb.Append(header.HeaderColumnSpan > 0 ? "<th colspan='" + header.HeaderColumnSpan + "' " : "<th "); sb.Append(string.IsNullOrEmpty(header.HeaderStyle) ? string.Empty : "style = " + header.HeaderStyle); sb.Append(">"); sb.Append(header.HeaderText); sb.Append("</th>"); } sb.Append("</tr>"); } } var html = webGrid.GetHtml(tableStyle, headerStyle, footerStyle, rowStyle, alternatingRowStyle, selectedRowStyle, caption, displayHeader, fillEmptyRows, emptyRowCellValue, columns, exclusions, mode, firstText, previousText, nextText, lastText, numericLinksCount, htmlAttributes); string htmlToReplaceThead = html.ToString(); //string htmlAfterReplaceThead = htmlToReplaceThead.Replace("</thead>\r\n <tbody>\r\n", ""); //string htmlBeforeReplaceTh = htmlAfterReplaceThead.Replace("<th", "<td"); //string htmlAfterReplaceTh = htmlBeforeReplaceTh.Replace("</th>", "</td>"); if (!hideIdColumn) { return(MvcHtmlString.Create(htmlToReplaceThead.Replace("<thead>", sb.ToString())));// Replace thead with extra header } if (string.IsNullOrEmpty(hideColumnName)) { hideColumnName = "ID"; } string htmlToReplaceIdColumn = htmlToReplaceThead.Replace("<th scope=\"col\">\r\n" + hideColumnName + " </th>\r\n", ""); string stringToSelectFirstRow = htmlToReplaceIdColumn.Replace("<thead>", sb.ToString()); return(MvcHtmlString.Create(stringToSelectFirstRow.Replace("<tbody>\r\n <tr>", "<tbody>\r\n <tr class='SelectedRow'>")));// Replace thead with extra header }
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)); }
/// <summary> /// Get the HTML string for a given grid. (render) /// </summary> /// <param name="grid"></param> /// <param name="columns"></param> /// <param name="title">grid header</param> /// <param name="_htmlAttributes"></param> /// <param name="tableStyle"></param> /// <param name="headerStyle"></param> /// <param name="footerStyle"></param> /// <param name="alternatingRowStyle"></param> /// <param name="fillEmptyRows"></param> /// <param name="emptyRowsCellValue"></param> /// <param name="gridWrapperDivID">This identifies the area to fill after an ajax operation</param> /// <returns></returns> public static MvcHtmlString GetHtmlCustom(this WebGrid grid, WebGridColumn[] columns, string title = null, object _htmlAttributes = null, string tableStyle = "webgrid", string headerStyle = "webgrid-header", string footerStyle = "webgrid-header grid-footer", string alternatingRowStyle = "webgrid-alternating-rows", bool fillEmptyRows = false, string emptyRowsCellValue = null, string gridWrapperDivID = "grid", bool scrollable = false, //if you turn off paging, you probably want to make the grid scrollable instead WebGridPagerModes pagerMode = WebGridPagerModes.Numeric | WebGridPagerModes.NextPrevious, int pagerLinksCount = PAGER_LINKS) { TagBuilder wrapper = new TagBuilder("div"); wrapper.AddCssClass("webgrid-wrapper"); TagBuilder titleWrapper = new TagBuilder("div"); titleWrapper.AddCssClass("webgrid-title"); titleWrapper.SetInnerText(title); wrapper.InnerHtml += titleWrapper.ToString(); TagBuilder gridWrapper = new TagBuilder("div"); gridWrapper.Attributes.Add("id", gridWrapperDivID); //this is where ajax ops will rerender returned content //make the wrapper div scrollable if paging is turned off if (scrollable) { gridWrapper.AddCssClass("scrollable"); } gridWrapper.InnerHtml += grid.GetHtml( htmlAttributes: (_htmlAttributes ?? new { id = "webGrid" }), tableStyle: tableStyle, headerStyle: headerStyle, footerStyle: footerStyle, alternatingRowStyle: alternatingRowStyle, fillEmptyRows: fillEmptyRows, columns: columns, mode: pagerMode, numericLinksCount: pagerLinksCount).ToString(); wrapper.InnerHtml += gridWrapper.ToString(); return(MvcHtmlString.Create(wrapper.ToString())); }
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 JsonResult EfficientWebGridPaging(int?page) { var mostPopular = GetFavouriteGiveNames(); int skip = page.HasValue ? page.Value - 1 : 0; var data = mostPopular.OrderBy(o => o.Id).Skip(skip * 5).Take(5).ToList(); var grid = new WebGrid(data); var htmlString = grid.GetHtml(tableStyle: "webGrid", headerStyle: "header", alternatingRowStyle: "alt", htmlAttributes: new { id = "DataTable" }); return(Json(new { Data = htmlString.ToHtmlString(), Count = mostPopular.Count() / 5 }, JsonRequestBehavior.AllowGet)); }