public void displaySign()
    {
        string regNo          = "";
        string fundCode       = "";
        string branchCode     = "";
        string unitHolderName = "";
        string branchName     = "";
        string fundName       = "";

        regNo      = regNoTextBox.Text.ToString();
        fundName   = opendMFDAO.GetFundName(fundCodeTextBox.Text.ToString());
        fundCode   = fundCodeTextBox.Text.ToString();
        branchName = opendMFDAO.GetBranchName(branchCodeTextBox.Text.ToString());
        branchCode = branchCodeTextBox.Text.ToString();


        unitHolderName = opendMFDAO.GetHolderName(fundCode, branchCode, regNo);


        string[] BranchCodeSign     = branchCode.Split('/');
        string   imageSignLocation  = Path.Combine(ConfigReader.SingLocation + "\\" + fundCode, fundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + regNo + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg";
        string   imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation + "\\" + fundCode, fundCode + "_" + BranchCodeSign[0] + BranchCodeSign[1] + "_" + regNo + ".jpg");

        if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + fundCode, fundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + regNo + ".jpg")))
        {
            SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(imageSignLocation.ToString());
        }
        else
        {
            SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
        }
    }
Esempio n. 2
0
    protected void tfereeRegNoTextBox_TextChanged(object sender, EventArgs e)
    {
        string unitHolderName             = "";
        string branchName                 = "";
        string fundName                   = "";
        UnitHolderRegistration unitRegObj = new UnitHolderRegistration();

        unitRegObj.FundCode   = tfereeFundCodeTextBox.Text.Trim();
        unitRegObj.BranchCode = tfereeBranhCodeTextBox.Text.Trim();
        unitRegObj.RegNumber  = tfereeRegNoTextBox.Text.Trim();
        DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);

        if (dtRegInfo.Rows.Count > 0)
        {
            tfereeHolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();

            tfereejHolderNameTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
            fundName       = opendMFDAO.GetFundName(unitRegObj.FundCode.ToString());
            branchName     = opendMFDAO.GetBranchName(unitRegObj.BranchCode.ToString());
            unitHolderName = opendMFDAO.GetHolderName(unitRegObj.FundCode, unitRegObj.BranchCode, unitRegObj.RegNumber);

            string[] branchCodeSign    = unitRegObj.BranchCode.Split('/');
            string   imageSignLocation = Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + branchCodeSign[0] + "_" + branchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");

            if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode.ToString() + "_" + branchCodeSign[0] + "_" + branchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg")))
            {
                PhotoImage.ImageUrl = encrypt.PhotoBase64ImgSrc(imageSignLocation.ToString());
            }
            else
            {
                PhotoImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
            }

            unitRegObj            = new UnitHolderRegistration();
            unitRegObj.FundCode   = tferorFundCodeTextBox.Text.Trim();
            unitRegObj.BranchCode = tferorBranchCodeTextBox.Text.Trim();
            unitRegObj.RegNumber  = tferorRegNoTextBox.Text.Trim();
            decimal tFerorTotalUnits = opendMFDAO.getTotalSaleUnitBalance(unitRegObj);
            if (tFerorTotalUnits > 0)
            {
                dvContentBottom.Visible = true;
            }
            else
            {
                dvContentBottom.Visible = false;
            }
        }
        else
        {
            PhotoImage.ImageUrl           = "";
            tfereeHolderNameTextBox.Text  = "";
            tfereejHolderNameTextBox.Text = "";
            dvContentBottom.Visible       = false;
            ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
        }
    }
    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 (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();
        }
    }