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();
//}
}