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