private void loadMetrics() { DataSet ds = WorkloadItem.Metrics_Get(); DataTable dtDescription = new DataTable(); if (ds.Tables.Contains("Workload")) { DataTable dtItemMetrics = ds.Tables["Workload"]; if (dtItemMetrics != null) { DCC_Workload = dtItemMetrics.Columns; InitializeColumnData_Workload(ref dtItemMetrics); SetupMultiHeader_Workload(dtItemMetrics); dtItemMetrics.AcceptChanges(); try { dtDescription = dtItemMetrics.Copy(); dtDescription.DefaultView.RowFilter = "PriorityLabel = 'Description'"; dtDescription = dtDescription.DefaultView.ToTable(); if (dtDescription != null && dtDescription.Rows.Count > 0) { NewDescription = dtDescription.Rows[0]["New"].ToString(); InProgressDescription = dtDescription.Rows[0]["In_Progress"].ToString(); ReOpenedDescription = dtDescription.Rows[0]["Re_Opened"].ToString(); InfoRequestedDescription = dtDescription.Rows[0]["Info_Requested"].ToString(); CheckedInDescription = dtDescription.Rows[0]["Checked_In"].ToString(); DeployedDescription = dtDescription.Rows[0]["Deployed"].ToString(); ClosedDescription = dtDescription.Rows[0]["Closed"].ToString(); } } catch (Exception) { } } gridWorkloadMetrics.DataSource = dtItemMetrics; gridWorkloadMetrics.DataBind(); } //if (ds.Tables.Contains("Request")) //{ // DataTable dtRequestMetrics = ds.Tables["Request"]; // if (dtRequestMetrics != null) // { // DCC_Request = dtRequestMetrics.Columns; // InitializeColumnData_Request(ref dtRequestMetrics); // SetupMultiHeader_Request(dtRequestMetrics); // dtRequestMetrics.AcceptChanges(); // try // { // dtDescription = dtRequestMetrics.Copy(); // dtDescription.DefaultView.RowFilter = "TypeLabel = 'Description'"; // dtDescription = dtDescription.DefaultView.ToTable(); // if (dtDescription != null && dtDescription.Rows.Count > 0) // { // InvestigationDescription = dtDescription.Rows[0]["Investigation"].ToString(); // PlanningDescription = dtDescription.Rows[0]["Planning"].ToString(); // DesignDescription = dtDescription.Rows[0]["Design"].ToString(); // DevelopDescription = dtDescription.Rows[0]["Develop"].ToString(); // TestingDescription = dtDescription.Rows[0]["Testing"].ToString(); // DeployDescription = dtDescription.Rows[0]["Deploy"].ToString(); // ReviewDescription = dtDescription.Rows[0]["Review"].ToString(); // } // } // catch (Exception) { } // } // gridRequestMetrics.DataSource = dtRequestMetrics; // gridRequestMetrics.DataBind(); //} }