protected void bankNameDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
branchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(bankNameDropDownList.SelectedValue.ToString()));
branchNameDropDownList.DataTextField = "BRANCH_NAME";
branchNameDropDownList.DataValueField = "BRANCH_CODE";
branchNameDropDownList.DataBind();
}
protected void IDbankNameDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
dvIDInof.Style.Add("visibility", "visible");
IDbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(IDbankNameDropDownList.SelectedValue.ToString()));
IDbranchNameDropDownList.DataTextField = "BRANCH_NAME";
IDbranchNameDropDownList.DataValueField = "BRANCH_CODE";
IDbranchNameDropDownList.DataBind();
}
protected void LienMarkDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = FundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = BranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = RegNoTextBox.Text.Trim();
UnitLien unitLienObj = new UnitLien();
unitLienObj.LienNo = Convert.ToInt32(LienMarkDropDownList.SelectedValue.ToString());
DataTable dtLienDetails = unitLienBLObj.dtLienDetailsInfo(unitRegObj, unitLienObj);
if (dtLienDetails.Rows.Count > 0)
{
LienbankNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_CODE"].ToString();
LienbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtLienDetails.Rows[0]["LN_BK_CODE"].ToString()));
LienbranchNameDropDownList.DataTextField = "BRANCH_NAME";
LienbranchNameDropDownList.DataValueField = "BRANCH_CODE";
LienbranchNameDropDownList.DataBind();
LienbranchNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_BR_CODE"].ToString();
LienReqDateTextBox.Text = dtLienDetails.Rows[0]["LN_REQ_DT"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtLienDetails.Rows[0]["LN_REQ_DT"].ToString()).ToString("dd-MMM-yyyy");
LienReqRefTextBox.Text = dtLienDetails.Rows[0]["LN_REQ_REF"].Equals(DBNull.Value) ? "" : dtLienDetails.Rows[0]["LN_REQ_REF"].ToString();
}
else
{
}
}
protected void moneyReceipDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dtMoneyReceitInfoDetails = unitSaleBLObj.dtMoneyRecieptInfoDetails(Convert.ToInt64(moneyReceipDropDownList.SelectedValue.ToString()));
if (dtMoneyReceitInfoDetails.Rows.Count > 0)
{
saleDateTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["RECEIPT_DATE"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(dtMoneyReceitInfoDetails.Rows[0]["RECEIPT_DATE"].ToString()).ToString("dd-MMM-yyyy");
saleRateTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["RATE"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["RATE"].ToString();
unitQtyTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["UNIT_QTY"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["UNIT_QTY"].ToString();
CashAmountTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["CASH_AMT"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["CASH_AMT"].ToString();
MultiplePayTypeTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["MULTI_PAY_REMARKS"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["MULTI_PAY_REMARKS"].ToString();
sellingAgentCodeTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["SELLING_AGENT_ID"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["SELLING_AGENT_ID"].ToString();
if (!dtMoneyReceitInfoDetails.Rows[0]["CHQ_TYPE"].Equals(DBNull.Value))
{
string chqType = dtMoneyReceitInfoDetails.Rows[0]["CHQ_TYPE"].ToString();
if (chqType.ToString().ToUpper() == "CHQ" || chqType.ToString().ToUpper() == "DD" || chqType.ToString().ToUpper() == "PO")
{
DataTable dtBankInfo = regBLObj.dtGetBankBracnhInfo(dtMoneyReceitInfoDetails.Rows[0]["ROUTING_NO"].ToString());
ChequeTypeDropDownList.SelectedValue = dtMoneyReceitInfoDetails.Rows[0]["CHQ_TYPE"].ToString();
bankNameDropDownList.SelectedValue = dtBankInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value) ? "0" : dtBankInfo.Rows[0]["BANK_CODE"].ToString();
branchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtBankInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value) ? "0" : dtBankInfo.Rows[0]["BANK_CODE"].ToString()));
branchNameDropDownList.DataTextField = "BRANCH_NAME";
branchNameDropDownList.DataValueField = "BRANCH_CODE";
branchNameDropDownList.DataBind();
branchNameDropDownList.SelectedValue = dtBankInfo.Rows[0]["BRANCH_CODE"].Equals(DBNull.Value) ? "0" : dtBankInfo.Rows[0]["BRANCH_CODE"].ToString();
CHQDDNoRemarksTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["CHQ_DD_NO"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["CHQ_DD_NO"].ToString();
chequeDateTextBox.Text = dtMoneyReceitInfoDetails.Rows[0]["CHQ_DD_DATE"].Equals(DBNull.Value) ? "" : dtMoneyReceitInfoDetails.Rows[0]["CHQ_DD_DATE"].ToString();
}
}
if (!dtMoneyReceitInfoDetails.Rows[0]["PAY_TYPE"].Equals(DBNull.Value))
{
string chqType = dtMoneyReceitInfoDetails.Rows[0]["CHQ_TYPE"].ToString();
if (chqType.ToString().ToUpper() == "CHQ")
{
ChqRadioButton.Checked = true;
}
else if (chqType.ToString().ToUpper() == "CASH")
{
CashRadioButton.Checked = true;
}
else if (chqType.ToString().ToUpper() == "BOTH")
{
BothRadioButton.Checked = true;
}
else if (chqType.ToString().ToUpper() == "MULT")
{
MultiRadioButton.Checked = true;
}
}
}
else
{
clearSale();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", 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 dtLienCerts = unitLienBLObj.dtTotalLienCert(unitRegObj, unitLienObj);
long totalLienAmount = unitLienBLObj.totalLienAmount(unitRegObj, unitLienObj);
DataTable dtLienDetails = unitLienBLObj.dtLienDetailsInfo(unitRegObj, unitLienObj);
if (dtLienDetails.Rows.Count > 0)
{
LienbankNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_CODE"].ToString();
LienbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtLienDetails.Rows[0]["LN_BK_CODE"].ToString()));
LienbranchNameDropDownList.DataTextField = "BRANCH_NAME";
LienbranchNameDropDownList.DataValueField = "BRANCH_CODE";
LienbranchNameDropDownList.DataBind();
LienbranchNameDropDownList.SelectedValue = dtLienDetails.Rows[0]["LN_BK_BR_CODE"].ToString();
if (dtLienCerts.Rows.Count > 0)
{
dvContentBottom.Visible = true;
leftDataGrid.DataSource = dtLienCerts;
leftDataGrid.DataBind();
TotalLienUnitHoldingTextBox.Text = totalLienAmount.ToString();
}
else
{
TotalLienUnitHoldingTextBox.Text = "";
TotalUnitLienCancelTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien Cancel ');", true);
}
LienMarkCancelNoTextBox.Text = unitLienBLObj.getNextLienCancelNo(unitRegObj, userObj).ToString();
unitLienObj.LienCancelNo = unitLienBLObj.getNextLienCancelNo(unitRegObj, userObj) - 1;
LienCancelReqDateTextBox.Text = unitLienBLObj.getLastLienCancelReqDate(unitRegObj, unitLienObj).ToString("dd-MMM-yyyy");
}
else
{
TotalLienUnitHoldingTextBox.Text = "";
TotalUnitLienCancelTextBox.Text = "";
dvContentBottom.Visible = false;
LienbankNameDropDownList.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Units To Lien Cancel ');", true);
}
}
protected void LienbankNameDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
LienbranchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(LienbankNameDropDownList.SelectedValue.ToString()));
LienbranchNameDropDownList.DataTextField = "BRANCH_NAME";
LienbranchNameDropDownList.DataValueField = "BRANCH_CODE";
LienbranchNameDropDownList.DataBind();
if (NormalRadioButton.Checked)
{
divDeath.Style.Add("visibility", "hidden");
dvChequeIssue.Style.Add("visibility", "hidden");
}
if (YesRadioButton.Checked)
{
divLienMark.Style.Add("visibility", "visible");
}
}
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);
}
}
public void displayRegInfo()
{
UnitSale saleObj = new UnitSale();
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = fundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = branchCodeTextBox.Text.Trim();
saleObj.SaleNo = Convert.ToInt32(saleNumberTextBox.Text.Trim().ToString());
DataTable dtDino = unitSaleBLObj.getTableDinoForEdit();
if (unitSaleBLObj.IsValidSaleNumber(unitRegObj, saleObj))
{
DataTable dtSaleInfo = unitSaleBLObj.dtGetSaleInfo(unitRegObj, saleObj);
if (dtSaleInfo.Rows.Count > 0)
{
dinoGridView.Visible = true;
regNoTextBox.Text = dtSaleInfo.Rows[0]["REG_NO"].ToString();
holderNameTextBox.Text = dtSaleInfo.Rows[0]["HNAME"].ToString();
jHolderTextBox.Text = dtSaleInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["JNT_NAME"].ToString();
holderAddress1TextBox.Text = dtSaleInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["ADDRS1"].ToString();
holderAddress2TextBox.Text = dtSaleInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["ADDRS2"].ToString();
holderTelphoneTextBox.Text = dtSaleInfo.Rows[0]["TEL_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["TEL_NO"].ToString();
string CIP = dtSaleInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtSaleInfo.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();
MoneyReceiptNoTextBox.Text = dtSaleInfo.Rows[0]["MONY_RECT_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["MONY_RECT_NO"].ToString();
saleDateTextBox.Text = dtSaleInfo.Rows[0]["SL_DT"].Equals(DBNull.Value) ? "" :Convert.ToDateTime(dtSaleInfo.Rows[0]["SL_DT"].ToString()).ToString("dd-MMM-yyyy");
saleRateTextBox.Text = dtSaleInfo.Rows[0]["SL_PRICE"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["SL_PRICE"].ToString();
saleTypeDropDownList.SelectedValue = dtSaleInfo.Rows[0]["SL_TYPE"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["SL_TYPE"].ToString();
unitQtyTextBox.Text = dtSaleInfo.Rows[0]["QTY"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["QTY"].ToString();
if (dtSaleInfo.Rows[0]["PAY_TYPE"].Equals(DBNull.Value))
{
}
else
{
string payType = dtSaleInfo.Rows[0]["PAY_TYPE"].ToString();
if (payType.ToString().ToUpper() == "CHQ" || payType.ToString().ToUpper() == "DD" || payType.ToString().ToUpper() == "PO")
{
ChqRadioButton.Checked = true;
ChequeTypeDropDownList.SelectedValue = dtSaleInfo.Rows[0]["PAY_TYPE"].ToString();
bankNameDropDownList.Enabled = true;
branchNameDropDownList.Enabled = true;
CashAmountTextBox.Enabled = false;
MultiplePayTypeTextBox.Enabled = false;
CHQDDNoRemarksTextBox.Enabled = true;
bankNameDropDownList.SelectedValue = dtSaleInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value)? "0":dtSaleInfo.Rows[0]["BANK_CODE"].ToString();
branchNameDropDownList.DataSource = opendMFDAO.dtFillBranchName(Convert.ToInt32(dtSaleInfo.Rows[0]["BANK_CODE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["BANK_CODE"].ToString()));
branchNameDropDownList.DataTextField = "BRANCH_NAME";
branchNameDropDownList.DataValueField = "BRANCH_CODE";
branchNameDropDownList.DataBind();
branchNameDropDownList.SelectedValue = dtSaleInfo.Rows[0]["BRANCH_CODE"].Equals(DBNull.Value) ? "0" : dtSaleInfo.Rows[0]["BRANCH_CODE"].ToString();
CHQDDNoRemarksTextBox.Text = dtSaleInfo.Rows[0]["CHQ_DD_NO"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CHQ_DD_NO"].ToString();
chequeDateTextBox.Text = dtSaleInfo.Rows[0]["CHEQUE_DT"].Equals(DBNull.Value) ? "" : dtSaleInfo.Rows[0]["CHEQUE_DT"].ToString();
}
}
dinoGridView.DataSource = dtSaleInfo;
dinoGridView.DataBind();
Session["dtSaleInfo"] = dtSaleInfo;
}
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 ('Sale Information is not Available');", true);
}
}
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 Sale Number');", true);
}
}
