protected void InitializeColumnData(ref DataTable dt)
{
try
{
string displayName = string.Empty, groupName = string.Empty;
bool blnVisible = false, blnSortable = false, blnOrderable = false;
foreach (DataColumn gridColumn in dt.Columns)
{
displayName = gridColumn.ColumnName;
blnVisible = false;
blnSortable = false;
blnOrderable = true;
groupName = string.Empty;
switch (gridColumn.ColumnName)
{
case "A":
displayName = ddlChildView.SelectedItem.ToString() + "s";
blnVisible = true;
blnOrderable = false;
break;
case "X":
displayName = "Delete";
blnVisible = true;
blnOrderable = false;
break;
case "WTS_SystemSuite":
displayName = "Suite";
blnVisible = true;
blnSortable = true;
break;
case "WTS_SYSTEM":
displayName = "System(Task)";
blnVisible = true;
blnSortable = true;
break;
case "DESCRIPTION":
displayName = "Description";
blnVisible = true;
break;
case "CONTRACT":
displayName = "Contract";
blnVisible = true;
break;
case "BusWorkloadManager":
displayName = "Bus Workload Manager";
blnVisible = true;
blnSortable = true;
break;
case "DevWorkloadManager":
displayName = "Dev Workload Manager";
blnVisible = true;
blnSortable = true;
break;
case "WorkArea_Count":
displayName = "Work Areas";
if (cvValue == "0")
{
blnVisible = true;
blnSortable = true;
}
break;
case "Work Area Added":
displayName = "Last Work Area Added";
if (cvValue == "0")
{
blnVisible = true;
blnSortable = true;
}
break;
case "Work Area Review":
displayName = "Work Areas Reviewed";
if (cvValue == "0")
{
blnVisible = true;
blnSortable = true;
}
break;
case "WorkItem_Count":
displayName = "Primary Tasks";
blnVisible = true;
blnSortable = true;
break;
case "SORT_ORDER":
displayName = "Sort Order";
blnVisible = true;
blnSortable = true;
break;
case "ARCHIVE":
displayName = "Archive";
blnVisible = true;
blnSortable = true;
break;
}
columnData.Columns.Add(gridColumn.ColumnName, displayName, blnVisible, blnSortable);
columnData.Columns.Item(columnData.Columns.Count - 1).CanReorder = blnOrderable;
columnData.Columns.Item(columnData.Columns.Count - 1).Viewable = blnVisible;
}
//Initialize the columnData
columnData.Initialize(ref dt, ";", "~", "|");
//Get sortable columns and default column order
SortableColumns = columnData.SortableColumnsToString();
DefaultColumnOrder = columnData.DefaultColumnOrderToString();
//Sort and Reorder Columns
columnData.ReorderDataTable(ref dt, ColumnOrder);
SortOrder = Workload.GetSortValuesFromDB(1, "MDGRID_SYSTEM.ASPX");
columnData.SortDataTable(ref dt, SortOrder);
SelectedColumnOrder = columnData.CurrentColumnOrderToString();
}
catch (Exception ex)
{
LogUtility.LogException(ex);
}
}
protected void InitializeColumnData_WorkItem(ref DataTable dt)
{
try
{
string displayName = string.Empty, groupName = string.Empty;
bool blnVisible = false, isViewable = false, blnSortable = false, blnOrderable = false;
foreach (DataColumn gridColumn in dt.Columns)
{
displayName = gridColumn.ColumnName;
blnVisible = false;
blnSortable = false;
blnOrderable = true;
isViewable = false;
groupName = string.Empty;
switch (gridColumn.ColumnName)
{
//case "WORKREQUESTID":
// displayName = "Request Number";
// blnVisible = false;
// isViewable = true;
// blnSortable = false;
// blnOrderable = false;
// break;
//case "WORKREQUEST":
// displayName = "Request";
// blnVisible = true;
// isViewable = true;
// blnSortable = true;
// break;
case "ItemID":
displayName = "Task Number";
blnVisible = true;
isViewable = true;
blnSortable = true;
blnOrderable = false;
break;
case "WORKITEMTYPE":
displayName = "Work Activity";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "Websystem":
displayName = "System(Task)";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "TITLE":
displayName = "Description";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
//case "ALLOCATION":
// displayName = "Allocation Assignment";
// blnVisible = true;
// isViewable = true;
// blnSortable = true;
// break;
case "ProductionStatus":
displayName = "Production Status";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "Version":
displayName = "Version";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "PRIORITY":
displayName = "Priority";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "Primary_Analyst":
displayName = "Primary Analyst";
blnVisible = false;
isViewable = true;
blnSortable = false;
break;
case "Primary_Developer":
displayName = "Primary Developer";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "Assigned":
displayName = "Assigned";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "SubmittedBy":
displayName = "Submitted";
blnVisible = true;
blnSortable = true;
blnOrderable = true;
isViewable = true;
break;
case "WorkType":
displayName = "Resource Group";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "STATUS":
displayName = "Status";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "Progress":
displayName = "Progress";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
case "ARCHIVE":
displayName = "Archive";
blnVisible = true;
isViewable = true;
blnSortable = true;
break;
}
columnData.Columns.Add(gridColumn.ColumnName, displayName, blnVisible, blnSortable);
columnData.Columns.Item(columnData.Columns.Count - 1).CanReorder = blnOrderable;
columnData.Columns.Item(columnData.Columns.Count - 1).Viewable = isViewable;
}
//Initialize the columnData
columnData.Initialize(ref dt, ";", "~", "|");
//Get sortable columns and default column order
SortableColumns = columnData.SortableColumnsToString();
DefaultColumnOrder = columnData.DefaultColumnOrderToString();
//Sort and Reorder Columns
columnData.ReorderDataTable(ref dt, ColumnOrder);
SortOrder = Workload.GetSortValuesFromDB(1, "WORKITEMGRID_QM.ASPX");
columnData.SortDataTable(ref dt, SortOrder);
SelectedColumnOrder = columnData.CurrentColumnOrderToString();
}
catch (Exception ex)
{
LogUtility.LogException(ex);
}
}
public static string GetSortOptionsFromDB(int openerPageID, string gridName)
{
return(Workload.GetSortValuesFromDB(openerPageID, gridName));
}
