/// <summary> /// Modified the function to add total field to the Client List Grid /// </summary> /// <param name="RMId"></param> public void getCustomerListforRM(int RMId) { DataSet dsCurrentValues = null; double total = 0.00; try { dsCurrentValues = assetBo.GetRMCustomersAssetAggregateCurrentValues(RMId); if (dsCurrentValues != null) { DataTable dtCurrentValusForRM = new DataTable(); dtCurrentValusForRM.Columns.Add("CustomerId"); dtCurrentValusForRM.Columns.Add("Customer_Name"); dtCurrentValusForRM.Columns.Add("EQCurrentVal"); dtCurrentValusForRM.Columns.Add("MFCurrentVal"); dtCurrentValusForRM.Columns.Add("Total"); DataRow drCurrentValuesForRM; for (int i = 0; i < dsCurrentValues.Tables[0].Rows.Count; i++) { drCurrentValuesForRM = dtCurrentValusForRM.NewRow(); drCurrentValuesForRM[0] = dsCurrentValues.Tables[0].Rows[i]["CustomerId"].ToString(); drCurrentValuesForRM[1] = dsCurrentValues.Tables[0].Rows[i]["Customer_Name"].ToString(); drCurrentValuesForRM[2] = String.Format("{0:n2}", decimal.Parse(dsCurrentValues.Tables[0].Rows[i]["EQCurrentVal"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); drCurrentValuesForRM[3] = String.Format("{0:n2}", decimal.Parse(dsCurrentValues.Tables[0].Rows[i]["MFCurrentVal"].ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); total = double.Parse(dsCurrentValues.Tables[0].Rows[i]["EQCurrentVal"].ToString()) + double.Parse(dsCurrentValues.Tables[0].Rows[i]["MFCurrentVal"].ToString()); drCurrentValuesForRM[4] = String.Format("{0:n2}", total.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); dtCurrentValusForRM.Rows.Add(drCurrentValuesForRM); } gvrRMClinetList.DataSource = dtCurrentValusForRM; gvrRMClinetList.DataBind(); } /* If AUM is zero, donot show customers */ //gvrRMClinetList.DataSource = dsCurrentValues; //gvrRMClinetList.DataBind(); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RMDashboard.ascx:getCustomerListforRM()"); object[] objects = new object[1]; objects[0] = dsCurrentValues; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }