public static string ValidateSubTaskNumber(int subTaskNumber, int parentTaskID) { var result = WTSPage.CreateDefaultResult(); WorkItem_Task task = new WorkItem_Task(); bool loaded = task.LoadByNumber(parentTaskID, subTaskNumber); if (loaded) { result["WORKITEMID"] = task.WorkItemID.ToString(); result["WORKITEM_TASKID"] = task.WorkItem_TaskID.ToString(); result["TASK_NUMBER"] = subTaskNumber.ToString(); result["title"] = task.Title; result["exists"] = "true"; } else { result["exists"] = "false"; } result["success"] = "true"; return(JsonConvert.SerializeObject(result, Newtonsoft.Json.Formatting.None)); }
public static string DeleteRQMTFromSet(int RQMTSetID, string checkedRQMTIDs, bool globalDelete) { var result = WTSPage.CreateDefaultResult(); string[] ids = checkedRQMTIDs.Split('|'); for (int i = ids.Length - 1; i >= 0; i--) // we go backwards so we can re-order as we go and not delete parents before children { int id = Int32.Parse(ids[i]); if (globalDelete) { DataTable dt = RQMT.RQMT_AssociatedSets_Get(id); foreach (DataRow row in dt.Rows) { RQMT.RQMTSet_DeleteRQMT((int)row["RQMTSetID"], id, 0, true); } } else { RQMT.RQMTSet_DeleteRQMT(RQMTSetID, id, 0, true); } } result["success"] = "true"; return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTDescription(int RQMTSet_RQMTSystemID, int RQMTSystemRQMTDescriptionID, string RQMTDescription, int RQMTDescriptionTypeID, bool editMode) { var result = WTSPage.CreateDefaultResult(); try { int RQMTDescriptionID = RQMT.RQMTSystem_SaveDescription(0, RQMTSet_RQMTSystemID, RQMTSystemRQMTDescriptionID, RQMTDescription, RQMTDescriptionTypeID, editMode, "all"); result["success"] = "true"; result["rqmtdescriptionid"] = RQMTDescriptionID.ToString(); } catch (Exception e) { if (e.Message.IndexOf("UNIQUE KEY") != -1) { result["error"] = "This description/type combination already exists in this RQMT."; } else { result["error"] = e.Message; } } return(WTSPage.SerializeResult(result)); }
public static string ValidateTaskID(int taskID) { var result = WTSPage.CreateDefaultResult(); DataTable dt = WorkloadItem.WorkItem_Get(taskID); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; result["title"] = dr["TITLE"] != DBNull.Value ? HttpUtility.HtmlEncode(dr["TITLE"].ToString()) : ""; result["exists"] = "true"; DataTable aorDT = AOR.AORTaskAORList_Get(taskID); if (aorDT != null && aorDT.Rows.Count > 0) { Dictionary <string, string> aors = new Dictionary <string, string>(); for (int i = 0; i < aorDT.Rows.Count; i++) { DataRow aorRow = aorDT.Rows[i]; aors.Add(aorRow["AORID"].ToString(), aorRow["AORName"].ToString()); } result["aors"] = JsonConvert.SerializeObject(aors, Newtonsoft.Json.Formatting.None); } } else { result["exists"] = "false"; } result["success"] = "true"; return(JsonConvert.SerializeObject(result, Newtonsoft.Json.Formatting.None)); }
public static string DeleteDescriptionAttachment(int AttachmentID) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTDescriptionAttachment_Delete(0, 0, AttachmentID)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string TaskAddedToRQMTSet(int RQMTSetID, int WORKITEM_TASKID) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSet_Task_Add(RQMTSetID, WORKITEM_TASKID)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string UpdateRQMTSetRQMTSystemUsage(int RQMTSet_RQMTSystemID, int month, bool selected) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSet_RQMTSystem_Usage_Update(RQMTSet_RQMTSystemID, month, selected)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTBase(int RQMTID, string txt) { var result = WTSPage.CreateDefaultResult(); var saveResult = RQMT.RQMT_Save(false, RQMTID, txt); result["success"] = saveResult["saved"].ToLower(); result["exists"] = saveResult["exists"].ToLower(); return(WTSPage.SerializeResult(result)); }
public static string DeleteRQMTSet(int RQMTSetID) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSet_Delete(RQMTSetID)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string DeleteRQMTBase(int RQMTID) { var result = WTSPage.CreateDefaultResult(); var deleteResult = RQMT.RQMT_Delete(RQMTID, false); result["success"] = deleteResult["deleted"]; result["hasdependencies"] = deleteResult["hasdependencies"]; return(WTSPage.SerializeResult(result)); }
public static string DeleteRQMTDescription(int RQMTSystemRQMTDescriptionID) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSystem_DeleteDescription(RQMTSystemRQMTDescriptionID)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTAttributes(int RQMTSet_RQMTSystemID, int RQMTStageID, int CriticalityID, int RQMTStatusID, bool RQMTAccepted) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSystemAttributes_Save(RQMTSet_RQMTSystemID, RQMTStageID, CriticalityID, RQMTStatusID, RQMTAccepted)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTSetOrdering(string order) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSet_ReorderRQMTs(0, order)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string DeleteRQMTFunctionality(int RQMTSetID, int RQMTSet_RQMTSystemID, int RQMTSetFunctionalityID) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTFunctionality_Delete(RQMTSetID, RQMTSet_RQMTSystemID, RQMTSetFunctionalityID)) { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTChanges(string changes) { var result = WTSPage.CreateDefaultResult(); try { JObject jobj = (JObject)JsonConvert.DeserializeObject(changes); int RQMTID = 0; string addToSets = ""; string deleteFromSets = ""; string RQMTText = ""; foreach (KeyValuePair <string, JToken> token in (JObject)jobj) { string value = token.Value.ToString(); if (token.Key == "RQMTID") { RQMTID = Int32.Parse(value); } else if (token.Key == "adds") { addToSets = value; } else if (token.Key == "deletes") { deleteFromSets = value; } else if (token.Key == "RQMT") { RQMTText = value; } } int returnID = RQMT.RQMTBuilder_RQMTUpdate(RQMTID, RQMTText, addToSets, deleteFromSets); if (returnID != RQMTID) { result["error"] = "Change cannot be saved. Another RQMT already exists with the same text (RQMT #" + returnID + ")."; } else { result["success"] = "true"; } } catch (Exception e) { result["error"] = e.Message; } return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTFunctionality(int RQMTSetID, int RQMTSet_RQMTSystemID, string RQMTFunctionalities, int RQMTSetFunctionalityID, int FunctionalityID, int ComplexityID, string Justification) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTFunctionality_Save(RQMTSetID, RQMTSet_RQMTSystemID, RQMTFunctionalities, RQMTSetFunctionalityID, FunctionalityID, ComplexityID, Justification)) { result["success"] = "true"; result["RQMTSetID"] = RQMTSetID.ToString(); } return(WTSPage.SerializeResult(result)); }
public static string SearchDescriptions(string txt) { DataTable dt; if (string.IsNullOrWhiteSpace(txt)) { txt = "__NONE__"; // we don't allow blank searches for descriptions } dt = RQMT.RQMTBuilderDescriptionList_Get(0, txt, false); return(WTSPage.SerializeResult(dt)); }
public static string RenameRQMTSetGroup(int RQMTSetNameID, string name) { var result = WTSPage.CreateDefaultResult(); if (RQMT.RQMTSetName_Save(RQMTSetNameID, name)) { result["success"] = "true"; } else { result["error"] = "Name already exists and could not be changed."; } return(WTSPage.SerializeResult(result)); }
public static string AddRQMTSet(string RQMTSetName, int WTS_SYSTEMID, int WorkAreaID, int RQMTTypeID) { var result = WTSPage.CreateDefaultResult(); var RQMTSetID = RQMT.RQMTSet_Save(0, RQMTSetName, WTS_SYSTEMID, WorkAreaID, RQMTTypeID, 0, null); if (RQMTSetID > 0) { result["success"] = "true"; } result["RQMTSetID"] = RQMTSetID.ToString(); return(WTSPage.SerializeResult(result)); }
public static string HideQuickAddWarning() { var result = WTSPage.CreateDefaultResult(); WTS_User u = WTSPage.GetLoggedInUser(); bool dup = false; string err = ""; u.UserSetting_Update(0, 2, 0, "0", out dup, out err); result["success"] = "true"; return(WTSPage.SerializeResult(result)); }
public static string SaveRQMTSet(int RQMTSetID, string RQMTSetName, int WTS_SYSTEMID, int WorkAreaID, int RQMTTypeID, int RQMTComplexityID, string justification) { var result = WTSPage.CreateDefaultResult(); var postSaveRQMTSetID = RQMT.RQMTSet_Save(RQMTSetID, string.IsNullOrWhiteSpace(RQMTSetName) ? "" : RQMTSetName, WTS_SYSTEMID, WorkAreaID, RQMTTypeID, RQMTComplexityID, justification); if (postSaveRQMTSetID == RQMTSetID) { result["success"] = "true"; } else { result["exists"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string PasteRQMTs(int RQMTSetID, string options) { var result = WTSPage.CreateDefaultResult(); string previousCopiedRQMTs = (string)HttpContext.Current.Session["copied.rqmts"]; // RQMTS, SYSIDS, RSRSIDS if (options == null) { options = ""; } bool pasteAttributes = options.IndexOf("attr") != -1; bool pasteDefects = options.IndexOf("def") != -1; bool pasteDescriptions = options.IndexOf("desc") != -1; string pasteOptions = (pasteAttributes ? "attr," : "") + (pasteDefects ? "def," : "") + (pasteDescriptions ? "desc," : ""); if (pasteOptions.Length > 0) { pasteOptions = pasteOptions.Substring(0, pasteOptions.Length - 1); } if (!string.IsNullOrWhiteSpace(previousCopiedRQMTs)) { string[] arr = previousCopiedRQMTs.Split(','); string[] prevRQMTIDs = arr[0].Split('|'); string[] prevRQMTSet_RQMTSystemIDs = arr[2].Split('|'); for (int i = 0; i < prevRQMTIDs.Length; i++) { int RQMTID = Int32.Parse(prevRQMTIDs[i]); int RQMTSet_RQMTSystemID = Int32.Parse(prevRQMTSet_RQMTSystemIDs[i]); RQMT.RQMTSet_AddRQMT(RQMTSetID, RQMTID, null, false, RQMTSet_RQMTSystemID, pasteOptions); } RQMT.RQMTSet_ReorderRQMTs(RQMTSetID, null); // this forces us to reclaim space from previously deleted rqmts result["success"] = "true"; } else // we shouldn't get here; the UI should have disabled the paste button if there is nothing on the clipboard { result["success"] = "true"; } return(WTSPage.SerializeResult(result)); }
public static string FillCustomLists() { Dictionary <string, object> results = new Dictionary <string, object>(); // functional rqmt priority DataTable dt = MasterData.PriorityList_Get(false, false, (int)WTS.Enums.PriorityTypeEnum.RQMT); dt.Columns.Add("Default"); foreach (DataRow row in dt.Rows) { row["Default"] = row["Priority"].ToString() == "Major" ? "true" : "false"; } dt.AcceptChanges(); results["RQMTPriority"] = dt; return(WTSPage.SerializeResult(results)); }
public static string AddRQMTToRQMTSet(int RQMTSetID, int RQMTID, string RQMTText, bool addAsChild) { var result = WTSPage.CreateDefaultResult(); try { RQMTID = RQMT.RQMTSet_AddRQMT(RQMTSetID, RQMTID, RQMTText, addAsChild, 0, null); result["success"] = "true"; result["RQMTID"] = RQMTID.ToString(); // only needed if we create a brand new RQMTID } catch (Exception e) { result["error"] = e.Message; } return(WTSPage.SerializeResult(result)); }
public static string CreateNewComponent(string compType, string txt) { var result = WTSPage.CreateDefaultResult(); try { if (compType == "rqmt") { txt = txt.Replace("|", "!"); txt = txt.Replace("\r", ""); txt = txt.Replace("\n", "|"); // we will be adding one rqmt for each | string[] txtarr = txt.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries); txt = string.Join("|", txtarr); // rqmtsNeedingParents stores the indexes of the rqmts that had a > in front of them // after the saving is done, we make ajax calls to add the new rqmts to the sets displayed on the page, and will preserve parent-child relationships based on > characters string rqmtsNeedingParents = ""; for (int i = 0; i < txtarr.Length; i++) { if (i > 0) { rqmtsNeedingParents += ","; } rqmtsNeedingParents += txtarr[i].Trim().StartsWith(">") ? "1" : "0"; } var saveResult = RQMT.RQMT_Save(true, 0, txt); result["success"] = saveResult["saved"].ToLower(); result["rqmtid"] = saveResult["newID"]; result["rqmtids"] = saveResult["newIDs"]; result["exists"] = saveResult["exists"]; result["rqmtsneedingparents"] = rqmtsNeedingParents; } } catch (Exception e) { result["error"] = e.Message; } return(WTSPage.SerializeResult(result)); }
public static string FilterRQMTSets(int RQMTSetID, string RQMTSetName, int WTS_SYSTEMID, int WorkAreaID, int RQMTTypeID) { var result = WTSPage.CreateDefaultResult(); if (RQMTSetID < 0) { RQMTSetID = 0; } // when results from back from the server, they come back as a data set containing the following tables: // [0] = RQMT // [1] = DESC // [2] = FUNC // [3] = DEFECT // [4] = TASK DataSet ds = RQMT.RQMTBuilder_Data_Get(RQMTSetID, !string.IsNullOrWhiteSpace(RQMTSetName) ? RQMTSetName : null, WTS_SYSTEMID, WorkAreaID, RQMTTypeID, 0); return(WTSPage.SerializeResult(ds)); }
public static string Save(int RQMTID, string RQMTName, string addToSets, string deleteFromSets, string attrChanges, string usageChanges, string funcChanges, string descChanges, int ParentRQMTID) { var result = WTSPage.CreateDefaultResult(); RQMTName = RQMTName.Replace("|", "!"); RQMTName = RQMTName.Replace("\r", ""); RQMTName = RQMTName.Replace("\n", ""); // new ID will be 0 if fail, RQMTID if updating, or a new RQMTID if new int savedID = RQMT.RQMTEditData_Save(RQMTID, RQMTName, addToSets, deleteFromSets, attrChanges, usageChanges, funcChanges, StringUtil.UndoStrongEscape(descChanges), RQMTID == 0 ? ParentRQMTID : 0); if (savedID > 0) { result["success"] = "true"; if (RQMTID == 0) { result["newid"] = savedID.ToString(); } } return(WTSPage.SerializeResult(result)); }
public static string LoadAllRQMTSetsForRQMT(int RQMTID) { return(WTSPage.SerializeResult(RQMT.RQMT_AssociatedSets_Get(RQMTID))); }
public static string LoadAllRQMTSets() { return(WTSPage.SerializeResult(RQMT.RQMTSetList_Get())); }
public static string CopyRQMTs(string RQMTIDs, string SystemIDs, string RQMTSet_RQMTSystemIDs) { var result = WTSPage.CreateDefaultResult(); if (string.IsNullOrWhiteSpace(RQMTIDs) || string.IsNullOrWhiteSpace(RQMTSet_RQMTSystemIDs)) { HttpContext.Current.Session["copied.rqmts"] = ""; result["rqmtids"] = ""; result["rqmtidsstr"] = ""; result["systemids"] = ""; result["rqmtsetrqmtsystmeids"] = ""; } else { string previousCopiedRQMTs = (string)HttpContext.Current.Session["copied.rqmts"]; if (string.IsNullOrWhiteSpace(previousCopiedRQMTs)) { HttpContext.Current.Session["copied.rqmts"] = RQMTIDs + "," + SystemIDs + "," + RQMTSet_RQMTSystemIDs; } else { string[] arr = previousCopiedRQMTs.Split(','); string prevRQMTIDs = arr[0]; string prevSystemIDs = arr[1]; string prevRQMTSet_RQMTSystemIDs = arr[2]; string[] newRQMTIdArr = RQMTIDs.Split('|'); string[] newSystemIdArr = SystemIDs.Split('|'); string[] newRQMTSet_RQMTSystemArr = RQMTSet_RQMTSystemIDs.Split('|'); string newRQMTIDs = prevRQMTIDs; string newSystemIDs = prevSystemIDs; string newRQMTSet_RQMTSystemIDs = prevRQMTSet_RQMTSystemIDs; for (int i = 0; i < newRQMTSet_RQMTSystemArr.Length; i++) { if (!("|" + prevRQMTIDs + "|").Contains("|" + newRQMTIdArr[i] + "|")) { newRQMTSet_RQMTSystemIDs += "|" + newRQMTSet_RQMTSystemArr[i]; newSystemIDs += "|" + newSystemIdArr[i]; if (("|" + prevRQMTIDs.Replace("*", "") + "|").Contains("|" + newRQMTIdArr[i] + "|")) { newRQMTIDs += "|" + newRQMTIdArr[i] + "*"; } else { newRQMTIDs += "|" + newRQMTIdArr[i]; } } } RQMTIDs = newRQMTIDs; SystemIDs = newSystemIDs; RQMTSet_RQMTSystemIDs = newRQMTSet_RQMTSystemIDs; HttpContext.Current.Session["copied.rqmts"] = newRQMTIDs + "," + newSystemIDs + "," + newRQMTSet_RQMTSystemIDs; } result["rqmtids"] = RQMTIDs; result["rqmtidsstr"] = RQMTIDs.Replace("|", ", "); result["systemids"] = SystemIDs; result["rqmtsetrqmtsystmeids"] = RQMTSet_RQMTSystemIDs; } result["success"] = "true"; return(WTSPage.SerializeResult(result)); }