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