protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); regNoTextBox.Focus(); //saleDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); // holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); if (!IsPostBack) { regObj.FundCode = fundCode.ToString(); regObj.BranchCode = branchCode.ToString(); // renewalNumberTextBox.Text = opendMFDAO.GetMaxSaleNo(regObj).ToString(); // renewalDateTextBox.Text = opendMFDAO.getLastSaleDate(regObj).ToString("dd-MMM-yyyy"); // totalUnitsTextBox.Text = opendMFDAO.getLastSaleRate(regObj).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); regNoTextBox.Focus(); if (!IsPostBack) { fundCodeDDL.DataSource = reportObj.dtFundCodeList(); fundCodeDDL.DataTextField = "NAME"; fundCodeDDL.DataValueField = "ID"; fundCodeDDL.SelectedValue = fundCode.ToString(); fundCodeDDL.DataBind(); branchCodeDDL.DataSource = reportObj.dtBranchCodeList(); branchCodeDDL.DataTextField = "NAME"; branchCodeDDL.DataValueField = "ID"; branchCodeDDL.SelectedValue = branchCode.ToString(); branchCodeDDL.DataBind(); dateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); saleNumberTextBox.Focus(); //saleDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); // holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); if (!IsPostBack) { bankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=1 "); bankNameDropDownList.DataTextField = "BANK_NAME"; bankNameDropDownList.DataValueField = "BANK_CODE"; bankNameDropDownList.DataBind(); CashAmountTextBox.Enabled = false; MultiplePayTypeTextBox.Enabled = false; } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); tferorFundCodeTextBox.Text = fundCode.ToString(); tferorBranchCodeTextBox.Text = branchCode.ToString(); tfereeFundCodeTextBox.Text = fundCode.ToString(); tfereeBranhCodeTextBox.Text = branchCode.ToString(); if (!IsPostBack) { tferorRegNoTextBox.Focus(); transferDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); FundCodeTextBox.Text = fundCode.ToString(); BranchCodeTextBox.Text = branchCode.ToString(); RegNoTextBox.Focus(); if (!IsPostBack) { LienbankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(); LienbankNameDropDownList.DataTextField = "BANK_NAME"; LienbankNameDropDownList.DataValueField = "BANK_CODE"; LienbankNameDropDownList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); FundCodeTextBox.Text = fundCode.ToString(); BranchCodeTextBox.Text = branchCode.ToString(); if (!IsPostBack) { regObj.FundCode = fundCode.ToString(); regObj.BranchCode = branchCode.ToString(); moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'REP' AND SL_REP_TR_RN_NO IS NULL ORDER BY RECEIPT_NO DESC "); moneyReceipDropDownList.DataTextField = "RECEIPT_NO"; moneyReceipDropDownList.DataValueField = "ID"; moneyReceipDropDownList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); if (!IsPostBack) { DataTable dtOccupationList = opendMFDAO.dtOccopationList(); nomiOccupationDropDownList.DataSource = dtOccupationList; nomiOccupationDropDownList.DataTextField = "DESCR"; nomiOccupationDropDownList.DataValueField = "CODE"; nomiOccupationDropDownList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); FundCodeTextBox.Text = fundCode.ToString(); BranchCodeTextBox.Text = branchCode.ToString(); RegNoTextBox.Focus(); if (!IsPostBack) { //UnitRepurchase unitRepObj = new UnitRepurchase(); //regObj.BranchCode = BranchCodeTextBox.Text.Trim().ToUpper().ToString(); //regObj.FundCode = FundCodeTextBox.Text.Trim().ToUpper().ToString(); //RepNoTextBox.Text = unitRepBLObj.getMaxRepurchaseNo(regObj).ToString(); //unitRepObj.RepurchaseNo = unitRepBLObj.getMaxRepurchaseNo(regObj) - 1; //RepDateTextBox.Text = unitRepBLObj.getLastRepDate(regObj, unitRepObj).ToString("dd-MMM-yyyy"); //RepRateTextBox.Text = unitRepBLObj.getLastRepRate(regObj, unitRepObj).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); // toRegDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); // fromRegDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); ; ///holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); if (!IsPostBack) { } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); fundCode = bcContent.FundCode.ToString(); branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); CDSStatus = bcContent.CDS.ToString().ToUpper(); if (!IsPostBack) { incomeTaxFYDropDownList.DataSource = reportObj.getDtFY(fundCode); incomeTaxFYDropDownList.DataTextField = "F_YEAR"; incomeTaxFYDropDownList.DataValueField = "DIVI_NO"; incomeTaxFYDropDownList.DataBind(); fyPartDropDownList.DataSource = reportObj.getDtFYPart(fundCode); fyPartDropDownList.DataTextField = "FY_PART"; fyPartDropDownList.DataValueField = "FY_PART"; fyPartDropDownList.DataBind(); } }
protected void SaveButton_Click(object sender, EventArgs e) { Hashtable htPriceRefixation = new Hashtable(); try { commonGatewayObj.BeginTransaction(); htPriceRefixation.Add("FUND_CD", fundNameDropDownList.SelectedValue.ToString().ToUpper()); htPriceRefixation.Add("FUND_NM", opendMFDAO.GetFundName(fundNameDropDownList.SelectedValue.ToString())); htPriceRefixation.Add("REFIX_DT", Convert.ToDateTime(PriceDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy")); htPriceRefixation.Add("REFIX_SL_PR", Convert.ToDecimal(SalePriceTextBox.Text.Trim().ToString())); htPriceRefixation.Add("REFIX_REP_PR", Convert.ToDecimal(RepPriceTextBox.Text.Trim().ToString())); htPriceRefixation.Add("USER_NM", userObj.UserID.ToString()); htPriceRefixation.Add("ENT_DT", DateTime.Today.ToString("dd-MMM-yyyy")); htPriceRefixation.Add("ENT_TM", DateTime.Now.ToShortTimeString()); commonGatewayObj.Insert(htPriceRefixation, "PRICE_REFIX"); commonGatewayObj.CommitTransaction(); PriceDateTextBox.Text = ""; SalePriceTextBox.Text = ""; RepPriceTextBox.Text = ""; fundNameDropDownList.Focus(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true); } catch (Exception ex) { commonGatewayObj.RollbackTransaction(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; DataTable dtReportStatement = (DataTable)Session["dtPriceInfo"]; string fundCode = (string)Session["fundCode"]; if (dtReportStatement.Rows.Count > 0) { // dtReportStatement.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtPriceRefixation.xsd"); CR_PRICE.Refresh(); CR_PRICE.SetDataSource(dtReportStatement); CR_PRICE.SetParameterValue("fudnName", opendMFDAO.GetFundName(fundCode.ToString())); CrystalReportViewer1.ReportSource = CR_PRICE; } else { Response.Write("No data found"); } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); regNoTextBox.Focus(); //saleDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); // holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); if (!IsPostBack) { CashAmountTextBox.Enabled = false; MultiplePayTypeTextBox.Enabled = false; } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); BOTextBox.Focus(); ///holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); if (!IsPostBack) { DataTable dtOccupationList = opendMFDAO.dtOccopationList(); holderOccupationDropDownList.DataSource = dtOccupationList; holderOccupationDropDownList.DataTextField = "DESCR"; holderOccupationDropDownList.DataValueField = "CODE"; holderOccupationDropDownList.DataBind(); //bankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=1 " ); //bankNameDropDownList.DataTextField = "BANK_NAME"; //bankNameDropDownList.DataValueField = "BANK_CODE"; //bankNameDropDownList.DataBind(); IDbankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=2 "); IDbankNameDropDownList.DataTextField = "BANK_NAME"; IDbankNameDropDownList.DataValueField = "BANK_CODE"; IDbankNameDropDownList.DataBind(); regTypeDropDownList.DataSource = unitHolderRegBLObj.dtFillRegType(); regTypeDropDownList.DataTextField = "NAME"; regTypeDropDownList.DataValueField = "CODE"; regTypeDropDownList.DataBind(); regDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); fundCodeTextBox.Text = fundCode.ToString(); branchCodeTextBox.Text = branchCode.ToString(); if (!IsPostBack) { DataTable dtOccupationList = opendMFDAO.dtOccopationList(); OccupationDropDownList.DataSource = dtOccupationList; OccupationDropDownList.DataTextField = "DESCR"; OccupationDropDownList.DataValueField = "CODE"; OccupationDropDownList.DataBind(); bankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=1 "); bankNameDropDownList.DataTextField = "BANK_NAME"; bankNameDropDownList.DataValueField = "BANK_CODE"; bankNameDropDownList.DataBind(); IDbankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE IN (1,2,3) "); IDbankNameDropDownList.DataTextField = "BANK_NAME"; IDbankNameDropDownList.DataValueField = "BANK_CODE"; IDbankNameDropDownList.DataBind(); regTypeDropDownList.DataSource = unitHolderRegBLObj.dtFillRegType(); regTypeDropDownList.DataTextField = "NAME"; regTypeDropDownList.DataValueField = "CODE"; regTypeDropDownList.DataBind(); regTypeDropDownList.SelectedValue = "N"; regObj.FundCode = fundCode.ToString(); regObj.BranchCode = branchCode.ToString(); regNoTextBox.Text = unitHolderRegBLObj.GetMaxRegNo(regObj).ToString(); regObj.RegNumber = (unitHolderRegBLObj.GetMaxRegNo(regObj) - 1).ToString(); regDateTextBox.Text = unitHolderRegBLObj.getLastRegDate(regObj).ToString("dd-MMM-yyyy"); regNoTextBox.Focus(); } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); if (!IsPostBack) { fundCodeDDL.DataSource = reportObj.dtFundCodeList(); fundCodeDDL.DataTextField = "NAME"; fundCodeDDL.DataValueField = "ID"; fundCodeDDL.SelectedValue = fundCode.ToString(); fundCodeDDL.DataBind(); FundCodeDDL_I.DataSource = reportObj.dtFundCodeList(); FundCodeDDL_I.DataTextField = "NAME"; FundCodeDDL_I.DataValueField = "ID"; FundCodeDDL_I.SelectedValue = fundCode.ToString(); FundCodeDDL_I.DataBind(); branchCodeDDL.DataSource = reportObj.dtBranchCodeList(); branchCodeDDL.DataTextField = "NAME"; branchCodeDDL.DataValueField = "ID"; branchCodeDDL.SelectedValue = branchCode.ToString(); branchCodeDDL.DataBind(); BranchCodeDDL_I.DataSource = reportObj.dtBranchCodeList(); BranchCodeDDL_I.DataTextField = "NAME"; BranchCodeDDL_I.DataValueField = "ID"; BranchCodeDDL_I.SelectedValue = branchCode.ToString(); BranchCodeDDL_I.DataBind(); regObj.FundCode = fundCode.ToString(); regObj.BranchCode = branchCode.ToString(); ReceiptDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); ReceiptNoTextBox.Text = unitSaleBLObj.GetMaxReceiptNo(regObj, "TR").ToString(); } }
protected void Page_Load(object sender, EventArgs e) { UnitHolderRegistration regObj = new UnitHolderRegistration(); if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); fundCode = bcContent.FundCode.ToString(); branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); if (!IsPostBack) { fundCodeDDL.DataSource = reportObj.dtFundCodeList(); fundCodeDDL.DataTextField = "NAME"; fundCodeDDL.DataValueField = "ID"; fundCodeDDL.SelectedValue = fundCode.ToString(); fundCodeDDL.DataBind(); branchCodeDDL.DataSource = reportObj.dtBranchCodeList(); branchCodeDDL.DataTextField = "NAME"; branchCodeDDL.DataValueField = "ID"; branchCodeDDL.SelectedValue = branchCode.ToString(); branchCodeDDL.DataBind(); regObj.FundCode = fundCode.ToString(); regObj.BranchCode = branchCode.ToString(); moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'SL' AND SL_REP_TR_RN_NO IS NULL AND ACC_VOUCHER_NO IS NULL ORDER BY RECEIPT_NO DESC "); moneyReceipDropDownList.DataTextField = "RECEIPT_NO"; moneyReceipDropDownList.DataValueField = "ID"; moneyReceipDropDownList.DataBind(); agentNameDDL.DataSource = unitSaleBLObj.dtSellingAgentInfoforDDL(); agentNameDDL.DataTextField = "NAME"; agentNameDDL.DataValueField = "ID"; agentNameDDL.SelectedValue = "0"; agentNameDDL.DataBind(); agentNameDDL.Enabled = true; sellingAgentCodeTextBox.Enabled = true; } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); fundCode = bcContent.FundCode.ToString(); branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); if (!IsPostBack) { } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserID"] == null) { Session.RemoveAll(); Response.Redirect("../../Default.aspx"); } string regNo = ""; string fundCode = ""; string branchCode = ""; string unitHolderName = ""; string branchName = ""; string fundName = ""; if (Request.QueryString["reg"] != null) { regNo = Request.QueryString["reg"].ToString(); } if (Request.QueryString["fund"] != null) { fundName = omfDAOObj.GetFundName(Request.QueryString["fund"].ToString()); fundCode = Request.QueryString["fund"].ToString(); } if (Request.QueryString["branch"] != null) { branchName = omfDAOObj.GetBranchName(Request.QueryString["branch"].ToString()); branchCode = Request.QueryString["branch"].ToString(); } if (regNo != "" && fundCode != "" && branchCode != "") { unitHolderName = omfDAOObj.GetHolderName(fundCode, branchCode, regNo); } tdBranch.InnerHtml = "<span style=\"color:Green\"><b>" + branchName.ToString() + "</b></span>"; tdFund.InnerHtml = "<span style=\"color:Green\"><b>" + fundName.ToString() + "</b></span>"; tdHolderName.InnerHtml = "<span style=\"color:Green\"><b>" + unitHolderName.ToString() + "</b></span>"; tdReg.InnerHtml = "<span style=\"color:Green\"><b>" + regNo.ToString() + "</b></span>"; //string imageLocation = string imageSignLocation = Path.Combine(ConfigReader.SingLocation, fundCode + "_" + branchCode + "_" + regNo + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg"; string imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation, fundCode + "_" + branchCode + "_" + regNo + ".jpg"); //SignImage.ImageUrl = imageSignLocation.ToString(); // PhotoImage.ImageUrl = imagePhotoLocation.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); fundCode = bcContent.FundCode.ToString(); branchCode = bcContent.BranchCode.ToString(); spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString()); if (!IsPostBack) { DRRefNoDropDownList.DataSource = unitSaleBLObj.dtDRRefNoListForFolioTransfer("AND SALE.REG_BK='" + fundCode + "'"); DRRefNoDropDownList.DataTextField = "NAME"; DRRefNoDropDownList.DataValueField = "ID"; DRRefNoDropDownList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); string fundCode = bcContent.FundCode.ToString(); string branchCode = bcContent.BranchCode.ToString(); DataTable dtSaleCertPrintReport = (DataTable)Session["dtSaleCertPrintReport"]; string certType = (string)Session["certType"]; // string certificate = ""; string literature = ""; int lineNumber = (int)Session["lineNumber"]; try { if (dtSaleCertPrintReport.Rows.Count > 0) { dtSaleCertPrintReport.TableName = "dtSaleCertPrintReport"; // dtSaleCertPrintReport.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.PORTAL\AMCL.REPORT\XMLSCHEMAS\dtSaleCertPrintReport.xsd"); if (certType.ToString() == "SALE" || certType.ToString() == "RENE") { if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE" && (fundCode.ToString().ToUpper() == "CFUF" || fundCode.ToString().ToUpper() == "IUF")) { //certificate = reportObj.getCIPCertificateForPrint(fundCode, branchCode,Convert.ToInt32(dtSaleCertPrintReport.Rows[0]["SL_NO"].ToString())); literature = "This is to certify that the above mentioned person(s)/institution is/are the registerd holder(s) of "; literature = literature + dtSaleCertPrintReport.Rows[0]["QTY"].ToString() + " ( " + NumToEngObj.changeNumericToWords(Convert.ToDecimal(dtSaleCertPrintReport.Rows[0]["QTY"].ToString())) + ")"; literature = literature + " Units of " + opendMFDAO.GetFundName(fundCode.ToString()) + " issued under the authority as provided in the Trust Deed of the " + opendMFDAO.GetFundName(fundCode.ToString()) + "."; } else if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE" && fundCode.ToString().ToUpper() == "IAMCL") { literature = " This is to certify that the above mentioned person(s)/institution is/are the registerd holder(s) of "; literature = literature + dtSaleCertPrintReport.Rows[0]["QTY"].ToString() + " (" + NumToEngObj.changeNumericToWords(Convert.ToDecimal(dtSaleCertPrintReport.Rows[0]["QTY"].ToString())) + ") "; literature = literature + " Units of " + opendMFDAO.GetFundName(fundCode.ToString()) + " 100.00 each issued under the authority as provided in the Trust Deed of the " + opendMFDAO.GetFundName(fundCode.ToString()) + "."; } if (fundCode.ToString().ToUpper() == "BDF") { CR_BSaleCertPrint.Refresh(); CR_BSaleCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_BSaleCertPrint; } else if (fundCode.ToString().ToUpper() == "CFUF") { if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE") { CR_CFUFCIPCertPrint.Refresh(); CR_CFUFCIPCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_CFUFCIPCertPrint; CR_CFUFCIPCertPrint.SetParameterValue("literature", literature); } else { CR_CFUFSaleCertPrint.Refresh(); CR_CFUFSaleCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_CFUFSaleCertPrint; } } else if (fundCode.ToString().ToUpper() == "IUF") { if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE") { CR_IUFCIPCertPrint.Refresh(); CR_IUFCIPCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_IUFCIPCertPrint; CR_IUFCIPCertPrint.SetParameterValue("literature", literature); } else { CR_CFUFSaleCertPrint.Refresh(); CR_CFUFSaleCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_CFUFSaleCertPrint; } } else if (fundCode.ToString().ToUpper() == "IAMCL") { if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE") { CR_UnitCIPScriptPrint.Refresh(); CR_UnitCIPScriptPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_UnitCIPScriptPrint; CR_UnitCIPScriptPrint.SetParameterValue("literature", literature); } else { CR_SaleCertPrint.Refresh(); CR_SaleCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_SaleCertPrint; } } else { CR_SaleCertPrint.Refresh(); CR_SaleCertPrint.SetDataSource(dtSaleCertPrintReport); CrystalReportViewer1.ReportSource = CR_SaleCertPrint; } } else if (certType.ToString() == "TRAN") { string date1 = ""; string date2 = ""; string date3 = ""; string date4 = ""; string date5 = ""; string date6 = ""; string date7 = ""; string transNumber1 = ""; string transNumber2 = ""; string transNumber3 = ""; string transNumber4 = ""; string transNumber5 = ""; string transNumber6 = ""; string transNumber7 = ""; string tfereeRegNo1 = ""; string tfereeRegNo2 = ""; string tfereeRegNo3 = ""; string tfereeRegNo4 = ""; string tfereeRegNo5 = ""; string tfereeRegNo6 = ""; string tfereeRegNo7 = ""; string tfereeName1 = ""; string tfereeName2 = ""; string tfereeName3 = ""; string tfereeName4 = ""; string tfereeName5 = ""; string tfereeName6 = ""; string tfereeName7 = ""; string tfreeJHolderName1 = ""; string tfreeJHolderName2 = ""; string tfreeJHolderName3 = ""; string tfreeJHolderName4 = ""; string tfreeJHolderName5 = ""; string tfreeJHolderName6 = ""; string tfreeJHolderName7 = ""; string tfreeAddress1 = ""; string tfreeAddress2 = ""; string tfreeAddress3 = ""; string tfreeAddress4 = ""; string tfreeAddress5 = ""; string tfreeAddress6 = ""; string tfreeAddress7 = ""; string tferorRegNo1 = ""; string tferorRegNo2 = ""; string tferorRegNo3 = ""; string tferorRegNo4 = ""; string tferorRegNo5 = ""; string tferorRegNo6 = ""; string tferorRegNo7 = ""; if (lineNumber == 1) { date1 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber1 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo1 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName1 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName1 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress1 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo1 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } else if (lineNumber == 2) { date2 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber2 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo2 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName2 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName2 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress2 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo2 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } else if (lineNumber == 3) { date3 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber3 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo3 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName3 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName3 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress3 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo3 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } else if (lineNumber == 4) { date4 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber4 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo4 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName4 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName4 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress4 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo4 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } else if (lineNumber == 5) { date5 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber5 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo5 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName5 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName5 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress5 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo5 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } else if (lineNumber == 6) { date6 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber6 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo6 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName6 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName6 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress6 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo6 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } else if (lineNumber == 7) { date7 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString(); transNumber7 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString(); tfereeRegNo7 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString(); tfereeName7 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString(); tfreeJHolderName7 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString(); tfreeAddress7 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString(); tferorRegNo7 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString(); } // dtSaleCertPrintReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtTransCertPrintReport.xsd"); //CR_Dividend.SetDataSource(dtReport); if (fundCode.ToString().ToUpper() == "BDF") { //CR_BTransCertPrint.Refresh(); //CR_BTransCertPrint.SetParameterValue("date1", date1); //CR_BTransCertPrint.SetParameterValue("transNumber1", transNumber1); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo1", tfereeRegNo1); //CR_BTransCertPrint.SetParameterValue("tfereeName1", tfereeName1); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName1", tfreeJHolderName1); //CR_BTransCertPrint.SetParameterValue("tfreeAddress1", tfreeAddress1); //CR_BTransCertPrint.SetParameterValue("tferorRegNo1", tferorRegNo1); //CR_BTransCertPrint.SetParameterValue("date2", date2); //CR_BTransCertPrint.SetParameterValue("transNumber2", transNumber2); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo2", tfereeRegNo2); //CR_BTransCertPrint.SetParameterValue("tfereeName2", tfereeName2); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName2", tfreeJHolderName2); //CR_BTransCertPrint.SetParameterValue("tfreeAddress2", tfreeAddress2); //CR_BTransCertPrint.SetParameterValue("tferorRegNo2", tferorRegNo2); //CR_BTransCertPrint.SetParameterValue("date3", date3); //CR_BTransCertPrint.SetParameterValue("transNumber3", transNumber3); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo3", tfereeRegNo3); //CR_BTransCertPrint.SetParameterValue("tfereeName3", tfereeName3); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName3", tfreeJHolderName3); //CR_BTransCertPrint.SetParameterValue("tfreeAddress3", tfreeAddress3); //CR_BTransCertPrint.SetParameterValue("tferorRegNo3", tferorRegNo3); //CR_BTransCertPrint.SetParameterValue("date4", date4); //CR_BTransCertPrint.SetParameterValue("transNumber4", transNumber4); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo4", tfereeRegNo4); //CR_BTransCertPrint.SetParameterValue("tfereeName4", tfereeName4); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName4", tfreeJHolderName4); //CR_BTransCertPrint.SetParameterValue("tfreeAddress4", tfreeAddress4); //CR_BTransCertPrint.SetParameterValue("tferorRegNo4", tferorRegNo4); //CR_BTransCertPrint.SetParameterValue("date5", date5); //CR_BTransCertPrint.SetParameterValue("transNumber5", transNumber5); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo5", tfereeRegNo5); //CR_BTransCertPrint.SetParameterValue("tfereeName5", tfereeName5); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName5", tfreeJHolderName5); //CR_BTransCertPrint.SetParameterValue("tfreeAddress5", tfreeAddress5); //CR_BTransCertPrint.SetParameterValue("tferorRegNo5", tferorRegNo5); //CR_BTransCertPrint.SetParameterValue("date6", date6); //CR_BTransCertPrint.SetParameterValue("transNumber6", transNumber6); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo6", tfereeRegNo6); //CR_BTransCertPrint.SetParameterValue("tfereeName6", tfereeName6); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName6", tfreeJHolderName6); //CR_BTransCertPrint.SetParameterValue("tfreeAddress6", tfreeAddress6); //CR_BTransCertPrint.SetParameterValue("tferorRegNo6", tferorRegNo6); //CR_BTransCertPrint.SetParameterValue("date7", date7); //CR_BTransCertPrint.SetParameterValue("transNumber7", transNumber7); //CR_BTransCertPrint.SetParameterValue("tfereeRegNo7", tfereeRegNo7); //CR_BTransCertPrint.SetParameterValue("tfereeName7", tfereeName7); //CR_BTransCertPrint.SetParameterValue("tfreeJHolderName7", tfreeJHolderName7); //CR_BTransCertPrint.SetParameterValue("tfreeAddress7", tfreeAddress7); //CR_BTransCertPrint.SetParameterValue("tferorRegNo7", tferorRegNo7); CrystalReportViewer1.ReportSource = CR_BTransCertPrint; } else { //CR_TransCertPrint.SetDatabaseLogon("UNIT", "UNIT","194.25.1.200","AMCL"); //CR_TransCertPrint.VerifyDatabase(); //CR_TransCertPrint.Refresh(); //CR_TransCertPrint.SetParameterValue("date1", date1); //CR_TransCertPrint.SetParameterValue("transNumber1", transNumber1); //CR_TransCertPrint.SetParameterValue("tfereeRegNo1", tfereeRegNo1); //CR_TransCertPrint.SetParameterValue("tfereeName1", tfereeName1); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName1", tfreeJHolderName1); //CR_TransCertPrint.SetParameterValue("tfreeAddress1", tfreeAddress1); //CR_TransCertPrint.SetParameterValue("tferorRegNo1", tferorRegNo1); //CR_TransCertPrint.SetParameterValue("date2", date2); //CR_TransCertPrint.SetParameterValue("transNumber2", transNumber2); //CR_TransCertPrint.SetParameterValue("tfereeRegNo2", tfereeRegNo2); //CR_TransCertPrint.SetParameterValue("tfereeName2", tfereeName2); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName2", tfreeJHolderName2); //CR_TransCertPrint.SetParameterValue("tfreeAddress2", tfreeAddress2); //CR_TransCertPrint.SetParameterValue("tferorRegNo2", tferorRegNo2); //CR_TransCertPrint.SetParameterValue("date3", date3); //CR_TransCertPrint.SetParameterValue("transNumber3", transNumber3); //CR_TransCertPrint.SetParameterValue("tfereeRegNo3", tfereeRegNo3); //CR_TransCertPrint.SetParameterValue("tfereeName3", tfereeName3); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName3", tfreeJHolderName3); //CR_TransCertPrint.SetParameterValue("tfreeAddress3", tfreeAddress3); //CR_TransCertPrint.SetParameterValue("tferorRegNo3", tferorRegNo3); //CR_TransCertPrint.SetParameterValue("date4", date4); //CR_TransCertPrint.SetParameterValue("transNumber4", transNumber4); //CR_TransCertPrint.SetParameterValue("tfereeRegNo4", tfereeRegNo4); //CR_TransCertPrint.SetParameterValue("tfereeName4", tfereeName4); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName4", tfreeJHolderName4); //CR_TransCertPrint.SetParameterValue("tfreeAddress4", tfreeAddress4); //CR_TransCertPrint.SetParameterValue("tferorRegNo4", tferorRegNo4); //CR_TransCertPrint.SetParameterValue("date5", date5); //CR_TransCertPrint.SetParameterValue("transNumber5", transNumber5); //CR_TransCertPrint.SetParameterValue("tfereeRegNo5", tfereeRegNo5); //CR_TransCertPrint.SetParameterValue("tfereeName5", tfereeName5); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName5", tfreeJHolderName5); //CR_TransCertPrint.SetParameterValue("tfreeAddress5", tfreeAddress5); //CR_TransCertPrint.SetParameterValue("tferorRegNo5", tferorRegNo5); //CR_TransCertPrint.SetParameterValue("date6", date6); //CR_TransCertPrint.SetParameterValue("transNumber6", transNumber6); //CR_TransCertPrint.SetParameterValue("tfereeRegNo6", tfereeRegNo6); //CR_TransCertPrint.SetParameterValue("tfereeName6", tfereeName6); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName6", tfreeJHolderName6); //CR_TransCertPrint.SetParameterValue("tfreeAddress6", tfreeAddress6); //CR_TransCertPrint.SetParameterValue("tferorRegNo6", tferorRegNo6); //CR_TransCertPrint.SetParameterValue("date7", date7); //CR_TransCertPrint.SetParameterValue("transNumber7", transNumber7); //CR_TransCertPrint.SetParameterValue("tfereeRegNo7", tfereeRegNo7); //CR_TransCertPrint.SetParameterValue("tfereeName7", tfereeName7); //CR_TransCertPrint.SetParameterValue("tfreeJHolderName7", tfreeJHolderName7); //CR_TransCertPrint.SetParameterValue("tfreeAddress7", tfreeAddress7); //CR_TransCertPrint.SetParameterValue("tferorRegNo7", tferorRegNo7); CrystalReportViewer1.ReportSource = CR_TransCertPrint; } } } else { Response.Write("No data found"); } } catch (Exception ex) { Response.Write("Error: " + ex.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { string fundCode = ""; string branchCode = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); branchCode = (string)Session["branchCode"]; fundCode = (string)Session["fundCode"]; int lienNo = (int)Session["lienNo"]; int regNo = (int)Session["regNo"]; DateTime lienReqDate = Convert.ToDateTime((string)Session["lienReqDate"]); string lienReqRef = (string)Session["lienReqRef"]; string lienInstitution = (string)Session["lienInstitution"]; string lienInstitutionBranch = (string)Session["lienInstitutionBranch"]; string holderName = (string)Session["holderName"]; string jHolderName = (string)Session["jHolderName"]; string toName = (string)Session["toName"]; string division = (string)Session["division"]; string address1 = (string)Session["address1"]; string address2 = (string)Session["address2"]; string address3 = (string)Session["address3"]; string signatory = (string)Session["signatory"]; string designation = (string)Session["designation"]; DataTable dtReport = new DataTable(); dtReport.Columns.Add("SL_TR_NO", typeof(string)); dtReport.Columns.Add("CERT_NO", typeof(string)); dtReport.Columns.Add("QTY", typeof(int)); dtReport.TableName = "ReportLienLetter"; DataRow drReport; DataTable dtReportStatement = commonGatewayObj.Select("SELECT SL_TR_NO,QTY FROM LIEN_MARK WHERE VALID IS NULL AND LIEN_NO=" + lienNo + " AND REG_BR='" + branchCode.ToString() + "' AND REG_BK='" + fundCode.ToString() + "' AND REG_NO=" + regNo); if (dtReportStatement.Rows.Count > 0) { string saleNo = ""; int totalUnits = 0; for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++) { drReport = dtReport.NewRow(); drReport["SL_TR_NO"] = dtReportStatement.Rows[looper]["SL_TR_NO"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["SL_TR_NO"].ToString(); saleNo = dtReportStatement.Rows[looper]["SL_TR_NO"].ToString(); drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT CERTIFICATE FROM LIEN_MARK_CERT_NO WHERE SL_TR_NO='" + saleNo + "' AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' AND REG_NO=" + regNo + " AND LIEN_NO=" + lienNo, fundCode.ToString()).ToString(); drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString()); dtReport.Rows.Add(drReport); totalUnits = totalUnits + Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["QTY"].ToString()); } // dtReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\ReportLienLetter.xsd"); CR_Lien.Refresh(); CR_Lien.SetDataSource(dtReport); CR_Lien.SetParameterValue("fudnName", opendMFDAO.GetFundName(fundCode.ToString())); CR_Lien.SetParameterValue("lienNo", lienNo); CR_Lien.SetParameterValue("regNo", regNo); CR_Lien.SetParameterValue("lienReqDate", lienReqDate); CR_Lien.SetParameterValue("lienReqRef", lienReqRef); CR_Lien.SetParameterValue("lienInstitution", lienInstitution); CR_Lien.SetParameterValue("lienInstitutionBranch", lienInstitutionBranch); CR_Lien.SetParameterValue("holderName", holderName); CR_Lien.SetParameterValue("jHolderName", jHolderName); CR_Lien.SetParameterValue("toName", toName); CR_Lien.SetParameterValue("division", division); CR_Lien.SetParameterValue("address1", address1); CR_Lien.SetParameterValue("address2", address2); CR_Lien.SetParameterValue("address3", address3); CR_Lien.SetParameterValue("signatory", signatory); CR_Lien.SetParameterValue("designation", designation); CR_Lien.SetParameterValue("fundCode", fundCode); CR_Lien.SetParameterValue("branchCode", branchCode); CR_Lien.SetParameterValue("totalUnits", totalUnits); CrystalReportViewer1.ReportSource = CR_Lien; } else { Response.Write("No data found"); } }
protected void Page_Load(object sender, EventArgs e) { string UserID = ""; string FundCode = ""; string BranchCode = ""; string UserName = ""; string queryStringParent = ""; string CDSStatus = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; UserID = bcContent.LoginID; FundCode = bcContent.FundCode; BranchCode = bcContent.BranchCode; UserName = bcContent.LoginUserName; CDSStatus = bcContent.CDS.ToString().ToUpper(); mnuMenu.Items.Clear(); skmMenu.MenuItem item; skmMenu.MenuItem Subitem; if (CDSStatus == "Y") { if (string.Compare(UserID, "admin", false) == 0) { queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE VALID='Y' and M_PARENT_ID<>0 AND PROJECT_ID=1 AND CDS='Y' ORDER BY PARENT_ID"; } else { queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE NON_CDS_M_ID IN (SELECT M_ID FROM USER_MENU WHERE USER_ID='" + UserID.ToString() + "' AND VALID IS NULL ) AND VALID='Y' and M_PARENT_ID <>0 AND CDS='Y' ORDER BY PARENT_ID"; } } else { if (string.Compare(UserID, "admin", false) == 0) { queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE VALID='Y' and M_PARENT_ID<>0 AND PROJECT_ID=1 AND M_ID=NVL(NON_CDS_M_ID,M_ID) ORDER BY PARENT_ID"; } else { queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE M_ID IN (SELECT M_ID FROM USER_MENU WHERE USER_ID='" + UserID.ToString() + "' AND VALID IS NULL) AND VALID='Y' and M_PARENT_ID<>0 ORDER BY PARENT_ID"; } } DataTable dtSubMenu = new DataTable(); DataTable dtParentMenu = new DataTable(); string parentItem = ""; if (queryStringParent != "") { dtParentMenu = commonGatewayObj.Select(queryStringParent.ToString()); } if (dtParentMenu.Rows.Count > 0) { for (int looper = 0; looper < dtParentMenu.Rows.Count; looper++) { parentItem = itemString(Convert.ToInt32(dtParentMenu.Rows[looper]["PARENT_ID"].ToString())).ToString(); item = new skmMenu.MenuItem(parentItem.ToString()); dtSubMenu = getdtSubMenu(Convert.ToInt32(dtParentMenu.Rows[looper]["PARENT_ID"].ToString()), UserID, BranchCode.ToString().ToUpper(), FundCode.ToString().ToUpper(), CDSStatus); if (dtSubMenu.Rows.Count == 1 && (dtSubMenu.Rows[0]["M_PARENT_ID"].ToString() == dtSubMenu.Rows[0]["M_ID"].ToString())) { item.Url = dtSubMenu.Rows[0]["M_URL"].ToString(); } else if (dtSubMenu.Rows.Count > 0) { for (int loop = 0; loop < dtSubMenu.Rows.Count; loop++) { Subitem = new skmMenu.MenuItem(dtSubMenu.Rows[loop]["M_CAPTION"].ToString()); Subitem.Url = dtSubMenu.Rows[loop]["M_URL"].ToString(); item.SubItems.Add(Subitem); } } mnuMenu.Items.Add(item); } } if (FundCode == null || BranchCode == null) { Response.Redirect("../Default.aspx"); } else { string cssColourCode = opendMFDAO.getFundCSSColourCode(FundCode.ToUpper()); tdFundName.InnerHtml = "<span style=\"color:" + cssColourCode + ";\">" + opendMFDAO.GetFundName(FundCode) + "</span>"; tdUser.InnerHtml = "<span style=\"color:" + cssColourCode + "\"> User: <b>" + UserName + "</b></span>"; tdBranch.InnerHtml = "<span style=\"color:" + cssColourCode + "\">Branch: <b>" + opendMFDAO.GetBranchName(BranchCode) + "</b></span>"; } mnuMenu1.Items.Clear(); //Home item = new skmMenu.MenuItem("Home"); item.Url = "Home.aspx"; mnuMenu1.Items.Add(item); //Logout item = new skmMenu.MenuItem("Logout"); item.Url = "../Default.aspx"; mnuMenu1.Items.Add(item); }
protected void Page_Load(object sender, EventArgs e) { string fundCode = ""; string branchCode = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); CDSStatus = bcContent.CDS.ToString().ToUpper(); branchCode = (string)Session["branchCode"]; fundCode = (string)Session["fundCode"]; DataTable dtReport = reportObj.getDtForReportStatement(); dtReport.TableName = "ReportSaleStatement"; DataRow drReport; DataTable dtReportStatement = (DataTable)Session["dtReportStatement"]; if (dtReportStatement.Rows.Count > 0) { int saleNo = 0; for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++) { drReport = dtReport.NewRow(); drReport["SL_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].ToString()); drReport["SL_DT"] = dtReportStatement.Rows[looper]["SL_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_DT"].ToString(); drReport["SL_TYPE"] = dtReportStatement.Rows[looper]["SL_TYPE"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_TYPE"].ToString(); drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].ToString(); drReport["MOBILE1"] = dtReportStatement.Rows[looper]["MOBILE1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["MOBILE1"].ToString(); drReport["NID"] = dtReportStatement.Rows[looper]["NID"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["NID"].ToString(); drReport["MONY_RECT_NO"] = dtReportStatement.Rows[looper]["MONY_RECT_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["MONY_RECT_NO"].ToString(); drReport["TIN"] = dtReportStatement.Rows[looper]["TIN"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TIN"].ToString(); if (!dtReportStatement.Rows[looper]["REG_TYPE"].Equals(DBNull.Value)) { drReport["REG_TYPE"] = reportObj.getRegTypeFullName(dtReportStatement.Rows[looper]["REG_TYPE"].ToString()).ToString(); } drReport["JNT_NAME"] = dtReportStatement.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["JNT_NAME"].ToString(); drReport["ADDRS1"] = dtReportStatement.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS1"].ToString(); drReport["ADDRS2"] = dtReportStatement.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS2"].ToString(); drReport["CITY"] = dtReportStatement.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CITY"].ToString(); drReport["REG_NO"] = dtReportStatement.Rows[looper]["REG_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REG_NO"].ToString(); DataTable dtNominee = reportObj.dtNominee(dtReportStatement.Rows[looper]["REG_BK"].ToString(), dtReportStatement.Rows[looper]["REG_BR"].ToString(), Convert.ToInt32(dtReportStatement.Rows[looper]["RG_NO"].ToString())); if (dtNominee.Rows.Count > 0) { for (int loop = 0; loop < dtNominee.Rows.Count; loop++) { if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 1) { drReport["NOMI1_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString(); } else if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 2) { drReport["NOMI2_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString(); } } } if (CDSStatus.ToString() == "Y") { drReport["DRF_REF_NO"] = dtReportStatement.Rows[looper]["DRF_REF_NO"]; drReport["DRF_REG_FOLIO_NO"] = dtReportStatement.Rows[looper]["DRF_REG_FOLIO_NO"]; drReport["DRF_CERT_NO"] = dtReportStatement.Rows[looper]["DRF_CERT_NO"]; drReport["DRF_DISTNCT_NO_FROM"] = dtReportStatement.Rows[looper]["DRF_DISTNCT_NO_FROM"]; drReport["DRF_DISTNCT_NO_TO"] = dtReportStatement.Rows[looper]["DRF_DISTNCT_NO_TO"]; drReport["DRF_CUST_REQ_DATE"] = dtReportStatement.Rows[looper]["DRF_CUST_REQ_DATE"]; drReport["DRF_ACCEPT_NO"] = dtReportStatement.Rows[looper]["DRF_ACCEPT_NO"]; drReport["DRF_DRN"] = dtReportStatement.Rows[looper]["DRF_DRN"]; drReport["DRF_ACCEPT_DATE"] = dtReportStatement.Rows[looper]["DRF_ACCEPT_DATE"]; drReport["DRF_TR_SEQ_NO"] = dtReportStatement.Rows[looper]["DRF_TR_SEQ_NO"]; drReport["DRF_TR_DATE"] = dtReportStatement.Rows[looper]["DRF_TR_DATE"]; drReport["BO"] = dtReportStatement.Rows[looper]["HOLDER_BO"]; } else { saleNo = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].ToString()); drReport["CERT_DLVRY_DT"] = dtReportStatement.Rows[looper]["CERT_DLVRY_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CERT_DLVRY_DT"].ToString(); drReport["CERT_RCV_BY"] = dtReportStatement.Rows[looper]["CERT_RCV_BY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CERT_RCV_BY"].ToString(); drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM SALE_CERT WHERE SL_NO=" + saleNo + " AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' ORDER BY CERT_TYPE ", fundCode.ToString()).ToString(); } if (!dtReportStatement.Rows[looper]["BK_FLAG"].Equals(DBNull.Value)) { if (string.Compare(dtReportStatement.Rows[looper]["BK_FLAG"].ToString(), "Y", true) == 0) { if (!dtReportStatement.Rows[looper]["BK_NM_CD"].Equals(DBNull.Value) && !dtReportStatement.Rows[looper]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtReportStatement.Rows[looper]["BK_AC_NO"].Equals(DBNull.Value)) { drReport["BK_AC_NO"] = dtReportStatement.Rows[looper]["BK_AC_NO"].ToString(); drReport["BANK_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString())).ToString(); drReport["BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtReportStatement.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString(); drReport["BRANCH_ADDRESS"] = reportObj.getBankBranchAddressByCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtReportStatement.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString(); } else { } } } drReport["CIP"] = dtReportStatement.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CIP"].ToString(); drReport["ID_AC"] = dtReportStatement.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ID_AC"].ToString(); drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString()); drReport["RATE"] = decimal.Parse(dtReportStatement.Rows[looper]["RATE"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["RATE"].ToString()); drReport["AMOUNT"] = decimal.Parse(dtReportStatement.Rows[looper]["AMOUNT"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["AMOUNT"].ToString()); dtReport.Rows.Add(drReport); } //dtReport.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitReportForStatement.xsd"); if (CDSStatus.ToString() == "Y") { sale_Statement_CDS.Refresh(); sale_Statement_CDS.SetDataSource(dtReport); sale_Statement_CDS.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString())); sale_Statement_CDS.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString()); sale_Statement_CDS.SetParameterValue("branchCode", branchCode.ToString()); CrystalReportViewer1.ReportSource = sale_Statement_CDS; } else { sale_Statement.Refresh(); sale_Statement.SetDataSource(dtReport); sale_Statement.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString())); sale_Statement.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString()); sale_Statement.SetParameterValue("branchCode", branchCode.ToString()); CrystalReportViewer1.ReportSource = sale_Statement; } } else { Response.Write("No data found"); } }
protected void Page_Load(object sender, EventArgs e) { string fundCodeStatement = ""; string branchCodeStatement = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); branchCodeStatement = (string)Session["branchCodeStatement"]; fundCodeStatement = (string)Session["fundCodeStatement"]; DataTable dtUnitHolderInfo = reportObj.getDtHolderInfo(); dtUnitHolderInfo.TableName = "UnitHolderStatementAfterClosing"; DataRow drUnitHolderInfo; DataTable dtHolderInfo = (DataTable)Session["dtStatementAfterClosing"]; if (dtHolderInfo.Rows.Count > 0) { for (int looper = 0; looper < dtHolderInfo.Rows.Count; looper++) { drUnitHolderInfo = dtUnitHolderInfo.NewRow(); drUnitHolderInfo["REG_NO"] = dtHolderInfo.Rows[looper]["REGI_NUMBER"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["REGI_NUMBER"].ToString(); drUnitHolderInfo["HNAME"] = dtHolderInfo.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["HNAME"].ToString(); drUnitHolderInfo["REG_BR_NAME"] = dtHolderInfo.Rows[looper]["REG_BR"].Equals(DBNull.Value) ? "" : opendMFDAO.GetBranchName(dtHolderInfo.Rows[looper]["REG_BR"].ToString()); drUnitHolderInfo["BEFTN"] = dtHolderInfo.Rows[looper]["BEFTN"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString(); drUnitHolderInfo["ADDRS1"] = dtHolderInfo.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ADDRS1"].ToString(); drUnitHolderInfo["ADDRS2"] = dtHolderInfo.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ADDRS2"].ToString(); drUnitHolderInfo["CITY"] = dtHolderInfo.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["CITY"].ToString(); drUnitHolderInfo["TIN"] = dtHolderInfo.Rows[looper]["TIN"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["TIN"].ToString(); drUnitHolderInfo["PASS_NO"] = dtHolderInfo.Rows[looper]["PASS_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString(); drUnitHolderInfo["BIRTH_CERT_NO"] = dtHolderInfo.Rows[looper]["BIRTH_CERT_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString(); drUnitHolderInfo["BIRTH_CERT_NO"] = dtHolderInfo.Rows[looper]["BIRTH_CERT_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString(); drUnitHolderInfo["NID"] = dtHolderInfo.Rows[looper]["NID"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["NID"].ToString(); drUnitHolderInfo["BALANCE"] = Convert.ToInt32(dtHolderInfo.Rows[looper]["BALANCE"].Equals(DBNull.Value) ? "0" : dtHolderInfo.Rows[looper]["BALANCE"].ToString()); drUnitHolderInfo["JNT_NAME"] = dtHolderInfo.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_NAME"].ToString(); drUnitHolderInfo["CIP"] = dtHolderInfo.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["CIP"].ToString(); if (!dtHolderInfo.Rows[looper]["CIP"].Equals(DBNull.Value)) { if (string.Compare(dtHolderInfo.Rows[looper]["CIP"].ToString(), "Y", true) == 0) { drUnitHolderInfo["CIP"] = "YES"; } else if (string.Compare(dtHolderInfo.Rows[looper]["CIP"].ToString(), "N", true) == 0) { drUnitHolderInfo["CIP"] = "NO"; } } if (!dtHolderInfo.Rows[looper]["ID_FLAG"].Equals(DBNull.Value)) { if (string.Compare(dtHolderInfo.Rows[looper]["ID_FLAG"].ToString(), "Y", true) == 0) { drUnitHolderInfo["ID_FLAG"] = "YES"; drUnitHolderInfo["ID_AC"] = dtHolderInfo.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ID_AC"].ToString(); drUnitHolderInfo["ID_INTSTITUTE_NAME"] = dtHolderInfo.Rows[looper]["BANK_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BANK_NAME"].ToString(); drUnitHolderInfo["ID_INTSTITUTE_BRANCH_NAME"] = dtHolderInfo.Rows[looper]["BRANCH_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BRANCH_NAME"].ToString(); } else if (string.Compare(dtHolderInfo.Rows[looper]["ID_FLAG"].ToString(), "N", true) == 0) { drUnitHolderInfo["ID_FLAG"] = "NO"; } } if (!dtHolderInfo.Rows[looper]["BK_FLAG"].Equals(DBNull.Value)) { if (string.Compare(dtHolderInfo.Rows[looper]["BK_FLAG"].ToString(), "Y", true) == 0) { if (!dtHolderInfo.Rows[looper]["BK_NM_CD"].Equals(DBNull.Value) && !dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtHolderInfo.Rows[looper]["BK_AC_NO"].Equals(DBNull.Value)) { drUnitHolderInfo["BK_AC_NO"] = dtHolderInfo.Rows[looper]["BK_AC_NO"].ToString(); drUnitHolderInfo["BANK_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString())).ToString(); drUnitHolderInfo["BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString(); drUnitHolderInfo["BRANCH_ADDRESS"] = reportObj.getBankBranchAddressByCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString(); } else { string branchAddress = ""; string BankAccInfo = dtHolderInfo.Rows[looper]["SPEC_IN1"].ToString() + dtHolderInfo.Rows[looper]["SPEC_IN2"].ToString(); string[] BankAccountInfo = BankAccInfo.Split(','); if (BankAccountInfo.Length > 0) { drUnitHolderInfo["BK_AC_NO"] = BankAccountInfo[0].ToString(); if (BankAccountInfo.Length > 1) { drUnitHolderInfo["BANK_NAME"] = BankAccountInfo[1].ToString(); } if (BankAccountInfo.Length > 2) { drUnitHolderInfo["BRANCH_NAME"] = BankAccountInfo[2].ToString(); } if (BankAccountInfo.Length > 3) { for (int loop = 3; loop < BankAccountInfo.Length; loop++) { branchAddress = branchAddress + BankAccountInfo[loop].ToString(); } drUnitHolderInfo["BRANCH_ADDRESS"] = branchAddress; } } } } } DataTable dtNominee = reportObj.dtNominee(dtHolderInfo.Rows[looper]["REG_BK"].ToString(), dtHolderInfo.Rows[looper]["REG_BR"].ToString(), Convert.ToInt32(dtHolderInfo.Rows[looper]["REG_NO"].ToString())); if (dtNominee.Rows.Count > 0) { for (int loop = 0; loop < dtNominee.Rows.Count; loop++) { if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 1) { drUnitHolderInfo["NOMI1_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString(); } else if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 2) { drUnitHolderInfo["NOMI2_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString(); } } } dtUnitHolderInfo.Rows.Add(drUnitHolderInfo); } //dtUnitHolderInfo.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2008\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitHolderStatementAfterClosing.xsd"); CR_StatementAfterClosing.Refresh(); CR_StatementAfterClosing.SetDataSource(dtUnitHolderInfo); CR_StatementAfterClosing.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCodeStatement.ToString())); CR_StatementAfterClosing.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCodeStatement.ToString())); CrystalReportViewer1.ReportSource = CR_StatementAfterClosing; //CR_StatementAfterClosing.Close(); //CR_StatementAfterClosing.Dispose(); } else { Response.Write("No data found"); } }
protected void Page_Load(object sender, EventArgs e) { string fundCode = ""; string branchCode = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); branchCode = (string)Session["branchCode"]; fundCode = (string)Session["fundCode"]; DataTable dtReport = reportObj.getDtForReportStatement(); dtReport.TableName = "ReportStatement"; DataRow drReport; DataTable dtReportStatement = (DataTable)Session["dtReportStatement"]; if (dtReportStatement.Rows.Count > 0) { int repNo = 0; string SL_TR_NO = ""; for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++) { drReport = dtReport.NewRow(); drReport["REP_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["REP_NO"].ToString()); drReport["REP_DT"] = dtReportStatement.Rows[looper]["REP_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REP_DT"].ToString(); drReport["SL_TR_REP_NO"] = dtReportStatement.Rows[looper]["SL_TR_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_TR_NO"].ToString(); drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].ToString(); drReport["JNT_NAME"] = dtReportStatement.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["JNT_NAME"].ToString(); drReport["ADDRS1"] = dtReportStatement.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS1"].ToString(); drReport["ADDRS2"] = dtReportStatement.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS2"].ToString(); drReport["CITY"] = dtReportStatement.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CITY"].ToString(); drReport["REG_NO"] = dtReportStatement.Rows[looper]["REG_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REG_NO"].ToString(); drReport["BO"] = dtReportStatement.Rows[looper]["BO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BO"].ToString(); repNo = Convert.ToInt32(dtReportStatement.Rows[looper]["REP_NO"].ToString()); SL_TR_NO = dtReportStatement.Rows[looper]["SL_TR_NO"].ToString(); drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM REP_CERT_NO WHERE REP_NO=" + repNo + " AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' AND SL_TR_NO='" + SL_TR_NO.ToString() + "'", fundCode.ToString()).ToString(); drReport["CIP"] = dtReportStatement.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CIP"].ToString(); // drReport["ID_AC"] = dtReportStatement.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ID_AC"].ToString(); drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString()); drReport["RATE"] = decimal.Parse(dtReportStatement.Rows[looper]["RATE"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["RATE"].ToString()); drReport["AMOUNT"] = decimal.Parse(dtReportStatement.Rows[looper]["AMOUNT"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["AMOUNT"].ToString()); dtReport.Rows.Add(drReport); } // dtReport.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitReportForStatement.xsd"); rep_Statement.Refresh(); rep_Statement.SetDataSource(dtReport); rep_Statement.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString())); rep_Statement.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString()); rep_Statement.SetParameterValue("branchCode", branchCode.ToString()); CrystalReportViewer1.ReportSource = rep_Statement; //ReportDocument rdoc = new ReportDocument(); //string Path = Server.MapPath("Report/rptRepStatement.rpt"); //rdoc.Load(Path); //rdoc.SetDataSource(dtReport); //CrystalReportViewer1.ReportSource = rdoc; //rdoc.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString())); //rdoc.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString()); //rdoc.SetParameterValue("branchCode", branchCode.ToString()); } else { Response.Write("No data found"); } }
protected void Page_Load(object sender, EventArgs e) { string fundCode = ""; string branchCode = ""; string regiNo = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); branchCode = (string)Session["branchCode"]; fundCode = (string)Session["fundCode"]; regiNo = (string)Session["regiNo"]; DataTable dtLedgerForReport = (DataTable)Session["dtLedgerForReport"]; dtLedgerForReport.TableName = "dtLedgerForReport"; if (dtLedgerForReport.Rows.Count > 0) { UnitHolderRegistration unitRegObj = new UnitHolderRegistration(); unitRegObj.FundCode = fundCode.ToString(); unitRegObj.BranchCode = branchCode.ToString(); unitRegObj.RegNumber = regiNo.ToString(); DataTable dtLedgerRegInfo = opendMFDAO.getDtRegInfo(unitRegObj); dtLedgerRegInfo.TableName = "dtLedgerRegInfo"; string regiNumber = dtLedgerRegInfo.Rows[0]["REG_BK"].ToString() + "/" + dtLedgerRegInfo.Rows[0]["REG_BR"].ToString() + "/" + dtLedgerRegInfo.Rows[0]["REG_NO"].ToString(); string holderName = dtLedgerRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["HNAME"].ToString(); string JointHolderName = dtLedgerRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["JNT_NAME"].ToString(); string address1 = dtLedgerRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["ADDRS1"].ToString(); string address2 = dtLedgerRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["ADDRS2"].ToString(); string city = dtLedgerRegInfo.Rows[0]["CITY"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["CITY"].ToString(); string cip = dtLedgerRegInfo.Rows[0]["CIP"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["CIP"].Equals("Y") ? "YES":"NO"; string regType = dtLedgerRegInfo.Rows[0]["REG_TYPE"].Equals(DBNull.Value) ? "" : reportObj.getRegTypeFullName(dtLedgerRegInfo.Rows[0]["REG_TYPE"].ToString()); string BO_Folio = ""; if (!dtLedgerRegInfo.Rows[0]["BO"].Equals(DBNull.Value)) { BO_Folio = dtLedgerRegInfo.Rows[0]["BO"].ToString(); } else if (!dtLedgerRegInfo.Rows[0]["FOLIO_NO"].Equals(DBNull.Value)) { BO_Folio = dtLedgerRegInfo.Rows[0]["FOLIO_NO"].ToString(); } string BEFTN = ""; if (!dtLedgerRegInfo.Rows[0]["IS_BEFTN"].Equals(DBNull.Value)) { BEFTN = dtLedgerRegInfo.Rows[0]["IS_BEFTN"].Equals("Y") ? "YES" : "NO"; } string ETIN = dtLedgerRegInfo.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtLedgerRegInfo.Rows[0]["TIN"].ToString(); //dtLedgerForReport. WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtLedgerForReport.xsd"); CR_Ledger.Refresh(); CR_Ledger.SetDataSource(dtLedgerForReport); CR_Ledger.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString())); CR_Ledger.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString()); CR_Ledger.SetParameterValue("branchCode", branchCode.ToString()); CR_Ledger.SetParameterValue("Regi_No", regiNumber); CR_Ledger.SetParameterValue("Holder_Name", holderName.ToString()); CR_Ledger.SetParameterValue("Jholder_name", JointHolderName.ToString()); CR_Ledger.SetParameterValue("Address1", address1.ToString()); CR_Ledger.SetParameterValue("Address2", address2.ToString()); CR_Ledger.SetParameterValue("City", city.ToString()); CR_Ledger.SetParameterValue("Cip", cip.ToString()); CR_Ledger.SetParameterValue("Reg_Type", regType.ToString()); CR_Ledger.SetParameterValue("BO_Folio", BO_Folio.ToString()); CR_Ledger.SetParameterValue("BEFTN", BEFTN.ToString()); CR_Ledger.SetParameterValue("ETIN", ETIN.ToString()); CrystalReportViewer1.ReportSource = CR_Ledger; } else { Response.Write("No data found"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserID"] == null) { Session.RemoveAll(); Response.Redirect("../../Default.aspx"); } string regNo = ""; string fundCode = ""; string branchCode = ""; string unitHolderName = ""; string branchName = ""; string fundName = ""; if (Request.QueryString["reg"] != null) { regNo = Request.QueryString["reg"].ToString(); } if (Request.QueryString["fund"] != null) { fundName = omfDAOObj.GetFundName(Request.QueryString["fund"].ToString()); fundCode = Request.QueryString["fund"].ToString(); } if (Request.QueryString["branch"] != null) { branchName = omfDAOObj.GetBranchName(Request.QueryString["branch"].ToString()); branchCode = Request.QueryString["branch"].ToString(); } if (regNo != "" && fundCode != "" && branchCode != "") { unitHolderName = omfDAOObj.GetHolderName(fundCode, branchCode, regNo); regObj.RegNumber = regNo; regObj.FundCode = fundCode.ToString(); regObj.BranchCode = branchCode.ToString(); } tdBranch.InnerHtml = "<span style=\"color:Green\"><b>" + unitLienBLObj.totalLienAmount(regObj).ToString() + "</b></span>"; tdFund.InnerHtml = "<span style=\"color:Green\"><b>" + fundName.ToString() + "</b></span>"; tdHolderName.InnerHtml = "<span style=\"color:Green\"><b>" + unitHolderName.ToString() + "</b></span>"; tdReg.InnerHtml = "<span style=\"color:Green\"><b>" + fundCode.ToString() + "/" + branchCode.ToString() + "/" + regNo.ToString() + "</b></span>"; StringBuilder sbInnerString = new StringBuilder(); DataTable dtLienDetails = unitLienBLObj.dtLienDetailsCertificate(regObj); DataTable dtLienBankDetails = new DataTable(); if (dtLienDetails.Rows.Count > 0) { sbInnerString.Append("<table width=\"800\" align=\"center\">"); sbInnerString.Append("<colgroup width=\"120\"></colgroup>"); sbInnerString.Append("<colgroup width=\"120\"></colgroup>"); sbInnerString.Append("<colgroup width=\"120\"></colgroup>"); sbInnerString.Append("<colgroup width=\"120\"></colgroup>"); sbInnerString.Append("<tr>"); sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> LIEN NUMBER </b></span></td>"); // sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> LIEN DATE </b></span></td>"); sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> TRANSACTION NUMBER</b></span></td>"); sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> CERTIFICATE </b></span></td>"); sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b>WEIGHT </b></span></td>"); sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b>LIEN INSTITUTION </b></span></td>"); sbInnerString.Append("</tr>"); for (int looper = 0; looper < dtLienDetails.Rows.Count; looper++) { unitLienObj = new UnitLien(); unitLienObj.LienNo = Convert.ToInt32(dtLienDetails.Rows[looper]["LIEN_NO"].ToString()); dtLienBankDetails = unitLienBLObj.dtLienDetailsInfo(regObj, unitLienObj); sbInnerString.Append("<tr>"); sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["LIEN_NO"].ToString() + " </b></td>"); //sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["LN_REQ_DT"].ToString() + " </b></td>"); sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b> " + dtLienDetails.Rows[looper]["SL_TR_NO"].ToString() + "</b></td>"); sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["CERTIFICATE"].ToString() + " </b></td>"); sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["QTY"].ToString() + " </b></td>"); sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + reportObj.getBankNameByBankCode(Convert.ToInt16(dtLienBankDetails.Rows[0]["LN_BK_CODE"].ToString())) + "," + reportObj.getBankBranchNameByCode(Convert.ToInt16(dtLienBankDetails.Rows[0]["LN_BK_CODE"].ToString()), Convert.ToInt16(dtLienBankDetails.Rows[0]["LN_BK_BR_CODE"].ToString())) + " </b></td>"); sbInnerString.Append("</tr>"); } sbInnerString.Append("</table>"); tdLeinDetails.InnerHtml = sbInnerString.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { string FundCode = ""; string BranchCode = ""; string UserName = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; UserID = bcContent.LoginID; FundCode = bcContent.FundCode; BranchCode = bcContent.BranchCode; UserName = bcContent.LoginUserName; CDSStatus = bcContent.CDS.ToString().ToUpper(); if (!IsPostBack) { DataTable dt = this.BindMenuData(0); DynamicMenuControlPopulation(dt, 0, null); if (FundCode == null || BranchCode == null) { Response.Redirect("../Default.aspx"); } else { string cssColourCode = opendMFDAO.getFundCSSColourCode(FundCode.ToUpper()); tdFundName.InnerHtml = "<span style=\"color:" + cssColourCode + ";\">" + opendMFDAO.GetFundName(FundCode) + "</span>"; tdUser.InnerHtml = "<span style=\"color:" + cssColourCode + "\"> User: <b>" + UserName + "</b></span>"; tdBranch.InnerHtml = "<span style=\"color:" + cssColourCode + "\">Branch: <b>" + opendMFDAO.GetBranchName(BranchCode) + "</b></span>"; } } }
protected void Page_Load(object sender, EventArgs e) { string fundCode = ""; string branchCode = ""; if (BaseContent.IsSessionExpired()) { Response.Redirect("../../Default.aspx"); return; } bcContent = (BaseClass)Session["BCContent"]; userObj.UserID = bcContent.LoginID.ToString(); branchCode = (string)Session["branchCode"]; fundCode = (string)Session["fundCode"]; DataTable dtReport = reportObj.getDtForReportStatement(); dtReport.TableName = "ReportStatement"; DataRow drReport; DataTable dtReportStatement = (DataTable)Session["dtReportStatement"]; if (dtReportStatement.Rows.Count > 0) { int saleNo = 0; for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++) { drReport = dtReport.NewRow(); drReport["SL_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].ToString()); drReport["SL_DT"] = dtReportStatement.Rows[looper]["SL_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_DT"].ToString(); drReport["SL_TYPE"] = dtReportStatement.Rows[looper]["SL_TYPE"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_TYPE"].ToString(); drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].ToString(); if (!dtReportStatement.Rows[looper]["REG_TYPE"].Equals(DBNull.Value)) { drReport["REG_TYPE"] = reportObj.getRegTypeFullName(dtReportStatement.Rows[looper]["REG_TYPE"].ToString()).ToString(); } drReport["JNT_NAME"] = dtReportStatement.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["JNT_NAME"].ToString(); drReport["ADDRS1"] = dtReportStatement.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS1"].ToString(); drReport["ADDRS2"] = dtReportStatement.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS2"].ToString(); drReport["CITY"] = dtReportStatement.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CITY"].ToString(); drReport["REG_NO"] = dtReportStatement.Rows[looper]["REG_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REG_NO"].ToString(); drReport["CERT_DLVRY_DT"] = dtReportStatement.Rows[looper]["CERT_DLVRY_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CERT_DLVRY_DT"].ToString(); drReport["CERT_RCV_BY"] = dtReportStatement.Rows[looper]["CERT_RCV_BY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CERT_RCV_BY"].ToString(); DataTable dtNominee = reportObj.dtNominee(dtReportStatement.Rows[looper]["REG_BK"].ToString(), dtReportStatement.Rows[looper]["REG_BR"].ToString(), Convert.ToInt32(dtReportStatement.Rows[looper]["RG_NO"].ToString())); if (dtNominee.Rows.Count > 0) { for (int loop = 0; loop < dtNominee.Rows.Count; loop++) { if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 1) { drReport["NOMI1_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString(); } else if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 2) { drReport["NOMI2_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString(); } } } saleNo = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].ToString()); drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM SALE_CERT WHERE SL_NO=" + saleNo + " AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "'", fundCode.ToString()).ToString(); //if (!dtReportStatement.Rows[looper]["BK_FLAG"].Equals(DBNull.Value)) //{ // if (string.Compare(dtReportStatement.Rows[looper]["BK_FLAG"].ToString(), "Y", true) == 0) // { // if (!dtReportStatement.Rows[looper]["BK_NM_CD"].Equals(DBNull.Value) && !dtReportStatement.Rows[looper]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtReportStatement.Rows[looper]["BK_AC_NO"].Equals(DBNull.Value)) // { // drReport["BK_AC_NO"] = dtReportStatement.Rows[looper]["BK_AC_NO"].ToString(); // drReport["BANK_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString())).ToString(); // drReport["BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtReportStatement.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString(); // drReport["BRANCH_ADDRESS"] = reportObj.getBankBranchAddressByCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtReportStatement.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString(); // } // else // { // string branchAddress = ""; // string BankAccInfo = dtReportStatement.Rows[looper]["SPEC_IN1"].ToString() + dtReportStatement.Rows[looper]["SPEC_IN2"].ToString(); // string[] BankAccountInfo = BankAccInfo.Split(','); // if (BankAccountInfo.Length > 0) // { // drReport["BK_AC_NO"] = BankAccountInfo[0].ToString(); // if (BankAccountInfo.Length > 1) // { // drReport["BANK_NAME"] = BankAccountInfo[1].ToString(); // } // if (BankAccountInfo.Length > 2) // { // drReport["BRANCH_NAME"] = BankAccountInfo[2].ToString(); // } // if (BankAccountInfo.Length > 3) // { // for (int loop = 3; loop < BankAccountInfo.Length; loop++) // { // branchAddress = branchAddress + BankAccountInfo[loop].ToString(); // } // drReport["BRANCH_ADDRESS"] = branchAddress; // } // } // } // } //} drReport["CIP"] = dtReportStatement.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CIP"].ToString(); drReport["BO"] = dtReportStatement.Rows[looper]["BO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BO"].ToString(); drReport["TIN"] = dtReportStatement.Rows[looper]["TIN"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TIN"].ToString(); drReport["BEFTN"] = dtReportStatement.Rows[looper]["BEFTN"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BEFTN"].ToString(); drReport["ID_AC"] = dtReportStatement.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ID_AC"].ToString(); drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString()); drReport["RATE"] = decimal.Parse(dtReportStatement.Rows[looper]["RATE"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["RATE"].ToString()); drReport["AMOUNT"] = decimal.Parse(dtReportStatement.Rows[looper]["AMOUNT"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["AMOUNT"].ToString()); dtReport.Rows.Add(drReport); } //dtReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitReportForStatement.xsd"); CRSaleLedger.Refresh(); CRSaleLedger.SetDataSource(dtReport); CRSaleLedger.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString())); CRSaleLedger.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString()); CRSaleLedger.SetParameterValue("branchCode", branchCode.ToString()); CrystalReportViewer1.ReportSource = CRSaleLedger; } else { Response.Write("No data found"); } }