protected void Page_Load(object sender, EventArgs e) { advisorVo = (AdvisorVo)Session["advisorVo"]; rmVo = (RMVo)Session[SessionContents.RmVo]; userVo = (UserVo)Session["userVo"]; AdvisorMISBo adviserMISBo = new AdvisorMISBo(); if (Session[SessionContents.ValuationDate] == null) GetLatestValuationDate(); genDict = (Dictionary<string, DateTime>)Session[SessionContents.ValuationDate]; strValuationDate = genDict[Constants.EQDate.ToString()].ToShortDateString(); lblPickDate.Text = DateTime.Parse(genDict[Constants.EQDate.ToString()].ToString()).ToShortDateString(); if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops") userType = "advisor"; else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm") userType = "rm"; else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm") userType = "bm"; else userType = Session[SessionContents.CurrentUserRole].ToString().ToLower(); advisorId = advisorVo.advisorId; int RMId = rmVo.RMId; rmId = rmVo.RMId; bmID = rmVo.RMId; //if (!IsPostBack) //{ // SetParameters(); // BindEQReturnsGrid(); //} pnlEqHoldings.Visible = false; pnlEQReturns.Visible = false; gvEqHldings.Visible = false; gvEQReturns.Visible = false; imgCompany.Visible = false; imgEQReturns.Visible = false; }
private void bindgrid(DateTime Valuationdate, int schemeplanid) { AdvisorMISBo adviserMISBo = new AdvisorMISBo(); DataSet dsMISReport = null; double totalAum = 0; double totalUnits = 0; int CurrentPage; int.TryParse(ddlBranch.SelectedValue, out branchId); int.TryParse(ddlRM.SelectedValue, out rmId); if (hdnCurrentPage.Value == string.Empty || hdnCurrentPage.Value == "") { CurrentPage = 1; } else { CurrentPage = int.Parse(hdnCurrentPage.Value); } //For paging //if (hdnCurrentPage.Value.ToString() != "") //{ // mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString()); // hdnCurrentPage.Value = ""; //} /* * if(userType == "rm") * { * if (AllPageExport == true) * { * dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); * * } * else * { * dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0); * } * } * * else if (userType == "bm") * { * if (AllPageExport == true) * { * dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), hdnAMCSearchVal.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); * } * else * { * dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), hdnAMCSearchVal.Value.ToString(), out Count, 0); * } * } * else if (userType == "advisor") * { * if (AllPageExport == true) * { * dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); * * } * else * { * dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0); * } * * } * * */ if (userType == "rm") { if (AllPageExport == true) { dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForRM(rmid, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); } else { dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForRM(rmid, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, 0); } } else if (userType == "bm") { if (AllPageExport == true) { dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), 0, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), string.Empty, out Count, int.Parse(hdnRecordCount.Value.ToString())); } else { dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), DateTime.Parse(hdnValuationDate.Value.ToString()), 0, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), string.Empty, out Count, 0); } } else if (userType == "adviser") { if (AllPageExport == true) { dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); } else { dsMISReport = adviserMISBo.GetCustomerAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuationdate, schemeplanid, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCustomerNameVal.Value.ToString(), hdnFolioNumVal.Value.ToString(), out Count, 0); } } if (dsMISReport.Tables[0].Rows.Count == 0) { trMessage.Visible = true; gvMFMIS.DataSource = dsMISReport; gvMFMIS.DataBind(); } else { double no_of_units = 0; double aum = 0; //for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++) //{ // dsMISReport.Tables[0].Rows[i]["MarketPrice"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["MarketPrice"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); // dsMISReport.Tables[0].Rows[i]["AUM"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); // dsMISReport.Tables[0].Rows[i]["Percentage"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //} foreach (DataRow dr in dsMISReport.Tables[0].Rows) { no_of_units = Convert.ToDouble(dr["Units"].ToString()); aum = Convert.ToDouble(dr["AUM"].ToString()); totalUnits = totalUnits + no_of_units; totalAum = totalAum + aum; } DataTable dtMISReport = new DataTable(); dtMISReport.Columns.Add("CustomerName"); dtMISReport.Columns.Add("FolioNum"); dtMISReport.Columns.Add("AMC"); dtMISReport.Columns.Add("Scheme"); dtMISReport.Columns.Add("Category"); dtMISReport.Columns.Add("MarketPrice"); dtMISReport.Columns.Add("Units"); dtMISReport.Columns.Add("AUM"); dtMISReport.Columns.Add("Percentage"); DataRow drMISReport; for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++) { drMISReport = dtMISReport.NewRow(); drMISReport[0] = dsMISReport.Tables[0].Rows[i][1].ToString(); drMISReport[1] = dsMISReport.Tables[0].Rows[i][2].ToString(); drMISReport[2] = dsMISReport.Tables[0].Rows[i][4].ToString(); drMISReport[3] = dsMISReport.Tables[0].Rows[i][5].ToString(); drMISReport[4] = dsMISReport.Tables[0].Rows[i][6].ToString(); drMISReport[5] = dsMISReport.Tables[0].Rows[i][9].ToString(); if (GridViewCultureFlag == true) { decimal temp = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][8].ToString()), 4); drMISReport[6] = temp.ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); decimal tempAum = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2); drMISReport[7] = tempAum.ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } else { drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][8].ToString()), 4).ToString(); decimal tempAum = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2); drMISReport[7] = tempAum.ToString(); //drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString(); } drMISReport[8] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][10].ToString()), 2).ToString(); dtMISReport.Rows.Add(drMISReport); } gvMFMIS.DataSource = dtMISReport; gvMFMIS.DataBind(); if (GridViewCultureFlag == true) { gvMFMIS.FooterRow.Cells[8].Text = System.Math.Round(decimal.Parse(totalAum.ToString()), 2).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); gvMFMIS.FooterRow.Cells[7].Text = totalUnits.ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } else { decimal tempTotalAum = System.Math.Round(decimal.Parse(totalAum.ToString()), 2); gvMFMIS.FooterRow.Cells[8].Text = tempTotalAum.ToString(); gvMFMIS.FooterRow.Cells[7].Text = totalUnits.ToString(); } } lblTotalRows.Text = hdnRecordCount.Value = Count.ToString(); if (Count > 0) { DivPager.Style.Add("display", "visible"); } else { DivPager.Style.Add("display", "none"); lblCurrentPage.Text = ""; lblCurrentPage.Text = ""; } ViewState["schemeplanid"] = schemeplanid.ToString(); ViewState["Valuationdate"] = Valuationdate.ToString(); TextBox txtamc = new TextBox(); TextBox txtscheme = new TextBox(); TextBox txtCustomer = new TextBox(); TextBox txtFolio = new TextBox(); if (gvMFMIS.HeaderRow != null) { txtamc = (TextBox)gvMFMIS.HeaderRow.FindControl("txtAMCSearch"); txtscheme = (TextBox)gvMFMIS.HeaderRow.FindControl("txtSchemeSearch"); txtCustomer = (TextBox)gvMFMIS.HeaderRow.FindControl("txtCustomerSearch"); txtFolio = (TextBox)gvMFMIS.HeaderRow.FindControl("txtFolioSearch"); } txtamc.Text = hdnAMCSearchVal.Value.ToString(); txtscheme.Text = hdnSchemeSearchVal.Value.ToString(); txtCustomer.Text = hdnCustomerNameVal.Value.ToString(); txtFolio.Text = hdnFolioNumVal.Value.ToString(); this.GetPageCount(); }
//protected void gvMFMIS_RowDataBound(object sender, GridViewRowEventArgs e) //{ // if (e.Row.RowType == DataControlRowType.Footer) // { // e.Row.Cells[5].Text = "Total "; // if (GridViewCultureFlag == true) // e.Row.Cells[7].Text = decimal.Parse(totalAmount.ToString()).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); // else // { // e.Row.Cells[7].Text = decimal.Parse(totalAmount.ToString()).ToString(); // } // e.Row.Cells[7].Attributes.Add("align", "Right"); // if (GridViewCultureFlag == true) // e.Row.Cells[6].Text = decimal.Parse(totalUnits.ToString()).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); // else // { // e.Row.Cells[6].Text = decimal.Parse(totalUnits.ToString()).ToString(); // } // e.Row.Cells[6].Attributes.Add("align", "Right"); // amcCode // //if (e.Row.RowType == DataControlRowType.Header) // //{ // // DropDownList ddlStatus = (DropDownList)e.Row.FindControl("ddlCategory"); // // if (hdnCategoryFilter.Value!=null) // // ddlStatus.SelectedValue = hdnCategoryFilter.Value; // //} //} private void bindgrid(DateTime Valuationdate, int amcCode) { AdvisorMISBo adviserMISBo = new AdvisorMISBo(); DataSet dsMISReport = null; //double totalAum = 0; //double totalUnits = 0; int CurrentPage; int rmId, branchId; int.TryParse(ddlBranch.SelectedValue, out branchId); int.TryParse(ddlRM.SelectedValue, out rmId); // DateTime Valuation_Date = Convert.ToDateTime(txtDate.Text); DateTime Valuation_Date = Valuationdate; if (hdnCurrentPage.Value == string.Empty || hdnCurrentPage.Value == "") { CurrentPage = 1; } else { CurrentPage = int.Parse(hdnCurrentPage.Value); } if ((Session["BranchFilterForAMC"] != null) || (Session["RMFilterForAMC"] != null)) { if (Session["PassAMCCode"] != null) { amcCode = int.Parse(Session["PassAMCCode"].ToString()); } else { amcCode = 0; } } if (userType == "rm") { if (AllPageExport == true) { dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); } else { dsMISReport = adviserMISBo.GetAMCSchemewiseMISForRM(rmid, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0); } } else if (userType == "bm") { if (AllPageExport == true) { dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), Valuation_Date, amcCode, 0, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), string.Empty, string.Empty, hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); } else { dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), Valuation_Date, amcCode, 0, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), string.Empty, string.Empty, hdnCategoryFilter.Value.ToString(), out Count, 0); } } else if (userType == "adviser") { if (AllPageExport == true) { dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, int.Parse(hdnRecordCount.Value.ToString())); } else { dsMISReport = adviserMISBo.GetAMCSchemewiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, amcCode, CurrentPage, hdnAMCSearchVal.Value.ToString(), hdnSchemeSearchVal.Value.ToString(), hdnCategoryFilter.Value.ToString(), out Count, 0); } } if (dsMISReport.Tables[0].Rows.Count == 0) { trMessage.Visible = true; gvMFMIS.DataSource = dsMISReport; gvMFMIS.DataBind(); imgBtnExport.Visible = false; } else { DataTable dtMISReport = new DataTable(); dtMISReport.Columns.Add("SchemePlanCode"); dtMISReport.Columns.Add("AMC"); dtMISReport.Columns.Add("Scheme"); dtMISReport.Columns.Add("Category"); dtMISReport.Columns.Add("SubCategory"); dtMISReport.Columns.Add("AUM"); dtMISReport.Columns.Add("Units"); dtMISReport.Columns.Add("MarketPrice"); dtMISReport.Columns.Add("Percentage"); DataRow drMISReport; for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++) { drMISReport = dtMISReport.NewRow(); drMISReport[0] = dsMISReport.Tables[0].Rows[i][1].ToString(); drMISReport[1] = dsMISReport.Tables[0].Rows[i][2].ToString(); drMISReport[2] = dsMISReport.Tables[0].Rows[i][3].ToString(); drMISReport[3] = dsMISReport.Tables[0].Rows[i][4].ToString(); drMISReport[4] = dsMISReport.Tables[0].Rows[i][5].ToString(); //drMISReport[5] = dsMISReport.Tables[0].Rows[i][6].ToString(); //drMISReport[6] = dsMISReport.Tables[0].Rows[i][7].ToString(); //drMISReport[7] = dsMISReport.Tables[0].Rows[i][8].ToString(); if (GridViewCultureFlag == true) { decimal temp = decimal.Parse(dsMISReport.Tables[0].Rows[i][6].ToString()); drMISReport[5] = temp.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); drMISReport[6] = decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString("n4", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } else { drMISReport[5] = decimal.Parse(dsMISReport.Tables[0].Rows[i][6].ToString()).ToString(); drMISReport[6] = decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()).ToString(); //drMISReport[6] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][7].ToString()), 2).ToString(); } drMISReport[7] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][8].ToString()), 2).ToString(); drMISReport[8] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][9].ToString()), 2).ToString(); dtMISReport.Rows.Add(drMISReport); } gvMFMIS.DataSource = dtMISReport; gvMFMIS.DataBind(); imgBtnExport.Visible = true; double no_of_units = 0; double aum = 0; foreach (DataRow dr in dsMISReport.Tables[0].Rows) { no_of_units = Convert.ToDouble(dr["Units"].ToString()); aum = Convert.ToDouble(dr["AUM"].ToString()); totalUnits = totalUnits + no_of_units; totalAmount = totalAmount + aum; } if (GridViewCultureFlag == true) { gvMFMIS.FooterRow.Cells[6].Text = totalUnits.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); gvMFMIS.FooterRow.Cells[7].Text = totalAmount.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } else { gvMFMIS.FooterRow.Cells[6].Text = totalUnits.ToString(); gvMFMIS.FooterRow.Cells[7].Text = totalAmount.ToString(); } } lblTotalRows.Text = hdnRecordCount.Value = Count.ToString(); if (Count > 0) { DivPager.Style.Add("display", "visible"); } else { DivPager.Style.Add("display", "none"); lblCurrentPage.Text = ""; lblCurrentPage.Text = ""; } ViewState["Valuationdate"] = Valuationdate.ToString(); TextBox txtamc = new TextBox(); TextBox txtscheme = new TextBox(); if (gvMFMIS.HeaderRow != null) { txtamc = (TextBox)gvMFMIS.HeaderRow.FindControl("txtAMCSearch"); txtscheme = (TextBox)gvMFMIS.HeaderRow.FindControl("txtSchemeSearch"); } txtamc.Text = hdnAMCSearchVal.Value.ToString(); txtscheme.Text = hdnSchemeSearchVal.Value.ToString(); if (dsMISReport.Tables[2].Rows.Count > 0) { DropDownList ddlcategorylist = GetCategoryDDL(); if (ddlcategorylist != null) { ddlcategorylist.DataSource = dsMISReport.Tables[2]; ddlcategorylist.DataTextField = dsMISReport.Tables[2].Columns[0].ToString(); ddlcategorylist.DataValueField = dsMISReport.Tables[2].Columns[0].ToString(); ddlcategorylist.DataBind(); ddlcategorylist.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "Select")); if (hdnCategoryFilter.Value.ToString() != "") { ddlcategorylist.SelectedValue = hdnCategoryFilter.Value.ToString(); } } } this.GetPageCount(); if (GridViewCultureFlag == false) { GridViewCultureFlag = true; } totalUnits = 0; totalAmount = 0; }
private void bindgrid(DateTime Valuationdate) { AdvisorMISBo adviserMISBo = new AdvisorMISBo(); DataSet dsMISReport = null; double totalAum = 0; double totalUnits = 0; decimal TotalAumPercentage = 0; DateTime Valuation_Date = new DateTime(); int.TryParse(ddlBranch.SelectedValue, out branchId); int.TryParse(ddlRM.SelectedValue, out rmId); if (Valuationdate != DateTime.MinValue) { Valuation_Date = Valuationdate; if (userType == "rm") { dsMISReport = adviserMISBo.GetAMCwiseMISForRM(rmid, Valuation_Date, hdnAMCSearchVal.Value.ToString()); } else if (userType == "adviser") { dsMISReport = adviserMISBo.GetAMCwiseMISForAdviser(advisorVo.advisorId, branchId, rmId, Valuation_Date, hdnAMCSearchVal.Value.ToString()); } else if (userType == "bm") { dsMISReport = adviserMISBo.GetMISForBM(int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), int.Parse(hdnbranchHeadId.Value.ToString()), int.Parse(hdnXWise.Value.ToString()), int.Parse(hdnAll.Value.ToString()), Valuationdate, 0, 0, 1, hdnAMCSearchVal.Value.ToString(), string.Empty, string.Empty, string.Empty, string.Empty, out count, 0); } } if (dsMISReport == null || dsMISReport.Tables[0].Rows.Count == 0) { trMessage.Visible = true; gvMFMIS.DataSource = dsMISReport; gvMFMIS.DataBind(); imgBtnExport.Visible = false; } else { double no_of_units = 0; double aum = 0; decimal AumPercentage = 0; for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++) { dsMISReport.Tables[0].Rows[i]["AUM"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString()); //dsMISReport.Tables[0].Rows[i]["Percentage"] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()).ToString(); //decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } foreach (DataRow dr in dsMISReport.Tables[0].Rows) { //no_of_units = Convert.ToDouble(dr["Units"].ToString()); aum = Convert.ToDouble(dr["AUM"].ToString()); AumPercentage = decimal.Parse(dr["Percentage"].ToString()); //totalUnits = totalUnits + no_of_units; totalAum = totalAum + aum; TotalAumPercentage = TotalAumPercentage + AumPercentage; } DataTable dtMISReport = new DataTable(); dtMISReport.Columns.Add("AMC"); dtMISReport.Columns.Add("AMCCode"); dtMISReport.Columns.Add("AUM"); dtMISReport.Columns.Add("Percentage"); DataRow drMISReport; for (int i = 0; i < dsMISReport.Tables[0].Rows.Count; i++) { drMISReport = dtMISReport.NewRow(); drMISReport[0] = dsMISReport.Tables[0].Rows[i]["AMC"].ToString(); drMISReport[1] = dsMISReport.Tables[0].Rows[i]["AMCCode"].ToString(); drMISReport[2] = dsMISReport.Tables[0].Rows[i]["AUM"].ToString(); if (GridViewCultureFlag == true) { decimal tempAum = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString()); drMISReport[2] = tempAum.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } else { //decimal tempAum = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i][2].ToString()), 2); //drMISReport[2] = tempAum.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); drMISReport[2] = decimal.Parse(dsMISReport.Tables[0].Rows[i]["AUM"].ToString()); } drMISReport[3] = System.Math.Round(decimal.Parse(dsMISReport.Tables[0].Rows[i]["Percentage"].ToString()), 2).ToString(); dtMISReport.Rows.Add(drMISReport); } gvMFMIS.DataSource = dtMISReport; gvMFMIS.DataBind(); imgBtnExport.Visible = true; if (GridViewCultureFlag == true) { decimal tempTotalAum = System.Math.Round(decimal.Parse(totalAum.ToString()), 2); gvMFMIS.FooterRow.Cells[2].Text = tempTotalAum.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); gvMFMIS.FooterRow.Cells[3].Text = TotalAumPercentage.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } else { decimal tempTotalAum = System.Math.Round(decimal.Parse(totalAum.ToString()), 4); gvMFMIS.FooterRow.Cells[2].Text = tempTotalAum.ToString(); gvMFMIS.FooterRow.Cells[3].Text = TotalAumPercentage.ToString(); } } ViewState["Valuationdate"] = Valuationdate.ToString(); TextBox txtamc = new TextBox(); TextBox txtscheme = new TextBox(); if (gvMFMIS.HeaderRow != null) { txtamc = (TextBox)gvMFMIS.HeaderRow.FindControl("txtAMCSearch"); } txtamc.Text = hdnAMCSearchVal.Value.ToString(); }
protected void Page_Load(object sender, EventArgs e) { advisorVo = (AdvisorVo)Session["advisorVo"]; rmVo = (RMVo)Session[SessionContents.RmVo]; userVo = (UserVo)Session["userVo"]; AdvisorMISBo adviserMISBo = new AdvisorMISBo(); if (Session[SessionContents.ValuationDate] == null) { GetLatestValuationDate(); } genDict = (Dictionary <string, DateTime>)Session[SessionContents.ValuationDate]; strValuationDate = genDict[Constants.MFDate.ToString()].ToShortDateString(); lblPickDate.Text = DateTime.Parse(genDict[Constants.MFDate.ToString()].ToString()).ToShortDateString(); if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops") { userType = "advisor"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm") { userType = "rm"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm") { userType = "bm"; } else { userType = Session[SessionContents.CurrentUserRole].ToString().ToLower(); } if (userType == "associates") { ddlTypes.Items[0].Enabled = false; ddlTypes.Items[2].Enabled = false; } advisorId = advisorVo.advisorId; int RMId = rmVo.RMId; rmId = rmVo.RMId; bmID = rmVo.RMId; pnlMfReturns.Visible = false; pnlScheme.Visible = false; gvMfReturns.Visible = false; gvMfReturnsScheme.Visible = false; imgScheme.Visible = false; imgMFReturns.Visible = false; if (!IsPostBack) { if (Request.QueryString["strCustomreId"] != null) { ddlType.SelectedValue = "SchemeWise"; SetParameters(); GetLatestValuationDate(); customerid = int.Parse(Request.QueryString["strCustomreId"].ToString()); BindMFSchemeWise(); gvMfReturnsScheme.Visible = true; //int accountId = int.Parse(Request.QueryString["folionum"].ToString()); //int SchemePlanCode = int.Parse(Request.QueryString["SchemePlanCode"].ToString()); //PasssedFolioValue = accountId; //BindLastTradeDate(); //string fromdate = "01-01-1990"; //txtFromDate.SelectedDate = DateTime.Parse(fromdate); //ViewState["SchemePlanCode"] = SchemePlanCode; } } }
protected void Page_Load(object sender, EventArgs e) { associateuserheirarchyVo = (AssociatesUserHeirarchyVo)Session[SessionContents.AssociatesLogin_AssociatesHierarchy]; advisorVo = (AdvisorVo)Session["advisorVo"]; rmVo = (RMVo)Session[SessionContents.RmVo]; userVo = (UserVo)Session["userVo"]; associatesVo = (AssociatesVO)Session["associatesVo"]; AdvisorMISBo adviserMISBo = new AdvisorMISBo(); path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops") { userType = "advisor"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm") { userType = "rm"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm") { userType = "bm"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "associates") { userType = "associates"; } else { userType = Session[SessionContents.CurrentUserRole].ToString().ToLower(); } advisorId = advisorVo.advisorId; int RMId = rmVo.RMId; rmId = rmVo.RMId; bmID = rmVo.RMId; //if (userType == "associates") //{ // SetParameters(); // BindMfDashBoard(); //} if (!IsPostBack) { if (userType == "advisor" || userType == "rm") { BindBranchDropDown(); BindRMDropDown(); if (userType == "rm") { ddlType.Visible = false; lblType.Visible = false; ddlBranch.Enabled = false; ddlRM.SelectedValue = rmVo.RMId.ToString(); ddlRM.Enabled = false; } if (Session["NodeType"] != null) { if (Session["NodeType"] == "MFDashBoard") { SetParameters(); BindMfDashBoard(); UpnlMFDashBoard.Visible = true; } } } else if (userType == "rm") { //BindBranchDropDown(); //BindRMDropDown(); //if (userType == "rm") //{ // ddlBranch.Enabled = false; // ddlRM.SelectedValue = rmVo.RMId.ToString(); // ddlRM.Enabled = false; //} } if (userType == "bm") { //trBranchRM.Visible = true; BindBranchForBMDropDown(); BindRMforBranchDropdown(0, bmID); //BindMfDashBoard(); } else if (userType == "associates") { SetParameters(); BindMfDashBoard(); BindBranchDropDown(); BindRMDropDown(); gvBranch.Visible = true; Label1.Visible = true; lnkBranchNavi.Visible = true; UpnlMFDashBoard.Visible = true; trBranchRM.Visible = false; btnGo.Visible = false; ddlType.Visible = false; lblType.Visible = false; } } // BindMfDashBoard(); }
protected void Page_Load(object sender, EventArgs e) { advisorVo = (AdvisorVo)Session["advisorVo"]; rmVo = (RMVo)Session[SessionContents.RmVo]; userVo = (UserVo)Session["userVo"]; AdvisorMISBo adviserMFMIS = new AdvisorMISBo(); path = Server.MapPath(ConfigurationManager.AppSettings["xmllookuppath"].ToString()); if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "admin" || Session[SessionContents.CurrentUserRole].ToString().ToLower() == "ops") { userType = "advisor"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "rm") { userType = "rm"; } else if (Session[SessionContents.CurrentUserRole].ToString().ToLower() == "bm") { userType = "bm"; } else { userType = Session[SessionContents.CurrentUserRole].ToString().ToLower(); } advisorId = advisorVo.advisorId; int RMId = rmVo.RMId; rmId = rmVo.RMId; bmID = rmVo.RMId; imgOrgGridExport.Visible = false; imgProductGridExport.Visible = false; pnlEQTurnover.Visible = false; pnlOrgLevel.Visible = false; gvEQTurnover.Visible = false; gvOrgLevel.Visible = false; if (!IsPostBack) { trEQProductLevel.Visible = false; trOrgLevel.Visible = false; rbtnPickDate.Checked = true; rbtnPickPeriod.Checked = false; divDateRange.Visible = true; divDatePeriod.Visible = false; if (userType == "advisor") { BindBranchDropDown(); BindRMDropDown(); } else if (userType == "rm") { trBranchRmDpRow.Visible = false; } if (userType == "bm") { BindBranchForBMDropDown(); BindRMforBranchDropdown(0, bmID); } LatestValuationdate = adviserMFMIS.GetLatestValuationDateFromHistory(advisorId, "EQ"); txtFromDate.SelectedDate = DateTime.Parse(LatestValuationdate.ToShortDateString()); txtToDate.SelectedDate = DateTime.Parse(LatestValuationdate.ToShortDateString()); } }
//private void BindGrid(DateTime dtFrom, DateTime dtTo) //{ // DataSet dsEQMIS = new DataSet(); // DataTable dtAdviserEQMIS = new DataTable(); // int ID = 0; // if (userType == "advisor") // ID = advisorVo.advisorId; // else if (userType == "rm") // { // rmVo = (RMVo)Session[SessionContents.RmVo]; // ID = rmVo.RMId; // } // else if (userType == "bm") // { // rmVo = (RMVo)Session[SessionContents.RmVo]; // ID = rmVo.RMId; // if (userType == "bm") // { // if (hdnall.Value == "0") // { // hdnbranchId.Value = ddlBranchForEQ.SelectedValue; // hdnrmId.Value = ddlRMEQ.SelectedValue; // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 0); // } // else if (hdnall.Value == "1") // { // hdnbranchId.Value = ddlBranchForEQ.SelectedValue; // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1); // } // else if (hdnall.Value == "2") // { // hdnbranchHeadId.Value = ddlBranchForEQ.SelectedValue; // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2); // } // else if (hdnall.Value == "3") // { // hdnbranchHeadId.Value = ddlBranchForEQ.SelectedValue; // hdnrmId.Value = ddlRMEQ.SelectedValue; // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 3); // } // //dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo,0, 0, 0, 0); // } // } // try // { // if (userType == "advisor") // { // if (hdnall.Value == "0") // { // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 0); // } // else if (hdnall.Value == "1") // { // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1); // } // else if (hdnall.Value == "2") // { // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2); // } // else if (hdnall.Value == "3") // { // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 3); // } // } // if (userType == "rm") // { // dsEQMIS = adviserMIS.GetEQMIS(userType, ID, dtFrom, dtTo, 0, 0, 0, 0); // } // if (dsEQMIS.Tables[0].Rows.Count > 0) // { // DataRow drAdvEQMIS; // drAdvEQMIS = dtAdviserEQMIS.NewRow(); // dtAdviserEQMIS.Columns.Add("CName_Industry_Delby"); // dtAdviserEQMIS.Columns.Add("Industry_MValue_DelSell"); // dtAdviserEQMIS.Columns.Add("MValue_Percentage_SpecSell"); // dtAdviserEQMIS.Columns.Add("MValue_Blank_SpecBuy"); // int flag = 0; // for (int i = 0; i < dsEQMIS.Tables[0].Rows.Count; i++) // { // NumberFormatInfo nfi0 = new CultureInfo("en-US", false).NumberFormat; // NumberFormatInfo nfi1 = new CultureInfo("en-US", false).NumberFormat; // NumberFormatInfo nfi2 = new CultureInfo("en-US", false).NumberFormat; // NumberFormatInfo nfi3 = new CultureInfo("en-US", false).NumberFormat; // nfi0.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["DeliveryBuy"].ToString()).ToString("N", nfi0)); // nfi1.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["DeliverySell"].ToString()).ToString("N", nfi1)); // nfi2.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["SpeculativeSell"].ToString()).ToString("N", nfi2)); // nfi3.NumberDecimalSeparator = String.Format("{0:n2}", decimal.Parse(dsEQMIS.Tables[0].Rows[i]["SpeculativeBuy"].ToString()).ToString("N", nfi3)); // drAdvEQMIS[0] = nfi0.NumberDecimalSeparator; // drAdvEQMIS[1] = nfi1.NumberDecimalSeparator; // drAdvEQMIS[2] = nfi2.NumberDecimalSeparator; // drAdvEQMIS[3] = nfi3.NumberDecimalSeparator; // dtAdviserEQMIS.Rows.Add(drAdvEQMIS); // } // if ((decimal.Parse(dsEQMIS.Tables[0].Rows[0]["DeliveryBuy"].ToString()) != 0) || (decimal.Parse(dsEQMIS.Tables[0].Rows[0]["DeliverySell"].ToString()) != 0) || // (decimal.Parse(dsEQMIS.Tables[0].Rows[0]["SpeculativeSell"].ToString()) != 0) || (decimal.Parse(dsEQMIS.Tables[0].Rows[0]["SpeculativeBuy"].ToString()) != 0)) // { // flag = 1; // } // if (flag == 0) // { // gvEQMIS.Visible = false; // ErrorMessage.Visible = true; // } // else // { // gvEQMIS.Visible = true; // ErrorMessage.Visible = false; // gvEQMIS.DataSource = dtAdviserEQMIS; // gvEQMIS.DataBind(); // gvEQMIS.Columns[0].ItemStyle.HorizontalAlign = HorizontalAlign.Right; // gvEQMIS.Columns[1].ItemStyle.HorizontalAlign = HorizontalAlign.Right; // //Assigning Text To Header template // Label Hlb1 = (Label)gvEQMIS.HeaderRow.FindControl("lblCustIndDelby"); // Hlb1.Text = "Delivery Buy Value"; // Label Hlb2 = (Label)gvEQMIS.HeaderRow.FindControl("lblIndMValueDelSell"); // Hlb2.Text = "Delivery Sell Value"; // Label Hlb3 = (Label)gvEQMIS.HeaderRow.FindControl("lblMValuePerCSpecSell"); // Hlb3.Text = "Speculative Sell Value"; // Label Hlb4 = (Label)gvEQMIS.HeaderRow.FindControl("lblMvalueBlankSpecbuy"); // Hlb4.Text = "Speculative Buy Value"; // Label TotalText = (Label)gvEQMIS.FooterRow.FindControl("lblTotalText"); // TotalText.Text = string.Empty; // Label TotalMText = (Label)gvEQMIS.FooterRow.FindControl("lblSectorWiseTotalText"); // TotalMText.Text = string.Empty; // Label TotalMarketValue = (Label)gvEQMIS.FooterRow.FindControl("lblFooterItemMValue"); // TotalMarketValue.Text = string.Empty; // Label TotalValue = (Label)gvEQMIS.FooterRow.FindControl("lblFooterItemMValue"); // TotalValue.Text = string.Empty; // } // } // } // catch (BaseApplicationException Ex) // { // throw Ex; // } // catch (Exception Ex) // { // BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); // NameValueCollection FunctionInfo = new NameValueCollection(); // FunctionInfo.Add("Method", "AdviserEQMIS.ascx.cs:BindGrid()"); // object[] objects = new object[2]; // objects[0] = dtFrom; // objects[1] = dtTo; // FunctionInfo = exBase.AddObject(FunctionInfo, objects); // exBase.AdditionalInformation = FunctionInfo; // ExceptionManager.Publish(exBase); // throw exBase; // } //} private void BindEQMISgrid(DateTime Valuationdate) { AdvisorMISBo adviserMISBo = new AdvisorMISBo(); DataSet dsCompSecEQMIS = new DataSet(); DataTable dtCompSecEQMIS = new DataTable(); int adviserId = 0; int rmId = 0; int TotalShares = 0; adviserId = advisorVo.advisorId; rmVo = (RMVo)Session[SessionContents.RmVo]; rmId = rmVo.RMId; hdnPortfolioType.Value = ddlPortfolioGroup.SelectedValue; hdnbranchHeadId.Value = ddlBranchForEQ.SelectedValue; hdnbranchId.Value = ddlBranchForEQ.SelectedValue; hdnrmId.Value = ddlRMEQ.SelectedValue; hdnEQMISType.Value = ddlMISType.SelectedValue; if (ddlMISType.SelectedValue == "SectorWise") { hdnEQMISType.Value = "1"; } else if (ddlMISType.SelectedValue == "CompanyWise") { hdnEQMISType.Value = "0"; } DateTime Valuation_Date = Convert.ToDateTime(hdnValuationDate.Value.ToString()); if (userType == "rm") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, rmId, 0, 0, 0, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } if (userType == "advisor") { if (hdnall.Value == "0") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 0, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } else if (hdnall.Value == "1") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } else if (hdnall.Value == "2") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } else if (hdnall.Value == "3") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 3, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } } if (userType == "bm") { if (hdnall.Value == "0") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, 0, int.Parse(hdnbranchHeadId.Value.ToString()), 0, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } else if (hdnall.Value == "1") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, 0, int.Parse(hdnbranchId.Value.ToString()), 0, 1, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } else if (hdnall.Value == "2") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), 0, int.Parse(hdnbranchHeadId.Value.ToString()), 2, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } else if (hdnall.Value == "3") { dsCompSecEQMIS = adviserMISBo.GetAllUsersEQMISForComSec(userType, Valuation_Date, adviserId, int.Parse(hdnrmId.Value.ToString()), int.Parse(hdnbranchId.Value.ToString()), 0, 3, int.Parse(hdnEQMISType.Value.ToString()), int.Parse(hdnPortfolioType.Value.ToString())); } } if (dsCompSecEQMIS.Tables[0].Rows.Count == 0) { gvEQMIS.DataSource = dsCompSecEQMIS; gvEQMIS.DataBind(); imgEQAllocatio.Visible = false; } else { dtCompSecEQMIS.Columns.Add("Company"); dtCompSecEQMIS.Columns.Add("Industry"); dtCompSecEQMIS.Columns.Add("NoOfShare", typeof(Decimal)); dtCompSecEQMIS.Columns.Add("MarketValue", typeof(Decimal)); dtCompSecEQMIS.Columns.Add("NetAssets", typeof(Decimal)); DataRow drAdvEQMIS; for (int i = 0; i < dsCompSecEQMIS.Tables[0].Rows.Count; i++) { drAdvEQMIS = dtCompSecEQMIS.NewRow(); if (hdnEQMISType.Value == "0") { drAdvEQMIS["Company"] = dsCompSecEQMIS.Tables[0].Rows[i]["CompanyName"].ToString(); } else { drAdvEQMIS["Company"] = string.Empty; } drAdvEQMIS["Industry"] = dsCompSecEQMIS.Tables[0].Rows[i]["Industry"].ToString(); drAdvEQMIS["NoOfShare"] = dsCompSecEQMIS.Tables[0].Rows[i]["NoOfShare"].ToString(); drAdvEQMIS["MarketValue"] = dsCompSecEQMIS.Tables[0].Rows[i]["MarketValue"].ToString(); drAdvEQMIS["NetAssets"] = dsCompSecEQMIS.Tables[0].Rows[i]["NetAssetsPercentage"].ToString(); dtCompSecEQMIS.Rows.Add(drAdvEQMIS); } GridBoundColumn ghItem = gvEQMIS.MasterTableView.Columns.FindByUniqueName("Company") as GridBoundColumn; if (ddlMISType.SelectedValue == "CompanyWise") { ghItem.Visible = true; } else if (ddlMISType.SelectedValue == "SectorWise") { ghItem.Visible = false; } gvEQMIS.DataSource = dtCompSecEQMIS; gvEQMIS.DataBind(); gvEQMIS.Visible = true; imgEQAllocatio.Visible = true; if (Cache["gvEQMIS" + userVo.UserId + userType] == null) { Cache.Insert("gvEQMIS" + userVo.UserId + userType, dtCompSecEQMIS); } else { Cache.Remove("gvEQMIS" + userVo.UserId + userType); Cache.Insert("gvEQMIS" + userVo.UserId + userType, dtCompSecEQMIS); } //Assigning Text To Header template } }