protected void LienMarkDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
unitLienObj.LienNo = Convert.ToInt32(LienMarkDropDownList.SelectedValue.ToString());
DataTable dtLienDetails = unitLienBLObj.dtLienDetailsInfo(unitRegObj, unitLienObj);
if (dtLienDetails.Rows.Count > 0)
{
LienbankNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_CODE"].ToString();
LienbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtLienDetails.Rows[0]["LN_BK_CODE"].ToString()));
LienbranchNameDropDownList.DataTextField = "BRANCH_NAME";
LienbranchNameDropDownList.DataValueField = "BRANCH_CODE";
LienbranchNameDropDownList.DataBind();
LienbranchNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_BR_CODE"].ToString();
LienReqDateTextBox.Text = dtLienDetails.Rows[0]["LN_REQ_DT"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtLienDetails.Rows[0]["LN_REQ_DT"].ToString()).ToString("dd-MMM-yyyy");
LienReqRefTextBox.Text = dtLienDetails.Rows[0]["LN_REQ_REF"].Equals(DBNull.Value) ? "" : dtLienDetails.Rows[0]["LN_REQ_REF"].ToString();
}
else
{
}
}
protected void findButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
HolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
HolderJNameTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
DataTable dtLienNumbers = unitLienBLObj.dtTotalLien(unitRegObj);
if (dtLienNumbers.Rows.Count > 1)
{
LienMarkDropDownList.DataSource = dtLienNumbers;
LienMarkDropDownList.DataTextField = "LIEN_NO";
LienMarkDropDownList.DataValueField = "ID";
LienMarkDropDownList.DataBind();
}
else
{
LienMarkDropDownList.DataSource = dtLienNumbers;
LienMarkDropDownList.DataTextField = "LIEN_NO";
LienMarkDropDownList.DataValueField = "ID";
LienMarkDropDownList.DataBind();
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Liened Units');", true);
}
}
}
public DataTable dtLienDetailsInfo(UnitHolderRegistration unitRegObj, UnitLien unitLienObj)
{
DataTable dtLienDetailsInfo = new DataTable();
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append("SELECT * FROM LIEN_MARK WHERE REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_BK = '" + unitRegObj.FundCode.ToString() + "'");
sbQuery.Append(" AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber) + " AND LIEN_NO='" + unitLienObj.LienNo.ToString() + "'");
dtLienDetailsInfo = commonGatewayObj.Select(sbQuery.ToString());
return(dtLienDetailsInfo);
}
public DataTable dtTotalLienCert(UnitHolderRegistration unitRegObj, UnitLien unitLienObj)
{
DataTable dtTotalSaleUnitCerts = new DataTable();
StringBuilder sbQueryString = new StringBuilder();
sbQueryString.Append(" SELECT SL_TR_NO AS SL_NO,CERTIFICATE,QTY FROM LIEN_MARK_CERT_NO WHERE LN_MK_CANCEL IS NULL AND REG_BR='" + unitRegObj.BranchCode.ToString() + "'");
sbQueryString.Append(" AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_NO=" + Convert.ToInt32(unitRegObj.RegNumber) + " AND LIEN_NO='" + unitLienObj.LienNo.ToString() + "'");
dtTotalSaleUnitCerts = commonGatewayObj.Select(sbQueryString.ToString());
return(dtTotalSaleUnitCerts);
}
protected void LienMarkDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
unitLienObj.LienNo = Convert.ToInt32(LienMarkDropDownList.SelectedValue.ToString());
DataTable dtLienCerts = unitLienBLObj.dtTotalLienCert(unitRegObj, unitLienObj);
long totalLienAmount = unitLienBLObj.totalLienAmount(unitRegObj, unitLienObj);
DataTable dtLienDetails = unitLienBLObj.dtLienDetailsInfo(unitRegObj, unitLienObj);
if (dtLienDetails.Rows.Count > 0)
{
LienbankNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_CODE"].ToString();
LienbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtLienDetails.Rows[0]["LN_BK_CODE"].ToString()));
LienbranchNameDropDownList.DataTextField = "BRANCH_NAME";
LienbranchNameDropDownList.DataValueField = "BRANCH_CODE";
LienbranchNameDropDownList.DataBind();
LienbranchNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_BR_CODE"].ToString();
if (dtLienCerts.Rows.Count > 0)
{
dvContentBottom.Visible = true;
leftDataGrid.DataSource = dtLienCerts;
leftDataGrid.DataBind();
TotalLienUnitHoldingTextBox.Text = totalLienAmount.ToString();
}
else
{
TotalLienUnitHoldingTextBox.Text = "";
TotalUnitLienCancelTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien Cancel ');", true);
}
LienMarkCancelNoTextBox.Text = unitLienBLObj.getNextLienCancelNo(unitRegObj, userObj).ToString();
unitLienObj.LienCancelNo = unitLienBLObj.getNextLienCancelNo(unitRegObj, userObj) - 1;
LienCancelReqDateTextBox.Text = unitLienBLObj.getLastLienCancelReqDate(unitRegObj, unitLienObj).ToString("dd-MMM-yyyy");
}
else
{
TotalLienUnitHoldingTextBox.Text = "";
TotalUnitLienCancelTextBox.Text = "";
dvContentBottom.Visible = false;
LienbankNameDropDownList.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien Cancel ');", true);
}
}
public bool IsDuplicateLien(UnitHolderRegistration regObj, UnitLien unitLienObj)
{
DataTable dtLien = new DataTable();
dtLien = commonGatewayObj.Select("SELECT * FROM LIEN_MARK WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "'AND REG_BR='" + regObj.BranchCode.ToString() + "' AND LIEN_NO='" + unitLienObj.LienNo.ToString() + "'");
if (dtLien.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public DateTime getLastLienCancelReqDate(UnitHolderRegistration regObj, UnitLien unitLienObj)
{
DateTime lastDate;
DataTable dtLastDate = new DataTable();
dtLastDate = commonGatewayObj.Select("SELECT MAX(LIEN_CANCL_DT) AS LIEN_CANCL_DT FROM LIEN_MARK_CANCEL WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "'AND LIEN_NO=" + unitLienObj.LienNo);
if (dtLastDate.Rows.Count > 0)
{
lastDate = Convert.ToDateTime(dtLastDate.Rows[0]["LIEN_CANCL_DT"].Equals(DBNull.Value) ? DateTime.Today.ToString() : dtLastDate.Rows[0]["LIEN_CANCL_DT"].ToString());
}
else
{
lastDate = DateTime.Today;
}
return(lastDate);
}
public long totalLienAmount(UnitHolderRegistration unitRegObj, UnitLien unitLienObj)
{
long totalLien = 0;
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append("SELECT SUM(QTY) AS TOTAL_LIEN FROM LIEN_MARK_CERT_NO WHERE LN_MK_CANCEL IS NULL AND REG_BR='" + unitRegObj.BranchCode.ToString() + "'");
sbQuery.Append(" AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_NO=" + unitRegObj.RegNumber + " AND LIEN_NO='" + unitLienObj.LienNo.ToString() + "'");
DataTable dtTotalLien = commonGatewayObj.Select(sbQuery.ToString());
if (dtTotalLien.Rows.Count > 0)
{
totalLien = dtTotalLien.Rows[0]["TOTAL_LIEN"].Equals(DBNull.Value) ? 0 : Convert.ToInt32(dtTotalLien.Rows[0]["TOTAL_LIEN"].ToString());
}
else
{
totalLien = 0;
}
return(totalLien);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
unitLienObj.LienCancelNo = Convert.ToInt32(LienMarkCancelNoTextBox.Text.Trim().ToString());
unitLienObj.LienNo = Convert.ToInt32(LienMarkDropDownList.SelectedValue.ToString());
unitLienObj.LienInst = Convert.ToInt16(LienbankNameDropDownList.SelectedValue.ToString());
unitLienObj.LienInstBranch = Convert.ToInt32(LienbranchNameDropDownList.SelectedValue.ToString());
unitLienObj.LienRefference = LienCancelReqRefTextBox.Text.Trim().ToString();
unitLienObj.LienCancelReqDate = LienCancelReqDateTextBox.Text.Trim().ToString();
unitLienObj.LienCancelDate = DateTime.Today.ToString();
try
{
if (unitLienBLObj.IsDuplicateLienCancel(regObj, unitLienObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Lien Cancel Number " + "');", true);
}
else
{
long totalSurrenderUnits = 0;
DataTable dtGrid = opendMFDAO.getTableDataGrid();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
drGrid = dtGrid.NewRow();
drGrid["SL_NO"] = gridRow.Cells[1].Text.Trim().ToString();
drGrid["CERTIFICATE"] = gridRow.Cells[2].Text.Trim().ToString();
drGrid["QTY"] = gridRow.Cells[3].Text.Trim().ToString();
totalSurrenderUnits = totalSurrenderUnits + Convert.ToInt64(gridRow.Cells[3].Text.Trim().ToString());
dtGrid.Rows.Add(drGrid);
}
}
if (totalSurrenderUnits == Convert.ToInt64(TotalUnitLienCancelTextBox.Text))
{
unitLienBLObj.saveLienMarkCancel(dtGrid, regObj, unitLienObj, userObj); //save Lien Cancel Data
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid(); // hide remaining Data
leftDataGrid.DataBind();
TotalLienUnitHoldingTextBox.Text = "";
LienMarkDropDownList.SelectedValue = "0";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed : Total Selected Units and Add Total Units is not equal');", true);
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void RegNoTextBox_TextChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
if (opendMFDAO.IsValidRegistration(unitRegObj))
{
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
// DataTable dtTotalSaleUnitCerts = unitLienBLObj.dtTotalLienCert(unitRegObj);
// decimal TotalUnitsBalance = opendMFDAO.getTotalSaleUnitBalance(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
HolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
HolderJNameTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
string[] BranchCodeSign = unitRegObj.BranchCode.Split('/');
string imageSignLocation = Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg";
string imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + "_" + BranchCodeSign[0] + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");
if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg")))
{
SignImage.ImageUrl = imageSignLocation.ToString();
}
else
{
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
}
DataTable dtLienNumbers = unitLienBLObj.dtTotalLien(unitRegObj);
if (dtLienNumbers.Rows.Count > 1)
{
LienMarkDropDownList.DataSource = dtLienNumbers;
LienMarkDropDownList.DataTextField = "LIEN_NO";
LienMarkDropDownList.DataValueField = "ID";
LienMarkDropDownList.DataBind();
}
else
{
LienMarkDropDownList.DataSource = dtLienNumbers;
LienMarkDropDownList.DataTextField = "LIEN_NO";
LienMarkDropDownList.DataValueField = "ID";
LienMarkDropDownList.DataBind();
dvContentBottom.Visible = false;
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien Cancel');", true);
}
}
else
{
dvContentBottom.Visible = false;
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien Cancel');", true);
}
}
else
{
dvContentBottom.Visible = false;
ClearText();
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);
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();
}
}
public void saveLienMark(DataTable dtTransferSaleCert, UnitHolderRegistration regObj, UnitLien unitLienObj, UnitUser unitUserObj)
{
try
{
UnitTransferBL unitTransferBLObj = new UnitTransferBL();
commonGatewayObj.BeginTransaction();
Hashtable htLienRegInfo = new Hashtable();
Hashtable htCertNoTemp = new Hashtable();
int SL_TR_RN = 0;
int CertNo = 0;
string certType = "";
string[] saleNoArray;
string[] certArray;
string statusFlag = "L";
string Old_SL_TR_RN = "";
for (int loop = 0; loop < dtTransferSaleCert.Rows.Count; loop++)
{
if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('S') >= 0)
{
htLienRegInfo = new Hashtable();
htLienRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htLienRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper());
htLienRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString());
htLienRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString());
saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('S');
SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
CertNo = Convert.ToInt32(certArray[1].ToString());
certType = certArray[0].ToString().ToUpper();
commonGatewayObj.Update(htLienRegInfo, "SALE_CERT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND SL_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "S" + SL_TR_RN.ToString();
}
else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('T') >= 0)
{
htLienRegInfo = new Hashtable();
htLienRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htLienRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper());
htLienRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString());
htLienRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString());
saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('T');
SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
CertNo = Convert.ToInt32(certArray[1].ToString());
certType = certArray[0].ToString().ToUpper();
commonGatewayObj.Update(htLienRegInfo, "TRANS_CERT", "F_CD='" + regObj.FundCode.ToString().ToUpper() + "' AND TR_NO=" + SL_TR_RN + " AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
//commonGatewayObj.Update(htLienRegInfo, "SALE_CERT", "CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
//commonGatewayObj.Update(htLienRegInfo, "RENEWAL_OUT", "CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "T" + SL_TR_RN.ToString();
}
else if (dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().ToUpper().IndexOf('R') >= 0)
{
htLienRegInfo = new Hashtable();
htLienRegInfo.Add("CURR_REG_BK", regObj.FundCode.ToString().ToUpper());
htLienRegInfo.Add("CURR_REG_BR", regObj.BranchCode.ToString().ToUpper());
htLienRegInfo.Add("CURR_REG_NO", regObj.RegNumber.ToString());
htLienRegInfo.Add("STATUS_FLAG", statusFlag.ToUpper().ToString());
saleNoArray = dtTransferSaleCert.Rows[loop]["SL_NO"].ToString().Split('R');
SL_TR_RN = Convert.ToInt32(saleNoArray[1].ToString());
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
CertNo = Convert.ToInt32(certArray[1].ToString());
certType = certArray[0].ToString().ToUpper();
commonGatewayObj.Update(htLienRegInfo, "RENEWAL_OUT", "REG_NO=" + Convert.ToInt32(regObj.RegNumber) + " AND REN_NO='" + SL_TR_RN + "' AND REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString().ToUpper() + "' AND CERT_NO=" + CertNo + " AND CERT_TYPE='" + certType + "'");
Old_SL_TR_RN = "R" + SL_TR_RN.ToString();
}
htLienRegInfo = new Hashtable();
htLienRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper());
htLienRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper());
htLienRegInfo.Add("REG_NO", regObj.RegNumber.ToString());
htLienRegInfo.Add("LIEN_NO", Convert.ToInt32(unitLienObj.LienNo.ToString()));
certArray = dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().Split('-');
htLienRegInfo.Add("CERT_TYPE", certArray[0].ToString().ToUpper());
htLienRegInfo.Add("CERT_NO", Convert.ToInt32(certArray[1].ToString()));
htLienRegInfo.Add("CERTIFICATE", dtTransferSaleCert.Rows[loop]["CERTIFICATE"].ToString().ToUpper());
htLienRegInfo.Add("QTY", Convert.ToInt32(dtTransferSaleCert.Rows[loop]["QTY"].ToString()));
htLienRegInfo.Add("SL_TR_NO", Old_SL_TR_RN.ToString().ToUpper());
commonGatewayObj.Insert(htLienRegInfo, "LIEN_MARK_CERT_NO");
}
DataTable dtTransfer = unitTransferBLObj.dtTrnasfer(dtTransferSaleCert);
for (int i = 0; i < dtTransfer.Rows.Count; i++)
{
htLienRegInfo = new Hashtable();
htLienRegInfo.Add("LIEN_NO", Convert.ToInt32(unitLienObj.LienNo.ToString()));
htLienRegInfo.Add("LIEN_DT", Convert.ToDateTime(unitLienObj.LienReqDate.ToString()).ToString("dd-MMM-yyyy"));
htLienRegInfo.Add("LN_REQ_REF", unitLienObj.LienRefference.ToString());
htLienRegInfo.Add("LN_BK_CODE", Convert.ToInt16(unitLienObj.LienInst.ToString()));
htLienRegInfo.Add("LN_BK_BR_CODE", Convert.ToInt16(unitLienObj.LienInstBranch.ToString()));
htLienRegInfo.Add("SL_TR_NO", dtTransfer.Rows[i]["SL_NO"].ToString());
htLienRegInfo.Add("REG_BK", regObj.FundCode.ToString().ToUpper());
htLienRegInfo.Add("REG_BR", regObj.BranchCode.ToString().ToUpper());
htLienRegInfo.Add("REG_NO", regObj.RegNumber.ToString());
htLienRegInfo.Add("QTY", Convert.ToInt32(dtTransfer.Rows[i]["QTY"].ToString()));
htLienRegInfo.Add("USER_NM", unitUserObj.UserID.ToString());
htLienRegInfo.Add("ENT_DT", DateTime.Now.ToString());
htLienRegInfo.Add("ENT_TM", DateTime.Now.ToShortTimeString().ToString());
commonGatewayObj.Insert(htLienRegInfo, "LIEN_MARK");
}
commonGatewayObj.CommitTransaction();
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
throw ex;
}
}
protected void RegNoTextBox_TextChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
if (opendMFDAO.IsValidRegistration(unitRegObj))
{
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
DataTable dtTotalSaleUnitCerts = opendMFDAO.getDtTotalSaleUnitCerts(unitRegObj);
decimal TotalUnitsBalance = opendMFDAO.getTotalSaleUnitBalance(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
HolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
HolderJNameTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
string[] BranchCodeSign = unitRegObj.BranchCode.Split('/');
string imageSignLocation = Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg";
string imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + "_" + BranchCodeSign[0] + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");
if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg")))
{
SignImage.ImageUrl = imageSignLocation.ToString();
}
else
{
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
}
if (dtTotalSaleUnitCerts.Rows.Count > 0)
{
dvContentBottom.Visible = true;
leftDataGrid.DataSource = dtTotalSaleUnitCerts;
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = TotalUnitsBalance.ToString();
}
else
{
// dvContentBottom.Visible = false;
TotalUnitHoldingTextBox.Text = "";
TotalUnitLienTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien ');", true);
}
LienMarkNoTextBox.Text = unitLienBLObj.getNextLienNo(unitRegObj, userObj).ToString();
unitLienObj.LienNo = unitLienBLObj.getNextLienNo(unitRegObj, userObj) - 1;
LienReqDateTextBox.Text = unitLienBLObj.getLastLienReqDate(unitRegObj, unitLienObj).ToString("dd-MMM-yyyy");
}
else
{
//HolderNameTextBox.Text = "";
//HolderJNameTextBox.Text = "";
TotalUnitHoldingTextBox.Text = "";
TotalUnitLienTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien');", true);
}
}
else
{
TotalUnitHoldingTextBox.Text = "";
TotalUnitLienTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
