public ActionResult SubmitForm(PaymentPostingViewModel formData)
        {
            PaymentPostingService service = new PaymentPostingService();

            //service.ExportReport(formData);

            service.ExportReport(formData);
            return(null);
        }
示例#2
0
        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;
            }
        }