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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
regNoTextBox.Focus();
//saleDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
// holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
if (!IsPostBack)
{
regObj.FundCode = fundCode.ToString();
regObj.BranchCode = branchCode.ToString();
// renewalNumberTextBox.Text = opendMFDAO.GetMaxSaleNo(regObj).ToString();
// renewalDateTextBox.Text = opendMFDAO.getLastSaleDate(regObj).ToString("dd-MMM-yyyy");
// totalUnitsTextBox.Text = opendMFDAO.getLastSaleRate(regObj).ToString();
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
regNoTextBox.Focus();
if (!IsPostBack)
{
fundCodeDDL.DataSource = reportObj.dtFundCodeList();
fundCodeDDL.DataTextField = "NAME";
fundCodeDDL.DataValueField = "ID";
fundCodeDDL.SelectedValue = fundCode.ToString();
fundCodeDDL.DataBind();
branchCodeDDL.DataSource = reportObj.dtBranchCodeList();
branchCodeDDL.DataTextField = "NAME";
branchCodeDDL.DataValueField = "ID";
branchCodeDDL.SelectedValue = branchCode.ToString();
branchCodeDDL.DataBind();
dateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
string fundCode = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
saleNumberTextBox.Focus();
//saleDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
// holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
if (!IsPostBack)
{
bankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=1 ");
bankNameDropDownList.DataTextField = "BANK_NAME";
bankNameDropDownList.DataValueField = "BANK_CODE";
bankNameDropDownList.DataBind();
CashAmountTextBox.Enabled = false;
MultiplePayTypeTextBox.Enabled = false;
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
tferorFundCodeTextBox.Text = fundCode.ToString();
tferorBranchCodeTextBox.Text = branchCode.ToString();
tfereeFundCodeTextBox.Text = fundCode.ToString();
tfereeBranhCodeTextBox.Text = branchCode.ToString();
if (!IsPostBack)
{
tferorRegNoTextBox.Focus();
transferDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
FundCodeTextBox.Text = fundCode.ToString();
BranchCodeTextBox.Text = branchCode.ToString();
RegNoTextBox.Focus();
if (!IsPostBack)
{
LienbankNameDropDownList.DataSource = opendMFDAO.dtFillBankName();
LienbankNameDropDownList.DataTextField = "BANK_NAME";
LienbankNameDropDownList.DataValueField = "BANK_CODE";
LienbankNameDropDownList.DataBind();
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
FundCodeTextBox.Text = fundCode.ToString();
BranchCodeTextBox.Text = branchCode.ToString();
if (!IsPostBack)
{
regObj.FundCode = fundCode.ToString();
regObj.BranchCode = branchCode.ToString();
moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'REP' AND SL_REP_TR_RN_NO IS NULL ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
string fundCode = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
if (!IsPostBack)
{
DataTable dtOccupationList = opendMFDAO.dtOccopationList();
nomiOccupationDropDownList.DataSource = dtOccupationList;
nomiOccupationDropDownList.DataTextField = "DESCR";
nomiOccupationDropDownList.DataValueField = "CODE";
nomiOccupationDropDownList.DataBind();
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
FundCodeTextBox.Text = fundCode.ToString();
BranchCodeTextBox.Text = branchCode.ToString();
RegNoTextBox.Focus();
if (!IsPostBack)
{
//UnitRepurchase unitRepObj = new UnitRepurchase();
//regObj.BranchCode = BranchCodeTextBox.Text.Trim().ToUpper().ToString();
//regObj.FundCode = FundCodeTextBox.Text.Trim().ToUpper().ToString();
//RepNoTextBox.Text = unitRepBLObj.getMaxRepurchaseNo(regObj).ToString();
//unitRepObj.RepurchaseNo = unitRepBLObj.getMaxRepurchaseNo(regObj) - 1;
//RepDateTextBox.Text = unitRepBLObj.getLastRepDate(regObj, unitRepObj).ToString("dd-MMM-yyyy");
//RepRateTextBox.Text = unitRepBLObj.getLastRepRate(regObj, unitRepObj).ToString();
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
// toRegDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
// fromRegDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy"); ;
///holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
if (!IsPostBack)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
fundCode = bcContent.FundCode.ToString();
branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
CDSStatus = bcContent.CDS.ToString().ToUpper();
if (!IsPostBack)
{
incomeTaxFYDropDownList.DataSource = reportObj.getDtFY(fundCode);
incomeTaxFYDropDownList.DataTextField = "F_YEAR";
incomeTaxFYDropDownList.DataValueField = "DIVI_NO";
incomeTaxFYDropDownList.DataBind();
fyPartDropDownList.DataSource = reportObj.getDtFYPart(fundCode);
fyPartDropDownList.DataTextField = "FY_PART";
fyPartDropDownList.DataValueField = "FY_PART";
fyPartDropDownList.DataBind();
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
Hashtable htPriceRefixation = new Hashtable();
try
{
commonGatewayObj.BeginTransaction();
htPriceRefixation.Add("FUND_CD", fundNameDropDownList.SelectedValue.ToString().ToUpper());
htPriceRefixation.Add("FUND_NM", opendMFDAO.GetFundName(fundNameDropDownList.SelectedValue.ToString()));
htPriceRefixation.Add("REFIX_DT", Convert.ToDateTime(PriceDateTextBox.Text.ToString()).ToString("dd-MMM-yyyy"));
htPriceRefixation.Add("REFIX_SL_PR", Convert.ToDecimal(SalePriceTextBox.Text.Trim().ToString()));
htPriceRefixation.Add("REFIX_REP_PR", Convert.ToDecimal(RepPriceTextBox.Text.Trim().ToString()));
htPriceRefixation.Add("USER_NM", userObj.UserID.ToString());
htPriceRefixation.Add("ENT_DT", DateTime.Today.ToString("dd-MMM-yyyy"));
htPriceRefixation.Add("ENT_TM", DateTime.Now.ToShortTimeString());
commonGatewayObj.Insert(htPriceRefixation, "PRICE_REFIX");
commonGatewayObj.CommitTransaction();
PriceDateTextBox.Text = "";
SalePriceTextBox.Text = "";
RepPriceTextBox.Text = "";
fundNameDropDownList.Focus();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert('" + msgObj.Success().ToString() + "');", true);
}
catch (Exception ex)
{
commonGatewayObj.RollbackTransaction();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Popup", "alert ('" + msgObj.Error().ToString() + " " + ex.Message.Replace("'", "").ToString() + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
DataTable dtReportStatement = (DataTable)Session["dtPriceInfo"];
string fundCode = (string)Session["fundCode"];
if (dtReportStatement.Rows.Count > 0)
{
// dtReportStatement.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtPriceRefixation.xsd");
CR_PRICE.Refresh();
CR_PRICE.SetDataSource(dtReportStatement);
CR_PRICE.SetParameterValue("fudnName", opendMFDAO.GetFundName(fundCode.ToString()));
CrystalReportViewer1.ReportSource = CR_PRICE;
}
else
{
Response.Write("No data found");
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
string fundCode = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
regNoTextBox.Focus();
//saleDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
// holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
if (!IsPostBack)
{
CashAmountTextBox.Enabled = false;
MultiplePayTypeTextBox.Enabled = false;
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
BOTextBox.Focus();
///holderDateofBirthTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
if (!IsPostBack)
{
DataTable dtOccupationList = opendMFDAO.dtOccopationList();
holderOccupationDropDownList.DataSource = dtOccupationList;
holderOccupationDropDownList.DataTextField = "DESCR";
holderOccupationDropDownList.DataValueField = "CODE";
holderOccupationDropDownList.DataBind();
//bankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=1 " );
//bankNameDropDownList.DataTextField = "BANK_NAME";
//bankNameDropDownList.DataValueField = "BANK_CODE";
//bankNameDropDownList.DataBind();
IDbankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=2 ");
IDbankNameDropDownList.DataTextField = "BANK_NAME";
IDbankNameDropDownList.DataValueField = "BANK_CODE";
IDbankNameDropDownList.DataBind();
regTypeDropDownList.DataSource = unitHolderRegBLObj.dtFillRegType();
regTypeDropDownList.DataTextField = "NAME";
regTypeDropDownList.DataValueField = "CODE";
regTypeDropDownList.DataBind();
regDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
string fundCode = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
fundCodeTextBox.Text = fundCode.ToString();
branchCodeTextBox.Text = branchCode.ToString();
if (!IsPostBack)
{
DataTable dtOccupationList = opendMFDAO.dtOccopationList();
OccupationDropDownList.DataSource = dtOccupationList;
OccupationDropDownList.DataTextField = "DESCR";
OccupationDropDownList.DataValueField = "CODE";
OccupationDropDownList.DataBind();
bankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE=1 ");
bankNameDropDownList.DataTextField = "BANK_NAME";
bankNameDropDownList.DataValueField = "BANK_CODE";
bankNameDropDownList.DataBind();
IDbankNameDropDownList.DataSource = opendMFDAO.dtFillBankName(" CATE_CODE IN (1,2,3) ");
IDbankNameDropDownList.DataTextField = "BANK_NAME";
IDbankNameDropDownList.DataValueField = "BANK_CODE";
IDbankNameDropDownList.DataBind();
regTypeDropDownList.DataSource = unitHolderRegBLObj.dtFillRegType();
regTypeDropDownList.DataTextField = "NAME";
regTypeDropDownList.DataValueField = "CODE";
regTypeDropDownList.DataBind();
regTypeDropDownList.SelectedValue = "N";
regObj.FundCode = fundCode.ToString();
regObj.BranchCode = branchCode.ToString();
regNoTextBox.Text = unitHolderRegBLObj.GetMaxRegNo(regObj).ToString();
regObj.RegNumber = (unitHolderRegBLObj.GetMaxRegNo(regObj) - 1).ToString();
regDateTextBox.Text = unitHolderRegBLObj.getLastRegDate(regObj).ToString("dd-MMM-yyyy");
regNoTextBox.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
string fundCode = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
if (!IsPostBack)
{
fundCodeDDL.DataSource = reportObj.dtFundCodeList();
fundCodeDDL.DataTextField = "NAME";
fundCodeDDL.DataValueField = "ID";
fundCodeDDL.SelectedValue = fundCode.ToString();
fundCodeDDL.DataBind();
FundCodeDDL_I.DataSource = reportObj.dtFundCodeList();
FundCodeDDL_I.DataTextField = "NAME";
FundCodeDDL_I.DataValueField = "ID";
FundCodeDDL_I.SelectedValue = fundCode.ToString();
FundCodeDDL_I.DataBind();
branchCodeDDL.DataSource = reportObj.dtBranchCodeList();
branchCodeDDL.DataTextField = "NAME";
branchCodeDDL.DataValueField = "ID";
branchCodeDDL.SelectedValue = branchCode.ToString();
branchCodeDDL.DataBind();
BranchCodeDDL_I.DataSource = reportObj.dtBranchCodeList();
BranchCodeDDL_I.DataTextField = "NAME";
BranchCodeDDL_I.DataValueField = "ID";
BranchCodeDDL_I.SelectedValue = branchCode.ToString();
BranchCodeDDL_I.DataBind();
regObj.FundCode = fundCode.ToString();
regObj.BranchCode = branchCode.ToString();
ReceiptDateTextBox.Text = DateTime.Today.ToString("dd-MMM-yyyy");
ReceiptNoTextBox.Text = unitSaleBLObj.GetMaxReceiptNo(regObj, "TR").ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
UnitHolderRegistration regObj = new UnitHolderRegistration();
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
fundCode = bcContent.FundCode.ToString();
branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
if (!IsPostBack)
{
fundCodeDDL.DataSource = reportObj.dtFundCodeList();
fundCodeDDL.DataTextField = "NAME";
fundCodeDDL.DataValueField = "ID";
fundCodeDDL.SelectedValue = fundCode.ToString();
fundCodeDDL.DataBind();
branchCodeDDL.DataSource = reportObj.dtBranchCodeList();
branchCodeDDL.DataTextField = "NAME";
branchCodeDDL.DataValueField = "ID";
branchCodeDDL.SelectedValue = branchCode.ToString();
branchCodeDDL.DataBind();
regObj.FundCode = fundCode.ToString();
regObj.BranchCode = branchCode.ToString();
moneyReceipDropDownList.DataSource = unitSaleBLObj.dtMoneyRecieptforDDL(" AND REG_BK = '" + regObj.FundCode.ToString().ToUpper() + "' AND REG_BR = '" + regObj.BranchCode.ToString().ToUpper() + "'AND RECEIPT_TYPE = 'SL' AND SL_REP_TR_RN_NO IS NULL AND ACC_VOUCHER_NO IS NULL ORDER BY RECEIPT_NO DESC ");
moneyReceipDropDownList.DataTextField = "RECEIPT_NO";
moneyReceipDropDownList.DataValueField = "ID";
moneyReceipDropDownList.DataBind();
agentNameDDL.DataSource = unitSaleBLObj.dtSellingAgentInfoforDDL();
agentNameDDL.DataTextField = "NAME";
agentNameDDL.DataValueField = "ID";
agentNameDDL.SelectedValue = "0";
agentNameDDL.DataBind();
agentNameDDL.Enabled = true;
sellingAgentCodeTextBox.Enabled = true;
}
}
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();
fundCode = bcContent.FundCode.ToString();
branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
if (!IsPostBack)
{
}
}
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)
{
if (BaseContent.IsSessionExpired())
{
Response.Redirect("../Default.aspx");
return;
}
bcContent = (BaseClass)Session["BCContent"];
userObj.UserID = bcContent.LoginID.ToString();
fundCode = bcContent.FundCode.ToString();
branchCode = bcContent.BranchCode.ToString();
spanFundName.InnerText = opendMFDAO.GetFundName(fundCode.ToString());
if (!IsPostBack)
{
DRRefNoDropDownList.DataSource = unitSaleBLObj.dtDRRefNoListForFolioTransfer("AND SALE.REG_BK='" + fundCode + "'");
DRRefNoDropDownList.DataTextField = "NAME";
DRRefNoDropDownList.DataValueField = "ID";
DRRefNoDropDownList.DataBind();
}
}
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 = bcContent.FundCode.ToString();
string branchCode = bcContent.BranchCode.ToString();
DataTable dtSaleCertPrintReport = (DataTable)Session["dtSaleCertPrintReport"];
string certType = (string)Session["certType"];
// string certificate = "";
string literature = "";
int lineNumber = (int)Session["lineNumber"];
try
{
if (dtSaleCertPrintReport.Rows.Count > 0)
{
dtSaleCertPrintReport.TableName = "dtSaleCertPrintReport";
// dtSaleCertPrintReport.WriteXmlSchema(@"F:\GITHUB_AMCL\DOTNET2015\AMCL.PORTAL\AMCL.REPORT\XMLSCHEMAS\dtSaleCertPrintReport.xsd");
if (certType.ToString() == "SALE" || certType.ToString() == "RENE")
{
if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE" && (fundCode.ToString().ToUpper() == "CFUF" || fundCode.ToString().ToUpper() == "IUF"))
{
//certificate = reportObj.getCIPCertificateForPrint(fundCode, branchCode,Convert.ToInt32(dtSaleCertPrintReport.Rows[0]["SL_NO"].ToString()));
literature = "This is to certify that the above mentioned person(s)/institution is/are the registerd holder(s) of ";
literature = literature + dtSaleCertPrintReport.Rows[0]["QTY"].ToString() + " ( " + NumToEngObj.changeNumericToWords(Convert.ToDecimal(dtSaleCertPrintReport.Rows[0]["QTY"].ToString())) + ")";
literature = literature + " Units of " + opendMFDAO.GetFundName(fundCode.ToString()) + " issued under the authority as provided in the Trust Deed of the " + opendMFDAO.GetFundName(fundCode.ToString()) + ".";
}
else if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE" && fundCode.ToString().ToUpper() == "IAMCL")
{
literature = " This is to certify that the above mentioned person(s)/institution is/are the registerd holder(s) of ";
literature = literature + dtSaleCertPrintReport.Rows[0]["QTY"].ToString() + " (" + NumToEngObj.changeNumericToWords(Convert.ToDecimal(dtSaleCertPrintReport.Rows[0]["QTY"].ToString())) + ") ";
literature = literature + " Units of " + opendMFDAO.GetFundName(fundCode.ToString()) + " 100.00 each issued under the authority as provided in the Trust Deed of the " + opendMFDAO.GetFundName(fundCode.ToString()) + ".";
}
if (fundCode.ToString().ToUpper() == "BDF")
{
CR_BSaleCertPrint.Refresh();
CR_BSaleCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_BSaleCertPrint;
}
else if (fundCode.ToString().ToUpper() == "CFUF")
{
if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE")
{
CR_CFUFCIPCertPrint.Refresh();
CR_CFUFCIPCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_CFUFCIPCertPrint;
CR_CFUFCIPCertPrint.SetParameterValue("literature", literature);
}
else
{
CR_CFUFSaleCertPrint.Refresh();
CR_CFUFSaleCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_CFUFSaleCertPrint;
}
}
else if (fundCode.ToString().ToUpper() == "IUF")
{
if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE")
{
CR_IUFCIPCertPrint.Refresh();
CR_IUFCIPCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_IUFCIPCertPrint;
CR_IUFCIPCertPrint.SetParameterValue("literature", literature);
}
else
{
CR_CFUFSaleCertPrint.Refresh();
CR_CFUFSaleCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_CFUFSaleCertPrint;
}
}
else if (fundCode.ToString().ToUpper() == "IAMCL")
{
if (dtSaleCertPrintReport.Rows[0]["SL_TYPE"].ToString().ToUpper() == "CIP" && certType.ToString() == "SALE")
{
CR_UnitCIPScriptPrint.Refresh();
CR_UnitCIPScriptPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_UnitCIPScriptPrint;
CR_UnitCIPScriptPrint.SetParameterValue("literature", literature);
}
else
{
CR_SaleCertPrint.Refresh();
CR_SaleCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_SaleCertPrint;
}
}
else
{
CR_SaleCertPrint.Refresh();
CR_SaleCertPrint.SetDataSource(dtSaleCertPrintReport);
CrystalReportViewer1.ReportSource = CR_SaleCertPrint;
}
}
else if (certType.ToString() == "TRAN")
{
string date1 = "";
string date2 = "";
string date3 = "";
string date4 = "";
string date5 = "";
string date6 = "";
string date7 = "";
string transNumber1 = "";
string transNumber2 = "";
string transNumber3 = "";
string transNumber4 = "";
string transNumber5 = "";
string transNumber6 = "";
string transNumber7 = "";
string tfereeRegNo1 = "";
string tfereeRegNo2 = "";
string tfereeRegNo3 = "";
string tfereeRegNo4 = "";
string tfereeRegNo5 = "";
string tfereeRegNo6 = "";
string tfereeRegNo7 = "";
string tfereeName1 = "";
string tfereeName2 = "";
string tfereeName3 = "";
string tfereeName4 = "";
string tfereeName5 = "";
string tfereeName6 = "";
string tfereeName7 = "";
string tfreeJHolderName1 = "";
string tfreeJHolderName2 = "";
string tfreeJHolderName3 = "";
string tfreeJHolderName4 = "";
string tfreeJHolderName5 = "";
string tfreeJHolderName6 = "";
string tfreeJHolderName7 = "";
string tfreeAddress1 = "";
string tfreeAddress2 = "";
string tfreeAddress3 = "";
string tfreeAddress4 = "";
string tfreeAddress5 = "";
string tfreeAddress6 = "";
string tfreeAddress7 = "";
string tferorRegNo1 = "";
string tferorRegNo2 = "";
string tferorRegNo3 = "";
string tferorRegNo4 = "";
string tferorRegNo5 = "";
string tferorRegNo6 = "";
string tferorRegNo7 = "";
if (lineNumber == 1)
{
date1 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber1 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo1 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName1 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName1 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress1 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo1 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
else if (lineNumber == 2)
{
date2 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber2 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo2 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName2 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName2 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress2 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo2 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
else if (lineNumber == 3)
{
date3 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber3 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo3 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName3 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName3 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress3 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo3 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
else if (lineNumber == 4)
{
date4 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber4 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo4 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName4 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName4 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress4 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo4 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
else if (lineNumber == 5)
{
date5 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber5 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo5 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName5 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName5 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress5 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo5 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
else if (lineNumber == 6)
{
date6 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber6 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo6 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName6 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName6 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress6 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo6 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
else if (lineNumber == 7)
{
date7 = dtSaleCertPrintReport.Rows[0]["TR_DT"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_DT"].ToString();
transNumber7 = dtSaleCertPrintReport.Rows[0]["TR_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TR_NO"].ToString();
tfereeRegNo7 = dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFREE_REG_NO"].ToString();
tfereeName7 = dtSaleCertPrintReport.Rows[0]["HNAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["HNAME"].ToString();
tfreeJHolderName7 = dtSaleCertPrintReport.Rows[0]["JNT_NAME"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["JNT_NAME"].ToString();
tfreeAddress7 = dtSaleCertPrintReport.Rows[0]["ADDRESS"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["ADDRESS"].ToString();
tferorRegNo7 = dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].Equals(DBNull.Value) ? "" : dtSaleCertPrintReport.Rows[0]["TFEROR_REG_NO"].ToString();
}
// dtSaleCertPrintReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\dtTransCertPrintReport.xsd");
//CR_Dividend.SetDataSource(dtReport);
if (fundCode.ToString().ToUpper() == "BDF")
{
//CR_BTransCertPrint.Refresh();
//CR_BTransCertPrint.SetParameterValue("date1", date1);
//CR_BTransCertPrint.SetParameterValue("transNumber1", transNumber1);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo1", tfereeRegNo1);
//CR_BTransCertPrint.SetParameterValue("tfereeName1", tfereeName1);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName1", tfreeJHolderName1);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress1", tfreeAddress1);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo1", tferorRegNo1);
//CR_BTransCertPrint.SetParameterValue("date2", date2);
//CR_BTransCertPrint.SetParameterValue("transNumber2", transNumber2);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo2", tfereeRegNo2);
//CR_BTransCertPrint.SetParameterValue("tfereeName2", tfereeName2);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName2", tfreeJHolderName2);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress2", tfreeAddress2);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo2", tferorRegNo2);
//CR_BTransCertPrint.SetParameterValue("date3", date3);
//CR_BTransCertPrint.SetParameterValue("transNumber3", transNumber3);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo3", tfereeRegNo3);
//CR_BTransCertPrint.SetParameterValue("tfereeName3", tfereeName3);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName3", tfreeJHolderName3);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress3", tfreeAddress3);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo3", tferorRegNo3);
//CR_BTransCertPrint.SetParameterValue("date4", date4);
//CR_BTransCertPrint.SetParameterValue("transNumber4", transNumber4);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo4", tfereeRegNo4);
//CR_BTransCertPrint.SetParameterValue("tfereeName4", tfereeName4);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName4", tfreeJHolderName4);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress4", tfreeAddress4);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo4", tferorRegNo4);
//CR_BTransCertPrint.SetParameterValue("date5", date5);
//CR_BTransCertPrint.SetParameterValue("transNumber5", transNumber5);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo5", tfereeRegNo5);
//CR_BTransCertPrint.SetParameterValue("tfereeName5", tfereeName5);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName5", tfreeJHolderName5);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress5", tfreeAddress5);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo5", tferorRegNo5);
//CR_BTransCertPrint.SetParameterValue("date6", date6);
//CR_BTransCertPrint.SetParameterValue("transNumber6", transNumber6);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo6", tfereeRegNo6);
//CR_BTransCertPrint.SetParameterValue("tfereeName6", tfereeName6);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName6", tfreeJHolderName6);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress6", tfreeAddress6);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo6", tferorRegNo6);
//CR_BTransCertPrint.SetParameterValue("date7", date7);
//CR_BTransCertPrint.SetParameterValue("transNumber7", transNumber7);
//CR_BTransCertPrint.SetParameterValue("tfereeRegNo7", tfereeRegNo7);
//CR_BTransCertPrint.SetParameterValue("tfereeName7", tfereeName7);
//CR_BTransCertPrint.SetParameterValue("tfreeJHolderName7", tfreeJHolderName7);
//CR_BTransCertPrint.SetParameterValue("tfreeAddress7", tfreeAddress7);
//CR_BTransCertPrint.SetParameterValue("tferorRegNo7", tferorRegNo7);
CrystalReportViewer1.ReportSource = CR_BTransCertPrint;
}
else
{
//CR_TransCertPrint.SetDatabaseLogon("UNIT", "UNIT","194.25.1.200","AMCL");
//CR_TransCertPrint.VerifyDatabase();
//CR_TransCertPrint.Refresh();
//CR_TransCertPrint.SetParameterValue("date1", date1);
//CR_TransCertPrint.SetParameterValue("transNumber1", transNumber1);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo1", tfereeRegNo1);
//CR_TransCertPrint.SetParameterValue("tfereeName1", tfereeName1);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName1", tfreeJHolderName1);
//CR_TransCertPrint.SetParameterValue("tfreeAddress1", tfreeAddress1);
//CR_TransCertPrint.SetParameterValue("tferorRegNo1", tferorRegNo1);
//CR_TransCertPrint.SetParameterValue("date2", date2);
//CR_TransCertPrint.SetParameterValue("transNumber2", transNumber2);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo2", tfereeRegNo2);
//CR_TransCertPrint.SetParameterValue("tfereeName2", tfereeName2);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName2", tfreeJHolderName2);
//CR_TransCertPrint.SetParameterValue("tfreeAddress2", tfreeAddress2);
//CR_TransCertPrint.SetParameterValue("tferorRegNo2", tferorRegNo2);
//CR_TransCertPrint.SetParameterValue("date3", date3);
//CR_TransCertPrint.SetParameterValue("transNumber3", transNumber3);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo3", tfereeRegNo3);
//CR_TransCertPrint.SetParameterValue("tfereeName3", tfereeName3);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName3", tfreeJHolderName3);
//CR_TransCertPrint.SetParameterValue("tfreeAddress3", tfreeAddress3);
//CR_TransCertPrint.SetParameterValue("tferorRegNo3", tferorRegNo3);
//CR_TransCertPrint.SetParameterValue("date4", date4);
//CR_TransCertPrint.SetParameterValue("transNumber4", transNumber4);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo4", tfereeRegNo4);
//CR_TransCertPrint.SetParameterValue("tfereeName4", tfereeName4);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName4", tfreeJHolderName4);
//CR_TransCertPrint.SetParameterValue("tfreeAddress4", tfreeAddress4);
//CR_TransCertPrint.SetParameterValue("tferorRegNo4", tferorRegNo4);
//CR_TransCertPrint.SetParameterValue("date5", date5);
//CR_TransCertPrint.SetParameterValue("transNumber5", transNumber5);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo5", tfereeRegNo5);
//CR_TransCertPrint.SetParameterValue("tfereeName5", tfereeName5);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName5", tfreeJHolderName5);
//CR_TransCertPrint.SetParameterValue("tfreeAddress5", tfreeAddress5);
//CR_TransCertPrint.SetParameterValue("tferorRegNo5", tferorRegNo5);
//CR_TransCertPrint.SetParameterValue("date6", date6);
//CR_TransCertPrint.SetParameterValue("transNumber6", transNumber6);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo6", tfereeRegNo6);
//CR_TransCertPrint.SetParameterValue("tfereeName6", tfereeName6);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName6", tfreeJHolderName6);
//CR_TransCertPrint.SetParameterValue("tfreeAddress6", tfreeAddress6);
//CR_TransCertPrint.SetParameterValue("tferorRegNo6", tferorRegNo6);
//CR_TransCertPrint.SetParameterValue("date7", date7);
//CR_TransCertPrint.SetParameterValue("transNumber7", transNumber7);
//CR_TransCertPrint.SetParameterValue("tfereeRegNo7", tfereeRegNo7);
//CR_TransCertPrint.SetParameterValue("tfereeName7", tfereeName7);
//CR_TransCertPrint.SetParameterValue("tfreeJHolderName7", tfreeJHolderName7);
//CR_TransCertPrint.SetParameterValue("tfreeAddress7", tfreeAddress7);
//CR_TransCertPrint.SetParameterValue("tferorRegNo7", tferorRegNo7);
CrystalReportViewer1.ReportSource = CR_TransCertPrint;
}
}
}
else
{
Response.Write("No data found");
}
}
catch (Exception ex)
{
Response.Write("Error: " + ex.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();
branchCode = (string)Session["branchCode"];
fundCode = (string)Session["fundCode"];
int lienNo = (int)Session["lienNo"];
int regNo = (int)Session["regNo"];
DateTime lienReqDate = Convert.ToDateTime((string)Session["lienReqDate"]);
string lienReqRef = (string)Session["lienReqRef"];
string lienInstitution = (string)Session["lienInstitution"];
string lienInstitutionBranch = (string)Session["lienInstitutionBranch"];
string holderName = (string)Session["holderName"];
string jHolderName = (string)Session["jHolderName"];
string toName = (string)Session["toName"];
string division = (string)Session["division"];
string address1 = (string)Session["address1"];
string address2 = (string)Session["address2"];
string address3 = (string)Session["address3"];
string signatory = (string)Session["signatory"];
string designation = (string)Session["designation"];
DataTable dtReport = new DataTable();
dtReport.Columns.Add("SL_TR_NO", typeof(string));
dtReport.Columns.Add("CERT_NO", typeof(string));
dtReport.Columns.Add("QTY", typeof(int));
dtReport.TableName = "ReportLienLetter";
DataRow drReport;
DataTable dtReportStatement = commonGatewayObj.Select("SELECT SL_TR_NO,QTY FROM LIEN_MARK WHERE VALID IS NULL AND LIEN_NO=" + lienNo + " AND REG_BR='" + branchCode.ToString() + "' AND REG_BK='" + fundCode.ToString() + "' AND REG_NO=" + regNo);
if (dtReportStatement.Rows.Count > 0)
{
string saleNo = "";
int totalUnits = 0;
for (int looper = 0; looper < dtReportStatement.Rows.Count; looper++)
{
drReport = dtReport.NewRow();
drReport["SL_TR_NO"] = dtReportStatement.Rows[looper]["SL_TR_NO"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["SL_TR_NO"].ToString();
saleNo = dtReportStatement.Rows[looper]["SL_TR_NO"].ToString();
drReport["CERT_NO"] = reportObj.getTotalCertNo("SELECT CERTIFICATE FROM LIEN_MARK_CERT_NO WHERE SL_TR_NO='" + saleNo + "' AND REG_BK='" + fundCode.ToString() + "'AND REG_BR='" + branchCode.ToString() + "' AND REG_NO=" + regNo + " AND LIEN_NO=" + lienNo, fundCode.ToString()).ToString();
drReport["QTY"] = Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0": dtReportStatement.Rows[looper]["QTY"].ToString());
dtReport.Rows.Add(drReport);
totalUnits = totalUnits + Convert.ToInt32(dtReportStatement.Rows[looper]["QTY"].Equals(DBNull.Value) ? "0" : dtReportStatement.Rows[looper]["QTY"].ToString());
}
// dtReport.WriteXmlSchema(@"D:\Project\Web\AMCL.OPENMF\AMCL.REPORT\XMLSCHEMAS\ReportLienLetter.xsd");
CR_Lien.Refresh();
CR_Lien.SetDataSource(dtReport);
CR_Lien.SetParameterValue("fudnName", opendMFDAO.GetFundName(fundCode.ToString()));
CR_Lien.SetParameterValue("lienNo", lienNo);
CR_Lien.SetParameterValue("regNo", regNo);
CR_Lien.SetParameterValue("lienReqDate", lienReqDate);
CR_Lien.SetParameterValue("lienReqRef", lienReqRef);
CR_Lien.SetParameterValue("lienInstitution", lienInstitution);
CR_Lien.SetParameterValue("lienInstitutionBranch", lienInstitutionBranch);
CR_Lien.SetParameterValue("holderName", holderName);
CR_Lien.SetParameterValue("jHolderName", jHolderName);
CR_Lien.SetParameterValue("toName", toName);
CR_Lien.SetParameterValue("division", division);
CR_Lien.SetParameterValue("address1", address1);
CR_Lien.SetParameterValue("address2", address2);
CR_Lien.SetParameterValue("address3", address3);
CR_Lien.SetParameterValue("signatory", signatory);
CR_Lien.SetParameterValue("designation", designation);
CR_Lien.SetParameterValue("fundCode", fundCode);
CR_Lien.SetParameterValue("branchCode", branchCode);
CR_Lien.SetParameterValue("totalUnits", totalUnits);
CrystalReportViewer1.ReportSource = CR_Lien;
}
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);
}
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)
{
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 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)
{
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");
}
}
