private void RenderReportModels(ReportData reportData) { HRMSData hraDal = new HRMSData(); try { ReportViewerHRAReports.Height = Unit.Parse("100%"); ReportViewerHRAReports.Width = Unit.Parse("100%"); ReportViewerHRAReports.CssClass = "table"; this.ReportViewerHRAReports.LocalReport.DataSources.Clear(); ReportViewerHRAReports.ProcessingMode = ProcessingMode.Local; var rptPath = Server.MapPath(@"./Report/" + reportData.ReportName + ".rdlc"); //reportData.ReportName if (!File.Exists(rptPath)) { return; } this.ReportViewerHRAReports.LocalReport.ReportPath = rptPath; var rpPms = ReportViewerHRAReports.LocalReport.GetParameters(); if (reportData.ReportName == "BankAdviceForSalary" || reportData.ReportName == "BankAdviceForSalaryWithBonus" || reportData.ReportName == "BankAdviceForBonus") { string forMonth = string.Empty, reportType = string.Empty, generateType = string.Empty; string locationCode = string.Empty, bankAccount = string.Empty; forMonth = this.ReportDataObj.DataParameters[0].Value; reportType = this.ReportDataObj.DataParameters[1].Value; generateType = this.ReportDataObj.DataParameters[2].Value; locationCode = this.ReportDataObj.DataParameters[3].Value; bankAccount = this.ReportDataObj.DataParameters[4].Value; List <BankAdviceForSalaryReport> lstBankAdviceForSalaryReport = new List <BankAdviceForSalaryReport>(); lstBankAdviceForSalaryReport = hraDal.ReadBankAdviceForSalaryReport(forMonth, reportType, generateType, locationCode, bankAccount); if (lstBankAdviceForSalaryReport.Count == 0) { lstBankAdviceForSalaryReport.Add(new BankAdviceForSalaryReport()); } int dds = 0; if (lstBankAdviceForSalaryReport.Count > 0) { dds = lstBankAdviceForSalaryReport.Max(m => m.AdviceLetterReferenceSeqNo); } EndLetterSequenceNoToShow.InnerText = dds.ToString(); ReportParameter[] parms = new ReportParameter[2]; parms[0] = new ReportParameter("SalaryBankAdviceMonth", Helper.DateFrom(forMonth).ToString("MMMM, yyyy")); parms[1] = new ReportParameter("SalaryBankAdviceDate", lstBankAdviceForSalaryReport[0].CreatedOn.ToString("MMMM dd, yyyy")); this.ReportViewerHRAReports.LocalReport.SetParameters(parms); var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstBankAdviceForSalaryReport)); } //LatterToCustomer else if (reportData.ReportName == "LetterToCustomer") { string OCT_End_CDODCUSTOMERS = "OCT_End_CDODCUSTOMERS"; List <BankAdviceForSalaryLatterReport> lstBankAdviceForSalaryLatterReport = new List <BankAdviceForSalaryLatterReport>(); lstBankAdviceForSalaryLatterReport = hraDal.ReadBankAdviceForSalaryLatterReport(OCT_End_CDODCUSTOMERS); if (lstBankAdviceForSalaryLatterReport.Count == 0) { lstBankAdviceForSalaryLatterReport.Add(new BankAdviceForSalaryLatterReport()); } var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstBankAdviceForSalaryLatterReport)); } // else if (reportData.ReportName == "LetterToChairman") { string OCT_End_CDODCUSTOMERS = "OCT_End_CDODCUSTOMERSUPC"; List <LatterToChairmanReport> lstLatterToChairmanReport = new List <LatterToChairmanReport>(); lstLatterToChairmanReport = hraDal.ReadLatterToChairmanReport(OCT_End_CDODCUSTOMERS); if (lstLatterToChairmanReport.Count == 0) { lstLatterToChairmanReport.Add(new LatterToChairmanReport()); } var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstLatterToChairmanReport)); } else if (reportData.ReportName == "LetterToUNO") { string OCT_End_CDODCUSTOMERS = "OCT_End_CDODCUSTOMERSUNO"; List <LatterToUpoZelaChairmanReport> lstLatterToUpoZelaChairmanReport = new List <LatterToUpoZelaChairmanReport>(); lstLatterToUpoZelaChairmanReport = hraDal.ReadLatterToUpoZelaChairmanReport(OCT_End_CDODCUSTOMERS); if (lstLatterToUpoZelaChairmanReport.Count == 0) { lstLatterToUpoZelaChairmanReport.Add(new LatterToUpoZelaChairmanReport()); } var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstLatterToUpoZelaChairmanReport)); } else if (reportData.ReportName == "Envelope") { string OCT_End_CDODCUSTOMERS = "OCT_End_CDODCUSTOMERS"; List <BankAdviceForSalaryLatterReport> lstBankAdviceForSalaryLatterReport = new List <BankAdviceForSalaryLatterReport>(); lstBankAdviceForSalaryLatterReport = hraDal.ReadBankAdviceForSalaryLatterReport(OCT_End_CDODCUSTOMERS); if (lstBankAdviceForSalaryLatterReport.Count == 0) { lstBankAdviceForSalaryLatterReport.Add(new BankAdviceForSalaryLatterReport()); } var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstBankAdviceForSalaryLatterReport)); }//AttachmentToUnionReport else if (reportData.ReportName == "AttachmentToUnionReport") { string OCT_End_CDODCUSTOMERS = "OCT_End_CDODCUSTOMERS"; List <BankAdviceForSalaryLatterReport> lstBankAdviceForSalaryLatterReport = new List <BankAdviceForSalaryLatterReport>(); lstBankAdviceForSalaryLatterReport = hraDal.ReadBankAdviceForSalaryLatterReport(OCT_End_CDODCUSTOMERS); if (lstBankAdviceForSalaryLatterReport.Count == 0) { lstBankAdviceForSalaryLatterReport.Add(new BankAdviceForSalaryLatterReport()); } var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstBankAdviceForSalaryLatterReport)); } else if (reportData.ReportName == "AttachmentToUpazilaReport") { string OCT_End_CDODCUSTOMERS = "OCT_End_CDODCUSTOMERS"; List <BankAdviceForSalaryLatterReport> lstBankAdviceForSalaryLatterReport = new List <BankAdviceForSalaryLatterReport>(); lstBankAdviceForSalaryLatterReport = hraDal.ReadBankAdviceForSalaryLatterReport(OCT_End_CDODCUSTOMERS); if (lstBankAdviceForSalaryLatterReport.Count == 0) { lstBankAdviceForSalaryLatterReport.Add(new BankAdviceForSalaryLatterReport()); } var dsmems = ReportViewerHRAReports.LocalReport.GetDataSourceNames(); ReportViewerHRAReports.LocalReport.DataSources.Add(new ReportDataSource(dsmems[0], lstBankAdviceForSalaryLatterReport)); } ReportViewerHRAReports.LocalReport.Refresh(); } catch (Exception ex) { ReportViewerHRAReports.DocumentMapCollapsed = true; ReportViewerHRAReports.LocalReport.Refresh(); throw ex; } }