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);
}
}
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);
}
}
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 findButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeTextBox.Text.Trim();
regObj.BranchCode = branchCodeTextBox.Text.Trim();
regObj.RegNumber = regNoTextBox.Text.Trim();
if (opendMFDAO.IsValidRegistration(regObj))
{
displayRegInfo();
}
else
{
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
ClearText();
dvLedger.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
protected void regNoTextBox_TextChanged(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeDDL.SelectedValue.ToString();
regObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
regObj.RegNumber = regNoTextBox.Text.Trim();
if (opendMFDAO.IsValidRegistration(regObj))
{
displayRegInfo(regObj);
}
else
{
ClearText();
dvLedger.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();
regObj.FundCode = fundCodeTextBox.Text;
regObj.BranchCode = branchCodeTextBox.Text;
regObj.RegNumber = regNoTextBox.Text;
UnitSale saleObj = new UnitSale();
saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString());
if (MoneyReceiptNoTextBox.Text.Trim() != "")
{
saleObj.MoneyReceiptNo = Convert.ToInt32(MoneyReceiptNoTextBox.Text.Trim());
}
if (ChqRadioButton.Checked)
{
saleObj.PaymentType = ChequeTypeDropDownList.SelectedValue.ToString();
if (CHQDDNoRemarksTextBox.Text.Trim() != "")
{
saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString();
}
if (chequeDateTextBox.Text.Trim() != "")
{
saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString();
}
if (bankNameDropDownList.SelectedValue.Trim() != "0")
{
saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString());
}
if (branchNameDropDownList.SelectedValue.Trim() != "0" && branchNameDropDownList.SelectedValue.Trim() != "")
{
saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString());
}
}
else if (CashRadioButton.Checked)
{
saleObj.PaymentType = "CASH";
saleObj.CashAmount = Convert.ToDecimal(Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString()) * Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()));
}
else if (BothRadioButton.Checked)
{
saleObj.PaymentType = "BOTH";
saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString();
if (CHQDDNoRemarksTextBox.Text.Trim() != "")
{
saleObj.ChequeNo = CHQDDNoRemarksTextBox.Text.Trim().ToString();
}
if (chequeDateTextBox.Text.Trim() != "")
{
saleObj.ChequeDate = chequeDateTextBox.Text.Trim().ToString();
}
if (bankNameDropDownList.SelectedValue.Trim() != "0")
{
saleObj.BankCode = Convert.ToInt16(bankNameDropDownList.SelectedValue.ToString());
}
if (branchNameDropDownList.SelectedValue.Trim() != "0" || branchNameDropDownList.SelectedValue.Trim() != "")
{
saleObj.BranchCode = Convert.ToInt16(branchNameDropDownList.SelectedValue.ToString());
}
if (CashAmountTextBox.Text.Trim() != "")
{
saleObj.CashAmount = Convert.ToDecimal(CashAmountTextBox.Text.Trim().ToString());
}
}
else if (MultiRadioButton.Checked)
{
saleObj.PaymentType = "MULTI";
if (MultiplePayTypeTextBox.Text.Trim() != "")
{
saleObj.MultiPayType = MultiplePayTypeTextBox.Text.Trim().ToString();
}
}
saleObj.SaleRate = Convert.ToDecimal(saleRateTextBox.Text.Trim().ToString());
saleObj.SaleType = saleTypeDropDownList.SelectedValue.ToString().ToUpper();
saleObj.SaleUnitQty = Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString());
saleObj.SaleDate = saleDateTextBox.Text.Trim().ToString();
saleObj.SaleRemarks = saleRemarksTextBox.Text.Trim().ToString();
int saleLimitLower = unitSaleBLObj.SaleLimitLower(regObj);
long saleLimmitUpper = unitSaleBLObj.SaleLimitUpper(regObj);
try
{
//if (unitSaleBLObj.IsDuplicateSale(regObj, saleObj))// Checking Duplicate Sale No
//{
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " "+"Sale Number "+"');", true);
//}
//else
if (saleLimitLower > Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()) && saleTypeDropDownList.SelectedValue.ToString() == "SL")
{
unitQtyTextBox.Focus();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not less than " + saleLimitLower.ToString() + "');", true);
}
else if (saleLimmitUpper < Convert.ToInt32(unitQtyTextBox.Text.Trim().ToString()))
{
unitQtyTextBox.Focus();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Sale Unit Quantity can not greater than " + saleLimmitUpper.ToString() + "');", true);
}
else if (!opendMFDAO.IsValidRegistration(regObj))
{
regNoTextBox.Focus();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Invalid Registration Number!!');", true);
}
//else if (regObj.FundCode == "IAMPH")
//{
// string errorMessage = "Please Contace with Administrator";
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed :" + errorMessage + "');", true);
//}
else
{
int loop = 0;
DataTable dtSaleInfo = (DataTable)Session["dtSaleInfo"];
int rowNumber = 1;
int line = 0;
int countCheck = 0;
DataTable dtDino = unitSaleBLObj.getTableDinoForEdit();
DataRow drDino;
bool invalidCert = false;
bool allocateCert = true;
bool bannedCert = false;
int duplicateCerNoReg = 0;
string dino = "";
string cerNo = "";
foreach (DataGridItem gridItem in dinoGridView.Items)
{
drDino = dtDino.NewRow();
TextBox txtDino = null;
TextBox txtCert = null;
TextBox txtWeight = null;
TextBox txtStatus = null;
txtDino = (TextBox)(gridItem.FindControl("dinoTextBox"));
txtCert = (TextBox)(gridItem.FindControl("certNoTextBox"));
txtWeight = (TextBox)(gridItem.FindControl("weightTextBox"));
txtStatus = (TextBox)(gridItem.FindControl("statusTextBox"));
CheckBox leftCheckBox = (CheckBox)gridItem.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
countCheck++;
duplicateCerNoReg = opendMFDAO.duplicateCerNoReg(regObj, txtDino.Text.ToString(), txtCert.Text.ToString());
allocateCert = unitSaleBLObj.IsCertificateAllocate(regObj, txtDino.Text.ToString(), txtCert.Text.ToString());
bannedCert = unitSaleBLObj.IsCertificateBanned(regObj, txtDino.Text.ToString(), txtCert.Text.ToString());
if (duplicateCerNoReg == Convert.ToInt32(regNoTextBox.Text.Trim().ToString()) || duplicateCerNoReg == 0)
{
if (opendMFDAO.validationDino(txtDino.Text.ToString().ToUpper(), regObj.FundCode.ToString().ToUpper()) && opendMFDAO.validationWeight(Convert.ToInt32(txtWeight.Text.ToString()), regObj.FundCode.ToString().ToUpper()))
{
if (allocateCert)
{
if (bannedCert)
{
bannedCert = true;
line = rowNumber;
dino = txtDino.Text.Trim().ToString();
cerNo = txtCert.Text.Trim().ToString();
break;
}
else
{
drDino["dino"] = txtDino.Text.Trim().ToString().ToUpper();
drDino["cert_no"] = Convert.ToInt32(txtCert.Text.Trim().ToString());
drDino["cert_weight"] = Convert.ToInt32(txtWeight.Text.Trim().ToString());
drDino["status"] = txtStatus.Text.Trim().ToString().ToUpper();
drDino["ROWID"] = dtSaleInfo.Rows[loop]["ROWID"].ToString();
dtDino.Rows.Add(drDino);
rowNumber++;
}
}
else
{
allocateCert = false;
line = rowNumber;
dino = txtDino.Text.Trim().ToString();
cerNo = txtCert.Text.Trim().ToString();
break;
}
}
else
{
invalidCert = true;
line = rowNumber;
break;
}
}
else
{
dino = txtDino.Text.Trim().ToString();
cerNo = txtCert.Text.Trim().ToString();
break;
}
}
loop++;
}
if (duplicateCerNoReg > 0 && !(duplicateCerNoReg == Convert.ToInt32(regNoTextBox.Text.Trim().ToString())))
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Certificate " + dino + "-" + cerNo + " is Already Sold to Reg No:" + duplicateCerNoReg + "');", true);
}
else
{
if (invalidCert)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!!Invalid Dinomination or Weight at Line: " + line + "');", true);
}
else if (!allocateCert)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Line: " + line + " and Certificate No: " + dino + "-" + cerNo + " is not allocated in this branch');", true);
}
else if (bannedCert)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed!! Line: " + line + " and Certificate No: " + dino + "-" + cerNo + " is banned for sale');", true);
}
else if (!invalidCert && allocateCert && !bannedCert)
{
unitSaleBLObj.SaveSaleEditInfo(regObj, saleObj, dtDino, userObj);
ClearText();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true);
}
}
}
}
catch (Exception ex)
{
errorMassege = msgObj.ExceptionErrorMessageString(ex.Message.ToString());
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + errorMassege.ToString() + "');", true);
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
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 = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
if (EFTRadioButton.Checked)
{
unitRepObj.PayType = "EFT";
}
else
{
unitRepObj.PayType = "CHQ";
}
try
{
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString()) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Surrender Value con not be equal or less than Zero');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", true);
}
else
{
DataTable dtGrid = opendMFDAO.getTableDataGridCDS();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
TextBox SL_TR_NOTxt = (TextBox)gridRow.FindControl("SL_TR_NoTextBox");
TextBox SURRENDER_UNITSTxt = (TextBox)gridRow.FindControl("Sale_UnitsTextBox");
TextBox EXIST_UNITSTxt = (TextBox)gridRow.FindControl("Exist_UnitsTextBox");
drGrid = dtGrid.NewRow();
drGrid["SL_TR_NO"] = SL_TR_NOTxt.Text.Trim().ToString();
drGrid["SURRENDER_UNITS"] = SURRENDER_UNITSTxt.Text.Trim().ToString();
drGrid["EXIST_UNITS"] = EXIST_UNITSTxt.Text.Trim().ToString();
dtGrid.Rows.Add(drGrid);
}
}
unitRepBLObj.saveRepurchaseCDS(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
}
else
{
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
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)
{
DataTable dtNomineeList = commonGatewayObj.Select("SELECT NOMI_NO, NOMI_NO as NOMINEE FROM U_NOMINEE WHERE REG_BK='" + regObj.FundCode + "' AND REG_BR='" + regObj.BranchCode + "' AND REG_NO=" + regObj.RegNumber + " ORDER BY NOMI_NO");
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";
if (dtNomineeList.Rows.Count > 0)
{
DataTable dtNomineeListDDL = new DataTable();
dtNomineeListDDL.Columns.Add("ID", typeof(string));
dtNomineeListDDL.Columns.Add("NOMI_NO", typeof(string));
DataRow drDDL;
drDDL = dtNomineeListDDL.NewRow();
drDDL["ID"] = "0";
drDDL["NOMI_NO"] = " ";
dtNomineeListDDL.Rows.Add(drDDL);
for (int loop = 0; loop < dtNomineeList.Rows.Count; loop++)
{
drDDL = dtNomineeListDDL.NewRow();
drDDL["ID"] = dtNomineeList.Rows[loop]["NOMI_NO"].ToString();
drDDL["NOMI_NO"] = dtNomineeList.Rows[loop]["NOMINEE"].ToString();
dtNomineeListDDL.Rows.Add(drDDL);
}
NomiNumberDropDownList.DataSource = dtNomineeListDDL;
NomiNumberDropDownList.DataTextField = "NOMI_NO";
NomiNumberDropDownList.DataValueField = "ID";
NomiNumberDropDownList.DataBind();
ClearText();
}
else
{
regNoTextBox.Focus();
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Nominee Found Found');", true);
}
}
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);
}
}
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(moneyReceipDropDownList.SelectedItem.Text.ToString());
unitRepObj.RepurchaseRate = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
unitRepObj.PayType = payTypeLabel.Text.ToUpper();
try
{
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", 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 (dtGrid.Rows.Count > 0)
{
if (totalSurrenderUnits == Convert.ToInt64(TotalUnitRepurchaseTextBox.Text) && totalSurrenderUnits == Convert.ToInt64(QtyTextBox.Text))
{
commonGatewayObj.ExecuteNonQuery("UPDATE MONEY_RECEIPT SET SL_REP_TR_RN_NO=" + unitRepObj.RepurchaseNo + " WHERE ID=" + Convert.ToUInt64(moneyReceipDropDownList.SelectedValue.ToString()));
unitRepBLObj.saveRepurchase(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
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 ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
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);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to No Sale Selected');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", 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);
}
}
public void displayRegInfo()
{
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);
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();
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();
if (dtTotalSaleUnitCerts.Rows.Count > 0)
{
renewalUnitsTextBox.Text = "";
leftDataGrid.Visible = true;
dvContentBottom.Visible = true;
dinoGridView.Visible = false;
leftDataGrid.DataSource = dtTotalSaleUnitCerts;
leftDataGrid.DataBind();
totalUnitsTextBox.Text = TotalUnitsBalance.ToString();
}
else
{
dinoGridView.DataSource = opendMFDAO.getTableDinomination();
dinoGridView.DataBind();
dinoGridView.Visible = false;
leftDataGrid.Visible = false;
totalUnitsTextBox.Text = "";
renewalUnitsTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Renewal');", true);
}
renewalNumberTextBox.Text = renewalBLObj.getNextRenNo(unitRegObj, userObj).ToString();
// saleObj.SaleNo = unitSaleBLObj.getNextSaleNo(unitRegObj, userObj) - 1;
// renewalDateTextBox.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 = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
tdCIP.InnerHtml = "";
leftDataGrid.Visible = false;
dvContentBottom.Visible = false;
// PhotoImage.ImageUrl = Path.Combine(ConfigReader.PhotoLocation, "Notavailable.JPG").ToString();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", " window.fnResetAll();", true);
}
}
else
{
totalUnitsTextBox.Text = "";
renewalUnitsTextBox.Text = "";
dvContentBottom.Visible = false;
leftDataGrid.Visible = false;
ClearText();
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
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)
{
DataTable dtJointHolder = opendMFDAO.dtJointHolderRegInfo(regObj);
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";
if (dtJointHolder.Rows.Count > 0)
{
NameTextBox.Text = dtJointHolder.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_NAME"].ToString();
FMTextBox.Text = dtJointHolder.Rows[0]["JNT_FMH_NAME"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_FMH_NAME"].ToString();
MotherTextBox.Text = dtJointHolder.Rows[0]["JNT_MO_NAME"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_MO_NAME"].ToString();
spouceTextBox.Text = dtJointHolder.Rows[0]["SP_NAME"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["SP_NAME"].ToString();
NIDTextBox.Text = dtJointHolder.Rows[0]["NID"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["NID"].ToString();;
passportTextBox.Text = dtJointHolder.Rows[0]["PASS_NO"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["PASS_NO"].ToString();;
TINTextBox.Text = dtJointHolder.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["TIN"].ToString();;
birthCertNoTextBox.Text = dtJointHolder.Rows[0]["BIRTH_CERT_NO"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["BIRTH_CERT_NO"].ToString();;
OccupationDropDownList.SelectedValue = dtJointHolder.Rows[0]["JNT_OCC_CODE"].Equals(DBNull.Value) ? "0" : dtJointHolder.Rows[0]["JNT_OCC_CODE"].ToString();
NationalityTextBox.Text = dtJointHolder.Rows[0]["JNT_NATIONALITY"].Equals(DBNull.Value) ? "BANGLADESHI" : dtJointHolder.Rows[0]["JNT_NATIONALITY"].ToString();
DateofBirthTextBox.Text = dtJointHolder.Rows[0]["JNT_B_DATE"].Equals(DBNull.Value) ? " " : dtJointHolder.Rows[0]["JNT_B_DATE"].ToString();
TelphoneTextBox.Text = dtJointHolder.Rows[0]["JNT_TEL_NO"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_TEL_NO"].ToString();
presentAddress1TextBox.Text = dtJointHolder.Rows[0]["JNT_ADDRS1"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_ADDRS1"].ToString();
presentAddress2TextBox.Text = dtJointHolder.Rows[0]["JNT_ADDRS2"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_ADDRS2"].ToString();
presentCityTextBox.Text = dtJointHolder.Rows[0]["JNT_CITY"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_CITY"].ToString();
parmanAddress1TextBox.Text = dtJointHolder.Rows[0]["PADDRESS1"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["PADDRESS1"].ToString();
parmanAddress2TextBox.Text = dtJointHolder.Rows[0]["PADDRESS2"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["PADDRESS2"].ToString();
parmentCityTextBox.Text = dtJointHolder.Rows[0]["PCITY"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["PCITY"].ToString();
SourceFundTextBox.Text = dtJointHolder.Rows[0]["SOURCE_FUND"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["SOURCE_FUND"].ToString();
EmailTextBox.Text = dtJointHolder.Rows[0]["JNT_EMAIL"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["JNT_EMAIL"].ToString();
MaritialStatusDropDownList.SelectedValue = dtJointHolder.Rows[0]["MAR_STAT"].Equals(DBNull.Value) ? "0" : dtJointHolder.Rows[0]["MAR_STAT"].ToString();
EducationDropDownList.SelectedValue = dtJointHolder.Rows[0]["EDU_QUA"].Equals(DBNull.Value) ? "0" : dtJointHolder.Rows[0]["EDU_QUA"].ToString();
SexDropDownList.SelectedValue = dtJointHolder.Rows[0]["SEX"].Equals(DBNull.Value) ? "0" : dtJointHolder.Rows[0]["SEX"].ToString();
ReligionDropDownList.SelectedValue = dtJointHolder.Rows[0]["RELIGION"].Equals(DBNull.Value) ? "0" : dtJointHolder.Rows[0]["RELIGION"].ToString();
RemarksTextBox.Text = dtJointHolder.Rows[0]["REMARKS"].Equals(DBNull.Value) ? "" : dtJointHolder.Rows[0]["REMARKS"].ToString();
}
else
{
ClearText();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Joint Holder Information Found');", true);
}
}
else
{
regNoTextBox.Focus();
ClearText();
DateLabel.Text = "";
TypeLabel.Text = "";
CIPLabel.Text = "";
IDLabel.Text = "";
NameLabel.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Data Found');", true);
}
}
else
{
regNoTextBox.Focus();
ClearText();
DateLabel.Text = "";
TypeLabel.Text = "";
CIPLabel.Text = "";
IDLabel.Text = "";
NameLabel.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Invalid Registration Number!! Please Enter Valid Registration Number');", true);
}
}
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);
// DataTable dtNomineeRegInfo = opendMFDAO.dtNomineeRegInfo(regObj);
if (dtHolderRegInfo.Rows.Count > 0)
{
regDateTextBox.Text = dtHolderRegInfo.Rows[0]["REG_DT"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtHolderRegInfo.Rows[0]["REG_DT"].ToString()).ToString("dd-MMM-yyyy");
if (dtHolderRegInfo.Rows[0]["REG_TYPE"].ToString().ToUpper() == "I")
{
IndividualButton.Checked = false;
CompRadioButton.Checked = true;
regTypeDropDownList.SelectedValue = "I";
}
else if (dtHolderRegInfo.Rows[0]["REG_TYPE"].ToString().ToUpper() == "N")
{
IndividualButton.Checked = true;
CompRadioButton.Checked = false;
regTypeDropDownList.SelectedValue = "N";
}
else if (dtHolderRegInfo.Rows[0]["REG_TYPE"].ToString().ToUpper() == "C")
{
IndividualButton.Checked = false;
CompRadioButton.Checked = true;
regTypeDropDownList.SelectedValue = "C";
}
else if (dtHolderRegInfo.Rows[0]["REG_TYPE"].ToString().ToUpper() == "F")
{
IndividualButton.Checked = true;
CompRadioButton.Checked = false;
regTypeDropDownList.SelectedValue = "F";
}
if (dtHolderRegInfo.Rows[0]["CIP"].Equals(DBNull.Value))
{
isCIPDropDownList.SelectedValue = "0";
}
else
{
isCIPDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["CIP"].ToString();
}
IDAccNoTextBox.Enabled = true;
IDbankNameDropDownList.Enabled = true;
IDbranchNameDropDownList.Enabled = true;
if (dtHolderRegInfo.Rows[0]["ID_FLAG"].ToString() == "Y")
{
IDAccNoTextBox.Text = dtHolderRegInfo.Rows[0]["ID_AC"].ToString();
IDNoRadioButton.Checked = false;
IDYesRadioButton.Checked = true;
if (!dtHolderRegInfo.Rows[0]["ID_BK_NM_CD"].Equals(DBNull.Value) && !dtHolderRegInfo.Rows[0]["ID_BK_BR_NM_CD"].Equals(DBNull.Value))
{
dvIDInof.Attributes.Add("style", "visibility:visible");
IDAccNoTextBox.Enabled = true;
IDbankNameDropDownList.Enabled = true;
IDbranchNameDropDownList.Enabled = true;
IDbankNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["ID_BK_NM_CD"].ToString();
IDbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtHolderRegInfo.Rows[0]["ID_BK_NM_CD"].ToString()));
IDbranchNameDropDownList.DataTextField = "BRANCH_NAME";
IDbranchNameDropDownList.DataValueField = "BRANCH_CODE";
IDbranchNameDropDownList.DataBind();
IDbranchNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["ID_BK_BR_NM_CD"].ToString();
}
else
{
dvIDInof.Attributes.Add("style", "visibility:hidden");
IDbankNameDropDownList.SelectedValue = "0";
IDbranchNameDropDownList.SelectedValue = "0";
IDAccNoTextBox.Text = "";
}
}
else
{
IDYesRadioButton.Checked = false;
IDNoRadioButton.Checked = true;
dvIDInof.Attributes.Add("style", "visibility:hidden");
IDAccNoTextBox.Text = "";
IDbankNameDropDownList.SelectedValue = "0";
IDbranchNameDropDownList.SelectedValue = "0";
}
NameTextBox.Text = dtHolderRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["HNAME"].ToString();
FMTextBox.Text = dtHolderRegInfo.Rows[0]["FMH_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["FMH_NAME"].ToString();
MotherTextBox.Text = dtHolderRegInfo.Rows[0]["MO_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["MO_NAME"].ToString();
spouceTextBox.Text = dtHolderRegInfo.Rows[0]["SP_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["SP_NAME"].ToString();
holderBONumberTextBox.Text = dtHolderRegInfo.Rows[0]["BO"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["BO"].ToString();
NIDTextBox.Text = dtHolderRegInfo.Rows[0]["NID"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["NID"].ToString();;
passportTextBox.Text = dtHolderRegInfo.Rows[0]["PASS_NO"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["PASS_NO"].ToString();;
TINTextBox.Text = dtHolderRegInfo.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["TIN"].ToString();;
birthCertNoTextBox.Text = dtHolderRegInfo.Rows[0]["BIRTH_CERT_NO"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["BIRTH_CERT_NO"].ToString();;
OccupationDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["OCC_CODE"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["OCC_CODE"].ToString();
NationalityTextBox.Text = dtHolderRegInfo.Rows[0]["NATIONALITY"].Equals(DBNull.Value) ? "BANGLADESHI" : dtHolderRegInfo.Rows[0]["NATIONALITY"].ToString();
// DateofBirthTextBox.Text = dtHolderRegInfo.Rows[0]["B_DATE"].Equals(DBNull.Value) ? " " : dtHolderRegInfo.Rows[0]["B_DATE"].ToString();
DateofBirthTextBox.Text = dtHolderRegInfo.Rows[0]["B_DATE"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtHolderRegInfo.Rows[0]["B_DATE"].ToString()).ToString("dd-MMM-yyyy");
TelphoneTextBox.Text = dtHolderRegInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["TEL_NO"].ToString();
MobileTextBox.Text = dtHolderRegInfo.Rows[0]["MOBILE1"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["MOBILE1"].ToString();
presentAddress1TextBox.Text = dtHolderRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["ADDRS1"].ToString();
presentAddress2TextBox.Text = dtHolderRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["ADDRS2"].ToString();
presentCityTextBox.Text = dtHolderRegInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["CITY"].ToString();
parmanAddress1TextBox.Text = dtHolderRegInfo.Rows[0]["PADDRESS1"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["PADDRESS1"].ToString();
parmanAddress2TextBox.Text = dtHolderRegInfo.Rows[0]["PADDRESS2"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["PADDRESS2"].ToString();
parmentCityTextBox.Text = dtHolderRegInfo.Rows[0]["PCITY"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["PCITY"].ToString();
SourceFundTextBox.Text = dtHolderRegInfo.Rows[0]["SOURCE_FUND"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["SOURCE_FUND"].ToString();
EmailTextBox.Text = dtHolderRegInfo.Rows[0]["EMAIL"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["EMAIL"].ToString();
MaritialStatusDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["MAR_STAT"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["MAR_STAT"].ToString();
EducationDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["EDU_QUA"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["EDU_QUA"].ToString();
SexDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["SEX"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["SEX"].ToString();
ReligionDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["RELIGION"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["RELIGION"].ToString();
RemarksTextBox.Text = dtHolderRegInfo.Rows[0]["REMARKS"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["REMARKS"].ToString();
if (dtHolderRegInfo.Rows[0]["IS_BEFTN"].Equals(DBNull.Value))
{
bftnNoRadioButton.Checked = true;
bftnYesRadioButton.Checked = false;
divBEFTN.Attributes.Add("style", "visibility:visible");
}
else if (dtHolderRegInfo.Rows[0]["IS_BEFTN"].ToString().ToUpper() == "N")
{
bftnNoRadioButton.Checked = true;
bftnYesRadioButton.Checked = false;
divBEFTN.Attributes.Add("style", "visibility:visible");
}
else if (dtHolderRegInfo.Rows[0]["IS_BEFTN"].ToString().ToUpper() == "Y")
{
bftnNoRadioButton.Checked = false;
bftnYesRadioButton.Checked = true;
divBEFTN.Attributes.Add("style", "visibility:visible");
}
if (dtHolderRegInfo.Rows[0]["BK_FLAG"].ToString() == "Y")
{
BankNORadioButton.Checked = false;
BankYesRadioButton.Checked = true;
DivBank.Attributes.Add("style", "visibility:visible");
if (!dtHolderRegInfo.Rows[0]["BK_NM_CD"].Equals(DBNull.Value) && !dtHolderRegInfo.Rows[0]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtHolderRegInfo.Rows[0]["BK_AC_NO"].Equals(DBNull.Value))
{
DivBank.Attributes.Add("style", "visibility:visible");
bankAccTextBox.Enabled = true;
bankNameDropDownList.Enabled = true;
branchNameDropDownList.Enabled = true;
bankAddressTextBox.Enabled = true;
bankNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["BK_NM_CD"].ToString();
branchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtHolderRegInfo.Rows[0]["BK_NM_CD"].ToString()));
branchNameDropDownList.DataTextField = "BRANCH_NAME";
branchNameDropDownList.DataValueField = "BRANCH_CODE";
branchNameDropDownList.DataBind();
branchNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["BK_BR_NM_CD"].ToString();
bankAccTextBox.Text = dtHolderRegInfo.Rows[0]["BK_AC_NO"].ToString();
DataTable dtBankBracnhInfo = unitHolderRegBLObj.dtGetBankBracnhInfo(Convert.ToInt32(dtHolderRegInfo.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtHolderRegInfo.Rows[0]["BK_BR_NM_CD"].ToString()));
if (dtBankBracnhInfo.Rows.Count > 0)
{
bankAddressTextBox.Text = dtBankBracnhInfo.Rows[0]["ADDRESS"].ToString();
routingNoTextBox.Text = dtBankBracnhInfo.Rows[0]["ROUTING_NO"].ToString();
}
}
}
else
{
DivBank.Attributes.Add("style", "visibility:hidden");
BankNORadioButton.Checked = true;
BankYesRadioButton.Checked = false;
bankAccTextBox.Text = "";
bankAddressTextBox.Text = "";
bankNameDropDownList.SelectedValue = "0";
branchNameDropDownList.SelectedValue = "0";
}
}
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);
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = FundCodeTextBox.Text.Trim();
regObj.BranchCode = BranchCodeTextBox.Text.Trim();
regObj.RegNumber = RegNoTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(moneyReceipDropDownList.SelectedItem.Text.ToString());
unitRepObj.RepurchaseRate = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
if (EFTRadioButton.Checked)
{
unitRepObj.PayType = "EFT";
}
else
{
unitRepObj.PayType = "CHQ";
}
try
{
commonGatewayObj.BeginTransaction();
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString()) <= 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Surrender Value con not be equal or less than Zero');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", true);
}
else
{
int CheckCount = 0;
long surrenderCheckUnit = 0;
DataTable dtGrid = opendMFDAO.getTableDataGridCDS();
DataRow drGrid;
foreach (DataGridItem gridRow in leftDataGrid.Items)
{
CheckBox leftCheckBox = (CheckBox)gridRow.FindControl("leftCheckBox");
if (leftCheckBox.Checked)
{
TextBox SL_TR_NOTxt = (TextBox)gridRow.FindControl("SL_TR_NoTextBox");
TextBox SURRENDER_UNITSTxt = (TextBox)gridRow.FindControl("Sale_UnitsTextBox");
TextBox EXIST_UNITSTxt = (TextBox)gridRow.FindControl("Exist_UnitsTextBox");
drGrid = dtGrid.NewRow();
drGrid["SL_TR_NO"] = SL_TR_NOTxt.Text.Trim().ToString();
drGrid["SURRENDER_UNITS"] = SURRENDER_UNITSTxt.Text.Trim().ToString();
drGrid["EXIST_UNITS"] = EXIST_UNITSTxt.Text.Trim().ToString();
dtGrid.Rows.Add(drGrid);
surrenderCheckUnit = surrenderCheckUnit + Convert.ToInt64(SURRENDER_UNITSTxt.Text.Trim().ToString());
CheckCount++;
}
}
if (CheckCount == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: No Surrender Units Selected');", true);
}
else if (surrenderCheckUnit != Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString()))
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Selected Units Mis Match to Actual Surrender Units');", true);
}
else if ((CheckCount > 0) && (surrenderCheckUnit != Convert.ToInt64(TotalUnitRepurchaseTextBox.Text.ToString())))
{
commonGatewayObj.ExecuteNonQuery("UPDATE MONEY_RECEIPT SET SL_REP_TR_RN_NO=" + unitRepObj.RepurchaseNo + " WHERE ID=" + Convert.ToUInt64(moneyReceipDropDownList.SelectedValue.ToString()));
unitRepBLObj.saveRepurchaseCDS(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
commonGatewayObj.CommitTransaction();
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();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save SuccessFully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed: Ambiguous Situation');", true);
}
}
}
else
{
ClearText();
commonGatewayObj.RollbackTransaction();
leftDataGrid.DataSource = opendMFDAO.getTableDataGridCDS();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
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 = decimal.Parse(RepRateTextBox.Text.Trim().ToString());
unitRepObj.RepurchaseDate = RepDateTextBox.Text.Trim().ToString();
if (EFTRadioButton.Checked)
{
unitRepObj.PayType = "EFT";
}
else
{
unitRepObj.PayType = "CHQ";
}
try
{
if (opendMFDAO.IsValidRegistration(regObj))
{
if (unitRepBLObj.IsRepurchaseLock(regObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + " Repurchase Operation is locked " + "');", true);
}
else if (unitRepBLObj.IsDuplicateRepurchase(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Repurchase Number " + "');", true);
}
else if (!unitRepBLObj.IsValidBEFTN(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "Either No Router Number or Account Number>13 digits " + "');", true);
}
else if (unitRepBLObj.IsIDAccount(regObj, unitRepObj))
{
dvContentBottom.Visible = true;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('" + msgObj.Error().ToString() + " " + "ID Account is not allow to BEFTN " + "');", 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 (dtGrid.Rows.Count > 0)
{
if (totalSurrenderUnits == Convert.ToInt64(TotalUnitRepurchaseTextBox.Text))
{
unitRepBLObj.saveRepurchase(dtGrid, regObj, unitRepObj, userObj);//save Repurchase Data
ClearText();
leftDataGrid.DataSource = opendMFDAO.getTableDataGrid();// hide remaining Data
leftDataGrid.DataBind();
TotalUnitHoldingTextBox.Text = "";
EFTRadioButton.Checked = true;
CHQRadioButton.Checked = false;
//NormalRadioButton.Checked = true;
//DeathRadioButton.Checked = false;
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);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Save Failed Due to No Sale Selected');", true);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
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);
DataTable dtNomineeRegInfo = opendMFDAO.dtNomineeRegInfo(regObj);
if (dtHolderRegInfo.Rows.Count > 0)
{
regDateTextBox.Text = dtHolderRegInfo.Rows[0]["REG_DT"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtHolderRegInfo.Rows[0]["REG_DT"].ToString()).ToString("dd-MMM-yyyy");
regTypeDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["REG_TYPE"].ToString();
isCIPDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["CIP"].ToString();
isIDDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["ID_FLAG"].ToString();
if (dtHolderRegInfo.Rows[0]["ID_FLAG"].ToString() == "Y")
{
IDAccNoTextBox.Text = dtHolderRegInfo.Rows[0]["ID_AC"].ToString();
if (!dtHolderRegInfo.Rows[0]["ID_BK_NM_CD"].Equals(DBNull.Value) && !dtHolderRegInfo.Rows[0]["ID_BK_BR_NM_CD"].Equals(DBNull.Value))
{
IDbankNameDropDownList.Enabled = true;
IDbranchNameDropDownList.Enabled = true;
IDbankNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["ID_BK_NM_CD"].ToString();
IDbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtHolderRegInfo.Rows[0]["ID_BK_NM_CD"].ToString()));
IDbranchNameDropDownList.DataTextField = "BRANCH_NAME";
IDbranchNameDropDownList.DataValueField = "BRANCH_CODE";
IDbranchNameDropDownList.DataBind();
IDbranchNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["ID_BK_BR_NM_CD"].ToString();
}
else
{
IDbankNameDropDownList.SelectedValue = "0";
IDbranchNameDropDownList.SelectedValue = "0";
IDbankNameDropDownList.Enabled = false;
IDbranchNameDropDownList.Enabled = false;
}
}
else
{
IDAccNoTextBox.Text = "";
IDbankNameDropDownList.SelectedValue = "0";
IDbranchNameDropDownList.SelectedValue = "0";
IDbankNameDropDownList.Enabled = false;
IDbranchNameDropDownList.Enabled = false;
}
holderNameTextBox.Text = dtHolderRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["HNAME"].ToString();
holderFMTextBox.Text = dtHolderRegInfo.Rows[0]["FMH_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["FMH_NAME"].ToString();
holderMotherTextBox.Text = dtHolderRegInfo.Rows[0]["MO_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["MO_NAME"].ToString();
holderAddress1TextBox.Text = dtHolderRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["ADDRS1"].ToString();
holderAddress2TextBox.Text = dtHolderRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["ADDRS2"].ToString();
holderOccupationDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["OCC_CODE"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["OCC_CODE"].ToString();
holderNationalityTextBox.Text = dtHolderRegInfo.Rows[0]["NATIONALITY"].Equals(DBNull.Value) ? "BANGLADESHI" : dtHolderRegInfo.Rows[0]["NATIONALITY"].ToString();
holderTelphoneTextBox.Text = dtHolderRegInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["TEL_NO"].ToString();
holderTINTextBox.Text = dtHolderRegInfo.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["TIN"].ToString();
holderEmailTextBox.Text = dtHolderRegInfo.Rows[0]["EMAIL"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["EMAIL"].ToString();
holderMaritialStatusDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["MAR_STAT"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["MAR_STAT"].ToString();
holderEducationDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["EDU_QUA"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["EDU_QUA"].ToString();
holderDateofBirthTextBox.Text = dtHolderRegInfo.Rows[0]["B_DATE"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtHolderRegInfo.Rows[0]["B_DATE"].ToString()).ToString("dd-MMM-yyyy");
holderCityTextBox.Text = dtHolderRegInfo.Rows[0]["CITY"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["CITY"].ToString();
holderSexDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["SEX"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["SEX"].ToString();
holderReligionDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["RELIGION"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["RELIGION"].ToString();
holderRemarksTextBox.Text = dtHolderRegInfo.Rows[0]["REMARKS"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["REMARKS"].ToString();
if (dtHolderRegInfo.Rows[0]["IS_BEFTN"].Equals(DBNull.Value))
{
bftnNoRadioButton.Checked = true;
bftnYesRadioButton.Checked = false;
}
else if (dtHolderRegInfo.Rows[0]["IS_BEFTN"].ToString().ToUpper() == "N")
{
bftnNoRadioButton.Checked = true;
bftnYesRadioButton.Checked = false;
}
else if (dtHolderRegInfo.Rows[0]["IS_BEFTN"].ToString().ToUpper() == "Y")
{
bftnNoRadioButton.Checked = false;
bftnYesRadioButton.Checked = true;
}
jHolderNameTextBox.Text = dtHolderRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["JNT_NAME"].ToString();
jHolderFMTextBox.Text = dtHolderRegInfo.Rows[0]["JNT_FMH_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["JNT_FMH_NAME"].ToString();
jHolderMotherTextBox.Text = dtHolderRegInfo.Rows[0]["JNT_MO_NAME"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["JNT_MO_NAME"].ToString();
jHolderAddress1TextBox.Text = dtHolderRegInfo.Rows[0]["JNT_ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["JNT_ADDRS1"].ToString();
jHolderAddress2TextBox.Text = dtHolderRegInfo.Rows[0]["JNT_ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["JNT_ADDRS2"].ToString();
jHolderNantionalityTextBox.Text = dtHolderRegInfo.Rows[0]["JNT_NATIONALITY"].Equals(DBNull.Value) ? "" : dtHolderRegInfo.Rows[0]["JNT_NATIONALITY"].ToString();
jHolderOccupationDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["JNT_OCC_CODE"].Equals(DBNull.Value) ? "0" : dtHolderRegInfo.Rows[0]["JNT_OCC_CODE"].ToString();
if (dtHolderRegInfo.Rows[0]["BK_FLAG"].ToString() == "Y")
{
isBankDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["BK_FLAG"].ToString();
//string BankAccInfo = dtHolderRegInfo.Rows[0]["SPEC_IN1"].ToString() + dtHolderRegInfo.Rows[0]["SPEC_IN2"].ToString();
//string[] BankAccountInfo = BankAccInfo.Split(',');
//if (BankAccountInfo.Length > 0)
//{
// bankAccTextBox.Text = BankAccountInfo[0].ToString();
// if (BankAccountInfo.Length > 1)
// {
// bankNameTextBox.Text = BankAccountInfo[1].ToString();
// }
// if (BankAccountInfo.Length > 2)
// {
// branchNameTextBox.Text = BankAccountInfo[2].ToString();
// }
// if (BankAccountInfo.Length > 3)
// {
// for (int loop = 3; loop < BankAccountInfo.Length; loop++)
// {
// branchAddress = branchAddress + BankAccountInfo[loop].ToString();
// }
// bankAddressTextBox.Text = branchAddress;
// }
// bankAccTextBox.Enabled = true;
// bankNameTextBox.Enabled = false;
// branchNameTextBox.Enabled = false;
// bankAddressTextBox.Enabled = true;
// bankNameDropDownList.Enabled = true;
// branchNameDropDownList.Enabled = true;
// bankNameDropDownList.SelectedValue = "0";
// branchNameDropDownList.SelectedValue = "0";
//}
//else
//{
// bankAccTextBox.Enabled = true;
// bankNameTextBox.Enabled = false;
// branchNameTextBox.Enabled = false;
// bankAddressTextBox.Enabled = true;
//}
if (!dtHolderRegInfo.Rows[0]["BK_NM_CD"].Equals(DBNull.Value) && !dtHolderRegInfo.Rows[0]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtHolderRegInfo.Rows[0]["BK_AC_NO"].Equals(DBNull.Value))
{
bankAccTextBox.Enabled = true;
bankNameDropDownList.Enabled = true;
branchNameDropDownList.Enabled = true;
bankAddressTextBox.Enabled = true;
bankNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["BK_NM_CD"].ToString();
branchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtHolderRegInfo.Rows[0]["BK_NM_CD"].ToString()));
branchNameDropDownList.DataTextField = "BRANCH_NAME";
branchNameDropDownList.DataValueField = "BRANCH_CODE";
branchNameDropDownList.DataBind();
branchNameDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["BK_BR_NM_CD"].ToString();
bankAccTextBox.Text = dtHolderRegInfo.Rows[0]["BK_AC_NO"].ToString();
DataTable dtBankBracnhInfo = unitHolderRegBLObj.dtGetBankBracnhInfo(Convert.ToInt32(dtHolderRegInfo.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtHolderRegInfo.Rows[0]["BK_BR_NM_CD"].ToString()));
if (dtBankBracnhInfo.Rows.Count > 0)
{
bankAddressTextBox.Text = "Routing No=[" + dtBankBracnhInfo.Rows[0]["ROUTING_NO"].ToString() + "] " + dtBankBracnhInfo.Rows[0]["ADDRESS"].ToString() + " ";
}
}
}
else
{
isBankDropDownList.SelectedValue = dtHolderRegInfo.Rows[0]["BK_FLAG"].ToString();
bankAccTextBox.Text = "";
bankAddressTextBox.Text = "";
bankNameDropDownList.SelectedValue = "0";
branchNameDropDownList.SelectedValue = "0";
bankAccTextBox.Enabled = false;
bankAddressTextBox.Enabled = false;
bankNameDropDownList.Enabled = false;
branchNameDropDownList.Enabled = false;
}
if (dtNomineeRegInfo.Rows.Count > 0)
{
NomiControlNoTextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_CTL_NO"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_CTL_NO"].ToString();
nomi1NameTextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_NAME"].ToString();
nomi1FMTextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_FMH_NAME"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_FMH_NAME"].ToString();
nomi1MotherNameTextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].ToString();
nomi1Address1TextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_ADDRS1"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_ADDRS1"].ToString();
nomi1Address2TextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_ADDRS2"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_ADDRS2"].ToString();
nomi1OccupationDropDownList.SelectedValue = dtNomineeRegInfo.Rows[0]["NOMI_OCC_CODE"].Equals(DBNull.Value) ? "0" : dtNomineeRegInfo.Rows[0]["NOMI_OCC_CODE"].ToString();
nomi1NationalityTextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_NATIONALITY"].Equals(DBNull.Value) ? "BANGLADESHI" : dtNomineeRegInfo.Rows[0]["NOMI_NATIONALITY"].ToString();
nomi1RelationDropDownList.SelectedValue = dtNomineeRegInfo.Rows[0]["NOMI_REL"].Equals(DBNull.Value) ? "0" : dtNomineeRegInfo.Rows[0]["NOMI_REL"].ToString();
nomi1PtcTextBox.Text = dtNomineeRegInfo.Rows[0]["PERCENTAGE"].Equals(DBNull.Value) ? "0" : dtNomineeRegInfo.Rows[0]["PERCENTAGE"].ToString();
}
if (dtNomineeRegInfo.Rows.Count > 1)
{
nomi2NameTextBox.Text = dtNomineeRegInfo.Rows[1]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[1]["NOMI_NAME"].ToString();
nomi2FMTextBox.Text = dtNomineeRegInfo.Rows[1]["NOMI_FMH_NAME"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[1]["NOMI_FMH_NAME"].ToString();
nomi2MotherNameTextBox.Text = dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].ToString();
nomi2Address1TextBox.Text = dtNomineeRegInfo.Rows[1]["NOMI_ADDRS1"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[1]["NOMI_ADDRS1"].ToString();
nomi2Address2TextBox.Text = dtNomineeRegInfo.Rows[1]["NOMI_ADDRS2"].Equals(DBNull.Value) ? "" : dtNomineeRegInfo.Rows[1]["NOMI_ADDRS2"].ToString();
nomi2OccupationDropDownList.SelectedValue = dtNomineeRegInfo.Rows[1]["NOMI_OCC_CODE"].Equals(DBNull.Value) ? "0" : dtNomineeRegInfo.Rows[1]["NOMI_OCC_CODE"].ToString();
nomi2NationalityTextBox.Text = dtNomineeRegInfo.Rows[1]["NOMI_NATIONALITY"].Equals(DBNull.Value) ? "BANGLADESHI" : dtNomineeRegInfo.Rows[1]["NOMI_NATIONALITY"].ToString();
nomi2RelationDropDownList.SelectedValue = dtNomineeRegInfo.Rows[1]["NOMI_REL"].Equals(DBNull.Value) ? "0" : dtNomineeRegInfo.Rows[1]["NOMI_REL"].ToString();
nomi2PtcTextBox.Text = dtNomineeRegInfo.Rows[1]["PERCENTAGE"].Equals(DBNull.Value) ? "0" : dtNomineeRegInfo.Rows[1]["PERCENTAGE"].ToString();
}
if (dtNomineeRegInfo.Rows.Count <= 0)
{
NomiControlNoTextBox.Text = "";
nomi1NameTextBox.Text = "";
nomi1FMTextBox.Text = "";
nomi1Address1TextBox.Text = "";
nomi1Address2TextBox.Text = "";
nomi1OccupationDropDownList.SelectedValue = "0";
nomi1NationalityTextBox.Text = "";
nomi1RelationDropDownList.SelectedValue = "0";
nomi1PtcTextBox.Text = "";
nomi2NameTextBox.Text = "";
nomi2FMTextBox.Text = "";
nomi2Address1TextBox.Text = "";
nomi2Address2TextBox.Text = "";
nomi2OccupationDropDownList.SelectedValue = "0";
nomi2NationalityTextBox.Text = "";
nomi2RelationDropDownList.SelectedValue = "0";
nomi2PtcTextBox.Text = "";
}
if (dtNomineeRegInfo.Rows.Count == 1)
{
nomi2NameTextBox.Text = "";
nomi2FMTextBox.Text = "";
nomi2Address1TextBox.Text = "";
nomi2Address2TextBox.Text = "";
nomi2OccupationDropDownList.SelectedValue = "0";
nomi2NationalityTextBox.Text = "";
nomi2RelationDropDownList.SelectedValue = "0";
nomi2PtcTextBox.Text = "";
}
}
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);
}
}
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();
UnitRepurchase unitRepObj = new UnitRepurchase();
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();
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
}
else
{
// dvContentBottom.Visible = false;
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Repurchase');", true);
}
RepNoTextBox.Text = unitRepBLObj.getNextRepurchaseNo(unitRegObj, userObj).ToString();
unitRepObj.RepurchaseNo = unitRepBLObj.getNextRepurchaseNo(unitRegObj, userObj) - 1;
RepDateTextBox.Text = unitRepBLObj.getLastRepDate(unitRegObj, unitRepObj).ToString("dd-MMM-yyyy");
RepRateTextBox.Text = unitRepBLObj.getLastRepRate(unitRegObj, unitRepObj).ToString();
//transferNoTextBox.Text = unitTransferBLObj.getNextTransferNo(unitRegObj, userObj).ToString();
}
else
{
//HolderNameTextBox.Text = "";
//HolderJNameTextBox.Text = "";
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Repurchase');", true);
}
}
else
{
TotalUnitHoldingTextBox.Text = "";
TotalUnitRepurchaseTextBox.Text = "";
TotalLienUnitHoldingTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
