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"));
}