protected void regSaveButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
regObj.FundCode = fundCodeTextBox.Text.Trim();
regObj.BranchCode = branchCodeTextBox.Text.Trim();
regObj.RegDate = Convert.ToDateTime(regDateTextBox.Text.Trim().ToString());
regObj.RegNumber = regNoTextBox.Text.Trim();
regObj.RegType = regTypeDropDownList.SelectedValue;
regObj.RegIsCIP = isCIPDropDownList.SelectedValue;
regObj.IsIDAccount = isIDDropDownList.SelectedValue;
if (isIDDropDownList.SelectedValue.ToString().ToUpper() == "Y")
{
regObj.IdBankID = Convert.ToInt32(IDbankNameDropDownList.SelectedValue.ToString());
regObj.IdBankBranchID = Convert.ToInt32(IDbranchNameDropDownList.SelectedValue.ToString());
}
regObj.IdAccNo = IDAccNoTextBox.Text.Trim().ToString();
UnitHolderInfo unitHolderObj = new UnitHolderInfo();
unitHolderObj.HolderName = holderNameTextBox.Text.Trim();
unitHolderObj.HolderFMHName = holderFMTextBox.Text.Trim();
unitHolderObj.HolderMotherName = holderMotherTextBox.Text.Trim();
unitHolderObj.HolderAddress1 = holderAddress1TextBox.Text.Trim();
unitHolderObj.HolderAddress2 = holderAddress2TextBox.Text.Trim();
unitHolderObj.HolderOccupation = Convert.ToInt16(holderOccupationDropDownList.SelectedValue);
unitHolderObj.HolderNationality = holderNationalityTextBox.Text.Trim();
unitHolderObj.HolderTIN = holderTINTextBox.Text.Trim();
unitHolderObj.HolderTelephone = holderTelphoneTextBox.Text.Trim();
unitHolderObj.HolderEmail = holderEmailTextBox.Text.Trim();
unitHolderObj.HolderMaritialStatus = holderMaritialStatusDropDownList.SelectedValue;
unitHolderObj.HolderEduQua = holderEducationDropDownList.SelectedValue;
unitHolderObj.HolderDateofBirth = holderDateofBirthTextBox.Text.Trim().ToString();
unitHolderObj.HolderCity = holderCityTextBox.Text.Trim();
unitHolderObj.HolderSex = holderSexDropDownList.SelectedValue;
unitHolderObj.HolderReligion = holderReligionDropDownList.SelectedValue;
unitHolderObj.HolderRemarks = holderRemarksTextBox.Text.Trim();
UnitJointHolderInfo jHolderObj = new UnitJointHolderInfo();
jHolderObj.JHolderName = jHolderNameTextBox.Text.Trim();
jHolderObj.JHolderFMHName = jHolderFMTextBox.Text.Trim();
jHolderObj.JHolderMotherName = jHolderMotherTextBox.Text.Trim().ToString().ToUpper();
jHolderObj.JHolderAddress1 = jHolderAddress1TextBox.Text.Trim();
jHolderObj.JHolderAddress2 = jHolderAddress2TextBox.Text.Trim();
jHolderObj.JHolderNationality = jHolderNantionalityTextBox.Text.Trim();
jHolderObj.JHolderOccupation = Convert.ToInt16(jHolderOccupationDropDownList.SelectedValue);
UnitHolderNominee nomiObj = new UnitHolderNominee();
nomiObj.NomiControlNo = NomiControlNoTextBox.Text.Trim().ToString();
nomiObj.Nomi1Name = nomi1NameTextBox.Text.Trim();
nomiObj.Nomi1FMName = nomi1FMTextBox.Text.Trim();
nomiObj.Nomi1MotherName = nomi1MotherNameTextBox.Text.Trim().ToUpper().ToString();
nomiObj.Nomi1Address1 = nomi1Address1TextBox.Text.Trim();
nomiObj.Nomi1Address2 = nomi1Address2TextBox.Text.Trim();
nomiObj.Nomi1Occupation = Convert.ToInt16(nomi1OccupationDropDownList.SelectedValue);
nomiObj.Nomi1Nationality = nomi1NationalityTextBox.Text.Trim();
nomiObj.Nomi1Relation = nomi1RelationDropDownList.SelectedValue;
nomiObj.Nomi1Percentage = nomi1PtcTextBox.Text.Trim().ToString();
nomiObj.Nomi2Name = nomi2NameTextBox.Text.Trim();
nomiObj.Nomi2FMName = nomi2FMTextBox.Text.Trim();
nomiObj.Nomi2MotherName = nomi2MotherNameTextBox.Text.Trim().ToString().ToUpper();
nomiObj.Nomi2Address1 = nomi2Address1TextBox.Text.Trim();
nomiObj.Nomi2Address2 = nomi2Address2TextBox.Text.Trim();
nomiObj.Nomi2Occupation = Convert.ToInt16(nomi2OccupationDropDownList.SelectedValue);
nomiObj.Nomi2Nationality = nomi2NationalityTextBox.Text.Trim();
nomiObj.Nomi2Relation = nomi2RelationDropDownList.SelectedValue;
nomiObj.Nomi2Percentage = nomi2PtcTextBox.Text.Trim();
UnitHolderBankInfo bankInfoObj = new UnitHolderBankInfo();
if (bftnNoRadioButton.Checked)
{
bankInfoObj.IsBEFTN = "N";
}
else if (bftnYesRadioButton.Checked)
{
bankInfoObj.IsBEFTN = "Y";
}
bankInfoObj.IsBankInfo = isBankDropDownList.SelectedValue;
if (isBankDropDownList.SelectedValue.ToString().ToUpper() == "Y")
{
bankInfoObj.BankAccountNo = bankAccTextBox.Text.Trim();
//bankInfoObj.BankName = bankNameDropDownList.SelectedItem.Text.Trim().ToString();
//bankInfoObj.BranchName = branchNameDropDownList.SelectedItem.Text.Trim().ToString();
//bankInfoObj.BankAddress = bankAddressTextBox.Text.Trim().ToString();
bankInfoObj.BankCode = bankNameDropDownList.SelectedValue.ToString();
bankInfoObj.BankBranchCode = branchNameDropDownList.SelectedValue.ToString();
}
try
{
//if (unitHolderRegBLObj.IsDuplicateNomineeControlEdit(regObj, nomiObj))
//{
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Duplicate().ToString() + " " + "Nominee Control Number " + "');", true);
//}
//else
if (unitHolderRegBLObj.CheckSanctionList(regObj, unitHolderObj) != "")
{
string errorMessage = unitHolderRegBLObj.CheckSanctionList(regObj, unitHolderObj);
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed :" + errorMessage + "');", true);
}
else if (unitHolderRegBLObj.IsEditPermit(regObj.FundCode.ToString()))
{
string errorMessage = "Please Contact with Administrator";
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed :" + errorMessage + "');", true);
}
//else if (regObj.FundCode == "IAMPH")
//{
// string errorMessage = "Please Contact with Administrator";
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('Save Failed :" + errorMessage + "');", true);
//}
else
{
unitHolderRegBLObj.SaveRegEditInfo(opendMFDAO.HolderRegInfo(regObj), opendMFDAO.dtNomineeRegInfo(regObj), userObj); // Backup Previous Information
unitHolderRegBLObj.UpdateRegInfo(regObj, unitHolderObj, jHolderObj, nomiObj, bankInfoObj, userObj); //Update reg Info;
ClearText();
// ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert(" msgObj.Success + ");", true);
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true);
//ClientScript.RegisterStartupScript(this.GetType(), "Reset Fields", "fnReset();", true);
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
public void displayRegInfo(UnitHolderRegistration unitRegObj)
{
dvLedger.Visible = true;
unitRegObj.FundCode = fundCodeDDL.SelectedValue.ToString();
unitRegObj.BranchCode = branchCodeDDL.SelectedValue.ToString();
unitRegObj.RegNumber = regNoTextBox.Text.Trim();
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
DataTable dtNominee = opendMFDAO.dtNomineeRegInfo(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
//Trasaction Lock Status
if (!(dtRegInfo.Rows[0]["ALL_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["ALL_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["SL_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["SL_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["REP_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["REP_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["TR_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["TR_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["LIEN_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["LIEN_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["REN_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["REN_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["LOCK_REMARKS"].Equals(DBNull.Value)))
{
dvLockin.Attributes.Add("style", "visibility:visible");
if (dtRegInfo.Rows[0]["ALL_LOCK"].ToString() == "Y")
{
SaleLockLabel.Text = "YES";
RepLockLabel.Text = "YES";
TransferLockLabel.Text = "YES";
LienLockLabel.Text = "YES";
RenLockLabel.Text = "YES";
LockRemarksTextBox.Text = dtRegInfo.Rows[0]["LOCK_REMARKS"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["LOCK_REMARKS"].ToString();
}
else
{
if (dtRegInfo.Rows[0]["SL_LOCK"].ToString() == "Y")
{
SaleLockLabel.Text = "YES";
}
else
{
SaleLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["REP_LOCK"].ToString() == "Y")
{
RepLockLabel.Text = "YES";
}
else
{
RepLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["TR_LOCK"].ToString() == "Y")
{
TransferLockLabel.Text = "YES";
}
else
{
TransferLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["LIEN_LOCK"].ToString() == "Y")
{
LienLockLabel.Text = "YES";
}
else
{
LienLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["REN_LOCK"].ToString() == "Y")
{
RenLockLabel.Text = "YES";
}
else
{
RenLockLabel.Text = "NO";
}
LockRemarksTextBox.Text = dtRegInfo.Rows[0]["LOCK_REMARKS"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["LOCK_REMARKS"].ToString();
}
}
else
{
SaleLockLabel.Text = "NO";
RepLockLabel.Text = "NO";
TransferLockLabel.Text = "NO";
LienLockLabel.Text = "NO";
RenLockLabel.Text = "NO";
dvLockin.Attributes.Add("style", "visibility:hidden");
}
regNoTextBox.Text = dtRegInfo.Rows[0]["REG_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["REG_NO"].ToString();
holderBOTextBox.Text = dtRegInfo.Rows[0]["BO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["BO"].ToString();
folioTextBox.Text = dtRegInfo.Rows[0]["FOLIO_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["FOLIO_NO"].ToString();
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();
tdTIN.InnerHtml = dtRegInfo.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["TIN"].ToString();
string CIP = dtRegInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["CIP"].ToString();
string BEFTN = dtRegInfo.Rows[0]["IS_BEFTN"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["IS_BEFTN"].ToString();
if (string.Compare(CIP, "Y", true) == 0)
{
tdCIP.InnerHtml = "YES";
}
else if (string.Compare(CIP, "N", true) == 0)
{
tdCIP.InnerHtml = "NO";
}
else
{
tdCIP.InnerHtml = " ";
}
if (string.Compare(BEFTN, "Y", true) == 0)
{
tdBEFTN.InnerHtml = "YES";
}
else
{
tdBEFTN.InnerHtml = "NO";
}
if (dtNominee.Rows.Count > 1)
{
Nominee1NameTextBox.Text = dtNominee.Rows[0]["NOMI_NAME"].ToString();
Nominee2NameTextBox.Text = dtNominee.Rows[1]["NOMI_NAME"].ToString();
}
else if (dtNominee.Rows.Count > 0)
{
Nominee1NameTextBox.Text = dtNominee.Rows[0]["NOMI_NAME"].ToString();
Nominee2NameTextBox.Text = "";
}
else
{
Nominee1NameTextBox.Text = "";
Nominee2NameTextBox.Text = "";
}
RemarksTextBox.Text = dtRegInfo.Rows[0]["REMARKS"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["REMARKS"].ToString();
if (dtRegInfo.Rows[0]["BK_FLAG"].ToString() == "Y")
{
string bankInfo = "";
if (!dtRegInfo.Rows[0]["BK_NM_CD"].Equals(DBNull.Value) && !dtRegInfo.Rows[0]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtRegInfo.Rows[0]["BK_AC_NO"].Equals(DBNull.Value))
{
bankInfo = "AC:" + dtRegInfo.Rows[0]["BK_AC_NO"].ToString();
bankInfo = bankInfo + " , " + reportObj.getBankNameByBankCode(Convert.ToInt32(dtRegInfo.Rows[0]["BK_NM_CD"].ToString())).ToString();
bankInfo = bankInfo + " , " + reportObj.getBankBranchNameByCode(Convert.ToInt32(dtRegInfo.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtRegInfo.Rows[0]["BK_BR_NM_CD"].ToString())).ToString();
DataTable dtBankBracnhInfo = unitHolderRegBLObj.dtGetBankBracnhInfo(Convert.ToInt32(dtRegInfo.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtRegInfo.Rows[0]["BK_BR_NM_CD"].ToString()));
if (dtBankBracnhInfo.Rows.Count > 0)
{
bankInfo = bankInfo + " Routing No=[" + dtBankBracnhInfo.Rows[0]["ROUTING_NO"].ToString() + "] " + dtBankBracnhInfo.Rows[0]["ADDRESS"].ToString() + " ";
}
}
BankInfoTextBox.Text = bankInfo.ToString();
}
else
{
BankInfoTextBox.Text = "";
}
DataTable dtDividendLedger = getDividendLedger(unitRegObj);
// int balance = 0;
if (dtDividendLedger.Rows.Count > 0)
{
dgLedger.DataSource = dtDividendLedger;
dgLedger.DataBind();
totalRowCountLabel.Text = dtDividendLedger.Rows.Count.ToString();
Session["dtDividendLedger"] = dtDividendLedger;
displaySign();
}
else
{
ClearText();
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
dvLedger.Visible = false;
Session["dtDividendLedger"] = null;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Ledger Balance Data Found');", true);
}
}
else
{
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
dvLedger.Visible = false;
Session["dtDividendLedger"] = null;
ClientScript.RegisterStartupScript(this.GetType(), "Popup", " window.fnResetAll();", true);
tdCIP.InnerHtml = "";
}
}
public void displayRegInfo(UnitHolderRegistration unitRegObj)
{
dvLedger.Visible = true;
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
DataTable dtNominee = opendMFDAO.dtNomineeRegInfo(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
//Trasaction Lock Status
if (!(dtRegInfo.Rows[0]["ALL_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["ALL_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["SL_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["SL_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["REP_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["REP_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["TR_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["TR_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["LIEN_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["LIEN_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["REN_LOCK"].Equals(DBNull.Value) || (dtRegInfo.Rows[0]["REN_LOCK"].ToString() == "N")) || !(dtRegInfo.Rows[0]["LOCK_REMARKS"].Equals(DBNull.Value)))
{
dvLockin.Attributes.Add("style", "visibility:visible");
if (dtRegInfo.Rows[0]["ALL_LOCK"].ToString() == "Y")
{
SaleLockLabel.Text = "YES";
RepLockLabel.Text = "YES";
TransferLockLabel.Text = "YES";
LienLockLabel.Text = "YES";
RenLockLabel.Text = "YES";
LockRemarksTextBox.Text = dtRegInfo.Rows[0]["LOCK_REMARKS"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["LOCK_REMARKS"].ToString();
}
else
{
if (dtRegInfo.Rows[0]["SL_LOCK"].ToString() == "Y")
{
SaleLockLabel.Text = "YES";
}
else
{
SaleLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["REP_LOCK"].ToString() == "Y")
{
RepLockLabel.Text = "YES";
}
else
{
RepLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["TR_LOCK"].ToString() == "Y")
{
TransferLockLabel.Text = "YES";
}
else
{
TransferLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["LIEN_LOCK"].ToString() == "Y")
{
LienLockLabel.Text = "YES";
}
else
{
LienLockLabel.Text = "NO";
}
if (dtRegInfo.Rows[0]["REN_LOCK"].ToString() == "Y")
{
RenLockLabel.Text = "YES";
}
else
{
RenLockLabel.Text = "NO";
}
LockRemarksTextBox.Text = dtRegInfo.Rows[0]["LOCK_REMARKS"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["LOCK_REMARKS"].ToString();
}
}
else
{
SaleLockLabel.Text = "NO";
RepLockLabel.Text = "NO";
TransferLockLabel.Text = "NO";
LienLockLabel.Text = "NO";
RenLockLabel.Text = "NO";
dvLockin.Attributes.Add("style", "visibility:hidden");
}
regNoTextBox.Text = dtRegInfo.Rows[0]["REG_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["REG_NO"].ToString();
holderBOTextBox.Text = dtRegInfo.Rows[0]["BO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["BO"].ToString();
folioTextBox.Text = dtRegInfo.Rows[0]["FOLIO_NO"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["FOLIO_NO"].ToString();
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();
tdTIN.InnerHtml = dtRegInfo.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["TIN"].ToString();
string CIP = dtRegInfo.Rows[0]["CIP"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["CIP"].ToString();
string BEFTN = dtRegInfo.Rows[0]["IS_BEFTN"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["IS_BEFTN"].ToString();
if (string.Compare(CIP, "Y", true) == 0)
{
tdCIP.InnerHtml = "YES";
}
else if (string.Compare(CIP, "N", true) == 0)
{
tdCIP.InnerHtml = "NO";
}
else
{
tdCIP.InnerHtml = " ";
}
if (string.Compare(BEFTN, "Y", true) == 0)
{
tdBEFTN.InnerHtml = "YES";
}
else
{
tdBEFTN.InnerHtml = "NO";
}
if (dtNominee.Rows.Count > 1)
{
Nominee1NameTextBox.Text = dtNominee.Rows[0]["NOMI_NAME"].ToString();
Nominee2NameTextBox.Text = dtNominee.Rows[1]["NOMI_NAME"].ToString();
}
else if (dtNominee.Rows.Count > 0)
{
Nominee1NameTextBox.Text = dtNominee.Rows[0]["NOMI_NAME"].ToString();
Nominee2NameTextBox.Text = "";
}
else
{
Nominee1NameTextBox.Text = "";
Nominee2NameTextBox.Text = "";
}
RemarksTextBox.Text = dtRegInfo.Rows[0]["REMARKS"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["REMARKS"].ToString();
if (dtRegInfo.Rows[0]["BK_FLAG"].ToString() == "Y")
{
string bankInfo = "";
if (!dtRegInfo.Rows[0]["BK_NM_CD"].Equals(DBNull.Value) && !dtRegInfo.Rows[0]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtRegInfo.Rows[0]["BK_AC_NO"].Equals(DBNull.Value))
{
bankInfo = "AC:" + dtRegInfo.Rows[0]["BK_AC_NO"].ToString();
bankInfo = bankInfo + " , " + reportObj.getBankNameByBankCode(Convert.ToInt32(dtRegInfo.Rows[0]["BK_NM_CD"].ToString())).ToString();
bankInfo = bankInfo + " , " + reportObj.getBankBranchNameByCode(Convert.ToInt32(dtRegInfo.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtRegInfo.Rows[0]["BK_BR_NM_CD"].ToString())).ToString();
DataTable dtBankBracnhInfo = unitHolderRegBLObj.dtGetBankBracnhInfo(Convert.ToInt32(dtRegInfo.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtRegInfo.Rows[0]["BK_BR_NM_CD"].ToString()));
if (dtBankBracnhInfo.Rows.Count > 0)
{
bankInfo = bankInfo + " Routing No=[" + dtBankBracnhInfo.Rows[0]["ROUTING_NO"].ToString() + "] " + dtBankBracnhInfo.Rows[0]["ADDRESS"].ToString() + " ";
}
}
BankInfoTextBox.Text = bankInfo.ToString();
}
else
{
BankInfoTextBox.Text = "";
}
DataTable dtLedger = reportObj.GetLedgerData(unitRegObj);
int balance = 0;
if (dtLedger.Rows.Count > 0)
{
DataTable dtLedgerForReport = reportObj.GetDtLedgerTable();
DataRow drLedgerForReport;
for (int looper = 0; looper < dtLedger.Rows.Count; looper++)
{
drLedgerForReport = dtLedgerForReport.NewRow();
drLedgerForReport["SI"] = looper + 1;
if (!dtLedger.Rows[looper]["TRANS_DATE"].Equals(DBNull.Value))
{
drLedgerForReport["TRANS_DATE"] = Convert.ToDateTime(dtLedger.Rows[looper]["TRANS_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
drLedgerForReport["TRANS_NO"] = Convert.ToInt32(dtLedger.Rows[looper]["TRANS_NO"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["TRANS_NO"].ToString());
//drLedgerForReport["TRANS_NO"] = Convert.ToInt32(dtLedgerForReport.Rows[looper]["TRANS_DATE"].Equals(DBNull.Value) ? "0" : dtLedgerForReport.Rows[looper]["TRANS_DATE"].ToString());
if (!dtLedger.Rows[looper]["TRANS_TYPE"].Equals(DBNull.Value))
{
drLedgerForReport["TRANS_TYPE"] = dtLedger.Rows[looper]["TRANS_TYPE"].ToString();
if ((string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "SL", true) == 0) || (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "CIP", true) == 0))
{
drLedgerForReport["UNIT_CREDIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
drLedgerForReport["RATE"] = decimal.Parse((dtLedger.Rows[looper]["RATE"].ToString()));
int saleBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance + saleBalance;
drLedgerForReport["BALANCE"] = balance;
}
else if (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "TRI", true) == 0)
{
drLedgerForReport["UNIT_CREDIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
//drLedgerForReport["RATE"] = Convert.ToInt32(dtLedgerForReport.Rows[looper]["RATE"].ToString());
int transferInBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance + transferInBalance;
drLedgerForReport["BALANCE"] = balance;
}
else if (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "TRO", true) == 0)
{
drLedgerForReport["UNIT_DEBIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
//drLedgerForReport["RATE"] = Convert.ToInt32(dtLedgerForReport.Rows[looper]["RATE"].ToString());
int transferOutBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance - transferOutBalance;
drLedgerForReport["BALANCE"] = balance;
}
else if (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "REP", true) == 0)
{
drLedgerForReport["UNIT_DEBIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
drLedgerForReport["RATE"] = decimal.Parse((dtLedger.Rows[looper]["RATE"].ToString()));
int repurchaseBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance - repurchaseBalance;
drLedgerForReport["BALANCE"] = balance;
}
}
dtLedgerForReport.Rows.Add(drLedgerForReport);
}
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
dgLedger.DataSource = dtLedgerForReport;
dgLedger.DataBind();
Session["dtLedgerForReport"] = dtLedgerForReport;
displaySign();
}
else
{
ClearText();
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
dvLedger.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Ledger Balance Data Found');", true);
}
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
dvLedger.Visible = false;
ClientScript.RegisterStartupScript(this.GetType(), "Popup", " window.fnResetAll();", true);
tdCIP.InnerHtml = "";
}
}
protected void ExportReportButton_Click(object sender, EventArgs e)
{
UnitHolderRegistration regObject = new UnitHolderRegistration();
regObject.FundCode = fundCodeTextBox.Text.Trim().ToString();
regObject.BranchCode = branchCodeTextBox.Text.Trim().ToString();
string[] BranchCode = branchCodeTextBox.Text.Trim().ToString().Split('/');
string fileName = fundCodeTextBox.Text.Trim().ToString() + "_" + BranchCode[0].ToString() + "_" + BranchCode[1].ToString() + "_TR_";
if (fromTrNoTextBox.Text != "" && toTrNoTextBox.Text != "")
{
fileName = fileName + fromTrNoTextBox.Text.Trim().ToString() + "_" + toTrNoTextBox.Text.Trim().ToString();
}
else if (fromTrNoTextBox.Text != "" && toTrNoTextBox.Text == "")
{
int MaxTrNo = unitTrObj.getMaxTRNo(regObject);
MaxTrNo = MaxTrNo - 1;
fileName = fileName + fromTrNoTextBox.Text.Trim().ToString() + "_" + MaxTrNo.ToString();
}
else if (fromTrNoTextBox.Text == "" && toTrNoTextBox.Text != "")
{
fileName = fileName + "1_" + toTrNoTextBox.Text.Trim().ToString();
}
else if (fromRegNoTextBox.Text != "" && toRegNoTextBox.Text != "")
{
fileName = fileName + "REG_";
fileName = fileName + fromRegNoTextBox.Text.Trim().ToString() + "_" + toRegNoTextBox.Text.Trim().ToString();
}
else if (fromRegNoTextBox.Text != "" && toRegNoTextBox.Text == "")
{
fileName = fileName + "REG_";
int MaxRegNo = unitHolderRegBLObj.GetMaxRegNo(regObject);
MaxRegNo = MaxRegNo - 1;
fileName = fileName + fromRegNoTextBox.Text.Trim().ToString() + "_" + MaxRegNo.ToString();
}
else if (fromRegNoTextBox.Text == "" && toRegNoTextBox.Text != "")
{
fileName = fileName + "REG_";
fileName = fileName + "1_" + toRegNoTextBox.Text.Trim().ToString();
}
//else if (fromSaleDateTextBox.Text != "" && toSaleDateTextBox.Text != "")
//{
// sbFilter.Append(" AND ( SL_DT BETWEEN '" + Convert.ToDateTime(fromSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "' AND '" + Convert.ToDateTime(toSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')");
//}
//else if (fromSaleDateTextBox.Text != "" && toSaleDateTextBox.Text == "")
//{
// sbFilter.Append(" AND ( SL_DT => '" + Convert.ToDateTime(fromSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')");
//}
//else if (fromSaleDateTextBox.Text == "" && toSaleDateTextBox.Text != "")
//{
// sbFilter.Append(" AND (SL_DT <= '" + Convert.ToDateTime(toSaleDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')");
//}
//else if (saleTypeDropDownList.SelectedValue.ToString() != "0")
//{
// sbFilter.Append(" AND SL_TYPE='" + saleTypeDropDownList.SelectedValue.ToString() + "'");
//}
UnitSale saleObj = new UnitSale();
string fileDirectory = ConfigReader.ExportFileLocation.ToString();
StreamWriter swFile = new StreamWriter(fileDirectory + "\\" + fileName + ".txt");
StringBuilder sbFileHeader = new StringBuilder();
StringBuilder sbFileData = new StringBuilder();
sbFileHeader.Append("F_CD~BR_CODE~TR_NO~TR_DT~REG_BK_O~REG_BR_O~REG_NO_O~QTY~TR_USER_NM~TR_ENT_DT~TR_ENT_TM~OLD_SL_TR_NO~");
sbFileHeader.Append("REG_BK~REG_BR~REG_NO~REG_DT~REG_TYPE~HNAME~FMH_NAME~ADDRS1~ADDRS2~CITY~");
sbFileHeader.Append("B_DATE~SEX~MAR_STAT~RELIGION~EDU_QUA~TEL_NO~EMAIL~OPN_BAL~BALANCE~CIP~ID_FLAG~ID_AC~BK_FLAG~DIVIDEND~");
sbFileHeader.Append("CIP_DIV~TOT_DIV~USER_NM~ENT_DT~REMARKS~ENT_TM~NOMI1_REL~NOMI2_REL~NATIONALITY~OCC_CODE~BK_AC_NO~BK_NM_CD~");
sbFileHeader.Append("BK_BR_NM_CD~ID_BK_NM_CD~ID_BK_BR_NM_CD~MO_NAME~JNT_NO~JNT_NAME~JNT_FMH_NAME~JNT_OCC_CODE~JNT_ADDRS1~");
sbFileHeader.Append("JNT_ADDRS2~JNT_NATIONALITY~JNT_CITY~JNT_TEL_NO~JNT_FMH_REL~JNT_MO_NAME~");
//FileHeader.Append("USER_NM~ENT_DT~ENT_TM~MONY_RECT_NO~PAY_TYPE~CHQ_DD_NO~CASH_AMT~BANK_CODE~BRANCH_CODE~MULTI_PAY_REMARKS~CHEQUE_DT~");
sbFileHeader.Append("NOMI1_NO~NOMI1_NAME~NOMI1_FMH_NAME~NOMI1_OCC_CODE~NOMI1_ADDRS1~NOMI1_REL~NOMI1_PERCENTAGE~NOMI1_ADDRS2~");
sbFileHeader.Append("NOMI1_REAMARKS~NOMI1_NATIONALITY~NOMI1_CITY~NOMI_CTL_NO~NOMI1_MO_NAME~");
sbFileHeader.Append("NOMI2_NO~NOMI2_NAME~NOMI2_FMH_NAME~NOMI2_OCC_CODE~NOMI2_ADDRS1~NOMI2_REL~NOMI2_PERCENTAGE~NOMI2_ADDRS2~");
sbFileHeader.Append("NOMI2_REAMARKS~NOMI2_NATIONALITY~NOMI2_CITY~NOMI2_MO_NAME~TR_CERTIFICATE");
sbFileHeader.Append("\r\n");
try
{
DataTable dtSaleWithRegInfo = dtGetTransferWithRegInfo();
if (dtSaleWithRegInfo.Rows.Count > 0)
{
for (int loop = 0; loop < dtSaleWithRegInfo.Rows.Count; loop++)
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["BR_CODE"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["TR_NO"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["TR_DT"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_BK_O"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_BR_O"].ToString() + "~");
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["REG_NO_O"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["QTY"].ToString() + "~");
if (dtSaleWithRegInfo.Rows[loop]["TR_USER_NM"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TR_USER_NM"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["TR_ENT_DT"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TR_ENT_DT"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["TR_ENT_TM"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TR_ENT_TM"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].ToString() + "~");
}
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["REG_BK"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_BR"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_NO"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_DT"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["REG_TYPE"].ToString() + "~" + dtSaleWithRegInfo.Rows[loop]["HNAME"].ToString() + "~");
if (dtSaleWithRegInfo.Rows[loop]["FMH_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["FMH_NAME"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ADDRS1"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ADDRS1"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ADDRS2"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ADDRS2"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["CITY"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["CITY"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["B_DATE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["B_DATE"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["SEX"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["SEX"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["MAR_STAT"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["MAR_STAT"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["RELIGION"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["RELIGION"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["EDU_QUA"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["EDU_QUA"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["TEL_NO"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TEL_NO"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["EMAIL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["EMAIL"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["OPN_BAL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["OPN_BAL"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["BALANCE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BALANCE"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["CIP"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["CIP"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ID_FLAG"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_FLAG"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ID_AC"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_AC"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["BK_FLAG"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_FLAG"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["DIVIDEND"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["DIVIDEND"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["CIP_DIV"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["CIP_DIV"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["TOT_DIV"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["TOT_DIV"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["USER_NM"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["USER_NM"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ENT_DT"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ENT_DT"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["REMARKS"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["REMARKS"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ENT_TM"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ENT_TM"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["NOMI1_REL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["NOMI1_REL"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["NOMI2_REL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["NOMI2_REL"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["NATIONALITY"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["NATIONALITY"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["OCC_CODE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["OCC_CODE"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["BK_AC_NO"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_AC_NO"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["BK_NM_CD"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_NM_CD"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["BK_BR_NM_CD"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["BK_BR_NM_CD"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ID_BK_NM_CD"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_BK_NM_CD"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["ID_BK_BR_NM_CD"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["ID_BK_BR_NM_CD"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["MO_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["MO_NAME"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_NO"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_NO"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_NAME"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_FMH_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_FMH_NAME"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_OCC_CODE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_OCC_CODE"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS1"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS1"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS2"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_ADDRS2"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_NATIONALITY"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_NATIONALITY"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_CITY"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_CITY"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_TEL_NO"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_TEL_NO"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_FMH_REL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_FMH_REL"].ToString() + "~");
}
if (dtSaleWithRegInfo.Rows[loop]["JNT_MO_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtSaleWithRegInfo.Rows[loop]["JNT_MO_NAME"].ToString() + "~");
}
regObj.FundCode = dtSaleWithRegInfo.Rows[loop]["REG_BK"].ToString();
regObj.BranchCode = dtSaleWithRegInfo.Rows[loop]["REG_BR"].ToString();
regObj.RegNumber = dtSaleWithRegInfo.Rows[loop]["REG_NO"].ToString();
DataTable dtNomineeRegInfo = opendMFDAO.dtNomineeRegInfo(regObj);
if (dtNomineeRegInfo.Rows.Count > 0)
{
sbFileData.Append("1~");
if (dtNomineeRegInfo.Rows[0]["NOMI_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_NAME"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["NOMI_FMH_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_FMH_NAME"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["NOMI_OCC_CODE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_OCC_CODE"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["NOMI_ADDRS1"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_ADDRS1"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["NOMI_REL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_REL"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["PERCENTAGE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["PERCENTAGE"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["NOMI_ADDRS2"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_ADDRS2"].ToString() + "~");
}
sbFileData.Append(" ~");
if (dtNomineeRegInfo.Rows[0]["NOMI_NATIONALITY"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_NATIONALITY"].ToString() + "~");
}
sbFileData.Append(" ~");
if (dtNomineeRegInfo.Rows[0]["NOMI_CTL_NO"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_CTL_NO"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[0]["NOMI_MO_NAME"].ToString() + "~");
}
}
if (dtNomineeRegInfo.Rows.Count > 1)
{
sbFileData.Append("2~");
if (dtNomineeRegInfo.Rows[1]["NOMI_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_NAME"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[1]["NOMI_FMH_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_FMH_NAME"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[1]["NOMI_OCC_CODE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_OCC_CODE"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[1]["NOMI_ADDRS1"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_ADDRS1"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[1]["NOMI_REL"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_REL"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[1]["PERCENTAGE"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["PERCENTAGE"].ToString() + "~");
}
if (dtNomineeRegInfo.Rows[1]["NOMI_ADDRS2"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_ADDRS2"].ToString() + "~");
}
sbFileData.Append(" ~");
if (dtNomineeRegInfo.Rows[1]["NOMI_NATIONALITY"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_NATIONALITY"].ToString() + "~");
}
sbFileData.Append(" ~");
if (dtNomineeRegInfo.Rows[1]["NOMI_MO_NAME"].Equals(DBNull.Value))
{
sbFileData.Append(" ~");
}
else
{
sbFileData.Append(dtNomineeRegInfo.Rows[1]["NOMI_MO_NAME"].ToString() + "~");
}
}
if (dtNomineeRegInfo.Rows.Count <= 0)
{
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
}
if (dtNomineeRegInfo.Rows.Count == 1)
{
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
sbFileData.Append(" ~");
}
string OLD_SL_TR_NO = dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].Equals(DBNull.Value) ? "" : dtSaleWithRegInfo.Rows[loop]["OLD_SL_TR_NO"].ToString();
string queryString = "";
if (OLD_SL_TR_NO != "")
{
queryString = "SELECT * FROM TRANS_CERT WHERE TR_NO=" + Convert.ToInt32(dtSaleWithRegInfo.Rows[loop]["TR_NO"].ToString()) + " AND BR_CODE='" + dtSaleWithRegInfo.Rows[loop]["BR_CODE"].ToString() + "' AND F_CD='" + dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString() + "' AND OLD_SL_TR_NO='" + OLD_SL_TR_NO.ToString() + "'";
}
else
{
queryString = "SELECT * FROM TRANS_CERT WHERE TR_NO=" + Convert.ToInt32(dtSaleWithRegInfo.Rows[loop]["TR_NO"].ToString()) + " AND BR_CODE='" + dtSaleWithRegInfo.Rows[loop]["BR_CODE"].ToString() + "' AND F_CD='" + dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString() + "'";
}
string trCertificate = reportObj.getTotalCertNo(queryString.ToString(), dtSaleWithRegInfo.Rows[loop]["F_CD"].ToString());
if (trCertificate != "")
{
sbFileData.Append(trCertificate.ToString());
}
else
{
sbFileData.Append(" ~");
}
sbFileData.Append("\r\n");
}
sbFileHeader.Append(sbFileData.ToString());
swFile.Write(sbFileHeader.ToString());
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Data Exported Successfully');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Data Found ');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('Data Export Failed Due to Eror:" + ex.ToString() + " ');", true);
}
finally
{
swFile.Close();
}
}
public void displayRegInfo()
{
dvLedger.Visible = true;
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = fundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = branchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = regNoTextBox.Text.Trim();
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
DataTable dtNominee = opendMFDAO.dtNomineeRegInfo(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";
}
if (dtNominee.Rows.Count > 1)
{
Nominee1NameTextBox.Text = dtNominee.Rows[0]["NOMI_NAME"].ToString();
Nominee2NameTextBox.Text = dtNominee.Rows[1]["NOMI_NAME"].ToString();
}
else if (dtNominee.Rows.Count > 0)
{
Nominee1NameTextBox.Text = dtNominee.Rows[0]["NOMI_NAME"].ToString();
Nominee2NameTextBox.Text = "";
}
else
{
Nominee1NameTextBox.Text = "";
Nominee2NameTextBox.Text = "";
}
DataTable dtLedger = reportObj.GetLedgerData(unitRegObj);
int balance = 0;
if (dtLedger.Rows.Count > 0)
{
DataTable dtLedgerForReport = reportObj.GetDtLedgerTable();
DataRow drLedgerForReport;
for (int looper = 0; looper < dtLedger.Rows.Count; looper++)
{
drLedgerForReport = dtLedgerForReport.NewRow();
drLedgerForReport["SI"] = looper + 1;
if (!dtLedger.Rows[looper]["TRANS_DATE"].Equals(DBNull.Value))
{
drLedgerForReport["TRANS_DATE"] = Convert.ToDateTime(dtLedger.Rows[looper]["TRANS_DATE"].ToString()).ToString("dd-MMM-yyyy");
}
drLedgerForReport["TRANS_NO"] = Convert.ToInt32(dtLedger.Rows[looper]["TRANS_NO"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["TRANS_NO"].ToString());
//drLedgerForReport["TRANS_NO"] = Convert.ToInt32(dtLedgerForReport.Rows[looper]["TRANS_DATE"].Equals(DBNull.Value) ? "0" : dtLedgerForReport.Rows[looper]["TRANS_DATE"].ToString());
if (!dtLedger.Rows[looper]["TRANS_TYPE"].Equals(DBNull.Value))
{
drLedgerForReport["TRANS_TYPE"] = dtLedger.Rows[looper]["TRANS_TYPE"].ToString();
if ((string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "SL", true) == 0) || (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "CIP", true) == 0))
{
drLedgerForReport["UNIT_CREDIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
drLedgerForReport["RATE"] = decimal.Parse((dtLedger.Rows[looper]["RATE"].ToString()));
int saleBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance + saleBalance;
drLedgerForReport["BALANCE"] = balance;
}
else if (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "TRI", true) == 0)
{
drLedgerForReport["UNIT_CREDIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
//drLedgerForReport["RATE"] = Convert.ToInt32(dtLedgerForReport.Rows[looper]["RATE"].ToString());
int transferInBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance + transferInBalance;
drLedgerForReport["BALANCE"] = balance;
}
else if (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "TRO", true) == 0)
{
drLedgerForReport["UNIT_DEBIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
//drLedgerForReport["RATE"] = Convert.ToInt32(dtLedgerForReport.Rows[looper]["RATE"].ToString());
int transferOutBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance - transferOutBalance;
drLedgerForReport["BALANCE"] = balance;
}
else if (string.Compare(dtLedger.Rows[looper]["TRANS_TYPE"].ToString(), "REP", true) == 0)
{
drLedgerForReport["UNIT_DEBIT"] = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
drLedgerForReport["RATE"] = decimal.Parse((dtLedger.Rows[looper]["RATE"].ToString()));
int repurchaseBalance = Convert.ToInt32(dtLedger.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtLedger.Rows[looper]["QTY"].ToString());
balance = balance - repurchaseBalance;
drLedgerForReport["BALANCE"] = balance;
}
}
dtLedgerForReport.Rows.Add(drLedgerForReport);
}
TotalLienUnitHoldingTextBox.Text = unitLienBLObj.totalLienAmount(unitRegObj).ToString();
dgLedger.DataSource = dtLedgerForReport;
dgLedger.DataBind();
Session["dtLedgerForReport"] = dtLedgerForReport;
displaySign();
}
else
{
ClearText();
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
dvLedger.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('No Ledger Balance Data Found');", true);
}
}
else
{
SignImage.ImageUrl = Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString();
dvLedger.Visible = false;
ClientScript.RegisterStartupScript(this.GetType(), "Popup", " window.fnResetAll();", true);
tdCIP.InnerHtml = "";
}
}
