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