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