protected void bindGrid(int advisorBranchId, int branchHeadId, int all)
{
//DataSet ds = new DataSet();
//DataTable BranchAssetsTab = new DataTable();
DataRow drAssets;
DataRow drValues;
branchDetailsDS = advisorBranchBo.GetBranchAssets(advisorBranchId, branchHeadId, all);
topFiveRMDT = branchDetailsDS.Tables[1];
topFiveCustomerDT = branchDetailsDS.Tables[2];
if (branchDetailsDS.Tables[0].Rows.Count > 0)
{
hrBranchAum.Visible = true;
ErrorMessage.Visible = false;
lblBranchAUM.Visible = true;
branchAumDT.Columns.Add("Asset");
branchAumDT.Columns.Add("CurrentValue");
drValues = branchDetailsDS.Tables[0].Rows[0];
//DataView view = branchAumDT.DefaultView;
//view.Sort = "CurrentValue";
for (int i = 0; i < branchDetailsDS.Tables[0].Columns.Count - 1; i++)
{
drAssets = branchAumDT.NewRow();
drAssets["Asset"] = branchDetailsDS.Tables[0].Columns[i].ColumnName;
drAssets["CurrentValue"] = drValues[i].ToString();
branchAumDT.Rows.Add(drAssets);
if (GridViewCultureFlag == true)
{
double tempCurrValue = 0;
double.TryParse(drValues[i].ToString(), out tempCurrValue);
tempCurrValue = Math.Round(tempCurrValue, 2);
drAssets["CurrentValue"] = tempCurrValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
else
{
double tempCurrValue = 0;
double.TryParse(drValues[i].ToString(), out tempCurrValue);
tempCurrValue = Math.Round(tempCurrValue, 2);
drAssets["CurrentValue"] = tempCurrValue;
}
}
gvBMDashBoardGrid.DataSource = branchAumDT;
//branchAumDT.DefaultView.Sort = "CurrentValue";
gvBMDashBoardGrid.DataBind();
gvBMDashBoardGrid.GridLines = GridLines.Both;
Label TotalText = (Label)gvBMDashBoardGrid.FooterRow.FindControl("lblTotalText");
Label TotalValue = (Label)gvBMDashBoardGrid.FooterRow.FindControl("lblTotalValue");
TotalText.Text = branchDetailsDS.Tables[0].Columns[branchDetailsDS.Tables[0].Columns.Count - 1].ColumnName;
TotalValue.Text = drValues[branchDetailsDS.Tables[0].Columns.Count - 1].ToString();
if (GridViewCultureFlag == true)
{
double tempTotalValue = 0;
double.TryParse(drValues[branchDetailsDS.Tables[0].Columns.Count - 1].ToString(), out tempTotalValue);
tempTotalValue = Math.Round(tempTotalValue, 2);
TotalValue.Text = tempTotalValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
}
}
else
{
hrBranchAum.Visible = false;
ErrorMessage.Visible = true;
gvBMDashBoardGrid.DataSource = null;
gvBMDashBoardGrid.Visible = false;
lblBranchAUM.Visible = false;
}
/* Top 5 RM Grid */
//DataRow drRMName;
//DataRow drRMValue;
//if (branchDetailsDS.Tables[0].Rows.Count > 0)
//{
// hrTop5Rm.Visible = true;
// ErrorMsgForTop5RMs.Visible = false;
// lblTop5RM.Visible = true;
//topFiveRMDT.Columns.Add("Rm Name");
//topFiveRMDT.Columns.Add("Staff Code");
//topFiveRMDT.Columns.Add("Customer base");
//topFiveRMDT.Columns.Add("Customer networth");
//drRMValue = branchDetailsDS.Tables[1].Rows[0];
//for (int i = 0; i < branchDetailsDS.Tables[1].Columns.Count; i++)
//{
// drRMName = topFiveRMDT.NewRow();
// drRMName["RmName"] = branchDetailsDS.Tables[1].Columns[i].ColumnName;
// drRMName["Staff_Code"] = branchDetailsDS.Tables[1].Columns[i].ColumnName;
// drRMName["Customer_base"] = branchDetailsDS.Tables[1].Columns[i].ColumnName;
// drRMName["Customer_networth"] = drRMValue[i].ToString();
// topFiveRMDT.Rows.Add(drRMName);
// //if (GridViewCultureFlag == true)
// //{
// // decimal tempRMValue = System.Math.Round(decimal.Parse(drRMValue[i].ToString()), 2);
// // drRMName["Customer networth"] = tempRMValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
// //}
// //else
// //{
// // drRMName["Customer networth"] = decimal.Parse(drRMValue[i].ToString());
// //}
//}
if (topFiveRMDT.Rows.Count > 0)
{
int i = 0;
hrTop5Rm.Visible = true;
ErrorMsgForTop5RMs.Visible = false;
lblTop5RM.Visible = true;
gvRMCustNetworth.Visible = true;
for (i = 0; i < topFiveRMDT.Rows.Count - 1; i++)
{
topFiveRMDT.Rows[i]["Customer_networth"] = topFiveRMDT.Rows[i]["Customer_networth"].ToString();
}
//if (GridViewCultureFlag == true)
//{
// decimal tempRMValue = System.Math.Round(decimal.Parse(topFiveRMDT.Rows[i]["Customer_networth"].ToString()), 2);
// topFiveRMDT.Rows[i]["Customer_networth"] = tempRMValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));
//}
gvRMCustNetworth.DataSource = topFiveRMDT;
gvRMCustNetworth.DataBind();
}
else
{
hrTop5Rm.Visible = false;
ErrorMsgForTop5RMs.Visible = true;
lblTop5RM.Visible = false;
gvRMCustNetworth.DataSource = null;
gvRMCustNetworth.Visible = false;
}
if (topFiveCustomerDT.Rows.Count > 0)
{
hrTop5Cust.Visible = true;
ErrorMsgForTop5Customer.Visible = false;
gvCustNetWorth.Visible = true;
lblTop5CustNetworth.Visible = true;
gvCustNetWorth.DataSource = topFiveCustomerDT;
gvCustNetWorth.DataBind();
}
else
{
hrTop5Cust.Visible = false;
ErrorMsgForTop5Customer.Visible = true;
lblTop5CustNetworth.Visible = false;
gvCustNetWorth.DataSource = null;
gvCustNetWorth.Visible = false;
}
}