public static int RQMTSystem_SaveDescription(int RQMTSystemID, int RQMTSet_RQMTSystemID, int RQMTSystemRQMTDescriptionID, string RQMTDescription, int RQMTDescriptionTypeID, bool editMode, string changeMode)
{
SqlParameter paramRQMTDescriptionID = new SqlParameter("@RQMTDescriptionID", -1);
paramRQMTDescriptionID.Direction = ParameterDirection.InputOutput;
if (WTSData.ExecuteStoredProcedure("RQMTSystem_SaveDescription", new SqlParameter[] {
new SqlParameter("@RQMTSystemID", RQMTSystemID),
new SqlParameter("@RQMTSet_RQMTSystemID", RQMTSet_RQMTSystemID),
new SqlParameter("@RQMTSystemRQMTDescriptionID", RQMTSystemRQMTDescriptionID),
paramRQMTDescriptionID,
new SqlParameter("@RQMTDescription", RQMTDescription != null ? RQMTDescription : (object)DBNull.Value),
new SqlParameter("@RQMTDescriptionTypeID", RQMTDescriptionTypeID),
new SqlParameter("@Edit", editMode),
new SqlParameter("@ChangeMode", changeMode),
new SqlParameter("@CreatedBy", HttpContext.Current.User.Identity.Name),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}))
{
return(paramRQMTDescriptionID.Value != DBNull.Value ? (int)paramRQMTDescriptionID.Value : 0);
}
else
{
return(0);
}
}
public static bool RQMTSet_Delete(int RQMTSetID)
{
return(WTSData.ExecuteStoredProcedure("RQMTSet_Delete", new SqlParameter[] {
new SqlParameter("@RQMTSetID", RQMTSetID),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static int RQMTBuilder_RQMTUpdate(int RQMTID, string RQMT, string addToSets, string deleteFromSets)
{
SqlParameter paramExistingID = new SqlParameter("@ExistingID", SqlDbType.Int);
paramExistingID.Direction = ParameterDirection.Output;
if (WTSData.ExecuteStoredProcedure("RQMTBuilder_RQMTUpdate", new SqlParameter[] {
new SqlParameter("@RQMTID", RQMTID),
new SqlParameter("@RQMT", RQMT),
new SqlParameter("@AddToSets", string.IsNullOrWhiteSpace(addToSets) ? (object)DBNull.Value : addToSets),
new SqlParameter("@DeleteFromSets", string.IsNullOrWhiteSpace(deleteFromSets) ? (object)DBNull.Value : deleteFromSets),
new SqlParameter("@AddedBy", HttpContext.Current.User.Identity.Name),
paramExistingID
}))
{
int eid = paramExistingID.Value != DBNull.Value && (int)paramExistingID.Value != 0 ? (int)paramExistingID.Value : RQMTID;
if (eid != RQMTID)
{
return(eid);
}
}
return(RQMTID);
}
public static int RQMTEditData_Save(int RQMTID, string RQMT, string addToSets, string deleteFromSets, string attrChanges, string usageChanges, string funcChanges, string descChanges, int ParentRQMTID)
{
SqlParameter newID = new SqlParameter("NewID", SqlDbType.Int);
newID.Direction = ParameterDirection.Output;
if (WTSData.ExecuteStoredProcedure("RQMTEditData_Save", new SqlParameter[] {
new SqlParameter("@RQMTID", RQMTID),
new SqlParameter("@RQMT", RQMT),
new SqlParameter("@AddToSets", string.IsNullOrWhiteSpace(addToSets) ? (object)DBNull.Value : addToSets),
new SqlParameter("@DeleteFromSets", string.IsNullOrWhiteSpace(deleteFromSets) ? (object)DBNull.Value : deleteFromSets),
new SqlParameter("@AttrChanges", string.IsNullOrWhiteSpace(attrChanges) ? (object)DBNull.Value : attrChanges),
new SqlParameter("@UsageChanges", string.IsNullOrWhiteSpace(usageChanges) ? (object)DBNull.Value : usageChanges),
new SqlParameter("@FuncChanges", string.IsNullOrWhiteSpace(funcChanges) ? (object)DBNull.Value : funcChanges),
new SqlParameter("@DescChanges", string.IsNullOrWhiteSpace(descChanges) ? (object)DBNull.Value : descChanges),
new SqlParameter("@ParentRQMTID", ParentRQMTID),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name),
newID
}))
{
int savedID = RQMTID > 0 ? RQMTID : (int)newID.Value;
return(savedID);
}
return(0);
}
public static bool RQMTDefectsImpactTask_Delete(int RQMTSystemDefectTaskID)
{
return(WTSData.ExecuteStoredProcedure("RQMTDefectsImpactTask_Delete", new SqlParameter[] {
new SqlParameter("@RQMTSystemDefectTaskID", RQMTSystemDefectTaskID),
new SqlParameter("@DeletedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTSet_ReorderRQMTs(int RQMTSetID, string order)
{
return(WTSData.ExecuteStoredProcedure("RQMTSet_ReorderRQMTs", new SqlParameter[] {
new SqlParameter("@RQMTSetID", RQMTSetID),
new SqlParameter("@Order", string.IsNullOrWhiteSpace(order) ? (object)DBNull.Value : order),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTSystem_DeleteDescription(int RQMTSystemRQMTDescriptionID)
{
return(WTSData.ExecuteStoredProcedure("RQMTSystem_DeleteDescription", new SqlParameter[] {
new SqlParameter("@RQMTSystemRQMTDescriptionID", RQMTSystemRQMTDescriptionID),
new SqlParameter("@DeleteOrphanedDescription", true),
new SqlParameter("@DeletedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTDescriptionAttachment_Delete(int RQMTDescriptionAttachmentID, int RQMTDescriptionID, int attachmentID)
{
return(WTSData.ExecuteStoredProcedure("RQMTDescriptionAttachment_Delete", new SqlParameter[] {
new SqlParameter("@RQMTDescriptionAttachmentID", RQMTDescriptionAttachmentID),
new SqlParameter("@RQMTDescriptionID", RQMTDescriptionID),
new SqlParameter("@AttachmentID", attachmentID)
}));
}
public static bool RQMTSet_Task_Add(int RQMTSetID, int WORKITEM_TASKID)
{
return(WTSData.ExecuteStoredProcedure("RQMTSet_Task_Add", new SqlParameter[] {
new SqlParameter("@RQMTSetID", RQMTSetID),
new SqlParameter("@WORKITEM_TASKID", WORKITEM_TASKID),
new SqlParameter("@AddedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTDefectsImpactSR_Add(int RQMTSystemDefectID, int SRID, int AORSR_SRID)
{
return(WTSData.ExecuteStoredProcedure("RQMTDefectsImpactSR_Add", new SqlParameter[] {
new SqlParameter("@RQMTSystemDefectID", RQMTSystemDefectID),
new SqlParameter("@SRID", SRID > 0 ? SRID : (object)DBNull.Value),
new SqlParameter("@AORSR_SRID", AORSR_SRID > 0 ? AORSR_SRID : (object)DBNull.Value),
new SqlParameter("@AddedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTSet_RQMTSystem_Usage_Update(int RQMTSet_RQMTSystemID, int month, bool selected)
{
return(WTSData.ExecuteStoredProcedure("RQMTSet_RQMTSystem_Usage_Update", new SqlParameter[] {
new SqlParameter("@RQMTSet_RQMTSystemID", RQMTSet_RQMTSystemID),
new SqlParameter("@Month", month),
new SqlParameter("@Selected", selected),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTSet_DeleteRQMT(int RQMTSetID, int RQMTID, int RQMTSet_RQMTSystemID, bool reorderAfterDelete)
{
return(WTSData.ExecuteStoredProcedure("RQMTSet_DeleteRQMT", new SqlParameter[] {
new SqlParameter("@RQMTSetID", RQMTSetID),
new SqlParameter("@RQMTID", RQMTID),
new SqlParameter("@RQMTSet_RQMTSystemID", RQMTSet_RQMTSystemID),
new SqlParameter("@ReorderAfterDelete", reorderAfterDelete),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTSystemAttributes_Save(int RQMTSet_RQMTSystemID, int RQMTStageID, int CriticalityID, int RQMTStatusID, bool RQMTAccepted)
{
return(WTSData.ExecuteStoredProcedure("RQMTSystemAttributes_Save", new SqlParameter[] {
new SqlParameter("@RQMTSet_RQMTSystemID", RQMTSet_RQMTSystemID),
new SqlParameter("@RQMTStageID", RQMTStageID != 0 ? RQMTStageID : (object)DBNull.Value),
new SqlParameter("@CriticalityID", CriticalityID != 0 ? CriticalityID : (object)DBNull.Value),
new SqlParameter("@RQMTStatusID", RQMTStatusID != 0 ? RQMTStatusID : (object)DBNull.Value),
new SqlParameter("@RQMTAccepted", RQMTAccepted),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTFunctionality_Save(int RQMTSetID, int RQMTSet_RQMTSystemID, string RQMTFunctionalities, int RQMTSetFunctionalityID, int FunctionalityID, int ComplexityID, string Justification)
{
return(WTSData.ExecuteStoredProcedure("RQMTFunctionality_Save", new SqlParameter[] {
new SqlParameter("@RQMTSetID", RQMTSetID),
new SqlParameter("@RQMTSet_RQMTSystemID", RQMTSet_RQMTSystemID),
new SqlParameter("@RQMTFunctionalities", string.IsNullOrWhiteSpace(RQMTFunctionalities) ? (object)DBNull.Value : RQMTFunctionalities),
new SqlParameter("@RQMTSetFunctionalityID", RQMTSetFunctionalityID),
new SqlParameter("@FunctionalityID", FunctionalityID),
new SqlParameter("@RQMTComplexityID", ComplexityID),
new SqlParameter("@Justification", string.IsNullOrWhiteSpace(Justification) ? (object)DBNull.Value : Justification),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}));
}
public static bool RQMTSetName_Save(int RQMTSetNameID, string RQMTSetName)
{
SqlParameter paramExists = new SqlParameter("@Exists", 1);
paramExists.Direction = ParameterDirection.InputOutput;
WTSData.ExecuteStoredProcedure("RQMTSetName_Save", new SqlParameter[] {
new SqlParameter("@RQMTSetNameID", RQMTSetNameID),
new SqlParameter("@RQMTSetName", RQMTSetName),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name),
paramExists
});
return((int)paramExists.Value == 0);
}
public static bool AuditLog_Save(int ItemID, int ParentItemID, int AuditLogTypeID, int ITEM_UPDATETYPEID, string FieldChanged, string OldValue, string NewValue, DateTime UpdatedDate, string UpdatedBy)
{
if (OldValue == NewValue)
{
return(true);
}
return(WTSData.ExecuteStoredProcedure("AuditLog_Save", new SqlParameter[] {
new SqlParameter("@ItemID", ItemID),
new SqlParameter("@ParentItemID", (ParentItemID > 0 ? ParentItemID : (object)DBNull.Value)),
new SqlParameter("@AuditLogTypeID", AuditLogTypeID),
new SqlParameter("@ITEM_UPDATETYPEID", ITEM_UPDATETYPEID),
new SqlParameter("@FieldChanged", FieldChanged),
new SqlParameter("@OldValue", string.IsNullOrWhiteSpace(OldValue) ? (object)DBNull.Value : OldValue),
new SqlParameter("@NewValue", string.IsNullOrWhiteSpace(NewValue) ? (object)DBNull.Value : NewValue),
new SqlParameter("@UpdatedDate", UpdatedDate == DateTime.MinValue ? (object)DBNull.Value : UpdatedDate),
new SqlParameter("@UpdatedBy", UpdatedBy)
}));
}
public static int RQMTSet_AddRQMT(int RQMTSetID, int RQMTID, string RQMT, bool addAsChild, int childBasedOnRQMTSet_RQMTSystemID, string pasteOptions)
{
SqlParameter paramRQMTID = new SqlParameter("@RQMTID", RQMTID);
paramRQMTID.Direction = ParameterDirection.InputOutput;
if (WTSData.ExecuteStoredProcedure("RQMTSet_AddRQMT", new SqlParameter[] {
new SqlParameter("@RQMTSetID", RQMTSetID),
paramRQMTID,
new SqlParameter("@RQMT", string.IsNullOrWhiteSpace(RQMT) ? (object)DBNull.Value : RQMT),
new SqlParameter("@AddAsChild", addAsChild),
new SqlParameter("@ChildBasedOnRQMTSet_RQMTSystemID", childBasedOnRQMTSet_RQMTSystemID), // this parameter overrides the AddAsChild parameter, and bases the child indent setting on the specified RSRS's setting
new SqlParameter("@PasteOptions", string.IsNullOrWhiteSpace(pasteOptions) ? (object)DBNull.Value : pasteOptions), // when the @ChildBasedOnRQMTSet_RQMTSystemID is filled out, this option specifies whether we are copying attributes, defects, and descriptsion from source rqmtsytems (if different than the target rqmtsystem)
new SqlParameter("@CreatedBy", HttpContext.Current.User.Identity.Name),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name)
}))
{
return(paramRQMTID.Value != DBNull.Value ? (int)paramRQMTID.Value : 0);
}
return(0);
}
public static int RQMTSet_Save(int RQMTSetID, string RQMTSetName, int WTS_SYSTEMID, int WorkAreaID, int RQMTTypeID, int RQMTComplexityID, string justification)
{
SqlParameter paramRQMTSetID = new SqlParameter("@RQMTSetID", RQMTSetID);
paramRQMTSetID.Direction = ParameterDirection.InputOutput;
if (WTSData.ExecuteStoredProcedure("RQMTSet_Save", new SqlParameter[] {
paramRQMTSetID,
new SqlParameter("@RQMTSetName", RQMTSetName),
new SqlParameter("@WTS_SYSTEMID", WTS_SYSTEMID),
new SqlParameter("@WorkAreaID", WorkAreaID),
new SqlParameter("@RQMTTypeID", RQMTTypeID),
new SqlParameter("@RQMTComplexityID", RQMTComplexityID),
new SqlParameter("@Justification", string.IsNullOrWhiteSpace(justification) ? (object)DBNull.Value : justification),
new SqlParameter("@CreatedBy", HttpContext.Current.User.Identity.Name),
new SqlParameter("@UpdatedBy", HttpContext.Current.User.Identity.Name),
}))
{
RQMTSetID = (int)paramRQMTSetID.Value;
}
return(RQMTSetID);
}
