protected void Page_Load(object sender, EventArgs e) { string FYPart = ""; string CertType = ""; string fundCode = ""; string branchCode = ""; string interim = ""; string ended = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); CertType = (string)Session["CertType"]; fundCode = (string)Session["FundCode"]; branchCode = (string)Session["branchCode"]; if (string.Compare(CertType, "IncomeTaxCert", true) == 0)//for Income Tax Report { DataTable dtIncomeTax = (DataTable)Session["dtIncomeTax"]; string FY = (string)Session["FY"]; int REG_NO = (int)Session["REG_NO"]; dtIncomeTax.TableName = "IncomeTax"; if (string.Compare(fundCode, "IAMPH", true) == 0) { FYPart = dtIncomeTax.Rows[0]["FY_PART"].Equals(DBNull.Value) ? "" : dtIncomeTax.Rows[0]["FY_PART"].ToString(); FYPart = "(" + FYPart.ToString() + ")"; } interim = dtIncomeTax.Rows[0]["FY_PART"].ToString(); if (interim.ToString().ToUpper() == "INTERIM") { ended = ""; } else if (interim.ToString().ToUpper() == "FINAL") { ended = "ended"; } else { interim = ""; ended = "ended"; } //dtIncomeTax.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\dtReportIncomeTax.xsd"); DataTable dtTaxCal = diviDAOObj.dtDividendInfo(REG_NO, fundCode, branchCode, FY); ReportDocument rdoc = new ReportDocument(); rdoc = new ReportDocument(); string Path = Server.MapPath("Report/rptIncomeTax.rpt"); rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtIncomeTax); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("FYPart", FYPart.ToString()); rdoc.SetParameterValue("Interim", interim.ToString()); rdoc.SetParameterValue("ended", ended.ToString()); rdoc = ReportFactory.GetReport(rdoc.GetType()); //} } else if (string.Compare(CertType, "SolventCert", true) == 0)//for Solvent { opendMFDAOObj = new OMFDAO(); DataTable dtInvestCertHolderInfo = (DataTable)Session["dtInvestCertHolderInfo"]; decimal totalUnitHolding = (decimal)Session["totalUnitHolding"]; decimal USDRate = Convert.ToDecimal((string)Session["USDRate"]); decimal repRate = Convert.ToDecimal((string)Session["RepRate"]); string TTDate = (string)Session["TTDate"]; decimal equivalentInvestValue = totalUnitHolding * repRate; equivalentInvestValue = decimal.Round(equivalentInvestValue / USDRate, 2); decimal equivalentMarketValue = totalUnitHolding * repRate; equivalentMarketValue = decimal.Round(equivalentMarketValue, 2); // dtInvestSaleInfo.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\rptSolventCert.xsd"); string Path = Server.MapPath("Report/rptSolventCert.rpt"); rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtInvestCertHolderInfo); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("HNAME", dtInvestCertHolderInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["HNAME"].ToString()); rdoc.SetParameterValue("JNT_NAME", dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].ToString()); rdoc.SetParameterValue("ADDRESS1", dtInvestCertHolderInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS1"].ToString()); rdoc.SetParameterValue("ADDRESS2", dtInvestCertHolderInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS2"].ToString()); rdoc.SetParameterValue("CITY", dtInvestCertHolderInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["CITY"].ToString()); rdoc.SetParameterValue("FUND_NAME", dtInvestCertHolderInfo.Rows[0]["FUND_NM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["FUND_NM"].ToString()); rdoc.SetParameterValue("Reg_No", dtInvestCertHolderInfo.Rows[0]["REG_NUM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["REG_NUM"].ToString()); rdoc.SetParameterValue("TotalUnit", totalUnitHolding); rdoc.SetParameterValue("equivalentInvestValue", equivalentInvestValue); rdoc.SetParameterValue("equivalentInvestValueinWord", numberToEnglisUSDObj.changeNumericToWords(equivalentInvestValue)); rdoc.SetParameterValue("equivalentMarketValue", equivalentMarketValue); rdoc.SetParameterValue("equivalentMarketValueinWord", numberToEnglisUSDObj.changeNumericToWords(equivalentMarketValue)); rdoc.SetParameterValue("TTDate", Convert.ToDateTime(TTDate).ToString("dd-MMM-yyyy")); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else if (string.Compare(CertType, "SurrendertCert", true) == 0)// for Surrender { DataTable dtInvestCertHolderInfo = (DataTable)Session["dtInvestCertHolderInfo"]; DataTable dtLadgerForReport = (DataTable)Session["dtLadgerForReport"]; DataTable dtSurrender = (DataTable)Session["dtSurrender"]; dtLadgerForReport.TableName = "dtLadgerForReport"; dtSurrender.TableName = "dtSurrender"; dtInvestCertHolderInfo.TableName = "dtInvestCertHolderInfo"; // dtLadgerForReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\rptSurrenderCert.xsd"); ReportDocument rdoc = new ReportDocument(); string Path = Server.MapPath("Report/rptSurrenderCert.rpt"); rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtLadgerForReport); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("HNAME", dtInvestCertHolderInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["HNAME"].ToString()); rdoc.SetParameterValue("ADDRESS1", dtInvestCertHolderInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS1"].ToString()); rdoc.SetParameterValue("ADDRESS2", dtInvestCertHolderInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS2"].ToString()); rdoc.SetParameterValue("CITY", dtInvestCertHolderInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["CITY"].ToString()); rdoc.SetParameterValue("FUND_NAME", dtInvestCertHolderInfo.Rows[0]["FUND_NM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["FUND_NM"].ToString()); rdoc.SetParameterValue("TotalBalance", (int)Session["totalBalance"]); rdoc.SetParameterValue("outBalance", (int)Session["outBalance"]); rdoc.SetParameterValue("inBalance", (int)Session["inBalance"]); rdoc.SetParameterValue("sur_Unit", Convert.ToInt32(dtSurrender.Rows[0]["REP_UNIT"].ToString())); rdoc.SetParameterValue("Sur_Date", dtSurrender.Rows[0]["REP_DATE"].ToString()); rdoc.SetParameterValue("sur_Amount", Convert.ToDecimal(dtSurrender.Rows[0]["AMOUNT"].ToString())); rdoc.SetParameterValue("inWord", numberToEnglisObj.changeNumericToWords(Convert.ToDecimal(dtSurrender.Rows[0]["AMOUNT"].ToString()))); rdoc.SetParameterValue("sur_Rate", Convert.ToDecimal(dtSurrender.Rows[0]["RATE"].ToString())); rdoc.SetParameterValue("repAmount", (decimal)Session["repAmount"]); rdoc.SetParameterValue("saleAmount", (decimal)Session["saleAmount"]); rdoc.SetParameterValue("ledgerAmount", (decimal)Session["ledgerAmount"]); rdoc.SetParameterValue("asOnDate", Convert.ToDateTime((string)Session["asOnDate"])); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else if (string.Compare(CertType, "InvestCert", true) == 0)// for Invest { DataTable dtInvestCertHolderInfo = (DataTable)Session["dtInvestCertHolderInfo"]; DataTable dtInvestSaleInfo = (DataTable)Session["dtInvestSaleInfo"]; DataTable dtInvestTotal = (DataTable)Session["dtInvestTotal"]; string FY = (string)Session["FY"]; string CloseDate = (string)Session["CloseDate"]; string investmentType = (string)Session["investmentType"]; // dtInvestSaleInfo.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\rptInvestCert.xsd"); rdoc = new ReportDocument(); string Path = ""; if (investmentType == "CIP") { Path = Server.MapPath("Report/rptInvestCertCIP.rpt"); } else { Path = Server.MapPath("Report/rptInvestCert.rpt"); } rdoc.Load(Path); rdoc.Refresh(); rdoc.SetDataSource(dtInvestSaleInfo); CrystalReportViewer1.ReportSource = rdoc; rdoc.SetParameterValue("branchCode", branchCode); rdoc.SetParameterValue("fundCode", fundCode); rdoc.SetParameterValue("FY", FY.ToString()); rdoc.SetParameterValue("close_dt", CloseDate.ToString()); rdoc.SetParameterValue("HNAME", dtInvestCertHolderInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["HNAME"].ToString()); rdoc.SetParameterValue("JHOLDER", dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["JNT_NAME"].ToString()); rdoc.SetParameterValue("ADDRESS1", dtInvestCertHolderInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS1"].ToString()); rdoc.SetParameterValue("ADDRESS2", dtInvestCertHolderInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["ADDRS2"].ToString()); rdoc.SetParameterValue("CITY", dtInvestCertHolderInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["CITY"].ToString()); rdoc.SetParameterValue("FUND_NAME", dtInvestCertHolderInfo.Rows[0]["FUND_NM"].Equals(DBNull.Value) ? "" : dtInvestCertHolderInfo.Rows[0]["FUND_NM"].ToString()); rdoc.SetParameterValue("TotalAmt", Convert.ToDecimal(dtInvestTotal.Rows[0]["TOTAL_AMOUNT"].Equals(DBNull.Value) ? "0" : dtInvestTotal.Rows[0]["TOTAL_AMOUNT"].ToString())); rdoc = ReportFactory.GetReport(rdoc.GetType()); } else { Response.Write("No Data Found"); } }