public ActionResult GetWitness(Loan data) { List <Witness> ret = new List <Witness>(); ret = WitnessControllerSql.GetAll(data.LoanId); return(Json(new { data = ret }, JsonRequestBehavior.AllowGet)); }
public ActionResult Download() { int id = Convert.ToInt32(Session["MemberId"]); LocalReport localreport = new LocalReport(); localreport.ReportPath = Server.MapPath("~/Views/Report/Loan.rdlc"); ReportDataSource rd1 = new ReportDataSource(); ReportDataSource rd2 = new ReportDataSource(); ReportDataSource rd = new ReportDataSource(); List <LoanReport> data = new List <LoanReport>(); data = LoanReportControllerSql.GetAll(id); rd.Name = "LoanReportt"; rd.Value = data.ToList(); List <Comaker> data1 = new List <Comaker>(); data1 = ComakerControllerSql.GetCo(data[0].Id.ToString()); localreport.DataSources.Add(rd); rd1.Name = "ComakerReportt"; rd1.Value = data1.ToList(); List <Witness> data2 = new List <Witness>(); data2 = WitnessControllerSql.GetAll(data[0].Id.ToString()); localreport.DataSources.Add(rd1); rd2.Name = "WitnessReportt"; rd2.Value = data2.ToList(); localreport.DataSources.Add(rd2); string reportType = "PDF"; string mimetype; string encoding; string filenameExtension = "pdf"; string[] streams; Warning[] warnings; byte[] renderbyte; string deviceInfo = "<DeviceInfo><OutputFormat>PDF</OutputFormat><PageWidth>8.5in</PageWidth><PageHeight>11in</PageHeight><MarginTop>0.5in</MarginTop><MarginLeft>11in</MarginLeft><MarginRight>11in</MarginRight><MarginBottom>0.5in</MarginBottom></DeviceInfo>"; renderbyte = localreport.Render(reportType, deviceInfo, out mimetype, out encoding, out filenameExtension, out streams, out warnings); Response.AddHeader("content-disposition", "attachment;filename=LoanInfo." + filenameExtension); return(File(renderbyte, filenameExtension)); }