/// <summary>
/// Checks if a copyright is used by a referenced entity
/// </summary>
/// <param name="ado"></param>
/// <param name="cprCode"></param>
/// <returns></returns>
internal bool IsInUse(ADO ado, string cprCode)
{
List <ADO_inputParams> paramList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CprCode", value = cprCode
}
};
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
ado.ExecuteNonQueryProcedure("System_Settings_Copyright_Usage", paramList, ref retParam);
if (retParam.value == 0)
{
//This record is not in use
return(false);
}
else
{
//This record is in use
return(true);
}
}
/// <summary>
/// Deletes a Copyright
/// </summary>
/// <param name="ado"></param>
/// <param name="copyright"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Delete(ADO ado, Copyright_DTO_Delete copyright, string ccnUsername)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsername", value = ccnUsername
},
new ADO_inputParams()
{
name = "@CprCode", value = copyright.CprCode
}
};
//Create a return parameter
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "@return";
retParam.value = 0;
//Executing the stored procedure
ado.ExecuteNonQueryProcedure("System_Settings_Copyright_Delete", inputParamList, ref retParam);
Log.Instance.Debug("Number of records affected: " + retParam.value);
return(retParam.value);
}
internal int Update(GeoLayer_DTO_Update dto, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@GlrCode", value = dto.GlrCode
},
new ADO_inputParams()
{
name = "@GlrName", value = dto.GlrName
},
new ADO_inputParams()
{
name = "@CcnUsername", value = userName
},
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_GeoLayer_Update", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Createws the Frequency record in the database
/// </summary>
/// <param name="dto"></param>
/// <param name="matrixId"></param>
/// <returns></returns>
internal int CreateFrequencyRecord(FrequencyRecordDTO_Create dto, int matrixId)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@FrqValue", value = dto.Value
},
new ADO_inputParams()
{
name = "@FrqCode", value = dto.Code
},
new ADO_inputParams()
{
name = "@FrqMtrId", value = matrixId
},
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Frequency_Create", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Creates a Copyright
/// </summary>
/// <param name="ado"></param>
/// <param name="copyright"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Create(ADO ado, Copyright_DTO_Create copyright, string ccnUsername)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsername", value = ccnUsername
},
new ADO_inputParams()
{
name = "@CprCode", value = copyright.CprCode
},
new ADO_inputParams()
{
name = "@CprValue", value = copyright.CprValue
},
new ADO_inputParams()
{
name = "@CprUrl", value = copyright.CprUrl
}
};
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("System_Settings_Copyright_Create", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
/// <summary>
/// Deletes a Keyword Subject
/// </summary>
/// <param name="dto"></param>
/// <param name="mandatoryOnly"></param>
/// <returns></returns>
internal int Delete(Keyword_Subject_DTO dto, bool?mandatoryOnly = null)
{
var inputParams = new List <ADO_inputParams>();
if (dto.KsbCode != default(int))
{
inputParams.Add(new ADO_inputParams()
{
name = "@KsbCode", value = dto.KsbCode
});
}
if (dto.SbjCode != default(int))
{
inputParams.Add(new ADO_inputParams()
{
name = "@SbjCode", value = dto.SbjCode
});
}
if (mandatoryOnly != null)
{
inputParams.Add(new ADO_inputParams()
{
name = "@KsbMandatoryFlag", value = mandatoryOnly
});
}
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Keyword_Subject_Delete", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Creates a Statistic object in the database
/// </summary>
/// <param name="dto"></param>
/// <param name="matrixId"></param>
/// <returns></returns>
internal int CreateStatisticalRecord(StatisticalRecordDTO_Create dto, int matrixId)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@SttMtrId", value = matrixId
},
new ADO_inputParams()
{
name = "@SttValue", value = dto.Value
},
new ADO_inputParams()
{
name = "@SttCode", value = dto.Code
},
new ADO_inputParams()
{
name = "@SttUnit", value = dto.Unit
},
new ADO_inputParams()
{
name = "@SttDecimal", value = dto.Decimal
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Statistic_Create", inputParams, ref returnParam);
return((int)returnParam.value);
}
internal bool UpdateKey(string subscriberUserId, string subscriberKey)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@SbrUserId", value = subscriberUserId
},
new ADO_inputParams()
{
name = "@SbrKey", value = subscriberKey
}
};
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam
{
name = "return",
value = 0
};
//Attempting to create the new entity
_ado.ExecuteNonQueryProcedure("Subscription_Subscriber_UpdateSubscriberKey", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value > 0);
}
/// <summary>
/// Creates a Matrix
/// </summary>
/// <param name="dto"></param>
/// <param name="releaseId"></param>
/// <param name="userName"></param>
/// <returns></returns>
internal int CreateMatrixRecord(Matrix_DTO dto, int releaseId, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@MtrCode", value = dto.MtrCode
},
new ADO_inputParams()
{
name = "@MtrTitle", value = dto.MtrTitle
},
new ADO_inputParams()
{
name = "@LngIsoCode", value = dto.LngIsoCode
},
new ADO_inputParams()
{
name = "@CprValue", value = dto.CprValue
},
new ADO_inputParams()
{
name = "@FrmType", value = dto.FrmType
},
new ADO_inputParams()
{
name = "@FrmVersion", value = dto.FrmVersion
},
new ADO_inputParams()
{
name = "@MtrOfficialFlag", value = dto.MtrOfficialFlag
},
new ADO_inputParams()
{
name = "@MtrNote", value = dto.MtrNote
},
new ADO_inputParams()
{
name = "@MtrInput", value = dto.MtrInput
},
new ADO_inputParams()
{
name = "@MtrRlsId", value = releaseId
},
new ADO_inputParams()
{
name = "@userName", value = userName
},
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Matrix_Create", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Updates an existing Group
/// </summary>
/// <param name="ado"></param>
/// <param name="group"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Update(ADO ado, Group_DTO_Update group, string ccnUsername)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>();
inputParamList.Add(new ADO_inputParams()
{
name = "@GrpCodeOld", value = group.GrpCodeOld
});
inputParamList.Add(new ADO_inputParams()
{
name = "@GrpCodeNew", value = group.GrpCodeNew
});
inputParamList.Add(new ADO_inputParams()
{
name = "@GrpName", value = group.GrpName
});
inputParamList.Add(new ADO_inputParams()
{
name = "@UpdateCcnUsername", value = ccnUsername
});
if (!string.IsNullOrEmpty(group.GrpContactName))
{
inputParamList.Add(new ADO_inputParams()
{
name = "@GrpContactName", value = group.GrpContactName
});
}
if (!string.IsNullOrEmpty(group.GrpContactPhone))
{
inputParamList.Add(new ADO_inputParams()
{
name = "@GrpContactPhone", value = group.GrpContactPhone
});
}
if (!string.IsNullOrEmpty(group.GrpContactEmail))
{
inputParamList.Add(new ADO_inputParams()
{
name = "@GrpContactEmail", value = group.GrpContactEmail
});
}
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Security_Group_Update", inputParamList, ref retParam);
Log.Instance.Debug("Called stored procedure Security_Group_Update");
//Assign the returned value for checking and output
return(retParam.value);
}
/// <summary>
/// Updates a workflow Request - in practice this means setting the CurrentFlag to true or false
/// </summary>
/// <param name="ado"></param>
/// <param name="dto"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Update(ADO ado, WorkflowRequest_DTO_Update dto, string ccnUsername)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsername", value = ccnUsername
},
new ADO_inputParams()
{
name = "@RlsCode", value = dto.RlsCode
},
new ADO_inputParams()
{
name = "@WrqCurrentFlag", value = dto.WrqCurrentFlag
}
};
if (dto.WrqArchiveFlag != null)
{
inputParams.Add(new ADO_inputParams()
{
name = "@WrqArchiveFlag", value = dto.WrqArchiveFlag
});
}
if (dto.WrqReservationFlag != null)
{
inputParams.Add(new ADO_inputParams()
{
name = "@WrqReservationFlag", value = dto.WrqReservationFlag
});
}
if (dto.WrqExperimentalFlag != null)
{
inputParams.Add(new ADO_inputParams()
{
name = "@WrqExperimentalFlag", value = dto.WrqExperimentalFlag
});
}
var retParam = new ADO_returnParam()
{
name = "return", value = 0
};
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Workflow_WorkflowRequest_Update", inputParams, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
/// <summary>
/// Runs an SQL Job to clean up old data after an updated release
/// </summary>
/// <param name="processName"></param>
internal void DeleteEntities(string processName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@job_name", value = processName
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("sp_start_job", inputParams, ref returnParam);
}
/// <summary>
/// Delete performance entries
/// </summary>
/// <param name="ado"></param>
/// <param name="dto"></param>
/// <param name="ccnUsername"></param>
/// <returns></returns>
internal int Delete(ADO ado, dynamic dto, string ccnUsername)
{
var inputParams = new List <ADO_inputParams>()
{
// No parameters required as will be truncating whole table
};
var retParam = new ADO_returnParam()
{
name = "return", value = 0
};
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Security_Performance_Delete", inputParams, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
internal bool Delete(string userQueryId, string subscriberUserId = null, string ccnUsername = null)
{
if (subscriberUserId == null && ccnUsername == null)
{
return(false);
}
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>();
if (userQueryId != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@UserQueryId", value = userQueryId
});
}
if (subscriberUserId != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@SubscriberUserId", value = subscriberUserId
});
}
if (ccnUsername != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@CcnUsername", value = ccnUsername
});
}
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
// Attempting to delete the entity
_ado.ExecuteNonQueryProcedure("Subscription_Query_Delete", inputParamList, ref retParam);
// Assign the returned value for checking and output
return(retParam.value > 0);
}
/// <summary>
/// Tests if an SQL Job is running
/// </summary>
/// <param name="processName"></param>
/// <returns></returns>
internal bool IsProcessRunning(string processName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams {
name = "@JobName", value = processName
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Matrix_IsJobRunning", inputParams, ref returnParam);
return(returnParam.value != 0);
}
/// <summary>
/// Updates a product
/// </summary>
/// <param name="dto"></param>
/// <param name="IsDefault"></param>
/// <param name="userName"></param>
/// <returns></returns>
internal int Update(Product_DTO dto, bool IsDefault, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@PrcCode", value = dto.PrcCode
},
new ADO_inputParams()
{
name = "@PrcCodeNew", value = dto.PrcCodeNew
},
new ADO_inputParams()
{
name = "@SbjCode", value = dto.SbjCode
},
new ADO_inputParams()
{
name = "@PrcValue", value = dto.PrcValue
},
new ADO_inputParams()
{
name = "@userName", value = userName
},
new ADO_inputParams()
{
name = "@IsDefault", value = IsDefault
},
};
var outputParam = new ADO_outputParam()
{
name = "@ProductID", value = 0
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("System_Navigation_Product_Update", inputParams, ref returnParam, ref outputParam);
return((int)outputParam.value);
}
internal int Create(GeoMap_DTO_Create dto, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@GmpCode", value = dto.GmpCode
},
new ADO_inputParams()
{
name = "@GmpName", value = dto.GmpName
},
new ADO_inputParams()
{
name = "@GmpDescription", value = dto.GmpDescription
},
new ADO_inputParams()
{
name = "@GmpGeoJson", value = dto.GmpGeoJson
},
new ADO_inputParams()
{
name = "@GmpFeatureCount", value = dto.GmpFeatureCount
},
new ADO_inputParams()
{
name = "@GlrCode", value = dto.GlrCode
},
new ADO_inputParams()
{
name = "@CcnUsername", value = userName
},
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Geomap_Create", inputParams, ref returnParam);
return((int)returnParam.value);
}
/// <summary>
/// Checks if a Reason exists
/// </summary>
/// <param name="ado"></param>
/// <param name="rsnCode"></param>
/// <returns></returns>
internal bool Exists(ADO ado, string rsnCode)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@RsnCode", value = rsnCode
}
};
//Create a return parameter
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "@return";
retParam.value = 0;
ado.ExecuteNonQueryProcedure("System_Settings_Reason_Exists", inputParamList, ref retParam);
return(retParam.value != default(int));
}
internal int Logout(string session)
{
List <ADO_inputParams> paramList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@LgnSession", value = session
}
};
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
ado.ExecuteNonQueryProcedure("Security_Login_Logout", paramList, ref retParam);
return(retParam.value);
}
/// <summary>
/// Checks if a Group is used by a referenced entity
/// </summary>
/// <param name="ado"></param>
/// <param name="grpCode"></param>
/// <returns></returns>
internal bool IsInUse(ADO ado, string grpCode)
{
List <ADO_inputParams> paramList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@GrpCode", value = grpCode
}
};
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
ado.ExecuteNonQueryProcedure("Security_Group_Usage", paramList, ref retParam);
return(retParam.value == 1);
}
/// <summary>
/// Creates a Trace
/// </summary>
/// <param name="ado"></param>
/// <param name="trace"></param>
/// <param name="inTransaction"></param>
/// <returns></returns>
internal int Create(ADO ado, Trace_DTO_Create trace)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@TrcMethod", value = trace.TrcMethod
},
new ADO_inputParams()
{
name = "@TrcParams", value = trace.TrcParams
},
new ADO_inputParams()
{
name = "@TrcIp", value = trace.TrcIp
},
new ADO_inputParams()
{
name = "@TrcUseragent", value = trace.TrcUseragent
}
};
if (!string.IsNullOrEmpty(trace.CcnUsername))
{
inputParamList.Add(new ADO_inputParams()
{
name = "@CcnUsername", value = trace.CcnUsername
});
}
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
//Executing the stored procedure
ado.ExecuteNonQueryProcedure("Security_Trace_Create", inputParamList, ref retParam);
return(retParam.value);
}
/// <summary>
/// Checks if a Current Workflow Request already exists
/// </summary>
/// <param name="ado"></param>
/// <param name="dto"></param>
/// <returns></returns>
internal bool IsCurrent(ADO ado, int rlsCode)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@RlsCode", value = rlsCode
},
};
var retParam = new ADO_returnParam()
{
name = "return", value = 0
};
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Workflow_ReadIsCurrent", inputParams, ref retParam);
//Assign the returned value for checking and output
return(retParam.value != default(int));
}
/// <summary>
/// Checks if there is already a Workflow Response for a given Release Code
/// </summary>
/// <param name="ado"></param>
/// <param name="dto"></param>
/// <returns></returns>
internal bool IsInUse(ADO ado, dynamic dto)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@RlsCode", value = dto.RlsCode
},
};
var retParam = new ADO_returnParam()
{
name = "return", value = 0
};
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Workflow_Response_Usage", inputParams, ref retParam);
//Assign the returned value for checking and output
return(retParam.value > 0);
}
internal void MarkMatrixAsContainingData(int mtrId, bool containsData)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@MtrDataFlag", value = containsData
},
new ADO_inputParams()
{
name = "@MtrId", value = mtrId
},
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Matrix_Update_Data_Flag", inputParams, ref returnParam);
}
/// <summary>
/// Creates a ReasonRelease entity
/// </summary>
/// <param name="ado"></param>
/// <param name="reasonRelease"></param>
/// <param name="userName"></param>
/// <returns></returns>
internal int Create(ADO ado, ReasonRelease_DTO_Create reasonRelease, string userName)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@RlsCode", value = reasonRelease.RlsCode
},
new ADO_inputParams()
{
name = "@RsnCode", value = reasonRelease.RsnCode
},
new ADO_inputParams()
{
name = "@CcnUsername", value = userName
},
};
if (reasonRelease.CmmValue != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@CmmValue", value = reasonRelease.CmmValue
});
}
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam
{
name = "return",
value = 0
};
//Attempting to create the new entity
ado.ExecuteNonQueryProcedure("Data_Reason_Release_Create", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value);
}
/// <summary>
/// Checks if this Release is the latest future live release
/// </summary>
/// <param name="ado"></param>
/// <param name="rlsCode"></param>
/// <returns></returns>
internal bool IsLiveNext(int rlsCode)
{
if (rlsCode == 0)
{
return(false);
}
var paramList = new List <ADO_inputParams>();
paramList.Add(new ADO_inputParams {
name = "@RlsCode", value = rlsCode
});
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Release_IsLiveNext", paramList, ref returnParam);
return(Convert.ToBoolean(returnParam.value));
}
internal bool Create(string sbrPreference, string subscriberUserId, string lngIsoCode, string sbrKey)
{
List <ADO_inputParams> inputParamList = new List <ADO_inputParams>();
if (sbrPreference != null)
{
inputParamList.Add(new ADO_inputParams()
{
name = "@Preference", value = sbrPreference
});
}
inputParamList.Add(new ADO_inputParams()
{
name = "@SubscriberUserId", value = subscriberUserId
});
inputParamList.Add(new ADO_inputParams()
{
name = "@LngIsoCode", value = lngIsoCode
});
inputParamList.Add(new ADO_inputParams()
{
name = "@SbrKey", value = sbrKey
});
// A return parameter is required for the operation
ADO_returnParam retParam = new ADO_returnParam();
retParam.name = "return";
retParam.value = 0;
//Attempting to create the new entity
_ado.ExecuteNonQueryProcedure("Subscription_Subscriber_Create", inputParamList, ref retParam);
//Assign the returned value for checking and output
return(retParam.value > 0);
}
internal void UpdateIndexes(ADO ado)
{
ADO adoBatch = new ADO("msdbConnection");
Matrix_ADO m = new Matrix_ADO(ado);
string dbName = m.getDbName();
string processName = "DataMatrixUpdateIndexes_" + dbName;
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@job_name", value = processName
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
if (!m.IsProcessRunning(processName))
{
try
{
adoBatch.ExecuteNonQueryProcedure("sp_start_job", inputParams, ref returnParam);
}
catch (Exception ex)
{
throw ex;
}
finally
{
adoBatch.CloseConnection();
adoBatch.Dispose();
}
}
}
/// <summary>
/// Deletes the Release Comment
/// </summary>
/// <param name="dto"></param>
/// <param name="userName"></param>
/// <returns></returns>
internal int DeleteComment(Release_DTO dto, string userName)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@CcnUsername", value = userName
},
new ADO_inputParams()
{
name = "@RlsCode", value = dto.RlsCode
}
};
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Release_Comment_Delete", inputParams, ref returnParam);
return(ReadInt(returnParam.value));
}
/// <summary>
/// Creates a Classfication record in the database
/// </summary>
/// <param name="dto"></param>
/// <param name="matrixId"></param>
/// <returns></returns>
internal int CreateClassificationRecord(ClassificationRecordDTO_Create dto, int matrixId)
{
var inputParams = new List <ADO_inputParams>()
{
new ADO_inputParams()
{
name = "@ClsMtrId", value = matrixId
},
new ADO_inputParams()
{
name = "@ClsValue", value = dto.Value
},
new ADO_inputParams()
{
name = "@ClsCode", value = dto.Code
},
new ADO_inputParams()
{
name = "@ClsGeoFlag", value = dto.GeoFlag
}
};
if (!string.IsNullOrEmpty(dto.GeoUrl))
{
inputParams.Add(new ADO_inputParams()
{
name = "@ClsGeoUrl", value = dto.GeoUrl
});
}
var returnParam = new ADO_returnParam()
{
name = "@ReturnVal", value = 0
};
ado.ExecuteNonQueryProcedure("Data_Classification_Create", inputParams, ref returnParam);
return((int)returnParam.value);
}
