protected void findRoutingButton_Click(object sender, EventArgs e)
{
string bankInfo = "";
DataTable dtBankBracnhInfo = regBLObj.dtGetBankBracnhInfo(RoutingNoTextBox.Text.Trim().ToString());
if (dtBankBracnhInfo.Rows.Count > 0)
{
bankInfo = bankInfo + reportObj.getBankNameByBankCode(Convert.ToInt32(dtBankBracnhInfo.Rows[0]["BANK_CODE"].ToString())).ToString();
bankInfo = bankInfo + " , " + reportObj.getBankBranchNameByCode(Convert.ToInt32(dtBankBracnhInfo.Rows[0]["BANK_CODE"].ToString()), Convert.ToInt32(dtBankBracnhInfo.Rows[0]["BRANCH_CODE"].ToString())).ToString() + " BRANCH ";
BankInfoTextBox.Text = bankInfo.ToString();
}
else
{
BankInfoTextBox.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert('No Bank Information Found');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string fundCode = "";
string branchCode = "";
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
CDSStatus = bcContent.CDS.ToString().ToUpper();
branchCode = (string)Session["branchCode"];
fundCode = (string)Session["fundCode"];
DataTable dtReport = reportObj.getDtForReportStatement();
dtReport.TableName = "ReportSaleStatement";
DataRow drReport;
DataTable dtReportStatement = (DataTable)Session["dtReportStatement"];
if (dtReportStatement.Rows.Count > 0)
{
int saleNo = 0;
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
drReport = dtReport.NewRow();
drReport["SL_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].ToString());
drReport["SL_DT"] = dtReportStatement.Rows[looper]["SL_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_DT"].ToString();
drReport["SL_TYPE"] = dtReportStatement.Rows[looper]["SL_TYPE"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_TYPE"].ToString();
drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].ToString();
drReport["MOBILE1"] = dtReportStatement.Rows[looper]["MOBILE1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["MOBILE1"].ToString();
drReport["NID"] = dtReportStatement.Rows[looper]["NID"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["NID"].ToString();
drReport["MONY_RECT_NO"] = dtReportStatement.Rows[looper]["MONY_RECT_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["MONY_RECT_NO"].ToString();
drReport["TIN"] = dtReportStatement.Rows[looper]["TIN"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TIN"].ToString();
if (!dtReportStatement.Rows[looper]["REG_TYPE"].Equals(DBNull.Value))
{
drReport["REG_TYPE"] = reportObj.getRegTypeFullName(dtReportStatement.Rows[looper]["REG_TYPE"].ToString()).ToString();
}
drReport["JNT_NAME"] = dtReportStatement.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["JNT_NAME"].ToString();
drReport["ADDRS1"] = dtReportStatement.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS1"].ToString();
drReport["ADDRS2"] = dtReportStatement.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ADDRS2"].ToString();
drReport["CITY"] = dtReportStatement.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CITY"].ToString();
drReport["REG_NO"] = dtReportStatement.Rows[looper]["REG_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REG_NO"].ToString();
DataTable dtNominee = reportObj.dtNominee(dtReportStatement.Rows[looper]["REG_BK"].ToString(), dtReportStatement.Rows[looper]["REG_BR"].ToString(), Convert.ToInt32(dtReportStatement.Rows[looper]["RG_NO"].ToString()));
if (dtNominee.Rows.Count > 0)
{
for (int loop = 0; loop < dtNominee.Rows.Count; loop++)
{
if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 1)
{
drReport["NOMI1_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString();
}
else if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 2)
{
drReport["NOMI2_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString();
}
}
}
if (CDSStatus.ToString() == "Y")
{
drReport["DRF_REF_NO"] = dtReportStatement.Rows[looper]["DRF_REF_NO"];
drReport["DRF_REG_FOLIO_NO"] = dtReportStatement.Rows[looper]["DRF_REG_FOLIO_NO"];
drReport["DRF_CERT_NO"] = dtReportStatement.Rows[looper]["DRF_CERT_NO"];
drReport["DRF_DISTNCT_NO_FROM"] = dtReportStatement.Rows[looper]["DRF_DISTNCT_NO_FROM"];
drReport["DRF_DISTNCT_NO_TO"] = dtReportStatement.Rows[looper]["DRF_DISTNCT_NO_TO"];
drReport["DRF_CUST_REQ_DATE"] = dtReportStatement.Rows[looper]["DRF_CUST_REQ_DATE"];
drReport["DRF_ACCEPT_NO"] = dtReportStatement.Rows[looper]["DRF_ACCEPT_NO"];
drReport["DRF_DRN"] = dtReportStatement.Rows[looper]["DRF_DRN"];
drReport["DRF_ACCEPT_DATE"] = dtReportStatement.Rows[looper]["DRF_ACCEPT_DATE"];
drReport["DRF_TR_SEQ_NO"] = dtReportStatement.Rows[looper]["DRF_TR_SEQ_NO"];
drReport["DRF_TR_DATE"] = dtReportStatement.Rows[looper]["DRF_TR_DATE"];
drReport["BO"] = dtReportStatement.Rows[looper]["HOLDER_BO"];
}
else
{
saleNo = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].ToString());
drReport["CERT_DLVRY_DT"] = dtReportStatement.Rows[looper]["CERT_DLVRY_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CERT_DLVRY_DT"].ToString();
drReport["CERT_RCV_BY"] = dtReportStatement.Rows[looper]["CERT_RCV_BY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CERT_RCV_BY"].ToString();
drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM SALE_CERT WHERE SL_NO=" + saleNo + " AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' ORDER BY CERT_TYPE ", fundCode.ToString()).ToString();
}
if (!dtReportStatement.Rows[looper]["BK_FLAG"].Equals(DBNull.Value))
{
if (string.Compare(dtReportStatement.Rows[looper]["BK_FLAG"].ToString(), "Y", true) == 0)
{
if (!dtReportStatement.Rows[looper]["BK_NM_CD"].Equals(DBNull.Value) && !dtReportStatement.Rows[looper]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtReportStatement.Rows[looper]["BK_AC_NO"].Equals(DBNull.Value))
{
drReport["BK_AC_NO"] = dtReportStatement.Rows[looper]["BK_AC_NO"].ToString();
drReport["BANK_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString())).ToString();
drReport["BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtReportStatement.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString();
drReport["BRANCH_ADDRESS"] = reportObj.getBankBranchAddressByCode(Convert.ToInt16(dtReportStatement.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtReportStatement.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString();
}
else
{
}
}
}
drReport["CIP"] = dtReportStatement.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CIP"].ToString();
drReport["ID_AC"] = dtReportStatement.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["ID_AC"].ToString();
drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString());
drReport["RATE"] = decimal.Parse(dtReportStatement.Rows[looper]["RATE"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["RATE"].ToString());
drReport["AMOUNT"] = decimal.Parse(dtReportStatement.Rows[looper]["AMOUNT"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["AMOUNT"].ToString());
dtReport.Rows.Add(drReport);
}
//dtReport.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitReportForStatement.xsd");
if (CDSStatus.ToString() == "Y")
{
sale_Statement_CDS.Refresh();
sale_Statement_CDS.SetDataSource(dtReport);
sale_Statement_CDS.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
sale_Statement_CDS.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
sale_Statement_CDS.SetParameterValue("branchCode", branchCode.ToString());
CrystalReportViewer1.ReportSource = sale_Statement_CDS;
}
else
{
sale_Statement.Refresh();
sale_Statement.SetDataSource(dtReport);
sale_Statement.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
sale_Statement.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
sale_Statement.SetParameterValue("branchCode", branchCode.ToString());
CrystalReportViewer1.ReportSource = sale_Statement;
}
}
else
{
Response.Write("No data found");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string fundCodeStatement = "";
string branchCodeStatement = "";
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
branchCodeStatement = (string)Session["branchCodeStatement"];
fundCodeStatement = (string)Session["fundCodeStatement"];
DataTable dtUnitHolderInfo = reportObj.getDtHolderInfo();
dtUnitHolderInfo.TableName = "UnitHolderStatementAfterClosing";
DataRow drUnitHolderInfo;
DataTable dtHolderInfo = (DataTable)Session["dtStatementAfterClosing"];
if (dtHolderInfo.Rows.Count > 0)
{
for (int looper = 0; looper < dtHolderInfo.Rows.Count; looper++)
{
drUnitHolderInfo = dtUnitHolderInfo.NewRow();
drUnitHolderInfo["REG_NO"] = dtHolderInfo.Rows[looper]["REGI_NUMBER"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["REGI_NUMBER"].ToString();
drUnitHolderInfo["HNAME"] = dtHolderInfo.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["HNAME"].ToString();
drUnitHolderInfo["REG_BR_NAME"] = dtHolderInfo.Rows[looper]["REG_BR"].Equals(DBNull.Value) ? "" : opendMFDAO.GetBranchName(dtHolderInfo.Rows[looper]["REG_BR"].ToString());
drUnitHolderInfo["BEFTN"] = dtHolderInfo.Rows[looper]["BEFTN"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString();
drUnitHolderInfo["ADDRS1"] = dtHolderInfo.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ADDRS1"].ToString();
drUnitHolderInfo["ADDRS2"] = dtHolderInfo.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ADDRS2"].ToString();
drUnitHolderInfo["CITY"] = dtHolderInfo.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["CITY"].ToString();
drUnitHolderInfo["TIN"] = dtHolderInfo.Rows[looper]["TIN"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["TIN"].ToString();
drUnitHolderInfo["PASS_NO"] = dtHolderInfo.Rows[looper]["PASS_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString();
drUnitHolderInfo["BIRTH_CERT_NO"] = dtHolderInfo.Rows[looper]["BIRTH_CERT_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString();
drUnitHolderInfo["BIRTH_CERT_NO"] = dtHolderInfo.Rows[looper]["BIRTH_CERT_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BEFTN"].ToString();
drUnitHolderInfo["NID"] = dtHolderInfo.Rows[looper]["NID"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["NID"].ToString();
drUnitHolderInfo["BALANCE"] = Convert.ToInt32(dtHolderInfo.Rows[looper]["BALANCE"].Equals(DBNull.Value) ? "0" : dtHolderInfo.Rows[looper]["BALANCE"].ToString());
drUnitHolderInfo["JNT_NAME"] = dtHolderInfo.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_NAME"].ToString();
drUnitHolderInfo["CIP"] = dtHolderInfo.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["CIP"].ToString();
if (!dtHolderInfo.Rows[looper]["CIP"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["CIP"].ToString(), "Y", true) == 0)
{
drUnitHolderInfo["CIP"] = "YES";
}
else if (string.Compare(dtHolderInfo.Rows[looper]["CIP"].ToString(), "N", true) == 0)
{
drUnitHolderInfo["CIP"] = "NO";
}
}
if (!dtHolderInfo.Rows[looper]["ID_FLAG"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["ID_FLAG"].ToString(), "Y", true) == 0)
{
drUnitHolderInfo["ID_FLAG"] = "YES";
drUnitHolderInfo["ID_AC"] = dtHolderInfo.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ID_AC"].ToString();
drUnitHolderInfo["ID_INTSTITUTE_NAME"] = dtHolderInfo.Rows[looper]["BANK_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BANK_NAME"].ToString();
drUnitHolderInfo["ID_INTSTITUTE_BRANCH_NAME"] = dtHolderInfo.Rows[looper]["BRANCH_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["BRANCH_NAME"].ToString();
}
else if (string.Compare(dtHolderInfo.Rows[looper]["ID_FLAG"].ToString(), "N", true) == 0)
{
drUnitHolderInfo["ID_FLAG"] = "NO";
}
}
if (!dtHolderInfo.Rows[looper]["BK_FLAG"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["BK_FLAG"].ToString(), "Y", true) == 0)
{
if (!dtHolderInfo.Rows[looper]["BK_NM_CD"].Equals(DBNull.Value) && !dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtHolderInfo.Rows[looper]["BK_AC_NO"].Equals(DBNull.Value))
{
drUnitHolderInfo["BK_AC_NO"] = dtHolderInfo.Rows[looper]["BK_AC_NO"].ToString();
drUnitHolderInfo["BANK_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString())).ToString();
drUnitHolderInfo["BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString();
drUnitHolderInfo["BRANCH_ADDRESS"] = reportObj.getBankBranchAddressByCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString();
}
else
{
string branchAddress = "";
string BankAccInfo = dtHolderInfo.Rows[looper]["SPEC_IN1"].ToString() + dtHolderInfo.Rows[looper]["SPEC_IN2"].ToString();
string[] BankAccountInfo = BankAccInfo.Split(',');
if (BankAccountInfo.Length > 0)
{
drUnitHolderInfo["BK_AC_NO"] = BankAccountInfo[0].ToString();
if (BankAccountInfo.Length > 1)
{
drUnitHolderInfo["BANK_NAME"] = BankAccountInfo[1].ToString();
}
if (BankAccountInfo.Length > 2)
{
drUnitHolderInfo["BRANCH_NAME"] = BankAccountInfo[2].ToString();
}
if (BankAccountInfo.Length > 3)
{
for (int loop = 3; loop < BankAccountInfo.Length; loop++)
{
branchAddress = branchAddress + BankAccountInfo[loop].ToString();
}
drUnitHolderInfo["BRANCH_ADDRESS"] = branchAddress;
}
}
}
}
}
DataTable dtNominee = reportObj.dtNominee(dtHolderInfo.Rows[looper]["REG_BK"].ToString(), dtHolderInfo.Rows[looper]["REG_BR"].ToString(), Convert.ToInt32(dtHolderInfo.Rows[looper]["REG_NO"].ToString()));
if (dtNominee.Rows.Count > 0)
{
for (int loop = 0; loop < dtNominee.Rows.Count; loop++)
{
if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 1)
{
drUnitHolderInfo["NOMI1_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString();
}
else if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 2)
{
drUnitHolderInfo["NOMI2_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString();
}
}
}
dtUnitHolderInfo.Rows.Add(drUnitHolderInfo);
}
//dtUnitHolderInfo.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2008\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitHolderStatementAfterClosing.xsd");
CR_StatementAfterClosing.Refresh();
CR_StatementAfterClosing.SetDataSource(dtUnitHolderInfo);
CR_StatementAfterClosing.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCodeStatement.ToString()));
CR_StatementAfterClosing.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCodeStatement.ToString()));
CrystalReportViewer1.ReportSource = CR_StatementAfterClosing;
//CR_StatementAfterClosing.Close();
//CR_StatementAfterClosing.Dispose();
}
else
{
Response.Write("No data found");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] == null)
{
Session.RemoveAll();
Response.Redirect("../../Default.aspx");
}
string regNo = "";
string fundCode = "";
string branchCode = "";
string unitHolderName = "";
string branchName = "";
string fundName = "";
if (Request.QueryString["reg"] != null)
{
regNo = Request.QueryString["reg"].ToString();
}
if (Request.QueryString["fund"] != null)
{
fundName = omfDAOObj.GetFundName(Request.QueryString["fund"].ToString());
fundCode = Request.QueryString["fund"].ToString();
}
if (Request.QueryString["branch"] != null)
{
branchName = omfDAOObj.GetBranchName(Request.QueryString["branch"].ToString());
branchCode = Request.QueryString["branch"].ToString();
}
if (regNo != "" && fundCode != "" && branchCode != "")
{
unitHolderName = omfDAOObj.GetHolderName(fundCode, branchCode, regNo);
regObj.RegNumber = regNo;
regObj.FundCode = fundCode.ToString();
regObj.BranchCode = branchCode.ToString();
}
tdBranch.InnerHtml = "<span style=\"color:Green\"><b>" + unitLienBLObj.totalLienAmount(regObj).ToString() + "</b></span>";
tdFund.InnerHtml = "<span style=\"color:Green\"><b>" + fundName.ToString() + "</b></span>";
tdHolderName.InnerHtml = "<span style=\"color:Green\"><b>" + unitHolderName.ToString() + "</b></span>";
tdReg.InnerHtml = "<span style=\"color:Green\"><b>" + fundCode.ToString() + "/" + branchCode.ToString() + "/" + regNo.ToString() + "</b></span>";
StringBuilder sbInnerString = new StringBuilder();
DataTable dtLienDetails = unitLienBLObj.dtLienDetailsCertificate(regObj);
DataTable dtLienBankDetails = new DataTable();
if (dtLienDetails.Rows.Count > 0)
{
sbInnerString.Append("<table width=\"800\" align=\"center\">");
sbInnerString.Append("<colgroup width=\"120\"></colgroup>");
sbInnerString.Append("<colgroup width=\"120\"></colgroup>");
sbInnerString.Append("<colgroup width=\"120\"></colgroup>");
sbInnerString.Append("<colgroup width=\"120\"></colgroup>");
sbInnerString.Append("<tr>");
sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> LIEN NUMBER </b></span></td>");
// sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> LIEN DATE </b></span></td>");
sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> TRANSACTION NUMBER</b></span></td>");
sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b> CERTIFICATE </b></span></td>");
sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b>WEIGHT </b></span></td>");
sbInnerString.Append("<td <span style=\"color:Green;border:1px solid; text-align:center;\"><b>LIEN INSTITUTION </b></span></td>");
sbInnerString.Append("</tr>");
for (int looper = 0; looper < dtLienDetails.Rows.Count; looper++)
{
unitLienObj = new UnitLien();
unitLienObj.LienNo = Convert.ToInt32(dtLienDetails.Rows[looper]["LIEN_NO"].ToString());
dtLienBankDetails = unitLienBLObj.dtLienDetailsInfo(regObj, unitLienObj);
sbInnerString.Append("<tr>");
sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["LIEN_NO"].ToString() + " </b></td>");
//sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["LN_REQ_DT"].ToString() + " </b></td>");
sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b> " + dtLienDetails.Rows[looper]["SL_TR_NO"].ToString() + "</b></td>");
sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["CERTIFICATE"].ToString() + " </b></td>");
sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + dtLienDetails.Rows[looper]["QTY"].ToString() + " </b></td>");
sbInnerString.Append("<td style=\"border:1px solid; text-align:center;\"><b>" + reportObj.getBankNameByBankCode(Convert.ToInt16(dtLienBankDetails.Rows[0]["LN_BK_CODE"].ToString())) + "," + reportObj.getBankBranchNameByCode(Convert.ToInt16(dtLienBankDetails.Rows[0]["LN_BK_CODE"].ToString()), Convert.ToInt16(dtLienBankDetails.Rows[0]["LN_BK_BR_CODE"].ToString())) + " </b></td>");
sbInnerString.Append("</tr>");
}
sbInnerString.Append("</table>");
tdLeinDetails.InnerHtml = sbInnerString.ToString();
}
}
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 = "";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string fundCode = "";
string branchCode = "";
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
branchCode = (string)Session["branchCode"];
fundCode = (string)Session["fundCode"];
DataTable dtUnitHolderInfo = reportObj.getDtHolderInfo();
dtUnitHolderInfo.TableName = "UnitHolderInfo";
DataRow drUnitHolderInfo;
DataTable dtHolderInfo = (DataTable)Session["dtHolderInfo"];
if (dtHolderInfo.Rows.Count > 0)
{
for (int looper = 0; looper < dtHolderInfo.Rows.Count; looper++)
{
drUnitHolderInfo = dtUnitHolderInfo.NewRow();
drUnitHolderInfo["REG_NO"] = dtHolderInfo.Rows[looper]["REG_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["REG_NO"].ToString();
drUnitHolderInfo["REG_DT"] = dtHolderInfo.Rows[looper]["REG_DT"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["REG_DT"].ToString();
if (!dtHolderInfo.Rows[looper]["REG_TYPE"].Equals(DBNull.Value))
{
drUnitHolderInfo["REG_TYPE"] = reportObj.getRegTypeFullName(dtHolderInfo.Rows[looper]["REG_TYPE"].ToString()).ToString();
}
drUnitHolderInfo["HNAME"] = dtHolderInfo.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["HNAME"].ToString();
drUnitHolderInfo["FMH_NAME"] = dtHolderInfo.Rows[looper]["FMH_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["FMH_NAME"].ToString();
drUnitHolderInfo["MO_NAME"] = dtHolderInfo.Rows[looper]["MO_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["MO_NAME"].ToString();
drUnitHolderInfo["ADDRS1"] = dtHolderInfo.Rows[looper]["ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ADDRS1"].ToString();
drUnitHolderInfo["ADDRS2"] = dtHolderInfo.Rows[looper]["ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ADDRS2"].ToString();
drUnitHolderInfo["CITY"] = dtHolderInfo.Rows[looper]["CITY"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["CITY"].ToString();
drUnitHolderInfo["NATIONALITY"] = dtHolderInfo.Rows[looper]["NATIONALITY"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["NATIONALITY"].ToString();
drUnitHolderInfo["OCC_CODE"] = dtHolderInfo.Rows[looper]["OCC_CODE"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["OCC_CODE"].ToString();
drUnitHolderInfo["B_DATE"] = dtHolderInfo.Rows[looper]["B_DATE"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["B_DATE"].ToString();
if (!dtHolderInfo.Rows[looper]["SEX"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["SEX"].ToString(), "M", true) == 0)
{
drUnitHolderInfo["SEX"] = "MAlE";
}
else if (string.Compare(dtHolderInfo.Rows[looper]["SEX"].ToString(), "F", true) == 0)
{
drUnitHolderInfo["SEX"] = "FEMALE";
}
}
if (!dtHolderInfo.Rows[looper]["MAR_STAT"].Equals(DBNull.Value))
{
drUnitHolderInfo["MAR_STAT"] = reportObj.getMaritialFullName(dtHolderInfo.Rows[looper]["MAR_STAT"].ToString()).ToString();
}
if (!dtHolderInfo.Rows[looper]["RELIGION"].Equals(DBNull.Value))
{
drUnitHolderInfo["RELIGION"] = reportObj.getReligionFullName(dtHolderInfo.Rows[looper]["RELIGION"].ToString()).ToString();
}
drUnitHolderInfo["EDU_QUA"] = dtHolderInfo.Rows[looper]["EDU_QUA"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["EDU_QUA"].ToString();
drUnitHolderInfo["TEL_NO"] = dtHolderInfo.Rows[looper]["TEL_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["TEL_NO"].ToString();
drUnitHolderInfo["EMAIL"] = dtHolderInfo.Rows[looper]["EMAIL"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["EMAIL"].ToString();
drUnitHolderInfo["JNT_NAME"] = dtHolderInfo.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_NAME"].ToString();
drUnitHolderInfo["JNT_FMH_NAME"] = dtHolderInfo.Rows[looper]["JNT_FMH_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_FMH_NAME"].ToString();
drUnitHolderInfo["JNT_MO_NAME"] = dtHolderInfo.Rows[looper]["JNT_MO_NAME"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_MO_NAME"].ToString();
drUnitHolderInfo["JNT_OCC_CODE"] = dtHolderInfo.Rows[looper]["JNT_OCC_CODE"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_OCC_CODE"].ToString();
drUnitHolderInfo["JNT_ADDRS1"] = dtHolderInfo.Rows[looper]["JNT_ADDRS1"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_ADDRS1"].ToString();
drUnitHolderInfo["JNT_ADDRS2"] = dtHolderInfo.Rows[looper]["JNT_ADDRS2"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_ADDRS2"].ToString();
drUnitHolderInfo["JNT_NATIONALITY"] = dtHolderInfo.Rows[looper]["JNT_NATIONALITY"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_NATIONALITY"].ToString();
drUnitHolderInfo["JNT_CITY"] = dtHolderInfo.Rows[looper]["JNT_CITY"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_CITY"].ToString();
drUnitHolderInfo["JNT_TEL_NO"] = dtHolderInfo.Rows[looper]["JNT_TEL_NO"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_TEL_NO"].ToString();
drUnitHolderInfo["JNT_FMH_REL"] = dtHolderInfo.Rows[looper]["JNT_FMH_REL"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["JNT_FMH_REL"].ToString();
drUnitHolderInfo["CIP"] = dtHolderInfo.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["CIP"].ToString();
if (!dtHolderInfo.Rows[looper]["CIP"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["CIP"].ToString(), "Y", true) == 0)
{
drUnitHolderInfo["CIP"] = "YES";
}
else if (string.Compare(dtHolderInfo.Rows[looper]["CIP"].ToString(), "N", true) == 0)
{
drUnitHolderInfo["CIP"] = "NO";
}
}
if (!dtHolderInfo.Rows[looper]["ID_FLAG"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["ID_FLAG"].ToString(), "Y", true) == 0)
{
drUnitHolderInfo["ID_FLAG"] = "YES";
drUnitHolderInfo["ID_AC"] = dtHolderInfo.Rows[looper]["ID_AC"].Equals(DBNull.Value) ? "" : dtHolderInfo.Rows[looper]["ID_AC"].ToString();
drUnitHolderInfo["ID_INTSTITUTE_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtHolderInfo.Rows[0]["ID_BK_NM_CD"].Equals(DBNull.Value) ? "0" : dtHolderInfo.Rows[0]["ID_BK_NM_CD"].ToString())).ToString();
drUnitHolderInfo["ID_INTSTITUTE_BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtHolderInfo.Rows[0]["ID_BK_NM_CD"].Equals(DBNull.Value) ? "0" : dtHolderInfo.Rows[0]["ID_BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[0]["ID_BK_BR_NM_CD"].Equals(DBNull.Value) ? "0" : dtHolderInfo.Rows[0]["ID_BK_BR_NM_CD"].ToString())).ToString();
}
else if (string.Compare(dtHolderInfo.Rows[looper]["ID_FLAG"].ToString(), "N", true) == 0)
{
drUnitHolderInfo["ID_FLAG"] = "NO";
}
}
if (!dtHolderInfo.Rows[looper]["BK_FLAG"].Equals(DBNull.Value))
{
if (string.Compare(dtHolderInfo.Rows[looper]["BK_FLAG"].ToString(), "Y", true) == 0)
{
if (!dtHolderInfo.Rows[looper]["BK_NM_CD"].Equals(DBNull.Value) && !dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].Equals(DBNull.Value) && !dtHolderInfo.Rows[looper]["BK_AC_NO"].Equals(DBNull.Value))
{
drUnitHolderInfo["BK_AC_NO"] = dtHolderInfo.Rows[looper]["BK_AC_NO"].ToString();
drUnitHolderInfo["BANK_NAME"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString())).ToString();
drUnitHolderInfo["BRANCH_NAME"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString();
drUnitHolderInfo["BRANCH_ADDRESS"] = reportObj.getBankBranchAddressByCode(Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_NM_CD"].ToString()), Convert.ToInt16(dtHolderInfo.Rows[looper]["BK_BR_NM_CD"].ToString())).ToString();
}
else
{
string branchAddress = "";
string BankAccInfo = dtHolderInfo.Rows[looper]["SPEC_IN1"].ToString() + dtHolderInfo.Rows[looper]["SPEC_IN2"].ToString();
string[] BankAccountInfo = BankAccInfo.Split(',');
if (BankAccountInfo.Length > 0)
{
drUnitHolderInfo["BK_AC_NO"] = BankAccountInfo[0].ToString();
if (BankAccountInfo.Length > 1)
{
drUnitHolderInfo["BANK_NAME"] = BankAccountInfo[1].ToString();
}
if (BankAccountInfo.Length > 2)
{
drUnitHolderInfo["BRANCH_NAME"] = BankAccountInfo[2].ToString();
}
if (BankAccountInfo.Length > 3)
{
for (int loop = 3; loop < BankAccountInfo.Length; loop++)
{
branchAddress = branchAddress + BankAccountInfo[loop].ToString();
}
drUnitHolderInfo["BRANCH_ADDRESS"] = branchAddress;
}
}
}
}
}
DataTable dtNominee = reportObj.dtNominee(dtHolderInfo.Rows[looper]["REG_BK"].ToString(), dtHolderInfo.Rows[looper]["REG_BR"].ToString(), Convert.ToInt32(dtHolderInfo.Rows[looper]["R_NO"].ToString()));
if (dtNominee.Rows.Count > 0)
{
for (int loop = 0; loop < dtNominee.Rows.Count; loop++)
{
if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 1)
{
drUnitHolderInfo["NOMI_CTL_NO"] = dtNominee.Rows[loop]["NOMI_CTL_NO"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_CTL_NO"].ToString();
drUnitHolderInfo["NOMI1_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString();
drUnitHolderInfo["NOMI1_FMH_NAME"] = dtNominee.Rows[loop]["NOMI_FMH_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_FMH_NAME"].ToString();
drUnitHolderInfo["NOMI1_OCC_CODE"] = dtNominee.Rows[loop]["DESCR"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["DESCR"].ToString();
drUnitHolderInfo["NOMI1_ADDRS1"] = dtNominee.Rows[loop]["NOMI_ADDRS1"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_ADDRS1"].ToString();
drUnitHolderInfo["NOMI1_ADDRS2"] = dtNominee.Rows[loop]["NOMI_ADDRS2"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_ADDRS2"].ToString();
drUnitHolderInfo["NOMI1_CITY"] = dtNominee.Rows[loop]["NOMI_CITY"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_CITY"].ToString();
drUnitHolderInfo["NOMI1_NATIONALITY"] = dtNominee.Rows[loop]["NOMI_NATIONALITY"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NATIONALITY"].ToString();
drUnitHolderInfo["NOMI1_NOMI_REL"] = dtNominee.Rows[loop]["NOMI_REL"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_REL"].ToString();
drUnitHolderInfo["NOMI1_PERCENTAGE"] = dtNominee.Rows[loop]["PERCENTAGE"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["PERCENTAGE"].ToString();
}
else if (Convert.ToInt16(dtNominee.Rows[loop]["NOMI_NO"].ToString()) == 2)
{
drUnitHolderInfo["NOMI2_NAME"] = dtNominee.Rows[loop]["NOMI_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NAME"].ToString();
drUnitHolderInfo["NOMI2_FMH_NAME"] = dtNominee.Rows[loop]["NOMI_FMH_NAME"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_FMH_NAME"].ToString();
drUnitHolderInfo["NOMI2_OCC_CODE"] = dtNominee.Rows[loop]["DESCR"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["DESCR"].ToString();
drUnitHolderInfo["NOMI2_ADDRS1"] = dtNominee.Rows[loop]["NOMI_ADDRS1"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_ADDRS1"].ToString();
drUnitHolderInfo["NOMI2_ADDRS2"] = dtNominee.Rows[loop]["NOMI_ADDRS2"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_ADDRS2"].ToString();
drUnitHolderInfo["NOMI2_CITY"] = dtNominee.Rows[loop]["NOMI_CITY"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_CITY"].ToString();
drUnitHolderInfo["NOMI2_NATIONALITY"] = dtNominee.Rows[loop]["NOMI_NATIONALITY"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_NATIONALITY"].ToString();
drUnitHolderInfo["NOMI2_NOMI_REL"] = dtNominee.Rows[loop]["NOMI_REL"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["NOMI_REL"].ToString();
drUnitHolderInfo["NOMI2_PERCENTAGE"] = dtNominee.Rows[loop]["PERCENTAGE"].Equals(DBNull.Value) ? "" : dtNominee.Rows[loop]["PERCENTAGE"].ToString();
}
}
}
dtUnitHolderInfo.Rows.Add(drUnitHolderInfo);
}
// dtUnitHolderInfo.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.Web\UI\ReportViewer\Report\dtUnitHolderInfo.xsd");
string Path = Server.MapPath("Report/rptRegHolderInfo.rpt");
rdoc.Load(Path);
rdoc.SetDataSource(dtUnitHolderInfo);
CrystalReportViewer1.ReportSource = rdoc;
rdoc.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
rdoc = ReportFactory.GetReport(rdoc.GetType());
}
else
{
Response.Write("No data found");
}
}
// AMCL.REPORT.CR_BDFInterimDividendWarrantPrint CRBDF_Inetrim_Dividend = new CR_BDFInterimDividendWarrantPrint();
protected void Page_Load(object sender, EventArgs e)
{
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
string fundCode = (string)Session["fundCode"];
DataTable dtDividend = (DataTable)Session["dtDividend"];
string duplicate = (string)Session["duplicate"];
string dividendCategory = (string)Session["dividendCategory"];
if (dtDividend.Rows.Count > 0)
{
DataTable dtReport = diviDAOObj.dtGetDataTableforDividend();
decimal taxDiduct = 0;
DataRow drReport;
for (int loop = 0; loop < dtDividend.Rows.Count; loop++)
{
drReport = dtReport.NewRow();
drReport["FUND_CD"] = dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString();
drReport["FUND_NM"] = dtDividend.Rows[loop]["FUND_NM"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_NM"].ToString();
drReport["DIVI_NO"] = Convert.ToInt32(dtDividend.Rows[loop]["DIVI_NO"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["DIVI_NO"].ToString());
drReport["F_YEAR"] = dtDividend.Rows[loop]["F_YEAR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["F_YEAR"].ToString();
drReport["CLOSE_DT"] = dtDividend.Rows[loop]["CLOSE_DT"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["CLOSE_DT"].ToString();
drReport["DIVI_RATE"] = Convert.ToDecimal(dtDividend.Rows[loop]["DIVI_RATE"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["DIVI_RATE"].ToString());
drReport["BK_AC_NO"] = dtDividend.Rows[loop]["BK_AC_NO"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_AC_NO"].ToString();
drReport["BK_AC_NO_MICR"] = dtDividend.Rows[loop]["BK_AC_NO_MICR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_AC_NO_MICR"].ToString();
drReport["BK_NAME"] = dtDividend.Rows[loop]["BK_NAME"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_NAME"].ToString();
drReport["BK_ADDRS1"] = dtDividend.Rows[loop]["BK_ADDRS1"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_ADDRS1"].ToString();
drReport["BK_ADDRS2"] = dtDividend.Rows[loop]["BK_ADDRS2"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_ADDRS2"].ToString();
drReport["BK_ROUTING_NO"] = dtDividend.Rows[loop]["BK_ROUTING_NO"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_ROUTING_NO"].ToString();
drReport["BK_ROUTING_NO_MICR"] = dtDividend.Rows[loop]["BK_ROUTING_NO_MICR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["BK_ROUTING_NO_MICR"].ToString();
drReport["BK_TRANSACTION_CODE"] = Convert.ToInt16(dtDividend.Rows[loop]["BK_TRANSACTION_CODE"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["BK_TRANSACTION_CODE"].ToString());
drReport["ISS_DT"] = dtDividend.Rows[loop]["ISS_DT"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["ISS_DT"].ToString();
drReport["REG_NO"] = dtDividend.Rows[loop]["REG_NO"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_NO"].ToString();
drReport["HNAME"] = dtDividend.Rows[loop]["HNAME"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["HNAME"].ToString();
drReport["JNT_NAME"] = dtDividend.Rows[loop]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["JNT_NAME"].ToString();
drReport["ADDRS1"] = dtDividend.Rows[loop]["ADDRS1"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["ADDRS1"].ToString();
drReport["ADDRS2"] = dtDividend.Rows[loop]["ADDRS2"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["ADDRS2"].ToString();
drReport["CITY"] = dtDividend.Rows[loop]["CITY"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["CITY"].ToString();
drReport["WAR_NO"] = dtDividend.Rows[loop]["WAR_NO"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["WAR_NO"].ToString();
drReport["WAR_NO_MICR"] = dtDividend.Rows[loop]["WAR_NO_MICR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["WAR_NO_MICR"].ToString();
if (!(dtDividend.Rows[loop]["H_BK_AC_NO"].Equals(DBNull.Value)) && !(dtDividend.Rows[loop]["H_BK_NM_CD"].Equals(DBNull.Value)) && !(dtDividend.Rows[loop]["H_BK_BR_NM_CD"].Equals(DBNull.Value)))
{
drReport["HOLDER_BK_ACC_NO"] = dtDividend.Rows[loop]["H_BK_AC_NO"].ToString();
drReport["HOLDER_BK_NM"] = reportObj.getBankNameByBankCode(Convert.ToInt16(dtDividend.Rows[loop]["H_BK_NM_CD"].ToString()));
drReport["HOLDER_BK_BR_NM"] = reportObj.getBankBranchNameByCode(Convert.ToInt16(dtDividend.Rows[loop]["H_BK_NM_CD"].ToString()), Convert.ToInt32(dtDividend.Rows[loop]["H_BK_BR_NM_CD"].ToString()));
}
drReport["NO_OF_UNITS"] = Convert.ToInt32(dtDividend.Rows[loop]["NO_OF_UNITS"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["NO_OF_UNITS"].ToString());
drReport["TOT_DIVI"] = Convert.ToDecimal(dtDividend.Rows[loop]["TOT_DIVI"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TOT_DIVI"].ToString());
drReport["TAX_DIDUCT"] = Convert.ToDecimal(dtDividend.Rows[loop]["TAX_DIDUCT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_DIDUCT"].ToString());
drReport["FI_DIVI_QTY"] = Convert.ToDecimal(dtDividend.Rows[loop]["FI_DIVI_QTY"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["FI_DIVI_QTY"].ToString());
drReport["FI_DIVI_QTY_INWORD"] = NumToEngObj.changeNumericToWords(Convert.ToDecimal(dtDividend.Rows[loop]["FI_DIVI_QTY"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["FI_DIVI_QTY"].ToString())) + "Only";
drReport["CIP_QTY"] = Convert.ToInt32(dtDividend.Rows[loop]["CIP_QTY"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["CIP_QTY"].ToString());
drReport["CIP_RATE"] = Convert.ToDecimal(dtDividend.Rows[loop]["CIP_RATE"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["CIP_RATE"].ToString());
drReport["CIP"] = dtDividend.Rows[loop]["CIP"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["CIP"].ToString();
drReport["AGM_DT"] = dtDividend.Rows[loop]["AGM_DT"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["AGM_DT"].ToString();
//taxDiduct = Convert.ToDecimal(dtDividend.Rows[loop]["TAX_DIDUCT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_DIDUCT"].ToString());
//decimal taxDiductCal = 0;
//if (taxDiduct == 0)
//{
// drReport["TAX_RT_INDIVIDUAL"] = 0;
// drReport["TAX_RT_INSTITUTION"] = 0;
// taxDiductCal = 0;
//}
//else if (taxDiduct > 0)
//{
// if (diviDAOObj.getRegType(Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString()), dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString(), dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString()).ToString().ToUpper() == "I")
// {
// drReport["TAX_RT_INDIVIDUAL"] = 0;
// drReport["TAX_RT_INSTITUTION"] = diviDAOObj.getTaxDiductRate(Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString()), dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString(), dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString(), dtDividend.Rows[loop]["F_YEAR"].ToString(), Convert.ToDecimal(dtDividend.Rows[loop]["TAX_LIMIT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_LIMIT"].ToString()));
// taxDiductCal = diviDAOObj.getTaxDiductRate(Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString()), dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString(), dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString(), dtDividend.Rows[loop]["F_YEAR"].ToString(), Convert.ToDecimal(dtDividend.Rows[loop]["TAX_LIMIT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_LIMIT"].ToString()));
// }
// else
// {
// drReport["TAX_RT_INDIVIDUAL"] = diviDAOObj.getTaxDiductRate(Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString()), dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString(), dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString(), dtDividend.Rows[loop]["F_YEAR"].ToString(), Convert.ToDecimal(dtDividend.Rows[loop]["TAX_LIMIT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_LIMIT"].ToString()));
// drReport["TAX_RT_INSTITUTION"] = 0;
// taxDiductCal = diviDAOObj.getTaxDiductRate(Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString()), dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString(), dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString(), dtDividend.Rows[loop]["F_YEAR"].ToString(), Convert.ToDecimal(dtDividend.Rows[loop]["TAX_LIMIT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_LIMIT"].ToString()));
// }
//}
drReport["REG_TYPE"] = dtDividend.Rows[loop]["REG_TYPE"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_TYPE"].ToString();
drReport["FY_PART"] = dtDividend.Rows[loop]["FY_PART"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FY_PART"].ToString();
drReport["NET_DIVI"] = Convert.ToDecimal(dtDividend.Rows[loop]["NET_DIVI"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["NET_DIVI"].ToString());
drReport["FRAC_DIVI"] = Convert.ToDecimal(dtDividend.Rows[loop]["FRAC_DIVI"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["FRAC_DIVI"].ToString());
drReport["REG_NUM"] = Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString());
drReport["REG_BR"] = dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString();
string taxCalText = "";
//DataTable dtTaxCal = diviDAOObj.dtDividendInfo(Convert.ToInt32(dtDividend.Rows[loop]["REG_NUM"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["REG_NUM"].ToString()), dtDividend.Rows[loop]["FUND_CD"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["FUND_CD"].ToString(), dtDividend.Rows[loop]["REG_BR"].Equals(DBNull.Value) ? "" : dtDividend.Rows[loop]["REG_BR"].ToString(), dtDividend.Rows[loop]["F_YEAR"].ToString());
//if (dtTaxCal.Rows.Count > 1)
//{
// if (taxDiduct == 0)
// {
// drReport["TAX_CAL_TEXT"] = "";
// }
// else
// {
// decimal totalDividend = Convert.ToDecimal(dtTaxCal.Rows[0]["TOT_DIVI"].ToString()) + Convert.ToDecimal(dtTaxCal.Rows[1]["TOT_DIVI"].ToString());
// decimal totalDiduct = Convert.ToDecimal(dtTaxCal.Rows[0]["DIDUCT"].ToString()) + Convert.ToDecimal(dtTaxCal.Rows[1]["DIDUCT"].ToString()); ;
// decimal total_remainning = totalDividend - Convert.ToDecimal(dtDividend.Rows[loop]["TAX_LIMIT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_LIMIT"].ToString());
// decimal taxtLimit = Convert.ToDecimal(dtDividend.Rows[loop]["TAX_LIMIT"].Equals(DBNull.Value) ? "0" : dtDividend.Rows[loop]["TAX_LIMIT"].ToString());
// decimal diduct1 = Convert.ToDecimal(dtTaxCal.Rows[0]["DIDUCT"].ToString());
// decimal diduct2 = Convert.ToDecimal(dtTaxCal.Rows[1]["DIDUCT"].ToString());
// string TAX_CAL_TEXT = "*" + dtTaxCal.Rows[0]["TOT_DIVI"].ToString() + " (" + dtTaxCal.Rows[0]["FY_PART"].ToString() + ") +" + dtTaxCal.Rows[1]["TOT_DIVI"].ToString() + " (" + dtTaxCal.Rows[1]["FY_PART"].ToString() + ") ";
// TAX_CAL_TEXT = TAX_CAL_TEXT + "=" + totalDividend.ToString() + "-" + taxtLimit + "=";
// TAX_CAL_TEXT = TAX_CAL_TEXT + total_remainning.ToString() + "@" + taxDiductCal + "%=" + totalDiduct.ToString() + " [" + diduct1 + "(" + dtTaxCal.Rows[0]["FY_PART"].ToString() + ")+" + diduct2 + "(" + dtTaxCal.Rows[1]["FY_PART"].ToString() + ")" + "]";
// drReport["TAX_CAL_TEXT"] = TAX_CAL_TEXT;
// }
//}
//else
//{
// drReport["TAX_CAL_TEXT"] = "";
//}
drReport["TAX_CAL_TEXT"] = "";
dtReport.Rows.Add(drReport);
}
dtReport.TableName = "ReportDividend";
//dtReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\ReportDividend.xsd");
if (fundCode.ToString().ToUpper() == "IAMPH")
{
CRPen_Dividend.Refresh();
CRPen_Dividend.SetDataSource(dtReport);
CRPen_Dividend.SetParameterValue("duplicate", duplicate);
CrystalReportViewer1.ReportSource = CRPen_Dividend;
}
else if (fundCode.ToString().ToUpper() == "BDF")
{
if (dividendCategory == "INTERIM")
{
CRBDF_Dividend.Refresh();
CRBDF_Dividend.SetDataSource(dtReport);
CRBDF_Dividend.SetParameterValue("duplicate", duplicate);
CrystalReportViewer1.ReportSource = CRBDF_Dividend;
}
else
{
CRBDF_Dividend.Refresh();
CRBDF_Dividend.SetDataSource(dtReport);
CRBDF_Dividend.SetParameterValue("duplicate", duplicate);
CrystalReportViewer1.ReportSource = CRBDF_Dividend;
}
}
else
{
CRUnit_Dividend.Refresh();
CRUnit_Dividend.SetDataSource(dtReport);
CRUnit_Dividend.SetParameterValue("duplicate", duplicate);
CrystalReportViewer1.ReportSource = CRUnit_Dividend;
}
}
else
{
Response.Write("No data found");
}
}
protected void ShowReportButton_Click(object sender, EventArgs e)
{
try
{
//StringBuilder sbRepurchase = new StringBuilder();
//sbRepurchase.Append("SELECT SUM(QTY) AS QTY, SUM(QTY * REP_PRICE) AS AMOUNT FROM (SELECT REPURCHASE.REP_NO, REPURCHASE.REP_DT, REPURCHASE.QTY, U_MASTER.HNAME, REPURCHASE.SL_TR_NO, ");
//sbRepurchase.Append(" ");
UnitHolderRegistration regObj = new UnitHolderRegistration();
// UnitTransfer transferObj = new UnitTransfer();
UnitRepurchase unitRepObj = new UnitRepurchase();
regObj.FundCode = fundCodeTextBox.Text.Trim();
regObj.BranchCode = branchCodeTextBox.Text.Trim();
unitRepObj.RepurchaseNo = Convert.ToInt32(fromRepNoTextBox.Text.Trim().ToString());
StringBuilder sbMaster = new StringBuilder();
StringBuilder sbFilter = new StringBuilder();
DataTable dtReportStatement = new DataTable();
StringBuilder sbReportString = new StringBuilder();
string copy = fundCodeTextBox.Text.ToString() + " Copy";
if (accoountRadioButton.Checked)
{
copy = "Accounts Copy";
}
sbMaster.Append("SELECT NVL(REPURCHASE.REP_NO,0) AS REP_NO , TO_CHAR(REPURCHASE.REP_DT, 'DD-MON-YYYY') AS REP_DT, U_MASTER.REG_BK, U_MASTER.REG_BR, U_MASTER.REG_NO AS RG_NO, ");
sbMaster.Append(" U_MASTER.HNAME, U_JHOLDER.JNT_NAME, U_MASTER.REG_BK || '/' || U_MASTER.REG_BR || '/' || U_MASTER.REG_NO AS REG_NO,U_MASTER.TIN,U_MASTER.BO,");
sbMaster.Append(" U_MASTER.ADDRS1, U_MASTER.ADDRS2, U_MASTER.CITY, U_MASTER.BK_AC_NO,U_MASTER.BK_NM_CD,U_MASTER.ID_FLAG,U_MASTER.ID_BK_NM_CD, U_MASTER.ID_BK_BR_NM_CD,");
sbMaster.Append(" U_MASTER.BK_BR_NM_CD, U_MASTER.BK_FLAG,REPURCHASE.QTY, REPURCHASE.REP_PRICE AS RATE, REPURCHASE.QTY * REPURCHASE.REP_PRICE AS AMOUNT, REPURCHASE.SL_TR_NO, U_MASTER.CIP, U_MASTER.ID_AC,");
sbMaster.Append(" DECODE(REPURCHASE.PAY_TYPE,'EFT','BEFTN','CHEQUE') AS PAY_TYPE ");
sbMaster.Append(" FROM U_MASTER INNER JOIN REPURCHASE ON U_MASTER.REG_BK = REPURCHASE.REG_BK AND U_MASTER.REG_BR = REPURCHASE.REG_BR AND U_MASTER.REG_NO = REPURCHASE.REG_NO");
sbMaster.Append(" LEFT OUTER JOIN U_JHOLDER ON U_MASTER.REG_BK = U_JHOLDER.REG_BK AND U_MASTER.REG_BR = U_JHOLDER.REG_BR AND U_MASTER.REG_NO = U_JHOLDER.REG_NO");
sbMaster.Append(" WHERE 1=1");
sbMaster.Append(" AND (U_MASTER.REG_BK = '" + fundCodeTextBox.Text.Trim().ToString().ToUpper() + "') AND (U_MASTER.REG_BR = '" + branchCodeTextBox.Text.Trim().ToString().ToUpper() + "')");
if (fromRepNoTextBox.Text != "")
{
sbFilter.Append(" AND (REPURCHASE.REP_NO = " + Convert.ToInt32(fromRepNoTextBox.Text.Trim().ToString()) + ")");
}
if (fromRegNoTextBox.Text != "")
{
sbFilter.Append(" AND (U_MASTER.REG_NO = " + Convert.ToInt32(fromRegNoTextBox.Text.Trim().ToString()) + ")");
}
if (fromRepDateTextBox.Text != "")
{
sbFilter.Append(" AND ( REPURCHASE.REP_DT ='" + Convert.ToDateTime(fromRepDateTextBox.Text.Trim().ToString()).ToString("dd-MMM-yyyy") + "')");
}
sbFilter.Append(" ORDER BY TO_NUMBER(SUBSTR(REPURCHASE.SL_TR_NO,2)) ");
sbMaster.Append(sbFilter.ToString());
dtReportStatement = commonGatewayObj.Select(sbMaster.ToString());
if (dtReportStatement.Rows.Count > 0)
{
string holderName = dtReportStatement.Rows[0]["HNAME"].ToString().ToUpper();
if (dtReportStatement.Rows[0]["BK_FLAG"].ToString().ToUpper() == "N" || dtReportStatement.Rows[0]["BK_NM_CD"].Equals(DBNull.Value) || dtReportStatement.Rows[0]["BK_BR_NM_CD"].Equals(DBNull.Value))
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('Please Update Bank Information');", true);
}
else if ((dtReportStatement.Rows[0]["ID_FLAG"].ToString().ToUpper() == "Y") && (dtReportStatement.Rows[0]["ID_BK_NM_CD"].Equals(DBNull.Value) || dtReportStatement.Rows[0]["ID_BK_BR_NM_CD"].Equals(DBNull.Value) || dtReportStatement.Rows[0]["ID_AC"].Equals(DBNull.Value)))
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('Please Update ID Information');", true);
}
else
{
if (dtReportStatement.Rows[0]["ID_FLAG"].ToString().ToUpper() == "Y")
{
holderName = reportObj.getBankNameByBankCode(Convert.ToInt32(dtReportStatement.Rows[0]["ID_BK_NM_CD"].ToString())).ToString() + " , " + reportObj.getBankBranchNameByCode(Convert.ToInt32(dtReportStatement.Rows[0]["ID_BK_NM_CD"].ToString()), Convert.ToInt32(dtReportStatement.Rows[0]["ID_BK_BR_NM_CD"].ToString())).ToString() + " ID NO:" + dtReportStatement.Rows[0]["ID_AC"].ToString().ToUpper();
}
string BankInfo = ", bank account no : " + dtReportStatement.Rows[0]["BK_AC_NO"].ToString().ToUpper() + " , " + reportObj.getBankNameByBankCode(int.Parse(dtReportStatement.Rows[0]["BK_NM_CD"].ToString())) + "," + " " + reportObj.getBankBranchNameByCode(int.Parse(dtReportStatement.Rows[0]["BK_NM_CD"].ToString()), int.Parse(dtReportStatement.Rows[0]["BK_BR_NM_CD"].ToString()));
DataTable dtBankBracnhInfo = unitHolderRegBLObj.dtGetBankBracnhInfo(Convert.ToInt32(dtReportStatement.Rows[0]["BK_NM_CD"].ToString()), Convert.ToInt32(dtReportStatement.Rows[0]["BK_BR_NM_CD"].ToString()));
if (dtBankBracnhInfo.Rows.Count > 0)
{
BankInfo = BankInfo + " [ " + dtBankBracnhInfo.Rows[0]["ROUTING_NO"].ToString() + "] ";
}
// string BankInfo = "";
decimal totalRepAmount = 0;
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
totalRepAmount = totalRepAmount + Convert.ToDecimal(dtReportStatement.Rows[looper]["AMOUNT"].ToString());
}
if (NoRadioButton.Checked)
{
string payType = unitRepBLObj.getPayType(regObj, unitRepObj);
if (payType.ToString() == "EFT")
{
sbReportString.Append(" Through BEFTN Tk. " + totalRepAmount.ToString("#,##0.00") + " ( Taka " + numberToEnglishObj.changeNumericToWords(totalRepAmount) + " ) ");
sbReportString.Append(" be issued in favour of Mr./Ms. " + holderName.ToString().ToUpper() + "" + BankInfo);
sbReportString.Append(" being the surrended value of units. ");
}
else
{
sbReportString.Append(" An account payee cheque for Tk. " + totalRepAmount.ToString("#,##0.00") + " ( Taka " + numberToEnglishObj.changeNumericToWords(totalRepAmount) + " ) ");
sbReportString.Append(" be issued in favour of Mr./Ms. " + holderName.ToString().ToUpper() + "" + BankInfo);
sbReportString.Append(" being the surrended value of units. ");
}
}
else if (YesRadioButton.Checked)
{
decimal lienAmount = Convert.ToDecimal(LienAmountTextBox.Text.Trim().ToString());
decimal remainingAmount = totalRepAmount - lienAmount;
sbReportString.Append("According to the letter no: " + LienReqRefTextBox.Text.Trim().ToString() + " dated on " + LienReqDateTextBox.Text.Trim().ToString() + ", the above certificates are ");
sbReportString.Append(" surrendered by " + LienbankNameDropDownList.SelectedItem.Text.ToString() + ", " + LienbranchNameDropDownList.SelectedItem.Text.ToString() + " . An account payee cheque for Tk. " + lienAmount.ToString("#,##0.00") + " ( Taka ");
sbReportString.Append(numberToEnglishObj.changeNumericToWords(lienAmount).ToString() + " ) be issued in favour of " + LienbankNameDropDownList.SelectedItem.Text.ToString() + " , " + LienbranchNameDropDownList.SelectedItem.Text.ToString());
sbReportString.Append(" and another account payee cheque of remaining amout for Tk. " + remainingAmount.ToString("#,##0.00") + " ( Taka " + numberToEnglishObj.changeNumericToWords(remainingAmount));
sbReportString.Append(" ) be issued in favour of Mr./Ms. " + holderName.ToString().ToUpper() + BankInfo + " being the surrended value of units. ");
}
Session["dtReportStatement"] = dtReportStatement;
Session["fundCode"] = fundCodeTextBox.Text.Trim().ToString();
Session["branchCode"] = branchCodeTextBox.Text.Trim().ToString();
Session["sbReportString"] = sbReportString.ToString();
Session["copy"] = copy;
// ClientScript.RegisterStartupScript(this.GetType(), "UnitHolderInfo", "window.open('ReportViewer/UnitReportRepurchaseVoucherReportViewer.aspx')", true);
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "UnitHolderInfo", "window.open('ReportViewer/UnitReportRepurchaseVoucherReportViewer.aspx')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('No data found');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
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 = "";
}
}