using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Data.Entity; using System.Data; using Microsoft.Reporting.WebForms; using System.IO; using ForumMVC; using ForumMVC.Models; using System.ComponentModel; namespace ForumMVC.Controllers { public class HomeController : Controller { forumEntities1 db = new forumEntities1(); public ActionResult Index() {
return View(); }
public ActionResult PrintPDF() { LocalReport localReport = new LocalReport(); localReport.ReportPath = Server.MapPath("~/Graph.rdlc"); ReportDataSource reportDataSource = new ReportDataSource(); reportDataSource.Name = "DataSet1"; DataSet ds = new DataSet(); DataTable dt = new DataTable();
var Result = from c in db.CUSTOMER join o in db.ORDER on c.CUST_ID equals o.CUST_ID join p in db.PRODUCT on o.PRODUCT_ID equals p.PRODUCT_ID select new { Id = c.CUST_ID, Name = c.CUST_NAME, Date = o.ORD_DATE, Product = p.PRODUCT_NAME, Price = p.PRICE }; dt = ConvertToDataTable(Result.ToList()); ds.Tables.Add(dt); reportDataSource.Value = ds.Tables[0]; localReport.DataSources.Add(reportDataSource); string reportType = "PDF"; string mimeType; string encoding; string fileNameExtension;
Anonymous User
15-Feb-2016