public string CurrentColumnOrderToString()
{
string strOrder = "";
try
{
for (int i = 0; i < _Columns.Count; i++)
{
GridColsColumn sColumn = _Columns.ItemByColumnOrder(i);
if ((sColumn == null) == false)
{
if (string.IsNullOrEmpty(strOrder))
{
strOrder = sColumn.ColumnName + _ColumnDelimeter2 + ReplaceHTMLTags(sColumn.DisplayName, " ") + _ColumnDelimeter2 + sColumn.Visible.ToString().ToLower() + _ColumnDelimeter2 + sColumn.CanReorder.ToString().ToLower() + _ColumnDelimeter2 + sColumn.GroupName + _ColumnDelimeter2 + sColumn.Viewable;
}
else
{
strOrder += _ColumnDelimeter1 + sColumn.ColumnName + _ColumnDelimeter2 + ReplaceHTMLTags(sColumn.DisplayName, " ") + _ColumnDelimeter2 + sColumn.Visible.ToString().ToLower() + _ColumnDelimeter2 + sColumn.CanReorder.ToString().ToLower() + _ColumnDelimeter2 + sColumn.GroupName + _ColumnDelimeter2 + sColumn.Viewable;
}
}
}
}
catch (Exception ex)
{
}
return(strOrder);
}
public GridColsColumn Add()
{
GridColsColumn Column = new GridColsColumn();
Column.ColumnIndex = List.Count;
List.Add(Column);
return(Column);
}
public void SetupGridHeader(GridViewRow row)
{
try
{
RemoveGridColumns(row);
for (int i = 0; i < row.Cells.Count; i++)
{
if (_Columns.ItemByColumnOrder(i) != null)
{
row.Cells[i].Text = _Columns.ItemByColumnOrder(i).DisplayName;
}
}
if (_Groups != null && _Groups.Count > 0)
{
GridColsColumn tColumn = null;
for (int y = 0; y < row.Cells.Count; y++)
{
tColumn = _Columns.ItemByColumnOrder(y);
if (tColumn == null || string.IsNullOrEmpty(tColumn.GroupName))
{
if (row.RowIndex == 0)
{
row.Cells[y].RowSpan = 2;
}
else
{
row.Cells[y].Style["display"] = "none";
}
}
}
if (row.RowIndex == 0)
{
int startColumn = 0, lastColumn = 0;
for (int z = 0; z < _Groups.Count; z++)
{
startColumn = _Columns.Item(_Groups.Item(z).FirstColumnName).ColumnIndex;
lastColumn = _Columns.Item(_Groups.Item(z).LastColumnName).ColumnIndex + 1;
row.Cells[startColumn].ColumnSpan = _Groups.Item(z).ColumnSpan;
row.Cells[startColumn].Text = _Groups.Item(z).GroupName;
startColumn += 1;
for (int i = startColumn; i < lastColumn; i++)
{
row.Cells[i].Style["display"] = "none";
}
}
}
}
}
catch (Exception ex)
{
string msg = string.Empty;
}
}
public GridColsColumn Add(string ColumnName, string DisplayName)
{
GridColsColumn Column = new GridColsColumn();
Column.ColumnName = ColumnName;
Column.DisplayName = DisplayName;
Column.ColumnIndex = List.Count;
List.Add(Column);
return(Column);
}
public GridColsColumn Add(string ColumnName, string DisplayName, bool Visible, bool Sortable)
{
GridColsColumn Column = new GridColsColumn();
Column.ColumnName = ColumnName;
Column.DisplayName = DisplayName;
Column.SortName = DisplayName;
Column.Visible = Visible;
Column.ColumnIndex = List.Count;
Column.CanSort = Sortable;
List.Add(Column);
return(Column);
}
public List <GridColsColumn> VisibleColumnsList()
{
List <GridColsColumn> columns = new List <GridColsColumn>();
GridColsColumn gcc = null;
for (int i = 0; i <= _Columns.Count; i++)
{
gcc = _Columns.ItemByColumnOrder(i);
if ((gcc == null) == false && gcc.Visible == true)
{
columns.Add(gcc);
}
}
return(columns);
}
public GridColsCollection VisibleColumns()
{
GridColsCollection columns = new GridColsCollection();
GridColsColumn gcc = null;
for (int i = 0; i <= _Columns.Count; i++)
{
gcc = _Columns.ItemByColumnOrder(i);
if ((gcc == null) == false && gcc.Visible == true)
{
columns.Add(gcc.ColumnName, gcc.DisplayName, gcc.Visible, gcc.CanSort);
columns.Item(columns.Count - 1).ColumnIndex = gcc.ColumnIndex;
columns.Item(columns.Count - 1).Viewable = gcc.Viewable;
}
}
return(columns);
}
private void RenameExcelColumns(ref DataTable dt)
{
GridColsCollection cols = columnData.VisibleColumns();
GridColsColumn gcCol = null;
DataColumn col = null;
for (int i = dt.Columns.Count - 1; i >= 0; i--)
{
col = dt.Columns[i];
gcCol = cols.ItemByColumnName(col.ColumnName);
if (gcCol != null)
{
dt.Columns[col.ColumnName].ColumnName = gcCol.DisplayName;
}
}
dt.AcceptChanges();
}
public GridColsCollection CurrentOrderedColumns()
{
GridColsCollection oColumns = new GridColsCollection();
for (int i = 0; i < _Columns.Count; i++)
{
GridColsColumn testColumn = _Columns.ItemByColumnOrder(i);
if ((testColumn == null) == false)
{
if (testColumn.CanReorder == true & testColumn.Viewable == true)
{
oColumns.Add(testColumn.ColumnName, testColumn.DisplayName, testColumn.Visible, testColumn.CanSort);
oColumns.Item(oColumns.Count - 1).ColumnIndex = testColumn.ColumnIndex;
oColumns.Item(oColumns.Count - 1).Viewable = testColumn.Viewable;
}
}
}
return(oColumns);
}
public void ReorderDataTable(ref DataTable dt, string orderColumns)
{
if (!string.IsNullOrEmpty(orderColumns))
{
try
{
string[] splitColumns = orderColumns.Split(_ColumnDelimeter1);
dynamic columnLength = splitColumns.Length;
for (int i = 0; i < columnLength; i++)
{
string columnName = splitColumns[i].Split(_ColumnDelimeter2)[0];
string visible = splitColumns[i].Split(_ColumnDelimeter2)[2];
GridColsColumn sColumn = null;
if (IsColumnInOrderList(splitColumns, ReplaceHTMLTags(_Columns.Item(i).ColumnName, " ")) == false)
{
sColumn = _Columns.Item(i);
columnLength += 1;
}
else
{
sColumn = _Columns.ItemByColumnName(columnName);
}
if ((sColumn == null) == false)
{
sColumn.ColumnIndex = i;
sColumn.Visible = (visible.ToUpper() == "TRUE" ? true : false);
dt.Columns[sColumn.ColumnName].SetOrdinal(sColumn.ColumnIndex);
}
}
}
catch (Exception ex)
{
string msg = string.Empty;
}
dt.AcceptChanges();
UpdateColumnGroups();
}
}
private void loadData()
{
DataTable dt = loadFromData(includeArchive: this.IncludeArchive, myData: this.MyData);
initializeColumnData(ref dt);
ListItem item = null;
// list is IEnumerable<int> (e.g., List<int>)
var ordered = _gridColumns.Keys.OrderBy(k => _gridColumns[k].DisplayName).ToList();
foreach (string key in ordered)
{
GridColsColumn col = _gridColumns[key];
if (col.Visible && col.ColumnName != "Version")
{
item = new ListItem(col.DisplayName, col.ColumnName);
item.Attributes.Add("id_field", col.SortName);
ddlAttribute.Items.Add(item);
}
}
}
public string[] VisibleColumnNamesArray()
{
GridColsCollection columns = VisibleColumns();
if ((columns == null) || columns.Count == 0)
{
return(new string[] { "" });
}
string[] colArray = new string[columns.Count + 1];
GridColsColumn gcc = null;
for (int i = 0; i <= columns.Count; i++)
{
gcc = columns.ItemByColumnOrder(i);
if ((gcc != null) && gcc.Visible)
{
colArray[i] = gcc.ColumnName;
}
}
return(colArray);
}
public static string LoadEntityFields(string entityType)
{
DataTable dtNew = new DataTable();
DataColumnCollection DCC;
Dictionary <string, GridColsColumn> _gridColumns = new Dictionary <string, GridColsColumn>();
GridCols _columnData = new GridCols();
DataTable dt = new DataTable();
int AOR_ID = 0;
bool isVisible = false;
string dbName = string.Empty, displayName = string.Empty, idField = string.Empty;
var ordered = _gridColumns.Keys.OrderBy(k => _gridColumns[k].DisplayName).ToList();
try
{
switch (entityType.ToUpper())
{
case "AOR":
dt = AOR.AORList_Get(AORID: AOR_ID);
_gridColumns = new Dictionary <string, GridColsColumn>();
GridColsColumn column = new GridColsColumn();
dbName = string.Empty;
displayName = string.Empty;
idField = string.Empty;
isVisible = false;
foreach (DataColumn gridColumn in dt.Columns)
{
column = new GridColsColumn();
displayName = gridColumn.ColumnName;
idField = gridColumn.ColumnName;
isVisible = false;
switch (gridColumn.ColumnName)
{
//case "Current Release":
// displayName = "Current Release";
// idField = "ProductVersion_ID";
// isVisible = true;
// break;
case "Workload Allocation":
displayName = "Workload Allocation";
idField = "WorkloadAllocation_ID";
isVisible = true;
break;
}
if (isVisible)
{
column.ColumnName = gridColumn.ColumnName;
column.DisplayName = displayName;
column.Visible = isVisible;
column.SortName = idField;
_gridColumns.Add(column.DisplayName, column);
}
}
//Initialize the columnData
_columnData.Initialize(ref dt, ";", "~", "|");
dtNew.Columns.Add("valueField");
dtNew.Columns.Add("textField");
dtNew.Columns.Add("id_field");
ordered = _gridColumns.Keys.OrderBy(k => _gridColumns[k].DisplayName).ToList();
foreach (string key in ordered)
{
GridColsColumn col = _gridColumns[key];
if (col.Visible)
{
DataRow dr = dtNew.NewRow();
dr[0] = col.ColumnName;
dr[1] = col.DisplayName;
dr[2] = col.SortName;
dtNew.Rows.Add(dr);
}
}
break;
case "CR":
dt = AOR.AORCRList_Get(AORID: AOR_ID, AORReleaseID: 0, CRID: 0);
_gridColumns = new Dictionary <string, GridColsColumn>();
column = new GridColsColumn();
dbName = string.Empty;
displayName = string.Empty;
idField = string.Empty;
isVisible = false;
foreach (DataColumn gridColumn in dt.Columns)
{
column = new GridColsColumn();
displayName = gridColumn.ColumnName;
idField = gridColumn.ColumnName;
isVisible = false;
switch (gridColumn.ColumnName)
{
case "Contract":
displayName = "Contract";
idField = "Contract_ID";
isVisible = true;
break;
case "Websystem":
displayName = "Websystem";
idField = "Websystem_ID";
isVisible = false;
break;
case "Related Release":
displayName = "Related Release";
idField = "RelatedRelease_ID";
isVisible = false;
break;
case "Status":
displayName = "CR Coordination";
idField = "Status_ID";
isVisible = true;
break;
case "CyberISMT":
displayName = "Cyber/ISMT";
idField = "CyberISMT_ID";
isVisible = false;
break;
}
if (isVisible)
{
column.ColumnName = gridColumn.ColumnName;
column.DisplayName = displayName;
column.Visible = isVisible;
column.SortName = idField;
_gridColumns.Add(column.DisplayName, column);
}
}
//Initialize the columnData
_columnData.Initialize(ref dt, ";", "~", "|");
dtNew.Columns.Add("valueField");
dtNew.Columns.Add("textField");
dtNew.Columns.Add("id_field");
ordered = _gridColumns.Keys.OrderBy(k => _gridColumns[k].DisplayName).ToList();
foreach (string key in ordered)
{
GridColsColumn col = _gridColumns[key];
if (col.Visible)
{
DataRow dr = dtNew.NewRow();
dr[0] = col.ColumnName;
dr[1] = col.DisplayName;
dr[2] = col.SortName;
dtNew.Rows.Add(dr);
}
}
break;
case "PRIMARYTASK":
dt = AOR.AORTaskList_Get(AORID: AOR_ID, AORReleaseID: 0);
// dt = WorkloadItem.WorkItemList_Get(workRequestID: 0
//, showArchived: 0
//, columnListOnly: 0
//, myData: false);
_gridColumns = new Dictionary <string, GridColsColumn>();
column = new GridColsColumn();
dbName = string.Empty;
displayName = string.Empty;
idField = string.Empty;
isVisible = false;
foreach (DataColumn gridColumn in dt.Columns)
{
column = new GridColsColumn();
displayName = gridColumn.ColumnName;
idField = gridColumn.ColumnName;
isVisible = false;
switch (gridColumn.ColumnName)
{
case "System(Task)":
displayName = "System(Task)";
idField = "WTS_SYSTEM_ID";
isVisible = true;
break;
case "Production Status":
displayName = "Production Status";
idField = "ProductionStatus_ID";
isVisible = true;
break;
//case "Product Version":
// displayName = "Product Version";
// idField = "ProductVersion_ID";
// isVisible = true;
// break;
case "Priority":
displayName = "Priority";
idField = "PRIORITY_ID";
isVisible = true;
break;
case "Primary Resource":
displayName = "Primary Resource";
idField = "PrimaryTechResource_ID";
isVisible = true;
break;
case "Assigned To":
displayName = "Assigned To";
idField = "AssignedTo_ID";
isVisible = true;
break;
case "Status":
displayName = "Status";
idField = "STATUS_ID";
isVisible = true;
break;
case "Percent Complete":
displayName = "Percent Complete";
idField = "PercentComplete_ID";
isVisible = false;
break;
}
if (isVisible)
{
column.ColumnName = gridColumn.ColumnName;
column.DisplayName = displayName;
column.Visible = isVisible;
column.SortName = idField;
_gridColumns.Add(column.DisplayName, column);
}
}
//Initialize the columnData
_columnData.Initialize(ref dt, ";", "~", "|");
dtNew.Columns.Add("valueField");
dtNew.Columns.Add("textField");
dtNew.Columns.Add("id_field");
ordered = _gridColumns.Keys.OrderBy(k => _gridColumns[k].DisplayName).ToList();
foreach (string key in ordered)
{
GridColsColumn col = _gridColumns[key];
if (col.Visible)
{
DataRow dr = dtNew.NewRow();
dr[0] = col.DisplayName;
dr[1] = col.ColumnName;
dr[2] = col.SortName;
dtNew.Rows.Add(dr);
}
}
break;
case "SUBTASK":
//dt = AOR.AORTaskList_Get(AORID: AOR_ID, AORReleaseID: 0);
dt = WorkloadItem.WorkItem_GetTaskList(workItemID: 0, showArchived: 0, showBacklog: false);
_gridColumns = new Dictionary <string, GridColsColumn>();
column = new GridColsColumn();
dbName = string.Empty;
displayName = string.Empty;
idField = string.Empty;
isVisible = false;
foreach (DataColumn gridColumn in dt.Columns)
{
column = new GridColsColumn();
displayName = gridColumn.ColumnName;
idField = gridColumn.ColumnName;
isVisible = false;
switch (gridColumn.ColumnName)
{
case "AssignedResource":
displayName = "Assigned To";
idField = "ASSIGNEDRESOURCEID";
isVisible = true;
break;
case "Production Status":
displayName = "Production Status";
idField = "ProductionStatus_ID";
isVisible = true;
break;
//case "Product Version":
// displayName = "Product Version";
// idField = "ProductVersion_ID";
// isVisible = true;
// break;
case "Priority":
displayName = "Priority";
idField = "PRIORITY_ID";
isVisible = true;
break;
case "Primary Resource":
displayName = "Primary Resource";
idField = "PrimaryTechResource_ID";
isVisible = true;
break;
case "Assigned To":
displayName = "Assigned To";
idField = "AssignedTo_ID";
isVisible = true;
break;
case "Status":
displayName = "Status";
idField = "STATUS_ID";
isVisible = true;
break;
case "Percent Complete":
displayName = "Percent Complete";
idField = "PercentComplete_ID";
isVisible = false;
break;
}
if (isVisible)
{
column.ColumnName = gridColumn.ColumnName;
column.DisplayName = displayName;
column.Visible = isVisible;
column.SortName = idField;
_gridColumns.Add(column.DisplayName, column);
}
}
//Initialize the columnData
_columnData.Initialize(ref dt, ";", "~", "|");
dtNew.Columns.Add("valueField");
dtNew.Columns.Add("textField");
dtNew.Columns.Add("id_field");
ordered = _gridColumns.Keys.OrderBy(k => _gridColumns[k].DisplayName).ToList();
foreach (string key in ordered)
{
GridColsColumn col = _gridColumns[key];
if (col.Visible)
{
DataRow dr = dtNew.NewRow();
dr[0] = col.ColumnName;
dr[1] = col.DisplayName;
dr[2] = col.SortName;
dtNew.Rows.Add(dr);
}
}
break;
}
}
catch (Exception ex)
{
LogUtility.LogException(ex);
}
return(JsonConvert.SerializeObject(dtNew, Newtonsoft.Json.Formatting.None));
}
protected void initializeColumnData(ref DataTable dt)
{
_gridColumns = new Dictionary <string, GridColsColumn>();
try
{
GridColsColumn column = new GridColsColumn();
string dbName = string.Empty, displayName = string.Empty, idField = string.Empty;
bool isVisible = false;
foreach (DataColumn gridColumn in dt.Columns)
{
column = new GridColsColumn();
displayName = gridColumn.ColumnName;
idField = gridColumn.ColumnName;
isVisible = false;
switch (gridColumn.ColumnName)
{
//case "WORKREQUEST":
// displayName = "Work Request";
// idField = "WORKREQUESTID";
// isVisible = true;
// break;
case "WORKITEMTYPE":
displayName = "Work Activity";
idField = "WORKITEMTYPEID";
isVisible = true;
break;
case "Websystem":
displayName = "System(Task)";
idField = "WTS_SYSTEMID";
isVisible = true;
break;
//case "ALLOCATION":
// displayName = "Allocation Assignment";
// idField = "ALLOCATIONID";
// isVisible = true;
// break;
case "WorkloadGroup":
displayName = "Workload Group";
idField = "WorkloadGroupID";
isVisible = true;
break;
case "WorkArea":
displayName = "Work Area";
idField = "WorkAreaID";
isVisible = true;
break;
case "Production":
displayName = "Production";
idField = "Production";
isVisible = false;
break;
case "Version":
displayName = "Release Version";
idField = "ProductVersionID";
isVisible = true;
break;
case "PRIORITY":
displayName = "Priority";
idField = "PRIORITYID";
isVisible = true;
break;
case "Primary_Developer":
displayName = "Primary Developer";
idField = "PRIMARYRESOURCEID";
isVisible = true;
break;
case "Assigned":
displayName = "Assigned To";
idField = "ASSIGNEDRESOURCEID";
isVisible = true;
break;
case "WorkType":
displayName = "Resource Group";
idField = "WorkTypeID";
isVisible = true;
break;
case "STATUS":
displayName = "Status";
idField = "STATUSID";
isVisible = false;
break;
case "Progress":
displayName = "Percent Complete";
idField = "Progress";
isVisible = false;
break;
case "ARCHIVE":
displayName = "Archive";
idField = "ARCHIVE";
isVisible = false;
break;
}
if (isVisible)
{
column.ColumnName = gridColumn.ColumnName;
column.DisplayName = displayName;
column.Visible = isVisible;
column.SortName = idField;
_gridColumns.Add(column.DisplayName, column);
}
//_columnData.Columns.Add(ColumnName: gridColumn.ColumnName, DisplayName: displayName, SortName: idField, Visible: isVisible, Sortable: false);
}
//Initialize the columnData
_columnData.Initialize(ref dt, ";", "~", "|");
}
catch (Exception ex)
{
LogUtility.LogException(ex);
}
}
public void Add(GridColsColumn Column)
{
Column.ColumnIndex = List.Count;
List.Add(Column);
}
