protected void GetControlDetails(int scheme, string folio, String SchemeType) { DataSet ds = new DataSet(); double finalamt; double finalunits; ds = onlineMforderBo.GetControlDetails(scheme, folio, 1); DataTable dt = ds.Tables[0]; if (SchemeType == "SO") { if (dt.Rows.Count > -1) { foreach (DataRow dr in dt.Rows) { if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) { lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); } if (!string.IsNullOrEmpty(dr["MinAmt"].ToString())) { lblMintxt.Text = dr["MinAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["MultiAmt"].ToString())) { lblMulti.Text = dr["MultiAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) { lbltime.Text = dr["CutOffTime"].ToString(); } if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) { lbldftext.Text = dr["divFrequency"].ToString(); } if (!string.IsNullOrEmpty(dr["url"].ToString())) { lnkFactSheet.PostBackUrl = dr["url"].ToString(); } } DataSet dsNav = commonLookupBo.GetLatestNav(int.Parse(ddlScheme.SelectedValue)); if (dsNav.Tables[0].Rows.Count > 0) { string date = Convert.ToDateTime(dsNav.Tables[0].Rows[0][0]).ToString("dd-MMM-yyyy"); lblNavDisplay.Text = dsNav.Tables[0].Rows[0][1] + " " + "As On " + " " + date; } CalculateCurrentholding(ds, out finalunits, out finalamt, dsNav.Tables[0].Rows[0][1].ToString()); lblUnitsVale.Text = Math.Round(finalunits, 2).ToString(); lblAmtVale.Text = Math.Round(finalamt, 2).ToString(); txtAmtVale.Text = Math.Round(finalamt, 2).ToString(); lblFolioNo.Text = ddlFolio.SelectedItem.Text; } } else { if (dt.Rows.Count > -1) { foreach (DataRow dr in dt.Rows) { if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) { lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); } if (!string.IsNullOrEmpty(dr["MinAmt"].ToString())) { lblMinAmntVale.Text = dr["MinAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["MultiAmt"].ToString())) { lblSqnAmtVale.Text = dr["MultiAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) { lblCuffTimeVale.Text = dr["CutOffTime"].ToString(); } if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) { lbldftext.Text = dr["divFrequency"].ToString(); } if (!string.IsNullOrEmpty(dr["url"].ToString())) { lnkFactSheet.PostBackUrl = dr["url"].ToString(); } } DataSet dsNav = commonLookupBo.GetLatestNav(int.Parse(ddlScheme.SelectedValue)); if (dsNav.Tables[0].Rows.Count > 0) { string date = Convert.ToDateTime(dsNav.Tables[0].Rows[0][0]).ToString("dd-MMM-yyyy"); lblNavVale.Text = dsNav.Tables[0].Rows[0][1] + " " + "As On " + " " + date; } } } }
protected void GetControlDetails(int scheme, string folio) { DataSet ds = new DataSet(); double finalamt; double finalunits; ds = onlineMforderBo.GetControlDetails(scheme, folio, exchangeType == "Online" ? 1 : 0); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > -1) { foreach (DataRow dr in dt.Rows) { if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) { lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); } if (!string.IsNullOrEmpty(dr["PSLV_DividendType"].ToString())) { ddlDivType.SelectedValue = dr["PSLV_DividendType"].ToString(); } if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) { lbltime.Text = dr["CutOffTime"].ToString(); lbltime.Visible = true; } if (!string.IsNullOrEmpty(dr["RedeemMinAmt"].ToString())) { lblMinAmountValue.Text = dr["RedeemMinAmt"].ToString(); lblMinAmountValue.Visible = true; } if (!string.IsNullOrEmpty(dr["RedeemMinUnit"].ToString())) { lblMinUnitValue.Text = dr["RedeemMinUnit"].ToString(); lblMinUnitValue.Visible = true; } if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) { lbldftext.Text = dr["divFrequency"].ToString(); } if (!string.IsNullOrEmpty(dr["url"].ToString())) { lnkFactSheet.PostBackUrl = dr["url"].ToString(); } if (!string.IsNullOrEmpty(dr["PAISC_AssetInstrumentSubCategoryCode"].ToString()) && lblUnitsheldDisplay.Text != null) { subcategory = dr["PAISC_AssetInstrumentSubCategoryCode"].ToString(); } if (!string.IsNullOrEmpty(dr["AVSD_ExpiryDtae"].ToString()) && Convert.ToDateTime(dr["AVSD_ExpiryDtae"].ToString()) > DateTime.Now && Convert.ToInt16(dr["PMFRD_RatingOverall"].ToString()) > 0) { trSchemeRating.Visible = true; imgSchemeRating.ImageUrl = @"../Images/MorningStarRating/RatingSmallIcon/" + dr["PMFRD_RatingOverall"].ToString() + ".png"; //Rating Overall imgRatingDetails.ImageUrl = @"../Images/MorningStarRating/RatingOverall/" + dr["PMFRD_RatingOverall"].ToString() + ".png"; //Rating yearwise imgRating3yr.ImageUrl = @"../Images/MorningStarRating/RatingSmallIcon/" + dr["PMFRD_Rating3Year"].ToString() + ".png"; imgRating5yr.ImageUrl = @"../Images/MorningStarRating/RatingSmallIcon/" + dr["PMFRD_Rating5Year"].ToString() + ".png"; imgRating10yr.ImageUrl = @"../Images/MorningStarRating/RatingSmallIcon/" + dr["PMFRD_Rating10Year"].ToString() + ".png"; lblSchemeRetrun3yr.Text = dr["PMFRD_Return3Year"].ToString(); lblSchemeRetrun5yr.Text = dr["PMFRD_Return5Year"].ToString(); lblSchemeRetrun10yr.Text = dr["PMFRD_Return10Year"].ToString(); lblSchemeRisk3yr.Text = dr["PMFRD_Risk3Year"].ToString(); lblSchemeRisk5yr.Text = dr["PMFRD_Risk5Year"].ToString(); lblSchemeRisk10yr.Text = dr["PMFRD_Risk10Year"].ToString(); if (!string.IsNullOrEmpty(dr["PMFRD_RatingDate"].ToString())) { lblSchemeRatingAsOn.Text = "As On " + Convert.ToDateTime(dr["PMFRD_RatingDate"].ToString()).ToShortDateString(); lblRatingAsOnPopUp.Text = lblSchemeRatingAsOn.Text; } } else { trSchemeRating.Visible = false; lblSchemeRatingAsOn.Visible = false; imgSchemeRating.ImageUrl = @"../Images/MorningStarRating/RatingSmallIcon/0.png"; } } } if (exchangeType == "Demat") { ddlRedeem.Items[2].Enabled = false; } if (ds.Tables[4].Rows.Count > 0) { ViewState["BseCode"] = ds.Tables[4].Rows[0][0].ToString(); } DataSet dsNav = commonLookupBo.GetLatestNav(scheme); if (dsNav.Tables[0].Rows.Count > 0) { string date = Convert.ToDateTime(dsNav.Tables[0].Rows[0][0]).ToString("dd-MMM-yyyy"); lblNavDisplay.Text = dsNav.Tables[0].Rows[0][1] + " " + "As On " + " " + date; } CalculateCurrentholding(ds, out finalunits, out finalamt, dsNav.Tables[0].Rows.Count > 0 ? Convert.ToString(dsNav.Tables[0].Rows[0][1]) : "0"); lblUnitsheldDisplay.Text = Math.Round(finalunits, 2).ToString(); lblCurrentValueDisplay.Text = Math.Round(finalamt, 2).ToString(); if (subcategory == "MFEQTP") { ddlRedeem.Items[3].Enabled = false; } if ((double.Parse(lblUnitsheldDisplay.Text) <= 0) && (subcategory == "MFEQTP")) { SetControlsState(false); } else { SetControlsState(true); } }
//protected void GetControlDetails(int scheme, string folio) //{ // DataSet ds = new DataSet(); // ds = boOnlineOrder.GetControlDetails(scheme, ddlFolio.SelectedValue); // DataTable dt = ds.Tables[0]; // if (dt.Rows.Count > -1) // { // foreach (DataRow dr in dt.Rows) // { // if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); // if (!string.IsNullOrEmpty(dr["MinAmt"].ToString())) txtMinAmtDisplay.Text = dr["MinAmt"].ToString(); // if (!string.IsNullOrEmpty(dr["MultiAmt"].ToString())) lblMutiplesThereAfterDisplay.Text = dr["MultiAmt"].ToString(); // if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) lblCutOffTimeDisplay.Text = dr["CutOffTime"].ToString(); // //if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) lblFrequency.Text = dr["divFrequency"].ToString(); // } // } //} protected void GetControlDetails(int scheme, string folio) { DataSet ds = new DataSet(); double finalamt; double finalunits; ds = boOnlineOrder.GetControlDetails(scheme, folio, 1); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > -1) { foreach (DataRow dr in dt.Rows) { if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) { lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); } if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) { lbltime.Text = dr["CutOffTime"].ToString(); lbltime.Visible = true; } if (!string.IsNullOrEmpty(dr["RedeemMinAmt"].ToString())) { lblMinAmountValue.Text = dr["RedeemMinAmt"].ToString(); lblMinAmountValue.Visible = true; } if (!string.IsNullOrEmpty(dr["RedeemMinUnit"].ToString())) { lblMinUnitValue.Text = dr["RedeemMinUnit"].ToString(); lblMinUnitValue.Visible = true; } //if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) //{ // lbldftext.Text = dr["divFrequency"].ToString(); //} if (!string.IsNullOrEmpty(dr["url"].ToString())) { lnkFactSheet.PostBackUrl = dr["url"].ToString(); } if (!string.IsNullOrEmpty(dr["PAISC_AssetInstrumentSubCategoryCode"].ToString()) && lblUnitHeldDisplay.Text != null) { subcategory = dr["PAISC_AssetInstrumentSubCategoryCode"].ToString(); } } } DataSet dsNav = commonLookupBo.GetLatestNav(scheme); if (dsNav.Tables[0].Rows.Count > 0) { string date = Convert.ToDateTime(dsNav.Tables[0].Rows[0][0]).ToString("dd-MMM-yyyy"); lblNavDisplay.Text = dsNav.Tables[0].Rows[0][1] + " " + "As On " + " " + date; } CalculateCurrentholding(ds, out finalunits, out finalamt, dsNav.Tables[0].Rows[0][1].ToString()); lblUnitHeldDisplay.Text = Math.Round(finalunits, 2).ToString(); lblUnitHeldDisplay.Text = Math.Round(finalamt, 2).ToString(); if ((double.Parse(lblUnitHeldDisplay.Text) <= 0) && (subcategory == "MFEQTP")) { SetControlsState(false); } else { SetControlsState(true); } }
protected void Page_Load(object sender, EventArgs e) { path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); OnlineUserSessionBo.CheckSession(); customerVo = (CustomerVo)Session["customerVo"]; userVo = (UserVo)Session["userVo"]; Session["OrderId"] = OrderId; if (System.Web.HttpContext.Current.Session["BackOfficeUserId"] != null) { BackOfficeUserId = Convert.ToInt32(Session["BackOfficeUserId"]); } else { BackOfficeUserId = 0; } RadInformation.VisibleOnPageLoad = false; TimeSpan now = DateTime.Now.TimeOfDay; if (Session["ExchangeMode"] != null && Session["ExchangeMode"].ToString() == "Demat") { CommonLookupBo boCommon = new CommonLookupBo(); if (!boCommon.CheckForBusinessDate(DateTime.Now)) { ScriptManager.RegisterStartupScript(this, typeof(Page), "LoadBottomPanelFromBlocking", "LoadTransactPanel('MFOnlineSchemeManager');", true); return; } if (!(now >= TimeSpan.Parse(ConfigurationSettings.AppSettings["BSETradeOpTime"]) && now <= TimeSpan.Parse(ConfigurationSettings.AppSettings["BSETradeEnTime"]))) { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscriptvwewv", "LoadTransactPanel('MFOnlineSchemeManager')", true); return; } } int TOcpmaretime = int.Parse(DateTime.Now.ToShortTimeString().Split(':')[0]); if (TOcpmaretime >= int.Parse(ConfigurationSettings.AppSettings["START_TIME"]) && TOcpmaretime < int.Parse(ConfigurationSettings.AppSettings["END_TIME"])) { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscriptvwewv", "LoadTransactPanel('MFOnlineSchemeManager')", true); return; } if (Session["ExchangeMode"] != null) { exchangeType = Session["ExchangeMode"].ToString(); } else { exchangeType = "Online"; } if (!IsPostBack) { BindKYCDetailDDl(); clientMFAccessCode = onlineMforderBo.GetClientMFAccessStatus(customerVo.CustomerId); if (clientMFAccessCode == "FA") { ShowAvailableLimits(); lblOption.Visible = false; lblDividendType.Visible = false; if ((Request.QueryString["accountId"] != null && Request.QueryString["SchemeCode"] != null) || Session["MFSchemePlan"] != null) { int accountId = 0; int schemeCode = 0; int amcCode = 0; string category = string.Empty; if (Request.QueryString["accountId"] != null) { schemeCode = int.Parse(Session["MFSchemePlan"].ToString()); accountId = int.Parse(Request.QueryString["accountId"].ToString()); commonLookupBo.GetSchemeAMCSchemeCategory(int.Parse(Session["MFSchemePlan"].ToString()), out amcCode, out category, out categoryname, out amcName, out schemeName, out IsSIPAvaliable, out IspurchaseAvaliable, out IsRedeemAvaliable, exchangeType == "Online" ? 1 : 0); lblNavDisplay.Text = ""; lblMintxt.Text = ""; lblMulti.Text = ""; lbltime.Text = ""; lblSchemeRatingAsOn.Text = ""; if (IspurchaseAvaliable != 1) { ShowMessage("Purchase is not available", 'I'); return; } lblAmc.Text = amcName; lblCategory.Text = categoryname; lblScheme.Text = schemeName; BindFolioNumber(int.Parse(Session["MFSchemePlan"].ToString())); ddlFolio.SelectedValue = accountId.ToString(); tdFolio.Visible = true; DataSet ds = onlineMforderBo.GetCustomerSchemeFolioHoldings(customerVo.CustomerId, int.Parse(Session["MFSchemePlan"].ToString()), out schemeDividendOption, exchangeType == "Online" ? 1 : 0, accountId); GetControlDetails(ds); SetControlDetails(); } else { //if (exchangeType == "Online") // tdFolio.Visible = true; //else //{ DataSet ds; ds = onlineMforderBo.GetControlDetails(int.Parse(Session["MFSchemePlan"].ToString()), null, exchangeType == "Online" ? 1 : 0); lblUnitsheldDisplay.Visible = false; GetControlDetails(ds); //} scheme = int.Parse(Session["MFSchemePlan"].ToString()); lblNavDisplay.Text = ""; lblMintxt.Text = ""; lblMulti.Text = ""; lbltime.Text = ""; lblSchemeRatingAsOn.Text = ""; //commonLookupBo.GetSchemeAMCCategory(38122, out amcCode, out category); commonLookupBo.GetSchemeAMCSchemeCategory(int.Parse(Session["MFSchemePlan"].ToString()), out amcCode, out category, out categoryname, out amcName, out schemeName, out IsSIPAvaliable, out IspurchaseAvaliable, out IsRedeemAvaliable, exchangeType == "Online" ? 1 : 0); if (IspurchaseAvaliable != 1) { ShowMessage("Purchase is not available", 'I'); return; } BindFolioNumber(int.Parse(Session["MFSchemePlan"].ToString())); lblAmc.Text = amcName; lblScheme.Text = schemeName; lblCategory.Text = categoryname; DataSet dst = onlineMforderBo.GetControlDetails(int.Parse(Session["MFSchemePlan"].ToString()), null, exchangeType == "Online" ? 1 : 0); lblUnitsheldDisplay.Visible = false; GetControlDetails(dst); SetControlDetails(); } } } else { ShowMessage(onlineMforderBo.GetOnlineOrderUserMessage(clientMFAccessCode), 'I'); PurchaseOrderControlsEnable(false); divControlContainer.Visible = false; } } }
protected void GetControlDetails(int scheme, string folio) { DataSet ds = new DataSet(); DataTable dtSchemeAmcCategory; ds = onlineMforderBo.GetControlDetails(scheme, folio, 1); dtSchemeAmcCategory = commonLookupBo.GetMFSchemeAMCCategory(scheme); DataTable dt = ds.Tables[0]; if (dt.Rows.Count > -1) { foreach (DataRow dr in dt.Rows) { if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) { lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); } if (!string.IsNullOrEmpty(dr["MinAmt"].ToString())) { lblMintxt.Text = dr["MinAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["MultiAmt"].ToString())) { lblMulti.Text = dr["MultiAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) { lbltime.Text = dr["CutOffTime"].ToString(); } if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) { lbldftext.Text = dr["divFrequency"].ToString(); } if (!string.IsNullOrEmpty(dr["url"].ToString())) { lnkFactSheet.PostBackUrl = dr["url"].ToString(); } if (!string.IsNullOrEmpty(dr["PASP_NFOStartDate"].ToString())) { NFOStartDate.Text = Convert.ToDateTime(dr["PASP_NFOStartDate"].ToString()).ToShortDateString().ToString(); } if (!string.IsNullOrEmpty(dr["PASP_NFOEndDate"].ToString())) { NFOEndDate.Text = Convert.ToDateTime(dr["PASP_NFOEndDate"].ToString()).ToShortDateString().ToString(); } } //DataSet dsNav = commonLookupBo.GetLatestNav(int.Parse(ddlScheme.SelectedValue)); //if (dsNav.Tables[0].Rows.Count > 0) //{ // string date = Convert.ToDateTime(dsNav.Tables[0].Rows[0][0]).ToString("dd-MMM-yyyy"); // lblNavDisplay.Text = dsNav.Tables[0].Rows[0][1] + " " + "As On " + " " + date; //} } if (dtSchemeAmcCategory.Rows.Count > 0) { lblNFOSchemeAMC.Text = dtSchemeAmcCategory.Rows[0]["PA_AMCName"].ToString(); lblSchemeCategory.Text = dtSchemeAmcCategory.Rows[0]["PAIC_AssetInstrumentCategoryName"].ToString(); BindFolioNumber(Convert.ToInt32(dtSchemeAmcCategory.Rows[0]["PA_AMCCode"].ToString())); } }
protected void GetControlDetails(int scheme, string folio) { DataSet ds = new DataSet(); DataTable dtSchemeAmcCategory; ds = onlineMforderBo.GetControlDetails(scheme, folio, exchangeType == "Online" ? 1 : 0); dtSchemeAmcCategory = commonLookupBo.GetMFSchemeAMCCategory(scheme); if (ds.Tables[0].Rows.Count > 0 && !string.IsNullOrEmpty(ds.Tables[0].Rows[0]["PASP_Status"].ToString())) { if (ds.Tables[0].Rows[0]["PASP_Status"].ToString() != "NFO") { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Scheme Is not Available as NFO');", true); return; } } DataTable dt = ds.Tables[0]; if (dt.Rows.Count > -1) { foreach (DataRow dr in dt.Rows) { if (!string.IsNullOrEmpty(dr["PSLV_LookupValue"].ToString())) { lblDividendType.Text = dr["PSLV_LookupValue"].ToString(); } if (!string.IsNullOrEmpty(dr["MinAmt"].ToString())) { lblMintxt.Text = dr["MinAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["MultiAmt"].ToString())) { lblMulti.Text = dr["MultiAmt"].ToString(); } if (!string.IsNullOrEmpty(dr["CutOffTime"].ToString())) { lbltime.Text = dr["CutOffTime"].ToString(); } if (!string.IsNullOrEmpty(dr["divFrequency"].ToString())) { lbldftext.Text = dr["divFrequency"].ToString(); } if (!string.IsNullOrEmpty(dr["url"].ToString())) { lnkFactSheet.PostBackUrl = dr["url"].ToString(); } if (!string.IsNullOrEmpty(dr["PASP_NFOStartDate"].ToString())) { NFOStartDate.Text = Convert.ToDateTime(dr["PASP_NFOStartDate"].ToString()).ToShortDateString().ToString(); } if (!string.IsNullOrEmpty(dr["PASP_NFOEndDate"].ToString())) { NFOEndDate.Text = Convert.ToDateTime(dr["PASP_NFOEndDate"].ToString()).ToShortDateString().ToString(); } } } if (dtSchemeAmcCategory.Rows.Count > 0) { lblNFOSchemeAMC.Text = dtSchemeAmcCategory.Rows[0]["PA_AMCName"].ToString(); lblSchemeCategory.Text = dtSchemeAmcCategory.Rows[0]["PAIC_AssetInstrumentCategoryName"].ToString(); BindFolioNumber(Convert.ToInt32(dtSchemeAmcCategory.Rows[0]["PA_AMCCode"].ToString())); } if (ds.Tables[4].Rows.Count > 0) { lblDemate.Text = ds.Tables[4].Rows[0][0].ToString(); onlinemforderVo.BSESchemeCode = ds.Tables[4].Rows[0][0].ToString(); } }