public static DataTable RQMTSetList_Get(int RQMTSetID = 0, bool addRQMTCount = false) { return(WTSData.GetDataTableFromStoredProcedure("RQMTSetList_Get", null, new SqlParameter[] { new SqlParameter("@RQMTSetID", RQMTSetID), new SqlParameter("@AddRQMTCount", addRQMTCount) })); }
public static DataTable RQMTBuilderDescriptionList_Get(int RQMTDescriptionID = 0, string RQMTDescription = null, bool includeArchive = false) { return(WTSData.GetDataTableFromStoredProcedure("RQMTBuilderDescriptionList_Get", "Data", new SqlParameter[] { new SqlParameter("@RQMTDescriptionID", RQMTDescriptionID), new SqlParameter("@RQMTDescription", RQMTDescription != null ? RQMTDescription : (object)DBNull.Value), new SqlParameter("@IncludeArchive", includeArchive) })); }
public static DataTable AuditHistory_Get(int AuditLogTypeID, int ItemID, int ParentItemID, DateTime maxUpdatedDate) { return(WTSData.GetDataTableFromStoredProcedure("AuditHistory_Get", null, new SqlParameter[] { new SqlParameter("@AuditLogTypeID", AuditLogTypeID), new SqlParameter("@ItemID", ItemID), new SqlParameter("@ParentItemID", ParentItemID > 0 ? ParentItemID : (object)DBNull.Value), new SqlParameter("@MaxUpdatedDate", maxUpdatedDate != DateTime.MinValue ? maxUpdatedDate : (object)DBNull.Value) })); }
public static DataTable RQMTDescriptionAttachment_Get(int RQMTDescriptionAttachmentID, int RQMTDescriptionID, int attachmentID, bool includeData, int RQMTID) { return(WTSData.GetDataTableFromStoredProcedure("RQMTDescriptionAttachment_Get", null, new SqlParameter[] { new SqlParameter("@RQMTDescriptionAttachmentID", RQMTDescriptionAttachmentID), new SqlParameter("@RQMTDescriptionID", RQMTDescriptionID), new SqlParameter("@AttachmentID", attachmentID), new SqlParameter("@IncludeData", includeData), new SqlParameter("@RQMTID", RQMTID) })); }
public static DataTable AORSRWebsystemList_Get(bool includeWTS) { DataTable dt = WTSData.GetDataTableFromStoredProcedure("AORSRWebsystemList_Get"); if (includeWTS) { DataRow row = dt.NewRow(); row["Websystem"] = "WTS"; } return(dt); }
public static int RQMT_GetRQMTSetRQMTSystemForSet(int RQMTID, int RQMTSetID) { int RQMTSet_RQMTSystemID = 0; DataTable dt = WTSData.GetDataTableFromStoredProcedure("RQMT_GetRQMTSetRQMTSystemForSet", null, new SqlParameter[] { new SqlParameter("@RQMTID", RQMTID), new SqlParameter("@RQMTSetID", RQMTSetID) }); if (dt.Rows.Count > 0) { RQMTSet_RQMTSystemID = (int)dt.Rows[0]["RQMTSet_RQMTSystemID"]; } return(RQMTSet_RQMTSystemID); }
public static DataTable RQMTAttribute_Get(int RQMTAttributeTypeID = 0) { return(WTSData.GetDataTableFromStoredProcedure("RQMTAttribute_Get", "Data", new SqlParameter[] { new SqlParameter("@RQMTAttributeTypeID", RQMTAttributeTypeID) })); }
public static DataTable RQMTSetName_Get(int RQMTSetNameID = 0) { return(WTSData.GetDataTableFromStoredProcedure("RQMTSetName_Get")); }
public static DataTable RQMT_AssociatedSets_Get(int RQMTID) { return(WTSData.GetDataTableFromStoredProcedure("RQMT_AssociatedSets_Get", "Data", new SqlParameter[] { new SqlParameter("@RQMTID", RQMTID) })); }
public static DataTable RQMTTypeList_Get(string RQMTType = null) { return(WTSData.GetDataTableFromStoredProcedure("RQMTTypeList_Get", "Data", new SqlParameter[] { new SqlParameter("@RQMTType", RQMTType != null ? RQMTType : (object)DBNull.Value) })); }
public static DataTable RQMTComplexityList_Get() { return(WTSData.GetDataTableFromStoredProcedure("RQMTComplexityList_Get")); }