public ActionResult SubmitForm(PaymentPostingViewModel formData) { PaymentPostingService service = new PaymentPostingService(); //service.ExportReport(formData); service.ExportReport(formData); return(null); }
public void ExportReport(PaymentPostingViewModel formData) { try { using (TransactionScope scope = new TransactionScope()) { //using (var context = new MIS_PAYMENTEntities()) //{ // var postingDB = context.PAYMENT_POSTING_MONTH.ToList(); //} } #region GetReportData DataTable getDataReport = new DataTable(); ReportDocument rd = new ReportDocument(); rd.Load(Path.Combine(HttpContext.Current.Server.MapPath("~/Reports/CAEvaluation/CALevelComparison"), "CALevelComparisonReport.rpt")); getDataReport = null;//ReportService.ConvertListToDatatable(null); getDataReport.TableName = "CALevelComparison"; rd.SetDataSource(getDataReport); rd.SetParameterValue("getFormPeriodName", ""); #endregion #region Export EXCEL //Encoding FileName //periodName = Uri.EscapeDataString(Path.GetFileNameWithoutExtension("")).Replace("%20", " ") + Path.GetExtension(periodName); ReportService.ExportExcel(rd, ""); #endregion } catch (Exception ex) { throw ex; } }