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());
}
}
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();
}
}
