protected void OnClick_Submit(object sender, EventArgs e) { MappingVo objVo = new MappingVo(); MappingBo objBo = new MappingBo(); string WERPCode = String.Empty; string Mode = Request.QueryString["Mode"]; if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("Equity")) { if (lblWERPCODE.Text != "") { objVo.WERPCOde = lblWERPCODE.Text; } else { objVo.WERPCOde = null; } objVo.Mode = lblWERPCODE.Text == String.Empty ? "New" : "Edit"; objVo.ScripName = txtScripName.Text; objVo.Ticker = txtTicker.Text; objVo.IncorporationDate = Convert.ToDateTime(txtIncdate.Text); objVo.PublishDate = Convert.ToDateTime(txtPublishDate.Text); objVo.MarketLot = Convert.ToInt32(txtMarketLot.Text); objVo.FaceValue = Convert.ToDecimal(txtFaceValue.Text); objVo.BookClosure = Convert.ToDateTime(txtBookClouser.Text); objVo.InstrumentCategory = ddlInstCategory.SelectedValue; objVo.SubCategory = ddlSubCategory.SelectedValue; // objVo.Sector =Convert.ToInt32(ddlSector.DataValueField); // objVo.MarketCap = Convert.ToInt32(ddlMarketCap.DataValueField); objVo.BSE = txtBSE.Text == "" ? null : txtBSE.Text; objVo.NSE = txtNSE.Text == "" ? null : txtNSE.Text; objVo.CERC = txtCERC.Text == "" ? null : txtCERC.Text; WERPCode = objBo.SubmitEquityMapping("Equity", objVo); lblWERPCODE.Text = WERPCode; } else if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("MF")) { if (lblSchMapWerpCode.Text != null) { objVo.MFWERPCode = lblSchMapWerpCode.Text; } else { objVo.MFWERPCode = null; } objVo.Mode = Mode; objVo.SchemePlanName = txtSchmPlnName.Text; objVo.MFInstrumentCategory = ddlSchmMapInstCat.SelectedValue; objVo.MFSubCategory = ddlSchmMapSubCat.SelectedValue; objVo.MFSubSubCategory = ddlSubSubCat.SelectedValue; // objVo.MFMarketCap = Convert.ToInt32(ddlSchmMapMrktCap.DataValueField); // objVo.MFSector = Convert.ToInt32(ddlSchmMapSector.DataValueField); objVo.AMFI = txtAMFI.Text; objVo.CAMS = txtCAMS.Text; objVo.Karvy = txtKarvy.Text; WERPCode = objBo.SubmitMFMapping("MF", objVo); lblSchMapWerpCode.Text = WERPCode; } }
protected void ddlSchmMapInstCat_SelectedIndexChanged(object sender, EventArgs e) { MappingBo obj = new MappingBo(); DataSet ds = new DataSet(); string instrumentgroup = ddlSchmMapInstCat.SelectedValue; if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"].ToString()) && Request.QueryString["AssetGroup"].Equals("MF")) { ds = obj.GetAssetInstrumentSubCategory("MF", instrumentgroup); ddlSchmMapSubCat.DataSource = ds.Tables[0]; ddlSchmMapSubCat.DataTextField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryName"].ToString(); ddlSchmMapSubCat.DataValueField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryCode"].ToString(); ddlSchmMapSubCat.DataBind(); } }
protected void OnSelectedIndexChanged_InstCategory(object sender, EventArgs e) { MappingBo obj = new MappingBo(); DataSet ds = new DataSet(); string instrumentgroup = ddlInstCategory.SelectedValue; if (ddlSubCategory.Items.Count > 0) { ddlSubCategory.Items.Clear(); } if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].ToString().Equals("Equity")) { ds = obj.GetAssetInstrumentSubCategory("DE", instrumentgroup); ddlSubCategory.DataSource = ds.Tables[0];; ddlSubCategory.DataTextField = "PAISC_AssetInstrumentSubCategoryName"; ddlSubCategory.DataValueField = "PAISC_AssetInstrumentSubCategoryCode"; ddlSubCategory.DataBind(); } }
protected void LoadData(string AssetGroup) { int WERPCODE; MappingVo objVo = new MappingVo(); MappingBo objBo = new MappingBo(); DataSet ds = new DataSet(); if (!String.IsNullOrEmpty(Request.QueryString["WERPCODE"]) & AssetGroup.Equals("Equity")) { WERPCODE = Convert.ToInt32(Request.QueryString["WERPCODE"]); objVo = objBo.GetProductEquityScripDetails(WERPCODE); lblWERPCODE.Text = WERPCODE.ToString(); txtScripName.Text = objVo.ScripName; txtTicker.Text = objVo.Ticker; txtIncdate.Text = objVo.IncorporationDate.ToString(); txtPublishDate.Text = objVo.PublishDate.ToString(); txtMarketLot.Text = objVo.MarketLot.ToString(); txtFaceValue.Text = objVo.FaceValue.ToString(); txtBookClouser.Text = objVo.BookClosure.ToString(); ddlInstCategory.SelectedValue = objVo.InstrumentCategory; txtBSE.Text = objVo.BSE; txtNSE.Text = objVo.NSE; txtCERC.Text = objVo.CERC; // ddlSector.SelectedValue = objVo.Sector.ToString(); // ddlMarketCap.SelectedValue = objVo.MarketCap.ToString(); ds = objBo.GetAssetInstrumentSubCategory("DE", objVo.InstrumentCategory); ddlSubCategory.DataSource = ds.Tables[0]; ddlSubCategory.DataTextField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryName"].ToString(); ddlSubCategory.DataValueField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryCode"].ToString(); ddlSubCategory.DataBind(); ddlSubCategory.SelectedValue = objVo.SubCategory; } else if (!String.IsNullOrEmpty(Request.QueryString["WERPCODE"]) & AssetGroup.Equals("MF")) { WERPCODE = Convert.ToInt32(Request.QueryString["WERPCODE"]); objVo = objBo.GetProductAMCSchemePlanDetails(WERPCODE); lblSchMapWerpCode.Text = WERPCODE.ToString(); txtSchmPlnName.Text = objVo.SchemePlanName; ddlSchmMapInstCat.SelectedValue = objVo.MFInstrumentCategory; // ddlSchmMapSector.SelectedValue = objVo.MFSector.ToString(); txtAMFI.Text = objVo.AMFI; txtCAMS.Text = objVo.CAMS; txtKarvy.Text = objVo.Karvy; ds = objBo.GetAssetInstrumentSubCategory(AssetGroup, objVo.MFInstrumentCategory); ddlSchmMapSubCat.DataSource = ds.Tables[0]; ddlSchmMapSubCat.DataTextField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryName"].ToString(); ddlSchmMapSubCat.DataValueField = ds.Tables[0].Columns["PAISC_AssetInstrumentSubCategoryCode"].ToString(); ddlSchmMapSubCat.DataBind(); ddlSchmMapSubCat.SelectedValue = objVo.MFSubCategory; ds.Clear(); ds = objBo.GetAssetInstrumentSubSubCategory(AssetGroup, objVo.MFInstrumentCategory, objVo.MFSubCategory); ddlSubSubCat.DataSource = ds.Tables[0]; ddlSubSubCat.DataTextField = ds.Tables[0].Columns["PAISSC_AssetInstrumentSubSubCategoryName"].ToString(); ddlSubSubCat.DataValueField = ds.Tables[0].Columns["PAISSC_AssetInstrumentSubSubCategoryCode"].ToString(); ddlSubSubCat.DataBind(); ddlSubSubCat.SelectedValue = objVo.MFSubSubCategory; } }
protected void Page_Load(object sender, EventArgs e) { SessionBo.CheckSession(); MappingBo obj = new MappingBo(); if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].ToString().Equals("Equity")) { DivScripMapping.Style.Add("display", "visible"); } else if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].ToString().Equals("MF")) { DivSchemeMapping.Style.Add("display", "visible"); } if (!IsPostBack) { DataSet ds = new DataSet(); this.ClearControl(); if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("Equity")) { ds = obj.GetInstrumentCategory("DE"); ddlInstCategory.DataSource = ds.Tables[0]; ddlInstCategory.DataTextField = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlInstCategory.DataValueField = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlInstCategory.DataBind(); ddlInstCategory.Items.Insert(0, "Select a InstrumentCategory"); ds.Clear(); ds = obj.GetProductMarketCapClassification(); ddlMarketCap.DataSource = ds.Tables[0]; ddlMarketCap.DataTextField = ds.Tables[0].Columns["PMCC_CapClassification"].ToString(); ddlMarketCap.DataValueField = ds.Tables[0].Columns["PMCC_MarketCapClassificationCode"].ToString(); ddlMarketCap.DataBind(); ddlMarketCap.Items.Insert(0, "Select a Market Cap"); ds.Clear(); } else if (!String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("MF")) { ds = obj.GetInstrumentCategory("MF"); ddlSchmMapInstCat.DataSource = ds; ddlSchmMapInstCat.DataTextField = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryName"].ToString(); ddlSchmMapInstCat.DataValueField = ds.Tables[0].Columns["PAIC_AssetInstrumentCategoryCode"].ToString(); ddlSchmMapInstCat.DataBind(); ddlSchmMapInstCat.Items.Insert(0, "Select a InstrumentCategory"); ds.Clear(); ds = obj.GetProductMarketCapClassification(); ddlSchmMapMrktCap.DataSource = ds; ddlSchmMapMrktCap.DataTextField = ds.Tables[0].Columns["PMCC_CapClassification"].ToString(); ddlSchmMapMrktCap.DataValueField = ds.Tables[0].Columns["PMCC_MarketCapClassificationCode"].ToString(); ddlSchmMapMrktCap.DataBind(); ddlSchmMapMrktCap.Items.Insert(0, "Select a Market Cap"); ds.Clear(); } if (!String.IsNullOrEmpty(Request.QueryString["From"]) && (Request.QueryString["From"].ToString()).Equals("Main") && !String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("Equity") && (Request.QueryString["Mode"].Equals("Edit") || Request.QueryString["Mode"].Equals("View")) ) { this.LoadData("Equity"); } if (!String.IsNullOrEmpty(Request.QueryString["From"]) && (Request.QueryString["From"].ToString()).Equals("Main") && !String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].ToString().Equals("MF") && (Request.QueryString["Mode"].Equals("Edit") || Request.QueryString["Mode"].Equals("View")) ) { this.LoadData("MF"); } } if (!String.IsNullOrEmpty(Request.QueryString["Mode"]) && Request.QueryString["Mode"].Equals("View")) { this.ReadOnly(true); btnSubmit.Visible = false; } if (!String.IsNullOrEmpty(Request.QueryString["From"]) && (Request.QueryString["From"].ToString()).Equals("R") && !String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("Equity") && !String.IsNullOrEmpty(Request.QueryString["RecordName"]) ) { txtScripName.Text = Request.QueryString["RecordName"]; } if (!String.IsNullOrEmpty(Request.QueryString["From"]) && (Request.QueryString["From"]).Equals("R") && !String.IsNullOrEmpty(Request.QueryString["AssetGroup"]) && Request.QueryString["AssetGroup"].Equals("MF") && !String.IsNullOrEmpty(Request.QueryString["RecordName"]) ) { txtSchmPlnName.Text = Request.QueryString["RecordName"]; } }