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();
}
}