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