protected void Page_Load(object sender, EventArgs e)
{
this.IsAdmin = UserManagement.UserIsInRole("Admin");
this.CanEdit = UserManagement.UserCanEdit(WTSModuleOption.MasterData);
this.CanView = (CanEdit || UserManagement.UserCanView(WTSModuleOption.MasterData));
ReadQueryString();
initControls();
//Gather RQMTAttribute data for dropdown(s)
if (Session["RQMTAttribute_Get"] == null)
{
dtRQMTAttribute = RQMT.RQMTAttribute_Get();
Session["RQMTAttribute_Get"] = dtRQMTAttribute;
}
else
{
dtRQMTAttribute = (DataTable)Session["RQMTAttribute_Get"];
}
DataTable dt = new DataTable();
dt = LoadData();
matchAORSRWebSystems = SR.GetAORWebSystemsForWTSSystem(SYSTEM_ID);
if (matchAORSRWebSystems.ToLower().IndexOf("wts") != -1)
{
matchAORSRWebSystems += ",wts"; // the aorsr forms of wts do not match the internal form, so we ensure that we get WTS results out of R&D WTS and other forms whenever a wts variant is present
}
grdData.DataSource = dt;
grdData.DataBind();
}
private void LoadControls()
{
// suites ddl
DataTable dtSuites = MasterData.SystemSuiteList_Get(0);
PopulateDDLFromDataTable(ddlSuite, dtSuites, "WTS_SYSTEM_SUITEID", "WTS_SYSTEM_SUITE", null, null, false);
SuiteOptions = CreateOptionStringFromDataTable(dtSuites, "WTS_SYSTEM_SUITEID", "WTS_SYSTEM_SUITE", "0", "", true);
// systems
DataTable dtSystems = MasterData.SystemList_Get(includeArchive: true, WTS_SYSTEM_SUITEID: 0);
SystemOptions = CreateOptionStringFromDataTable(dtSystems, "WTS_SYSTEMID", "WTS_SYSTEM", "0", "", true);
List <string> columnsToRemove = new List <string>();
List <string> columnsToKeep = new List <string>()
{
"WTS_SystemSuiteID", "WTS_SystemSuite", "WTS_SystemID", "WTS_SYSTEM"
};
foreach (DataColumn col in dtSystems.Columns)
{
if (!columnsToKeep.Contains(col.ColumnName))
{
columnsToRemove.Add(col.ColumnName);
}
}
foreach (string colName in columnsToRemove)
{
dtSystems.Columns.Remove(colName);
}
dtSystems.AcceptChanges();
dtSystems = dtSystems.DefaultView.ToTable(true);
dtSystemsJSON = JsonConvert.SerializeObject(dtSystems);
// workarea ddl
DataTable dtWorkAreas = MasterData.WorkAreaList_Get();
WorkAreaOptions = CreateOptionStringFromDataTable(dtWorkAreas, "WorkAreaID", "WorkArea", "0", "", true);
DataTable dtWorkAreaSystems = MasterData.WorkArea_SystemList_Get();
columnsToRemove = new List <string>();
columnsToKeep = new List <string>()
{
"WorkArea_SystemID", "WorkArea", "WorkAreaID", "WTS_SYSTEM", "WTS_SYSTEMID"
};
foreach (DataColumn col in dtWorkAreaSystems.Columns)
{
if (!columnsToKeep.Contains(col.ColumnName))
{
columnsToRemove.Add(col.ColumnName);
}
}
foreach (string colName in columnsToRemove)
{
dtWorkAreaSystems.Columns.Remove(colName);
}
dtWorkAreaSystems.AcceptChanges();
dtWorkAreaSystems = dtWorkAreaSystems.DefaultView.ToTable(true);
dtWorkAreaSystemsJSON = JsonConvert.SerializeObject(dtWorkAreaSystems);
// RQMTType ddl (purpose)
DataTable dtTypes = RQMT.RQMTTypeList_Get();
PopulateDDLFromDataTable(ddlRQMTType, dtTypes, "RQMTTypeID", "RQMTType", null, null, false, "InternalType");
RQMTTypeOptions = CreateOptionStringFromDataTable(dtTypes, "RQMTTypeID", "RQMTType", "0", "", true, "InternalType");
// Description Types option list
DataTable dtDescTypes = RQMT.RQMTDescriptionTypeList_Get();
DescriptionTypeOptions = CreateOptionStringFromDataTable(dtDescTypes, "RQMTDescriptionTypeID", "RQMTDescriptionType", null, null, true);
// RQMTComplexity
DataTable dtComplexity = RQMT.RQMTComplexityList_Get();
ComplexityOptions = CreateOptionStringFromDataTable(dtComplexity, "RQMTComplexityID", "RQMTComplexity", null, null, true);
// Functionality
DataTable dtFunctionality = MasterData.WorkloadGroupList_Get();
dtFunctionality.DefaultView.Sort = "WorkloadGroup";
dtFunctionality = dtFunctionality.DefaultView.ToTable();
FunctionalitySelectOptions = CreateOptionStringFromDataTable(dtFunctionality, "WorkloadGroupID", "WorkloadGroup", "0", "", true, null);
FunctionalityCheckBoxOptions = CreateCheckBoxStringFromDataTable(dtFunctionality, "WorkloadGroupID", "WorkloadGroup", true, 1, null);
// Attributes
AttributeOptions = new Dictionary <string, string>();
DataTable dtStage = RQMT.RQMTAttribute_Get((int)WTS.Enums.RQMTAttributeTypeEnum.Stage);
AttributeOptions["stage"] = CreateOptionStringFromDataTable(dtStage, "RQMTAttributeID", "RQMTAttribute", "0", "", true);
DataTable dtCrit = RQMT.RQMTAttribute_Get((int)WTS.Enums.RQMTAttributeTypeEnum.Criticality);
AttributeOptions["criticality"] = CreateOptionStringFromDataTable(dtCrit, "RQMTAttributeID", "RQMTAttribute", "0", "", true);
DataTable dtStatus = RQMT.RQMTAttribute_Get((int)WTS.Enums.RQMTAttributeTypeEnum.Status);
AttributeOptions["status"] = CreateOptionStringFromDataTable(dtStatus, "RQMTAttributeID", "RQMTAttribute", "0", "", true);
if (!string.IsNullOrWhiteSpace((string)Session["copied.rqmts"]))
{
string[] arr = ((string)Session["copied.rqmts"]).Split(',');
string[] rqmts = arr[0].Split('|');
CopiedRQMTs = "";
CopiedRQMTSystems = arr[1];
for (int i = 0; i < rqmts.Length; i++)
{
string rqmt = rqmts[i];
if (CopiedRQMTs.Length > 0)
{
CopiedRQMTs += ", ";
}
if (CopiedRQMTs.Contains(rqmt))
{
CopiedRQMTs += rqmt + "*";
}
else
{
CopiedRQMTs += rqmt;
}
}
}
//ShowMultipleSetQuickAddWarning
DataTable userSettingDt = LoggedInUser.UserSettingList_Get(LoggedInUserID, 2);
if (userSettingDt != null && userSettingDt.Rows.Count > 0 && userSettingDt.Rows[0]["SettingValue"].ToString() == "0")
{
QuickAddWarningEnabled = false;
}
}
private void LoadData()
{
// get the full attribute list
dtRQMTAttribute = RQMT.RQMTAttribute_Get();
if (!this.NewRQMT)
{
DataSet dsRQMT = RQMT.RQMTEditData_Get(RQMTID);
dtRQMT = dsRQMT.Tables["RQMT"];
if (dtRQMT.Rows.Count == 0)
{
pageIsInvalid = true;
return;
}
dtAllSets = dsRQMT.Tables["ALLSETS"];
dtAssociations = dsRQMT.Tables["ASSOCIATIONS"];
dtAttributes = dsRQMT.Tables["ATTRIBUTES"];
dtUsage = dsRQMT.Tables["USAGE"];
dtAvailableFunctionalities = dsRQMT.Tables["AVAILABLEFUNCTIONALITIES"];
dtFunctionality = dsRQMT.Tables["FUNCTIONALITY"];
dtDescriptions = dsRQMT.Tables["DESCRIPTIONS"];
dtDescriptionTypes = dsRQMT.Tables["DESCTYPES"];
dtDefects = dsRQMT.Tables["DEFECTS"];
dtDescriptionAttachments = dsRQMT.Tables["DESCATT"];
SetAssociationsCount = dtAssociations.Rows.Count;
SystemAssociationsCount = dtAttributes.Rows.Count;
sectionCounts = "associations=" + SetAssociationsCount + ",attributes=" + SystemAssociationsCount + ",usage=" + SetAssociationsCount + ",functionalities=0,descriptions=0,defects=0";
CanDeleteRQMT = true;
if (SetAssociationsCount > 0 ||
(dtDefects.Rows.Count > 0 && dtDefects.Rows[0]["RQMTSystemDefect_ID"] != DBNull.Value) ||
(dtFunctionality.Rows.Count > 0 && dtFunctionality.Rows[0]["Functionality_ID"] != DBNull.Value) ||
(dtDescriptions.Rows.Count > 0 && dtDescriptions.Rows[0]["RQMTSystemRQMTDescription_ID"] != DBNull.Value))
{
CanDeleteRQMT = false;
}
descTypeOptions = CreateOptionStringFromDataTable(dtDescriptionTypes, "RQMTDescriptionType_ID", "RQMTDescriptionType", null, null, true);
if (dtRQMT != null && dtRQMT.Rows.Count > 0)
{
spnRQMT.InnerText = dtRQMT.Rows[0]["RQMTID"].ToString();
string createdDateDisplay = string.Empty, updatedDateDisplay = string.Empty;
DateTime nCreatedDate = new DateTime(), nUpdatedDate = new DateTime();
if (DateTime.TryParse(dtRQMT.Rows[0]["CreatedDate"].ToString(), out nCreatedDate))
{
createdDateDisplay = String.Format("{0:M/d/yyyy h:mm tt}", nCreatedDate);
}
if (DateTime.TryParse(dtRQMT.Rows[0]["UpdatedDate"].ToString(), out nUpdatedDate))
{
updatedDateDisplay = String.Format("{0:M/d/yyyy h:mm tt}", nUpdatedDate);
}
spnCreated.InnerText = "Created: " + dtRQMT.Rows[0]["CreatedBy"].ToString() + " - " + createdDateDisplay;
spnUpdated.InnerText = "Updated: " + dtRQMT.Rows[0]["UpdatedBy"].ToString() + " - " + updatedDateDisplay;
txtRQMT.Text = dtRQMT.Rows[0]["RQMT"].ToString();
txtRQMT.Attributes.Add("original_value", dtRQMT.Rows[0]["RQMT"].ToString());
}
if (dtAllSets != null && dtAllSets.Rows.Count > 0)
{
dtAllSets.Columns.Add("X", typeof(string));
dtAllSets.Columns["X"].SetOrdinal(0);
dtAllSets.Columns.Add("Z", typeof(string));
grdAssociations.GridHeaderRowDataBound += grdAssociations_GridHeaderRowDataBound;
grdAssociations.GridRowDataBound += grdAssociations_GridRowDataBound;
grdAssociations.DataSource = dtAllSets;
grdAssociations.DataBind();
}
if (dtAttributes != null && dtAttributes.Rows.Count > 0)
{
dtAttributes.Columns.Add("Z", typeof(string));
grdAttributes.GridHeaderRowDataBound += grdAttributes_GridHeaderRowDataBound;
grdAttributes.GridRowDataBound += grdAttributes_GridRowDataBound;
grdAttributes.DataSource = dtAttributes;
grdAttributes.DataBind();
}
if (dtUsage != null && dtUsage.Rows.Count > 0)
{
dtUsage.Columns.Add("Toggle", typeof(string));
dtUsage.Columns.Add("Z", typeof(string));
grdUsage.GridHeaderRowDataBound += grdUsage_GridHeaderRowDataBound;
grdUsage.GridRowDataBound += grdUsage_GridRowDataBound;
grdUsage.DataSource = dtUsage;
grdUsage.DataBind();
}
if (dtFunctionality != null && dtFunctionality.Rows.Count > 0)
{
// produce a unique table with one row per rsrs
dtFunctionalityDistinct = dtFunctionality.Copy();
dtFunctionalityDistinct.Columns.Remove("Functionality");
dtFunctionalityDistinct.Columns.Remove("Functionality_ID");
dtFunctionalityDistinct.AcceptChanges();
dtFunctionalityDistinct = dtFunctionalityDistinct.DefaultView.ToTable(true);
dtFunctionalityDistinct.Columns.Add("Functionality", typeof(string));
grdFunctionalities.GridHeaderRowDataBound += grdFunctionalities_GridHeaderRowDataBound;
grdFunctionalities.GridRowDataBound += grdFunctionalities_GridRowDataBound;
grdFunctionalities.DataSource = dtFunctionalityDistinct;
grdFunctionalities.DataBind();
int cnt = 0;
for (int i = 0; i < dtFunctionality.Rows.Count; i++)
{
if (dtFunctionality.Rows[i]["Functionality_ID"] != DBNull.Value)
{
cnt++;
}
}
sectionCounts = sectionCounts.Replace("functionalities=0", "functionalities=" + cnt);
}
if (dtDescriptions != null && dtDescriptions.Rows.Count > 0)
{
// produce a unique table with one row per rs
dtDescriptionsDistinct = dtDescriptions.Copy();
dtDescriptionsDistinct.Columns.Remove("RQMTSystemRQMTDescription_ID");
dtDescriptionsDistinct.Columns.Remove("RQMTDescription_ID");
dtDescriptionsDistinct.Columns.Remove("RQMTDescription");
dtDescriptionsDistinct.Columns.Remove("RQMTDescriptionType_ID");
dtDescriptionsDistinct.Columns.Remove("RQMTDescriptionType");
dtDescriptionsDistinct.AcceptChanges();
dtDescriptionsDistinct = dtDescriptionsDistinct.DefaultView.ToTable(true);
dtDescriptionsDistinct.Columns.Add("Descriptions", typeof(string));
grdDescriptions.GridHeaderRowDataBound += grdDescriptions_GridHeaderRowDataBound;
grdDescriptions.GridRowDataBound += grdDescriptions_GridRowDataBound;
grdDescriptions.DataSource = dtDescriptionsDistinct;
grdDescriptions.DataBind();
int cnt = 0;
for (int i = 0; i < dtDescriptions.Rows.Count; i++)
{
int RQMTSystemRQMTDescription_ID = dtDescriptions.Rows[i]["RQMTSystemRQMTDescription_ID"] != DBNull.Value ? (int)dtDescriptions.Rows[i]["RQMTSystemRQMTDescription_ID"] : 0;
if (RQMTSystemRQMTDescription_ID != 0 && (DisplayItemID == 0 || RQMTSystemRQMTDescription_ID == DisplayItemID))
{
cnt++;
}
}
sectionCounts = sectionCounts.Replace("descriptions=0", "descriptions=" + cnt);
SystemDescriptionsCount = cnt;
}
if (dtDefects != null && dtDefects.Rows.Count > 0)
{
dtDefectsDistinct = dtDefects.Copy();
dtDefectsDistinct.Columns.Remove("RQMTSystemDefect_ID");
dtDefectsDistinct.Columns.Remove("Description");
dtDefectsDistinct.Columns.Remove("Impact");
dtDefectsDistinct.Columns.Remove("RQMTStage");
dtDefectsDistinct.Columns.Remove("SortOrder_ID");
dtDefectsDistinct.AcceptChanges();
dtDefectsDistinct = dtDefectsDistinct.DefaultView.ToTable(true);
dtDefectsDistinct.Columns.Add("Defects", typeof(string));
grdDefects.GridHeaderRowDataBound += grdDefects_GridHeaderRowDataBound;
grdDefects.GridRowDataBound += grdDefects_GridRowDataBound;
grdDefects.DataSource = dtDefectsDistinct;
grdDefects.DataBind();
int cnt = 0;
for (int i = 0; i < dtDefects.Rows.Count; i++)
{
if (dtDefects.Rows[i]["RQMTSystemDefect_ID"] != DBNull.Value)
{
cnt++;
}
}
sectionCounts = sectionCounts.Replace("defects=0", "defects=" + cnt);
}
}
}
