public DataTable dtGetSaleCertBySaleNo(UnitHolderRegistration unitRegObj, UnitSale unitSaleObj)
{
// DataTable dtDinomination = new DataTable();
DataTable dtDinomination = commonGatewayObj.Select("SELECT * FROM SALE_CERT WHERE SL_NO=" + unitSaleObj.SaleNo + " AND REG_BK='" + unitRegObj.FundCode.ToString() + "' AND REG_BR='" + unitRegObj.BranchCode.ToString() + "' AND REG_NO=" + unitRegObj.RegNumber);
return(dtDinomination);
}
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;
}
}
public bool IsValidSaleNumber(UnitHolderRegistration regObj, UnitSale saleObj)
{
DataTable dtValidSaleNumber = new DataTable();
bool ValidSaleNumber = false;
string queryString = "SELECT * FROM SALE WHERE REG_BK='" + regObj.FundCode.ToString() + "' AND REG_BR='" + regObj.BranchCode + "' AND SL_NO=" + Convert.ToInt32(saleObj.SaleNo.ToString());
dtValidSaleNumber = commonGatewayObj.Select(queryString.ToString());
if (dtValidSaleNumber.Rows.Count > 0)
{
if (dtValidSaleNumber.Rows[0]["SL_NO"].Equals(DBNull.Value))
{
ValidSaleNumber = false;
}
else
{
int SaleNo = Convert.ToInt32(dtValidSaleNumber.Rows[0]["SL_NO"].ToString());
if (saleObj.SaleNo.ToString() == SaleNo.ToString())
{
ValidSaleNumber = true;
}
else
{
ValidSaleNumber = false;
}
}
}
else
{
ValidSaleNumber = false;
}
return(ValidSaleNumber);
}
protected void DeleteButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
Hashtable htUpdateMoneyReceipt = new Hashtable();
try
{
commonGatewayObj.BeginTransaction();
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append("UPDATE MONEY_RECEIPT SET VALID='N' , RECEIPT_EDIT_TYPE='D' , RECEIPT_EDIT_BY='" + userObj.UserID.ToString() + "',");
sbQuery.Append(" RECEIPT_EDIT_DATE='" + DateTime.Today.ToString("dd-MMM-yyyy") + "' WHERE ID=" + moneyReceipDropDownList.SelectedValue.ToString());
commonGatewayObj.ExecuteNonQuery(sbQuery.ToString());
commonGatewayObj.CommitTransaction();
ClearText();
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 AND VALID IS NULL AND ACC_VOUCHER_NO IS NULL ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Delete Success');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Delete Failed');", true);
}
}
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);
}
}
}
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
{
}
}
public DataTable dtTotalLien(UnitHolderRegistration regObj)
{
DataTable dtTotalLien = new DataTable();
dtTotalLien.Columns.Add("ID", typeof(int));
dtTotalLien.Columns.Add("LIEN_NO", typeof(string));
DataRow drTotalLien = dtTotalLien.NewRow();
drTotalLien["ID"] = 0;
drTotalLien["LIEN_NO"] = " ";
dtTotalLien.Rows.Add(drTotalLien);
DataTable dtLien = commonGatewayObj.Select("SELECT DISTINCT TO_NUMBER(LIEN_NO) AS LIEN_NO FROM LIEN_MARK_CERT_NO WHERE LN_MK_CANCEL IS NULL AND REG_BK='" + regObj.FundCode.ToString() + "'AND REG_NO=" + regObj.RegNumber + " AND REG_BR='" + regObj.BranchCode.ToString() + "' ORDER BY TO_NUMBER(LIEN_NO)");
if (dtLien.Rows.Count > 0)
{
for (int loop = 0; loop < dtLien.Rows.Count; loop++)
{
drTotalLien = dtTotalLien.NewRow();
drTotalLien["ID"] = dtLien.Rows[loop]["LIEN_NO"].ToString();
drTotalLien["LIEN_NO"] = dtLien.Rows[loop]["LIEN_NO"].ToString();
dtTotalLien.Rows.Add(drTotalLien);
}
}
return(dtTotalLien);
}
protected void regDeleteButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeTextBox.Text.Trim();
regObj.BranchCode = branchCodeTextBox.Text.Trim();
regObj.RegNumber = regNoTextBox.Text.Trim();
DataTable dtJointHolder = opendMFDAO.dtJointHolderRegInfo(regObj);
try
{
if (dtJointHolder.Rows.Count > 0) //IS Joint holder exist ??
{
unitHolderRegBLObj.DeleteJointHolderInfo(regObj, dtJointHolder, userObj);
ClearText();
regNoTextBox.Focus();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true);
}
else
{
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Joint Holder Information Found to Edit !! Please Entry Joint Holder ');", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
try
{
UnitUser userObj = new UnitUser();
UnitHolderRegistration regObj = new UnitHolderRegistration();
userObj.UserID = UserIDTextBox.Text.Trim().ToString();
userObj.UserPassword = encrypt.Encrypt(oldPasswordTextBox.Text.Trim().ToString());
userObj.UserChangePassword = encrypt.Encrypt(confirmPasswordTextBox.Text.Trim().ToString());
if (string.Compare((string)Session["UserID"].ToString().ToUpper(), UserIDTextBox.Text.Trim().ToString().ToUpper()) == 0 || string.Compare("ADMIN", (string)Session["UserID"].ToString().ToUpper()) == 0)
{
if (!userBLObj.CheckExistUser(userObj))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('Password Change Failed: Invalid User ID or Password');", true);
}
else
{
userBLObj.updateUserPassword(userObj);
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "window.fnReset();alert ('Password Changed Successfully');", true);
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Created Successfully');", true);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('You have no permission to change password for this User');", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('User Create Failed:" + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
public string getPayType(UnitHolderRegistration regObj, UnitRepurchase repObj)
{
DataTable dtpayTypeInfo = commonGatewayObj.Select(" SELECT PAY_TYPE FROM REPURCHASE WHERE REG_BK='" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR='" + regObj.BranchCode.ToString() + "' AND REP_NO=" + repObj.RepurchaseNo);
string payType = dtpayTypeInfo.Rows[0]["PAY_TYPE"].ToString().ToUpper();
return(payType);
}
private void FindRegInfo()
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeTextBox.Text;
regObj.BranchCode = branchCodeTextBox.Text;
regObj.RegNumber = regNoTextBox.Text;
if (opendMFDAO.IsValidRegistration(regObj))
{
DataTable dtHolderRegInfo = opendMFDAO.HolderRegInfo(regObj);
if (dtHolderRegInfo.Rows.Count > 0)
{
NameLabel.Text = dtHolderRegInfo.Rows[0]["HNAME"].ToString();
DateLabel.Text = dtHolderRegInfo.Rows[0]["REG_DT"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtHolderRegInfo.Rows[0]["REG_DT"].ToString()).ToString("dd-MMM-yyyy");
TypeLabel.Text = dtHolderRegInfo.Rows[0]["REG_TYPE"].Equals("N") ? "INDIVIDUAL" : dtHolderRegInfo.Rows[0]["REG_TYPE"].Equals("C") ? "CHARITY" : dtHolderRegInfo.Rows[0]["REG_TYPE"].Equals("I") ? "INSTITUTION" : dtHolderRegInfo.Rows[0]["REG_TYPE"].Equals("F") ? "FOREIGNER" : dtHolderRegInfo.Rows[0]["REG_TYPE"].ToString();
CIPLabel.Text = dtHolderRegInfo.Rows[0]["CIP"].Equals("N") ? "NO" : "YES";
IDLabel.Text = dtHolderRegInfo.Rows[0]["ID_FLAG"].Equals("N") ? "NO" : "YES";
}
else
{
regNoTextBox.Focus();
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Data Found');", true);
}
}
else
{
regNoTextBox.Focus();
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Invalid Registration Number!! Please Enter Valid Registration Number');", true);
}
}
private void ClearText()
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
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();
ReceiptDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
ReceiptNoTextBox.Text = unitSaleBLObj.GetMaxReceiptNo(regObj, "REP").ToString();
regNoTextBox.Text = "";
holderBOTextBox.Text = "";
NameTextBox.Text = "";
addressTextBox.Text = "";
QtyTextBox.Text = "";
// RateTextBox.Text = "";
SaleTRRNNoTextBox.Text = "";
PayDateTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
}
private void ClearText()
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
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();
ReceiptDateTextBox.Text = "";
moneyReceipDropDownList.SelectedValue = "0";
regNoTextBox.Text = "";
holderBOTextBox.Text = "";
NameTextBox.Text = "";
addressTextBox.Text = "";
QtyTextBox.Text = "";
RateTextBox.Text = "";
SaleTRRNNoTextBox.Text = "";
PayDateTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
}
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)
{
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 regDeleteButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeTextBox.Text.Trim();
regObj.BranchCode = branchCodeTextBox.Text.Trim();
regObj.RegNumber = regNoTextBox.Text.Trim();
UnitHolderNominee nomiObj = new UnitHolderNominee();
nomiObj.NomiControlNo = controlNumberTextBox.Text.Trim().ToString().ToUpper();
nomiObj.NomiType = TypeDropDownList.SelectedValue.ToString().ToUpper();
nomiObj.NomiNumber = NomiNumberDropDownList.SelectedValue.ToString();
try
{
unitHolderRegBLObj.DeleteNomineeInfo(regObj, nomiObj, userObj);
ClearText();
regNoTextBox.Focus();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void findButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
regObj.RegNumber = regNoTextBox.Text.Trim();
regObj.BO = holderBOTextBox.Text.ToString().Trim();
regObj.Folio = folioTextBox.Text.Trim();
DataTable dtValidSearch = opendMFDAO.dtValidSearch(regObj);
if (dtValidSearch.Rows.Count > 0)
{
regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
regObj.RegNumber = dtValidSearch.Rows[0]["REG_NO"].ToString();
displayRegInfo(regObj);
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
ClearText();
dvLedger.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number OR BO OR Foilo');", true);
}
}
protected void tferorRegNoTextBox_TextChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = tferorFundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = tferorBranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = tferorRegNoTextBox.Text.Trim();
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
DataTable dtTotalSaleUnitCerts = opendMFDAO.getDtTotalSaleUnitCerts(unitRegObj);
decimal TotalUnitsBalance = opendMFDAO.getTotalSaleUnitBalance(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
tferorHolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
tferorjHolderNameTextBox.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");
if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode.ToString() + "_" + branchCodeSign[0] + "_" + branchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg")))
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(imageSignLocation.ToString());
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
}
if (dtTotalSaleUnitCerts.Rows.Count > 0)
{
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
dvContentBottom.Visible = true;
leftDataGrid.DataSource = dtTotalSaleUnitCerts;
leftDataGrid.DataBind();
transferNoTextBox.Text = unitTransferBLObj.getNextTransferNo(unitRegObj, userObj).ToString();
TotalUnitHoldingTextBox.Text = TotalUnitsBalance.ToString();
}
else
{
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
dvContentBottom.Visible = false;
transferNoTextBox.Text = unitTransferBLObj.getNextTransferNo(unitRegObj, userObj).ToString();
TotalUnitHoldingTextBox.Text = TotalUnitsBalance.ToString();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Transfer');", true);
}
}
else
{
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = "";
tferorHolderNameTextBox.Text = "";
tferorjHolderNameTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
UnitTransfer transferObj = new UnitTransfer();
regObj.FundCode = tfereeFundCodeTextBox.Text.Trim();
regObj.BranchCode = tfereeBranhCodeTextBox.Text.Trim();
regObj.RegNumber = tferorRegNoTextBox.Text.Trim();
transferObj.TransferNo = Convert.ToInt32(transferNoTextBox.Text.Trim());
transferObj.TransferDate = transferDateTextBox.Text.Trim().ToString();
transferObj.TransferorRegNo = tferorRegNoTextBox.Text.Trim().ToString();
transferObj.TferorBranchCode = tferorBranchCodeTextBox.Text.Trim().ToString();
transferObj.TransfereeRegNo = tfereeRegNoTextBox.Text.Trim().ToString();
transferObj.TfereeBranchCode = tfereeBranhCodeTextBox.Text.Trim().ToString();
try
{
if (unitTransferBLObj.IsTransferLock(regObj))
{
dvContentBottom.Visible = true;
transferNoTextBox.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Transfer Opearation is Locked " + "');", true);
}
else if (unitTransferBLObj.IsDuplicateTransfer(regObj, transferObj))
{
dvContentBottom.Visible = true;
transferNoTextBox.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Transfer Number " + "');", true);
}
else
{
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();
dtGrid.Rows.Add(drGrid);
}
}
unitTransferBLObj.saveTransfer(dtGrid, regObj, transferObj, userObj); //save Transfer Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid(); // hide remaining Data
leftDataGrid.DataBind();
tferorRegNoTextBox.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
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 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();
// spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
// fundCodeTextBox.Text = fundCode.ToString();
// branchCodeTextBox.Text = branchCode.ToString();
if (!IsPostBack)
{
fundNameDropDownList.DataSource = opendMFDAO.dtFundList();
fundNameDropDownList.DataTextField = "FUND_NM";
fundNameDropDownList.DataValueField = "FUND_CD";
fundNameDropDownList.DataBind();
branchNameDropDownList.DataSource = opendMFDAO.dtBranchList();
branchNameDropDownList.DataTextField = "BR_NM";
branchNameDropDownList.DataValueField = "BR_CD";
branchNameDropDownList.DataBind();
}
}
public void displayRegInfo()
{
UnitSale saleObj = new UnitSale();
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = fundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = branchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = regNoTextBox.Text.Trim();
if (opendMFDAO.IsValidRegistration(unitRegObj))
{
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
holderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
jHolderTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
holderAddress1TextBox.Text = dtRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS1"].ToString();
holderAddress2TextBox.Text = dtRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS2"].ToString();
holderTelphoneTextBox.Text = dtRegInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["TEL_NO"].ToString();
string CIP = dtRegInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["CIP"].ToString();
if (string.Compare(CIP, "Y", true) == 0)
{
tdCIP.InnerHtml = " YES ";
}
else if (string.Compare(CIP, "N", true) == 0)
{
tdCIP.InnerHtml = " NO ";
}
displaySign();
dinoGridView.DataSource = opendMFDAO.getTableDinomination();
dinoGridView.DataBind();
dinoGridView.Visible = false;
saleNumberTextBox.Text = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj).ToString();
// MoneyReceiptNoTextBox.Text = unitSaleBLObj.getNextMoneReceiptNo(unitRegObj, userObj).ToString();
saleObj.SaleNo = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj) - 1;
saleDateTextBox.Text = opendMFDAO.getLastSaleDate(unitRegObj, saleObj).ToString("dd-MMM-yyyy");
saleRateTextBox.Text = opendMFDAO.getLastSaleRate(unitRegObj, saleObj).ToString();
saleTypeDropDownList.SelectedValue = unitSaleBLObj.GetNextSaleType(unitRegObj, userObj).ToString();
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
// PhotoImage.ImageUrl = Path.Combine(ConfigReader.PhotoLocation, "Notavailable.JPG").ToString();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", " window.fnResetAll();", true);
tdCIP.InnerHtml = "";
dinoGridView.Visible = false;
}
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
tdCIP.InnerHtml = "";
dinoGridView.Visible = false;
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
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();
if (!IsPostBack)
{
fundNameDropDownList.DataSource = opendMFDAO.dtFundList();
fundNameDropDownList.DataTextField = "FUND_NM";
fundNameDropDownList.DataValueField = "FUND_CD";
fundNameDropDownList.DataBind();
refixationDateFromDropDownList.DataSource = reportObj.dtFillFixationDate(" ");
refixationDateFromDropDownList.DataTextField = "NAME";
refixationDateFromDropDownList.DataValueField = "ID";
refixationDateFromDropDownList.SelectedValue = "0";
refixationDateFromDropDownList.DataBind();
refixationDateToDropDownList.DataSource = reportObj.dtFillFixationDate(" ");
refixationDateToDropDownList.DataTextField = "NAME";
refixationDateToDropDownList.DataValueField = "ID";
refixationDateToDropDownList.SelectedValue = "0";
refixationDateToDropDownList.DataBind();
effectiveDateFromDropDownList.DataSource = reportObj.dtFillFixationDate(" ");
effectiveDateFromDropDownList.DataTextField = "NAME";
effectiveDateFromDropDownList.DataValueField = "ID";
effectiveDateFromDropDownList.SelectedValue = "0";
effectiveDateFromDropDownList.DataBind();
effectiveDateToDropDownList.DataSource = reportObj.dtFillFixationDate(" ");
effectiveDateToDropDownList.DataTextField = "NAME";
effectiveDateToDropDownList.DataValueField = "ID";
effectiveDateToDropDownList.SelectedValue = "0";
effectiveDateToDropDownList.DataBind();
DataTable dtFundInfoDetails = reportObj.dtFundInfoDetails(" ");
DataTable dtPriceDetails = dtPriceDetails = reportObj.dtPriceDetails(" AND FUND_CD='" + dtFundInfoDetails.Rows[0]["FUND_CD"].ToString().ToUpper() + "' AND REFIX_DT=(SELECT MAX (REFIX_DT) FROM PRICE_REFIX WHERE FUND_CD='" + dtFundInfoDetails.Rows[0]["FUND_CD"].ToString().ToUpper() + "') ");
for (int looper = 1; looper < dtFundInfoDetails.Rows.Count; looper++)
{
DataTable dtprice = reportObj.dtPriceDetails(" AND FUND_CD='" + dtFundInfoDetails.Rows[looper]["FUND_CD"].ToString().ToUpper() + "' AND REFIX_DT=(SELECT MAX (REFIX_DT) FROM PRICE_REFIX WHERE FUND_CD='" + dtFundInfoDetails.Rows[looper]["FUND_CD"].ToString().ToUpper() + "') ");
dtPriceDetails.Merge(dtprice);
}
dvGridSurrender.Visible = true;
SurrenderListGridView.DataSource = dtPriceDetails;
SurrenderListGridView.DataBind();
}
}
protected void fundCodeDDL_SelectedIndexChanged(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
ReceiptNoTextBox.Text = unitSaleBLObj.GetMaxReceiptNo(regObj, "TR").ToString();
}
public long SaleLimitUpper(UnitHolderRegistration regObj)
{
int SaleLimitUpper = 0;
DataTable dtUnitLimitUpper = commonGatewayObj.Select("SELECT A.MAX_MK_LOT FROM " + bizSchema + ".FUND_INFO A WHERE A.FUND_CD='" + regObj.FundCode.ToString() + "'");
SaleLimitUpper = Convert.ToInt32(dtUnitLimitUpper.Rows[0]["MAX_MK_LOT"].Equals(DBNull.Value) ? "0" : dtUnitLimitUpper.Rows[0]["MAX_MK_LOT"].ToString());
return(SaleLimitUpper);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
// UnitTransfer transferObj = new UnitTransfer();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(RepNoTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseRate = Convert.ToInt32(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
try
{
if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else
{
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();
dtGrid.Rows.Add(drGrid);
}
}
unitRepBLObj.saveRepurchase(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
//RepNoTextBox.Text = unitRepBLObj.getNextRepurchaseNo(regObj, userObj).ToString();
//unitRepObj.RepurchaseNo = unitRepBLObj.getNextRepurchaseNo(regObj, userObj) - 1;
//RepDateTextBox.Text = unitRepBLObj.getLastRepDate(regObj, unitRepObj).ToString("dd-MMM-yyyy");
//RepRateTextBox.Text = unitRepBLObj.getLastRepRate(regObj, unitRepObj).ToString();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void NomiNumberDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeTextBox.Text;
regObj.BranchCode = branchCodeTextBox.Text;
regObj.RegNumber = regNoTextBox.Text;
DataTable dtNomineeInfo = unitHolderRegBLObj.dtGetNomineeInfo(regObj, Convert.ToInt32(NomiNumberDropDownList.SelectedValue.ToString()));
if (dtNomineeInfo.Rows.Count > 0)
{
controlNumberTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_CTL_NO"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_CTL_NO"].ToString();
nomiNumberTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_NO"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_NO"].ToString();
nomiNameTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_NAME"].ToString();
TypeDropDownList.SelectedValue = dtNomineeInfo.Rows[0]["NOMI_TYPE"].Equals(DBNull.Value) ? "N" : dtNomineeInfo.Rows[0]["NOMI_TYPE"].ToString();
nomiFMTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_FMH_NAME"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_FMH_NAME"].ToString();
nomiMotherTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_MO_NAME"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_MO_NAME"].ToString();
nomiOccupationDropDownList.SelectedValue = dtNomineeInfo.Rows[0]["NOMI_OCC_CODE"].Equals(DBNull.Value) ? "0" : dtNomineeInfo.Rows[0]["NOMI_OCC_CODE"].ToString();
nomiAddress1TextBox.Text = dtNomineeInfo.Rows[0]["NOMI_ADDRS1"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_ADDRS1"].ToString();
nomiAddress2TextBox.Text = dtNomineeInfo.Rows[0]["NOMI_ADDRS2"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_ADDRS2"].ToString();
nomiCityTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_CITY"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_CITY"].ToString();
nomiNationalityTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_NATIONALITY"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_NATIONALITY"].ToString();
nomiDateofBirthTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_BIRTH_DT"].Equals(DBNull.Value) ? "" :Convert.ToDateTime(dtNomineeInfo.Rows[0]["NOMI_BIRTH_DT"]).ToString("dd-MMM-yyyy");
//nomiAgeTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_NAME"].ToString();
RelationDropDownList.SelectedValue = dtNomineeInfo.Rows[0]["NOMI_REL"].Equals(DBNull.Value) ? "0" : dtNomineeInfo.Rows[0]["NOMI_REL"].ToString();
percentageTextBox.Text = dtNomineeInfo.Rows[0]["PERCENTAGE"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["PERCENTAGE"].ToString();
nomiRemarksTextBox.Text = dtNomineeInfo.Rows[0]["REAMARKS"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["REAMARKS"].ToString();
if (dtNomineeInfo.Rows[0]["NOMI_IS_MINOR"].ToString() == "Y")
{
yesMinorRadioButton.Checked = true;
noMinorRadioButton.Checked = false;
DivGardian.Attributes.Add("style", "visibility:visible");
gardianAddressTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_GARDIAN_NAME"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_GARDIAN_NAME"].ToString();
gardianRelationDropDownList.SelectedValue = dtNomineeInfo.Rows[0]["GARD_REL_WITH_NOMI"].Equals(DBNull.Value) ? "0" : dtNomineeInfo.Rows[0]["GARD_REL_WITH_NOMI"].ToString();
gardianBirthDateTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_GARDIAN_BIRTH_DT"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtNomineeInfo.Rows[0]["NOMI_GARDIAN_BIRTH_DT"]).ToString("dd-MMM-yyyy");
gardianAddressTextBox.Text = dtNomineeInfo.Rows[0]["NOMI_GARDIAN_ADDRESS"].Equals(DBNull.Value) ? "" : dtNomineeInfo.Rows[0]["NOMI_GARDIAN_ADDRESS"].ToString();
}
else
{
yesMinorRadioButton.Checked = false;
noMinorRadioButton.Checked = true;
DivGardian.Attributes.Add("style", "visibility:hidden");
gardianAddressTextBox.Text = "";
gardianRelationDropDownList.SelectedValue = "0";
gardianBirthDateTextBox.Text = "";
gardianAddressTextBox.Text = "";
}
}
else
{
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Data Found');", true);
}
}
public void displayRegInfo()
{
UnitSale saleObj = new UnitSale();
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = fundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = branchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = regNoTextBox.Text.Trim();
if (opendMFDAO.IsValidRegistration(unitRegObj))
{
moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptInfoforDDL(unitRegObj, "SL");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
holderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
jHolderTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
holderAddress1TextBox.Text = dtRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS1"].ToString();
holderAddress2TextBox.Text = dtRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["ADDRS2"].ToString();
holderTelphoneTextBox.Text = dtRegInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["TEL_NO"].ToString();
string CIP = dtRegInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["CIP"].ToString();
if (string.Compare(CIP, "Y", true) == 0)
{
tdCIP.InnerHtml = " YES ";
}
else if (string.Compare(CIP, "N", true) == 0)
{
tdCIP.InnerHtml = " NO ";
}
displaySign();
saleNumberTextBox.Text = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj).ToString();
saleObj.SaleNo = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj) - 1;
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", " window.fnResetAll();", true);
tdCIP.InnerHtml = "";
}
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
tdCIP.InnerHtml = "";
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
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 fundCodeDDL_SelectedIndexChanged(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
ReceiptNoTextBox.Text = unitSaleBLObj.GetMaxReceiptNo(regObj, "REP").ToString();
RateTextBox.Text = unitSaleBLObj.GetLastPrice(regObj, "REP").ToString();
CDSStatus = opendMFDAO.getCDSStatus(fundCodeDDL.SelectedValue.ToString());
}
