protected void LoadAdminDashBoardDataInCaching() { double totalEquity = 0; double totalMF = 0; ds = assetBo.GetAdviserBranchMF_EQ_In_AggregateCurrentValues(advisorVo.advisorId); if (ds.Tables[0].Rows.Count > 0) { totalEquity = double.Parse(ds.Tables[0].Compute("SUM(EquityAggr)", String.Empty).ToString()); totalMF = double.Parse(ds.Tables[0].Compute("SUM(MFAggr)", String.Empty).ToString()); } }
/// <summary> /// Modified this function to add a new column(No. of customers) to the Branch AUM grid /// </summary> private void LoadAdminBranchPerformance() { List <AdvisorBranchVo> branchList = new List <AdvisorBranchVo>(); AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo(); DataTable dt = new DataTable(); DataRow drResult = null; DataRow dr = null; int Count = 0; mfTotal = 0; total = 0; try { ds = assetBo.GetAdviserBranchMF_EQ_In_AggregateCurrentValues(advisorVo.advisorId, out Count, mypager.CurrentPage, out total); lblTotalRows.Text = hdnRecordCount.Value = Count.ToString(); if (ds.Tables[0].Rows.Count > 0) { lblGT.Visible = true; lblGTT.Visible = true; dt.Columns.Add("Branch Id"); dt.Columns.Add("Branch Name"); dt.Columns.Add("Branch Code"); //dt.Columns.Add("Equity"); dt.Columns.Add("Equity"); dt.Columns.Add("MF"); dt.Columns.Add("Insurance"); dt.Columns.Add("NoOfCustomers"); //dt.Columns.Add(new DataColumn("Equity", typeof(decimal))); //dt.Columns.Add(new DataColumn("MF", typeof(decimal))); //dt.Columns.Add(new DataColumn("Insurance", typeof(decimal))); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = dt.NewRow(); drResult = ds.Tables[0].Rows[i]; dr[0] = drResult["A_AdviserId"].ToString(); dr[1] = drResult["AB_BranchName"].ToString(); dr[2] = drResult["AB_BranchCode"].ToString(); if (Convert.ToDecimal(drResult["EquityAggr"].ToString()) == 0) { dr[3] = "0"; } else { dr[3] = decimal.Parse(drResult["EquityAggr"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } eqTotal = eqTotal + Convert.ToDecimal(drResult["EquityAggr"].ToString()); if (Convert.ToDecimal(drResult["MFAggr"].ToString()) == 0) { dr[4] = "0"; } else { dr[4] = decimal.Parse(drResult["MFAggr"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } mfTotal = mfTotal + Convert.ToDecimal(drResult["MFAggr"].ToString()); if (Convert.ToDecimal(drResult["InsuranceAggr"].ToString()) == 0) { dr[5] = "0"; } else { dr[5] = decimal.Parse(drResult["InsuranceAggr"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); } insuranceTotal = insuranceTotal + Convert.ToDecimal(drResult["InsuranceAggr"].ToString()); dr[6] = drResult["NoOfCustomers"].ToString(); customerTotal = customerTotal + Int32.Parse(drResult["NoOfCustomers"].ToString()); dt.Rows.Add(dr); } gvrAdminBranchPerform.DataSource = dt; gvrAdminBranchPerform.DataBind(); gvrAdminBranchPerform.Visible = true; GetPageCount(); } else { lblGT.Visible = false; lblGTT.Visible = false; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "IFAAdminMainDashboard.ascx:LoadAdminBranchPerformance()"); object[] objects = new object[3]; objects[0] = advisorVo; objects[1] = branchList; objects[2] = ds; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }