public void displaySign()
{
string regNo = "";
string fundCode = "";
string branchCode = "";
string unitHolderName = "";
string branchName = "";
string fundName = "";
regNo = regNoTextBox.Text.ToString();
fundName = opendMFDAO.GetFundName(fundCodeTextBox.Text.ToString());
fundCode = fundCodeTextBox.Text.ToString();
branchName = opendMFDAO.GetBranchName(branchCodeTextBox.Text.ToString());
branchCode = branchCodeTextBox.Text.ToString();
unitHolderName = opendMFDAO.GetHolderName(fundCode, branchCode, regNo);
string[] BranchCodeSign = branchCode.Split('/');
string imageSignLocation = Path.Combine(ConfigReader.SingLocation + "\\" + fundCode, fundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + regNo + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg";
string imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation + "\\" + fundCode, fundCode + "_" + BranchCodeSign[0] + BranchCodeSign[1] + "_" + regNo + ".jpg");
if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + fundCode, fundCode + "_" + BranchCodeSign[0] + "_" + BranchCodeSign[1] + "_" + regNo + ".jpg")))
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(imageSignLocation.ToString());
}
else
{
SignImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
}
}
protected void tfereeRegNoTextBox_TextChanged(object sender, EventArgs e)
{
string unitHolderName = "";
string branchName = "";
string fundName = "";
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = tfereeFundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = tfereeBranhCodeTextBox.Text.Trim();
unitRegObj.RegNumber = tfereeRegNoTextBox.Text.Trim();
DataTable dtRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
if (dtRegInfo.Rows.Count > 0)
{
tfereeHolderNameTextBox.Text = dtRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["HNAME"].ToString();
tfereejHolderNameTextBox.Text = dtRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtRegInfo.Rows[0]["JNT_NAME"].ToString();
fundName = opendMFDAO.GetFundName(unitRegObj.FundCode.ToString());
branchName = opendMFDAO.GetBranchName(unitRegObj.BranchCode.ToString());
unitHolderName = opendMFDAO.GetHolderName(unitRegObj.FundCode, unitRegObj.BranchCode, unitRegObj.RegNumber);
string[] branchCodeSign = unitRegObj.BranchCode.Split('/');
string imageSignLocation = Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode + "_" + branchCodeSign[0] + "_" + branchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg");
if (File.Exists(Path.Combine(ConfigReader.SingLocation + "\\" + unitRegObj.FundCode, unitRegObj.FundCode.ToString() + "_" + branchCodeSign[0] + "_" + branchCodeSign[1] + "_" + unitRegObj.RegNumber + ".jpg")))
{
PhotoImage.ImageUrl = encrypt.PhotoBase64ImgSrc(imageSignLocation.ToString());
}
else
{
PhotoImage.ImageUrl = encrypt.PhotoBase64ImgSrc(Path.Combine(ConfigReader.SingLocation, "Notavailable.JPG").ToString());
}
unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = tferorFundCodeTextBox.Text.Trim();
unitRegObj.BranchCode = tferorBranchCodeTextBox.Text.Trim();
unitRegObj.RegNumber = tferorRegNoTextBox.Text.Trim();
decimal tFerorTotalUnits = opendMFDAO.getTotalSaleUnitBalance(unitRegObj);
if (tFerorTotalUnits > 0)
{
dvContentBottom.Visible = true;
}
else
{
dvContentBottom.Visible = false;
}
}
else
{
PhotoImage.ImageUrl = "";
tfereeHolderNameTextBox.Text = "";
tfereejHolderNameTextBox.Text = "";
dvContentBottom.Visible = false;
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Popup", "alert ('Invalid Registration Number');", true);
}
}
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);
}
tdBranch.InnerHtml = "<span style=\"color:Green\"><b>" + branchName.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>" + regNo.ToString() + "</b></span>";
//string imageLocation =
string imageSignLocation = Path.Combine(ConfigReader.SingLocation, fundCode + "_" + branchCode + "_" + regNo + ".jpg");//"../../Image/IAMCL/Sign/"+ fundCode + "_" + branchCode + "_" + regNo + ".jpg";
string imagePhotoLocation = Path.Combine(ConfigReader.PhotoLocation, fundCode + "_" + branchCode + "_" + regNo + ".jpg");
//SignImage.ImageUrl = imageSignLocation.ToString();
// PhotoImage.ImageUrl = imagePhotoLocation.ToString();
}
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string FundCode = "";
string BranchCode = "";
string UserName = "";
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
UserID = bcContent.LoginID;
FundCode = bcContent.FundCode;
BranchCode = bcContent.BranchCode;
UserName = bcContent.LoginUserName;
CDSStatus = bcContent.CDS.ToString().ToUpper();
if (!IsPostBack)
{
DataTable dt = this.BindMenuData(0);
DynamicMenuControlPopulation(dt, 0, null);
if (FundCode == null || BranchCode == null)
{
Response.Redirect("../Default.aspx");
}
else
{
string cssColourCode = opendMFDAO.getFundCSSColourCode(FundCode.ToUpper());
tdFundName.InnerHtml = "<span style=\"color:" + cssColourCode + ";\">" + opendMFDAO.GetFundName(FundCode) + "</span>";
tdUser.InnerHtml = "<span style=\"color:" + cssColourCode + "\"> User: <b>" + UserName + "</b></span>";
tdBranch.InnerHtml = "<span style=\"color:" + cssColourCode + "\">Branch: <b>" + opendMFDAO.GetBranchName(BranchCode) + "</b></span>";
}
}
}
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 dtReport = reportObj.getDtForReportStatement();
dtReport.TableName = "ReportStatement";
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();
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();
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();
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();
}
}
}
saleNo = Convert.ToInt32(dtReportStatement.Rows[looper]["SL_NO"].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() + "'", 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
// {
// string branchAddress = "";
// string BankAccInfo = dtReportStatement.Rows[looper]["SPEC_IN1"].ToString() + dtReportStatement.Rows[looper]["SPEC_IN2"].ToString();
// string[] BankAccountInfo = BankAccInfo.Split(',');
// if (BankAccountInfo.Length > 0)
// {
// drReport["BK_AC_NO"] = BankAccountInfo[0].ToString();
// if (BankAccountInfo.Length > 1)
// {
// drReport["BANK_NAME"] = BankAccountInfo[1].ToString();
// }
// if (BankAccountInfo.Length > 2)
// {
// drReport["BRANCH_NAME"] = BankAccountInfo[2].ToString();
// }
// if (BankAccountInfo.Length > 3)
// {
// for (int loop = 3; loop < BankAccountInfo.Length; loop++)
// {
// branchAddress = branchAddress + BankAccountInfo[loop].ToString();
// }
// drReport["BRANCH_ADDRESS"] = branchAddress;
// }
// }
// }
// }
//}
drReport["CIP"] = dtReportStatement.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CIP"].ToString();
drReport["BO"] = dtReportStatement.Rows[looper]["BO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BO"].ToString();
drReport["TIN"] = dtReportStatement.Rows[looper]["TIN"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TIN"].ToString();
drReport["BEFTN"] = dtReportStatement.Rows[looper]["BEFTN"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BEFTN"].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(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtUnitReportForStatement.xsd");
CRSaleLedger.Refresh();
CRSaleLedger.SetDataSource(dtReport);
CRSaleLedger.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
CRSaleLedger.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
CRSaleLedger.SetParameterValue("branchCode", branchCode.ToString());
CrystalReportViewer1.ReportSource = CRSaleLedger;
}
else
{
Response.Write("No data found");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string fundCode = "";
string branchCode = "";
string regiNo = "";
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"];
regiNo = (string)Session["regiNo"];
DataTable dtLedgerForReport = (DataTable)Session["dtLedgerForReport"];
dtLedgerForReport.TableName = "dtLedgerForReport";
if (dtLedgerForReport.Rows.Count > 0)
{
UnitHolderRegistration unitRegObj = new UnitHolderRegistration();
unitRegObj.FundCode = fundCode.ToString();
unitRegObj.BranchCode = branchCode.ToString();
unitRegObj.RegNumber = regiNo.ToString();
DataTable dtLedgerRegInfo = opendMFDAO.getDtRegInfo(unitRegObj);
dtLedgerRegInfo.TableName = "dtLedgerRegInfo";
string regiNumber = dtLedgerRegInfo.Rows[0]["REG_BK"].ToString() + "/" + dtLedgerRegInfo.Rows[0]["REG_BR"].ToString() + "/" + dtLedgerRegInfo.Rows[0]["REG_NO"].ToString();
string holderName = dtLedgerRegInfo.Rows[0]["HNAME"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["HNAME"].ToString();
string JointHolderName = dtLedgerRegInfo.Rows[0]["JNT_NAME"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["JNT_NAME"].ToString();
string address1 = dtLedgerRegInfo.Rows[0]["ADDRS1"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["ADDRS1"].ToString();
string address2 = dtLedgerRegInfo.Rows[0]["ADDRS2"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["ADDRS2"].ToString();
string city = dtLedgerRegInfo.Rows[0]["CITY"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["CITY"].ToString();
string cip = dtLedgerRegInfo.Rows[0]["CIP"].Equals(DBNull.Value)? "":dtLedgerRegInfo.Rows[0]["CIP"].Equals("Y") ? "YES":"NO";
string regType = dtLedgerRegInfo.Rows[0]["REG_TYPE"].Equals(DBNull.Value) ? "" : reportObj.getRegTypeFullName(dtLedgerRegInfo.Rows[0]["REG_TYPE"].ToString());
string BO_Folio = "";
if (!dtLedgerRegInfo.Rows[0]["BO"].Equals(DBNull.Value))
{
BO_Folio = dtLedgerRegInfo.Rows[0]["BO"].ToString();
}
else if (!dtLedgerRegInfo.Rows[0]["FOLIO_NO"].Equals(DBNull.Value))
{
BO_Folio = dtLedgerRegInfo.Rows[0]["FOLIO_NO"].ToString();
}
string BEFTN = "";
if (!dtLedgerRegInfo.Rows[0]["IS_BEFTN"].Equals(DBNull.Value))
{
BEFTN = dtLedgerRegInfo.Rows[0]["IS_BEFTN"].Equals("Y") ? "YES" : "NO";
}
string ETIN = dtLedgerRegInfo.Rows[0]["TIN"].Equals(DBNull.Value) ? "" : dtLedgerRegInfo.Rows[0]["TIN"].ToString();
//dtLedgerForReport. WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtLedgerForReport.xsd");
CR_Ledger.Refresh();
CR_Ledger.SetDataSource(dtLedgerForReport);
CR_Ledger.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
CR_Ledger.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
CR_Ledger.SetParameterValue("branchCode", branchCode.ToString());
CR_Ledger.SetParameterValue("Regi_No", regiNumber);
CR_Ledger.SetParameterValue("Holder_Name", holderName.ToString());
CR_Ledger.SetParameterValue("Jholder_name", JointHolderName.ToString());
CR_Ledger.SetParameterValue("Address1", address1.ToString());
CR_Ledger.SetParameterValue("Address2", address2.ToString());
CR_Ledger.SetParameterValue("City", city.ToString());
CR_Ledger.SetParameterValue("Cip", cip.ToString());
CR_Ledger.SetParameterValue("Reg_Type", regType.ToString());
CR_Ledger.SetParameterValue("BO_Folio", BO_Folio.ToString());
CR_Ledger.SetParameterValue("BEFTN", BEFTN.ToString());
CR_Ledger.SetParameterValue("ETIN", ETIN.ToString());
CrystalReportViewer1.ReportSource = CR_Ledger;
}
else
{
Response.Write("No data found");
}
}
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 dtReport = reportObj.getDtForReportStatement();
dtReport.TableName = "ReportStatement";
DataRow drReport;
DataTable dtReportStatement = (DataTable)Session["dtReportStatement"];
if (dtReportStatement.Rows.Count > 0)
{
int repNo = 0;
string SL_TR_NO = "";
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
drReport = dtReport.NewRow();
drReport["REP_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["REP_NO"].ToString());
drReport["REP_DT"] = dtReportStatement.Rows[looper]["REP_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REP_DT"].ToString();
drReport["SL_TR_REP_NO"] = dtReportStatement.Rows[looper]["SL_TR_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_TR_NO"].ToString();
drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].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();
drReport["BO"] = dtReportStatement.Rows[looper]["BO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BO"].ToString();
repNo = Convert.ToInt32(dtReportStatement.Rows[looper]["REP_NO"].ToString());
SL_TR_NO = dtReportStatement.Rows[looper]["SL_TR_NO"].ToString();
drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM REP_CERT_NO WHERE REP_NO=" + repNo + " AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' AND SL_TR_NO='" + SL_TR_NO.ToString() + "'", fundCode.ToString()).ToString();
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");
rep_Statement.Refresh();
rep_Statement.SetDataSource(dtReport);
rep_Statement.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
rep_Statement.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
rep_Statement.SetParameterValue("branchCode", branchCode.ToString());
CrystalReportViewer1.ReportSource = rep_Statement;
//ReportDocument rdoc = new ReportDocument();
//string Path = Server.MapPath("Report/rptRepStatement.rpt");
//rdoc.Load(Path);
//rdoc.SetDataSource(dtReport);
//CrystalReportViewer1.ReportSource = rdoc;
//rdoc.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
//rdoc.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
//rdoc.SetParameterValue("branchCode", branchCode.ToString());
}
else
{
Response.Write("No data found");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string UserID = "";
string FundCode = "";
string BranchCode = "";
string UserName = "";
string queryStringParent = "";
string CDSStatus = "";
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
UserID = bcContent.LoginID;
FundCode = bcContent.FundCode;
BranchCode = bcContent.BranchCode;
UserName = bcContent.LoginUserName;
CDSStatus = bcContent.CDS.ToString().ToUpper();
mnuMenu.Items.Clear();
skmMenu.MenuItem item;
skmMenu.MenuItem Subitem;
if (CDSStatus == "Y")
{
if (string.Compare(UserID, "admin", false) == 0)
{
queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE VALID='Y' and M_PARENT_ID<>0 AND PROJECT_ID=1 AND CDS='Y' ORDER BY PARENT_ID";
}
else
{
queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE NON_CDS_M_ID IN (SELECT M_ID FROM USER_MENU WHERE USER_ID='" + UserID.ToString() + "' AND VALID IS NULL ) AND VALID='Y' and M_PARENT_ID <>0 AND CDS='Y' ORDER BY PARENT_ID";
}
}
else
{
if (string.Compare(UserID, "admin", false) == 0)
{
queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE VALID='Y' and M_PARENT_ID<>0 AND PROJECT_ID=1 AND M_ID=NVL(NON_CDS_M_ID,M_ID) ORDER BY PARENT_ID";
}
else
{
queryStringParent = "SELECT DISTINCT( M_PARENT_ID) AS PARENT_ID FROM MENU WHERE M_ID IN (SELECT M_ID FROM USER_MENU WHERE USER_ID='" + UserID.ToString() + "' AND VALID IS NULL) AND VALID='Y' and M_PARENT_ID<>0 ORDER BY PARENT_ID";
}
}
DataTable dtSubMenu = new DataTable();
DataTable dtParentMenu = new DataTable();
string parentItem = "";
if (queryStringParent != "")
{
dtParentMenu = commonGatewayObj.Select(queryStringParent.ToString());
}
if (dtParentMenu.Rows.Count > 0)
{
for (int looper = 0; looper < dtParentMenu.Rows.Count; looper++)
{
parentItem = itemString(Convert.ToInt32(dtParentMenu.Rows[looper]["PARENT_ID"].ToString())).ToString();
item = new skmMenu.MenuItem(parentItem.ToString());
dtSubMenu = getdtSubMenu(Convert.ToInt32(dtParentMenu.Rows[looper]["PARENT_ID"].ToString()), UserID, BranchCode.ToString().ToUpper(), FundCode.ToString().ToUpper(), CDSStatus);
if (dtSubMenu.Rows.Count == 1 && (dtSubMenu.Rows[0]["M_PARENT_ID"].ToString() == dtSubMenu.Rows[0]["M_ID"].ToString()))
{
item.Url = dtSubMenu.Rows[0]["M_URL"].ToString();
}
else if (dtSubMenu.Rows.Count > 0)
{
for (int loop = 0; loop < dtSubMenu.Rows.Count; loop++)
{
Subitem = new skmMenu.MenuItem(dtSubMenu.Rows[loop]["M_CAPTION"].ToString());
Subitem.Url = dtSubMenu.Rows[loop]["M_URL"].ToString();
item.SubItems.Add(Subitem);
}
}
mnuMenu.Items.Add(item);
}
}
if (FundCode == null || BranchCode == null)
{
Response.Redirect("../Default.aspx");
}
else
{
string cssColourCode = opendMFDAO.getFundCSSColourCode(FundCode.ToUpper());
tdFundName.InnerHtml = "<span style=\"color:" + cssColourCode + ";\">" + opendMFDAO.GetFundName(FundCode) + "</span>";
tdUser.InnerHtml = "<span style=\"color:" + cssColourCode + "\"> User: <b>" + UserName + "</b></span>";
tdBranch.InnerHtml = "<span style=\"color:" + cssColourCode + "\">Branch: <b>" + opendMFDAO.GetBranchName(BranchCode) + "</b></span>";
}
mnuMenu1.Items.Clear();
//Home
item = new skmMenu.MenuItem("Home");
item.Url = "Home.aspx";
mnuMenu1.Items.Add(item);
//Logout
item = new skmMenu.MenuItem("Logout");
item.Url = "../Default.aspx";
mnuMenu1.Items.Add(item);
}
//private ReportDocument rdoc = new ReportDocument();
protected void Page_Load(object sender, EventArgs e)
{
string fundCode = "";
string branchCode = "";
string sbReportString = "";
string copy = "";
if (Session["UserID"] == null)
{
Session.RemoveAll();
Response.Redirect("../../Default.aspx");
}
else
{
branchCode = (string)Session["branchCode"];
fundCode = (string)Session["fundCode"];
sbReportString = (string)Session["sbReportString"];
copy = (string)Session["copy"];
}
DataTable dtReport = reportObj.getDtForReportStatement();
dtReport.TableName = "ReportStatement";
DataRow drReport;
DataTable dtReportStatement = (DataTable)Session["dtReportStatement"];
if (dtReportStatement.Rows.Count > 0)
{
int repNo = 0;
string SL_TR_NO = "";
decimal totalAmount = 0;
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
drReport = dtReport.NewRow();
drReport["REP_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["REP_NO"].ToString());
drReport["REP_DT"] = dtReportStatement.Rows[looper]["REP_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["REP_DT"].ToString();
drReport["SL_TR_REP_NO"] = dtReportStatement.Rows[looper]["SL_TR_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["SL_TR_NO"].ToString();
drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].ToString();
if (string.Compare(fundCode, "IAMPH", true) != 0)
{
drReport["JNT_NAME"] = dtReportStatement.Rows[looper]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["JNT_NAME"].ToString();
}
drReport["BO"] = dtReportStatement.Rows[looper]["BO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["BO"].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();
drReport["PAY_TYPE"] = dtReportStatement.Rows[looper]["PAY_TYPE"].ToString();
repNo = Convert.ToInt32(dtReportStatement.Rows[looper]["REP_NO"].ToString());
SL_TR_NO = dtReportStatement.Rows[looper]["SL_TR_NO"].ToString();
drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM REP_CERT_NO WHERE REP_NO=" + repNo + " AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' AND SL_TR_NO='" + SL_TR_NO.ToString() + "' ORDER BY CERT_TYPE,CERT_NO ", fundCode.ToString()).ToString();
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());
totalAmount = totalAmount + Convert.ToDecimal(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");
CR_RepVoucher.Refresh();
CR_RepVoucher.SetDataSource(dtReport);
CR_RepVoucher.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
CR_RepVoucher.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
CR_RepVoucher.SetParameterValue("branchCode", branchCode.ToString());
CR_RepVoucher.SetParameterValue("inWord", sbReportString);
CR_RepVoucher.SetParameterValue("copy", copy);
CrystalReportViewer1.ReportSource = CR_RepVoucher;
//string Path = Server.MapPath("Report/rptRepVoucherStatement.rpt");
//rdoc.Load(Path);
//rdoc.SetDataSource(dtReport);
//CrystalReportViewer1.ReportSource = rdoc;
//rdoc.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
//rdoc.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
//rdoc.SetParameterValue("branchCode", branchCode.ToString());
//rdoc.SetParameterValue("inWord", sbReportString);
//rdoc.SetParameterValue("copy", copy);
//rdoc = ReportFactory.GetReport(rdoc.GetType());
}
else
{
Response.Write("No data found");
}
}
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 dtReport = reportObj.getDtForReportStatement();
dtReport.TableName = "ReportStatement";
DataRow drReport;
DataTable dtReportStatement = (DataTable)Session["dtReportStatement"];
if (dtReportStatement.Rows.Count > 0)
{
int transferNo = 0;
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
drReport = dtReport.NewRow();
drReport["TR_NO"] = Convert.ToInt32(dtReportStatement.Rows[looper]["TR_NO"].ToString());
drReport["TR_DT"] = dtReportStatement.Rows[looper]["TR_DT"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TR_DT"].ToString();
drReport["OLD_SL_TR_NO"] = dtReportStatement.Rows[looper]["OLD_SL_TR_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["OLD_SL_TR_NO"].ToString();
drReport["HNAME"] = dtReportStatement.Rows[looper]["HNAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["HNAME"].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();
transferNo = Convert.ToInt32(dtReportStatement.Rows[looper]["TR_NO"].ToString());
if (!dtReportStatement.Rows[looper]["OLD_SL_TR_NO"].Equals(DBNull.Value))
{
drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM TRANS_CERT WHERE TR_NO=" + transferNo + " AND OLD_SL_TR_NO='" + dtReportStatement.Rows[looper]["OLD_SL_TR_NO"] + "' AND F_CD='" + fundCode.ToString() + "' AND BR_CODE='" + fundCode.ToString() + "_" + branchCode.ToString().ToUpper() + "'", fundCode.ToString()).ToString();
}
else
{
drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT NVL(CERT_TYPE,' ') AS CERT_TYPE, NVL(CERT_NO,0) AS CERT_NO FROM TRANS_CERT WHERE TR_NO=" + transferNo + " AND F_CD='" + fundCode.ToString() + "' AND BR_CODE='" + fundCode.ToString() + "_" + branchCode.ToString().ToUpper() + "'", fundCode.ToString()).ToString();
}
drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString());
drReport["TFEREE_NAME"] = dtReportStatement.Rows[looper]["TFEREE_NAME"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TFEREE_NAME"].ToString();
drReport["TFEREE_ADDRS1"] = dtReportStatement.Rows[looper]["TFEREE_ADDRS1"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TFEREE_ADDRS1"].ToString();
drReport["TFEREE_ADDRS2"] = dtReportStatement.Rows[looper]["TFEREE_ADDRS2"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TFEREE_ADDRS2"].ToString();
drReport["TFEREE_CITY"] = dtReportStatement.Rows[looper]["TFEREE_CITY"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TFEREE_CITY"].ToString();
drReport["TFEREE_REG_NO"] = dtReportStatement.Rows[looper]["TFEREE_REG_NO"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["TFEREE_REG_NO"].ToString();
drReport["CIP"] = dtReportStatement.Rows[looper]["CIP"].Equals(DBNull.Value) ? "" : dtReportStatement.Rows[looper]["CIP"].ToString();
dtReport.Rows.Add(drReport);
}
// dtReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OpenEndMF\UI\ReportViewer\Report\dtUnitReportForStatement.xsd");
string Path = Server.MapPath("Report/rptTransStatement.rpt");
rdoc.Load(Path);
rdoc.SetDataSource(dtReport);
CrystalReportViewer1.ReportSource = rdoc;
rdoc.SetParameterValue("fundName", opendMFDAO.GetFundName(fundCode.ToString()));
rdoc.SetParameterValue("branchName", opendMFDAO.GetBranchName(branchCode.ToString()).ToString());
rdoc.SetParameterValue("branchCode", branchCode.ToString());
}
else
{
Response.Write("No data found");
}
}
