public static string GetRequirementTypes() { DataTable dtTypes = RQMT.RQMTTypeList_Get(); return(WTSPage.SerializeResult(dtTypes)); }
public static string ExecuteComponentSearch(string compType, string txt) { DataTable dt = new DataTable(); bool returnAll = txt == "[ALL]"; if (txt != null && txt.Length > 2000) { txt = txt.Substring(0, 2000); } switch (compType) { case "rqmt": if (string.IsNullOrWhiteSpace(txt)) { txt = "[NONE]"; // we don't allow blank searches for rqmts } txt = txt.Trim(); txt = txt.Replace("\r", ""); txt = txt.Replace("\n", "[CR]"); // do another check for empty string if (string.IsNullOrWhiteSpace(txt)) { txt = "[NONE]"; } dt = RQMT.RQMTList_Get(0, txt, true); break; case "type": dt = RQMT.RQMTTypeList_Get(returnAll || string.IsNullOrWhiteSpace(txt) ? null : txt); // the type list is short so we default to showing all break; case "workarea": dt = MasterData.WorkAreaList_Get(); if (!string.IsNullOrWhiteSpace(txt)) { txt = txt.ToUpper(); foreach (DataRow row in dt.Rows) { if (row["WorkArea"].ToString().ToUpper().IndexOf(txt) == -1) { row.Delete(); } } } break; case "sys": dt = MasterData.SystemList_Get(); DataColumn col = dt.Columns["WTS_SystemID"]; col.ColumnName = "WTS_SYSTEMID"; if (!string.IsNullOrWhiteSpace(txt)) { txt = txt.ToUpper(); foreach (DataRow row in dt.Rows) { if (row["WTS_SYSTEM"].ToString().ToUpper().IndexOf(txt) == -1) { row.Delete(); } } } break; case "desc": if (string.IsNullOrWhiteSpace(txt)) { txt = "__NONE__"; // we don't allow blank searches for descriptions } dt = RQMT.RQMTBuilderDescriptionList_Get(0, txt, false); break; } // some of the source queries are returning invalid xml/json column names, so we fix the common errors foreach (DataColumn x in dt.Columns) { x.ColumnName = x.ColumnName.Replace(" ", "_").Replace("#", "NUM"); } dt.AcceptChanges(); string str = WTSPage.SerializeResult(dt); return(WTSPage.SerializeResult(dt)); }
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; } }