private void loadGridData(bool bind = true)
{
_dtResources = MasterData.WTS_Resource_Get(includeArchive: false);
_dtUser = UserManagement.LoadUserList(organizationId: 0, excludeDeveloper: false, loadArchived: false, userNameSearch: "");
Page.ClientScript.RegisterArrayDeclaration("_userList", JsonConvert.SerializeObject(_dtUser, Newtonsoft.Json.Formatting.None));
DataTable dt = null, dtTemp = null;
DataSet ds = null;
if (_refreshData || Session["dtMD_AllocationDS"] == null)
{
ds = MasterData.AllocationList_Get(includeArchive: true);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables.Contains("Allocation"))
{
dt = ds.Tables["Allocation"];
HttpContext.Current.Session["dtMD_AllocationDS"] = ds;
}
}
}
else
{
ds = (DataSet) HttpContext.Current.Session["dtMD_AllocationDS"];
if (ds.Tables.Contains("Allocation"))
{
dt = ds.Tables["Allocation"];
}
}
if (dt != null)
{
// 12902 - 3:
dtTemp = dt.DefaultView.ToTable(true, new string[] { "AllocationGroupID", "AllocationGroup", "AllocationCategoryID", "AllocationCategory" });
dtTemp.DefaultView.RowFilter = "AllocationGroupID IS NOT NULL";
//dtTemp = dt.DefaultView.ToTable(true, new string[] { "AllocationCategoryID", "AllocationCategory" });
//dtTemp.DefaultView.RowFilter = "AllocationCategoryID IS NOT NULL";
dtTemp = dtTemp.DefaultView.ToTable();
this.DCC = dt.Columns;
Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None));
if (ds.Tables.Contains("Category"))
{
_dtCat = ds.Tables["Category"];
Page.ClientScript.RegisterArrayDeclaration("_AllocationCategoryList", JsonConvert.SerializeObject(_dtCat, Newtonsoft.Json.Formatting.None));
}
//12092 - 3:
if (ds.Tables.Contains("Group"))
{
_dtGroup = ds.Tables["Group"];
Page.ClientScript.RegisterArrayDeclaration("_AllocationGroupList", JsonConvert.SerializeObject(_dtGroup, Newtonsoft.Json.Formatting.None));
}
ListItem item = null;
foreach (DataRow row in dtTemp.Rows)
{
item = ddlQF.Items.FindByValue(row["AllocationCategoryID"].ToString());
if (item == null)
{
ddlQF.Items.Add(new ListItem(row["AllocationCategory"].ToString(), row["AllocationCategoryID"].ToString()));
}
// 12902 - 3:
item = ddlQFGroup.Items.FindByValue(row["AllocationGroupID"].ToString());
if (item == null)
{
ddlQFGroup.Items.Add(new ListItem(row["AllocationGroup"].ToString(), row["AllocationGroupID"].ToString()));
}
}
// 12092 - 3 - Remarked out:
// item = ddlQF.Items.FindByValue(_qfAllocationCategoryID.ToString());
//if (item != null)
//{
// item.Selected = true;
//}
// 12092 - 3:
item = ddlQFGroup.Items.FindByValue(_qfAllocationGroupID.ToString());
if (item != null)
{
item.Selected = true;
}
InitializeColumnData(ref dt);
dt.AcceptChanges();
iti_Tools_Sharp.DynamicHeader head = WTSUtility.CreateGridMultiHeader(dt);
if (head != null)
{
grdMD.DynamicHeader = head;
}
}
// 12902 - 3:
if (_qfAllocationGroupID != 0 && dt != null && dt.Rows.Count > 0)
{
dt.DefaultView.RowFilter = string.Format(" AllocationGroupID = {0}", _qfAllocationGroupID.ToString());
dt = dt.DefaultView.ToTable();
}
//if (_qfAllocationCategoryID != 0 && dt != null && dt.Rows.Count > 0)
//{
// dt.DefaultView.RowFilter = string.Format(" AllocationCategoryID = {0}", _qfAllocationCategoryID.ToString());
// dt = dt.DefaultView.ToTable();
//}
int count = dt.Rows.Count;
count = count > 0 ? count - 1 : count; //need to subtract the empty row
spanRowCount.InnerText = count.ToString();
if (_export)
{
exportExcel(dt);
}
grdMD.DataSource = dt;
if (bind) grdMD.DataBind();
}
protected static DataTable GetMasterDataValues(string idField, string columnName, string textField, bool includeArchive = false)
{
DataSet ds = null;
DataTable dt = null;
try
{
switch (columnName.ToUpper())
{
case "ALLOCATION":
ds = MasterData.AllocationList_Get(includeArchive: includeArchive);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
dt = ds.Tables[0];
dt.Columns["ALLOCATIONID"].ColumnName = "valueField";
dt.Columns["ALLOCATION"].ColumnName = "textField";
}
break;
case "ARCHIVE":
dt = new DataTable();
dt.Columns.Add("valueField");
dt.Columns.Add("textField");
dt.AcceptChanges();
dt.Rows.Add(new object[] { "0", "No" });
dt.Rows.Add(new object[] { "1", "Yes" });
break;
case "ASSIGNED":
dt = UserManagement.LoadUserList(organizationId: 0, excludeDeveloper: false, loadArchived: includeArchive, userNameSearch: "");
if (dt != null)
{
dt.Columns["WTS_RESOURCEID"].ColumnName = "valueField";
dt.Columns["UserName"].ColumnName = "textField";
}
break;
case "PRIMARY_DEVELOPER":
dt = UserManagement.LoadUserList(organizationId: 0, excludeDeveloper: false, loadArchived: includeArchive, userNameSearch: "");
if (dt != null)
{
dt.Columns["WTS_RESOURCEID"].ColumnName = "valueField";
dt.Columns["UserName"].ColumnName = "textField";
}
break;
case "WORKITEMTYPE":
dt = MasterData.WorkItemTypeList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt.Columns["WORKITEMTYPEID"].ColumnName = "valueField";
dt.Columns["WORKITEMTYPE"].ColumnName = "textField";
}
break;
case "PRIORITY":
dt = MasterData.PriorityList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt.DefaultView.RowFilter = "PriorityType = 'Work Item'";
dt = dt.DefaultView.ToTable();
dt.Columns["PriorityID"].ColumnName = "valueField";
dt.Columns["Priority"].ColumnName = "textField";
}
break;
case "PRODUCTION":
dt = new DataTable();
dt.Columns.Add("valueField");
dt.Columns.Add("textField");
dt.AcceptChanges();
dt.Rows.Add(new object[] { "0", "No" });
dt.Rows.Add(new object[] { "1", "Yes" });
break;
case "VERSION":
dt = MasterData.ProductVersionList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt = dt.DefaultView.ToTable();
dt.Columns["ProductVersionID"].ColumnName = "valueField";
dt.Columns["ProductVersion"].ColumnName = "textField";
}
break;
case "WEBSYSTEM":
dt = MasterData.SystemList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt = dt.DefaultView.ToTable();
dt.Columns["WTS_SYSTEMID"].ColumnName = "valueField";
dt.Columns["WTS_SYSTEM"].ColumnName = "textField";
}
break;
case "WORKAREA":
dt = MasterData.WorkAreaList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt = dt.DefaultView.ToTable();
dt.Columns["WorkAreaID"].ColumnName = "valueField";
dt.Columns["WorkArea"].ColumnName = "textField";
}
break;
case "WORKREQUEST":
dt = WorkRequest.WorkRequestList_Get(typeID: 0, requestGroupID: 0, myData: false);
if (dt != null)
{
dt = dt.DefaultView.ToTable();
dt.Columns["WORKREQUESTID"].ColumnName = "valueField";
dt.Columns["TITLE"].ColumnName = "textField";
}
break;
case "WORKTYPE":
dt = MasterData.WorkTypeList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt.Columns["WORKTYPEID"].ColumnName = "valueField";
dt.Columns["WORKTYPE"].ColumnName = "textField";
}
break;
case "WORKLOADGROUP":
dt = MasterData.WorkloadGroupList_Get(includeArchive: includeArchive);
if (dt != null)
{
dt = dt.DefaultView.ToTable();
dt.Columns["WorkloadGroupID"].ColumnName = "valueField";
dt.Columns["WorkloadGroup"].ColumnName = "textField";
}
break;
default:
dt = null;
break;
}
}
catch (Exception ex)
{
LogUtility.LogException(ex);
dt = null;
}
return(dt);
}
private void loadGridData()
{
_dtSystem = MasterData.SystemList_Get(includeArchive: false);
if (_dtSystem != null && _qfSystemID != 0)
{
_dtSystem.DefaultView.RowFilter = string.Format(" WTS_SYSTEMID IN (0, {0}) ", _qfSystemID.ToString());
_dtSystem = _dtSystem.DefaultView.ToTable();
}
DataSet dsAllocation = MasterData.AllocationList_Get(includeArchive: false);
if (dsAllocation != null && dsAllocation.Tables.Count > 0)
{
_dtAllocation = dsAllocation.Tables[0];
}
if (_dtAllocation != null && _qfAllocationID != 0)
{
_dtAllocation.DefaultView.RowFilter = string.Format(" AllocationID = {0} ", _qfAllocationID.ToString());
_dtAllocation = _dtAllocation.DefaultView.ToTable();
}
DataTable dt = MasterData.Allocation_SystemList_Get(allocationID: this._qfAllocationID, systemID: this._qfSystemID);
if (dt != null)
{
if (_qfSystemID > 0)
{
dt.Columns["WTS_SYSTEM"].SetOrdinal(dt.Columns["AllocationID"].Ordinal);
dt.Columns["WTS_SYSTEMID"].SetOrdinal(dt.Columns["WTS_SYSTEM"].Ordinal);
dt.AcceptChanges();
}
this.DCC = dt.Columns;
Page.ClientScript.RegisterArrayDeclaration("_dcc", JsonConvert.SerializeObject(DCC, Newtonsoft.Json.Formatting.None));
ListItem item = null;
foreach (DataRow row in _dtAllocation.Rows)
{
item = ddlQF.Items.FindByValue(row["AllocationID"].ToString());
if (item == null)
{
ddlQF.Items.Add(new ListItem(row["Allocation"].ToString(), row["AllocationID"].ToString()));
}
}
item = ddlQF.Items.FindByValue(_qfAllocationID.ToString());
if (item != null)
{
item.Selected = true;
}
foreach (DataRow row in _dtSystem.Rows)
{
item = ddlQF_System.Items.FindByValue(row["WTS_SYSTEMID"].ToString());
if (item == null)
{
ddlQF_System.Items.Add(new ListItem(row["WTS_SYSTEM"].ToString(), row["WTS_SYSTEMID"].ToString()));
}
}
item = ddlQF_System.Items.FindByValue(_qfSystemID.ToString());
if (item != null)
{
item.Selected = true;
}
InitializeColumnData(ref dt);
dt.AcceptChanges();
}
if (_qfAllocationID != 0 && dt != null && dt.Rows.Count > 0)
{
dt.DefaultView.RowFilter = string.Format(" AllocationID = {0} OR (AllocationID = 0 AND WTS_SYSTEMID = 0) ", _qfAllocationID.ToString());
dt = dt.DefaultView.ToTable();
}
if (_qfSystemID != 0 && dt != null && dt.Rows.Count > 0)
{
dt.DefaultView.RowFilter = string.Format(" WTS_SYSTEMID = {0} OR (WTS_SYSTEMID = 0 AND AllocationID = 0) OR WTS_SYSTEMID IS NULL ", _qfSystemID.ToString());
dt = dt.DefaultView.ToTable();
}
int count = dt.Rows.Count;
count = count > 0 ? count - 1 : count; //need to subtract the empty row
spanRowCount.InnerText = count.ToString();
grdMD.DataSource = dt;
grdMD.DataBind();
}