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 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 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 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 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 <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(); }
// 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 <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 <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 <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 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() { 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 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 <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 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 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); }
/// <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 )); }
// // 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 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 static WebGridColumn[] StationGridColumns(this HtmlHelper htmlHelper, WebGrid grid) { System.Security.Principal.IPrincipal user = htmlHelper.ViewContext.HttpContext.User; var columns = new List <WebGridColumn>(); columns.Add(grid.Column(columnName: "StationName")); columns.Add(grid.Column( header: "Watches", format: item => htmlHelper.ActionLink(linkText: "Watches", actionName: "/Watch/Index/", routeValues: new { id = item.StationId }), style: "column-action" )); if (user.IsInRole(role: "OPCS")) { columns.Add(grid.Column(header: "", format: (item) => htmlHelper.ActionLink(linkText: "Edit", actionName: "Edit", routeValues: new { id = item.StationId }), style: "column-action")); columns.Add(grid.Column(header: "", format: (item) => htmlHelper.ActionLink(linkText: "Delete", actionName: "Delete", routeValues: new { id = item.StationId }, htmlAttributes: new { oneclick = "return confirm('Are you sure that you want to delete " + item.StationName + "?');" }), style: "column-action")); } return(columns.ToArray()); }
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)); }
public void DownloadExcelAccountStatement() { CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData(); List <AccountSearch> list = obj.viewAccountStatement(Convert.ToInt32(Session["id"]), Convert.ToInt32(Session["Cycle"])); WebGrid grid = new WebGrid(source: list); string gridData = grid.GetHtml(columns: grid.Columns( grid.Column("TransactionID", "Transaction ID"), grid.Column("TransactionDescription", "Description"), grid.Column("TransactionDate", "Date(mm-dd-yyyy)"), grid.Column("TransactionAmount", "Amount(INR)") )).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=AccountStatementexcel.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public static WebGridColumn ColumnaEliminarModificar(this WebGrid grid, HtmlHelper html, string controller, string style = "") { return(grid.Column("EliminarModificar", "", f => html.Raw( "<span>" + html.BotonLink(Textos.Modificar, "Modificar", controller, new { f.id }, style + " ajax-editar-link", "glyphicon-edit", true).ToHtmlString() + html.BotonLink(Textos.Eliminar, "Eliminar", controller, new { f.id }, style + " ajax-borrar-link", "glyphicon-trash", true).ToHtmlString() + "</span>" ) , "editar-borrar-columna", false)); }
public void ExportData() { var lstFeedBack = db.FeedBacks.ToList(); WebGrid webGrid = new WebGrid(lstFeedBack, canPage: true, rowsPerPage: 10); string gridData = webGrid.GetHtml( columns: webGrid.Columns( webGrid.Column(columnName: "name", header: "Name"), webGrid.Column(columnName: "Email", header: "Email"), webGrid.Column(columnName: "Content", header: "Content"), webGrid.Column(columnName: "PhoneNumber", header: "PhoneNumber"), webGrid.Column(columnName: "Creared", header: "Creared") )).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=FeedBack-Details.xls"); Response.ContentType = "applicatiom/excel"; Response.Write(gridData); Response.End(); }
public JsonResult ClientGridAjaxPaging(DynamicFormSearchViewModel viewModel) { var currentUser = (User)Session["CurrentUser"]; CYCADynamicFormModel model = new CYCADynamicFormModel(); var listOfDynamicItems = model.GetDynamicFormDatasForClient(viewModel.DynamicFormId, viewModel.ChildId); var query = from p in listOfDynamicItems select p; var filteredResults = query.ToList(); var child = model.GetChild(viewModel.ChildId); var clientItems = filteredResults.Select(x => new DynamicFormGridMain() { ChildId = x.Client_Id, ChildName = child.First_Name + " " + child.Last_Name, CreateDate = x.CreatedDate, DynamicFormDataId = x.Dynamic_Form_Data_Id, UserId = currentUser.User_Id, UserName = currentUser.fullname }).ToList(); var data = clientItems.OrderBy(o => o.CreateDate).ToList(); var grid = new WebGrid(data, canPage: true, rowsPerPage: 20, canSort: false); var htmlString = grid.GetHtml(tableStyle: "NestedMainGrid", headerStyle: "webgrid-header", alternatingRowStyle: "webgrid-alternating-row", selectedRowStyle: "webgrid-selected-row", rowStyle: "webgrid-row-style", htmlAttributes: new { id = "clientsListGrid" }, mode: WebGridPagerModes.NextPrevious, columns: grid.Columns( grid.Column("UserName", "Performed By"), grid.Column("Date", "CreateDate")) ); return(Json(new { Data = htmlString.ToHtmlString(), Count = clientItems.Count(), Page = 1 }, JsonRequestBehavior.AllowGet)); }
public void DownloadExcel() { DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager(); List <Customer> clist = obj.ViewAllCustomer(); WebGrid grid = new WebGrid(source: clist); string gridData = grid.GetHtml(columns: grid.Columns( grid.Column("Customer_Id", "Customer ID"), grid.Column("Customer_ssn_Id", "Customer SSN ID"), grid.Column("customer_status", "Status"), grid.Column("customer_message", "Message"), grid.Column("update_date", "Last updated") )).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment;filename=customerexcel.xls"); Response.ContentType = "application/excel"; Response.Write(gridData); Response.End(); }
public void ExportarExcel() { ViewBag.ListaTramites = Session["ListaTramites"]; var datasource = ViewBag.ListaTramites; WebGrid grid = new WebGrid(source: datasource, canPage: false, canSort: false); string GridData = grid.GetHtml( columns: new[] { grid.Column("T_NombreProyecto", "Nombre proyecto"), grid.Column("T_NombreTramite", "Nombre tramite"), grid.Column("T_Estatus"), grid.Column("T_FechaInicio", "Fecha de registro") }).ToString(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=Report.xls"); Response.ContentType = "application/ms-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 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(); }