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));
}