/// <summary> /// Updates the Control record /// </summary> /// <param name="entity">The entity.</param> public void Update(PatControl entity) { var patControl = entity; Debug.Assert(patControl != null, "control != null"); using (var connection = new SqlConnection(DbConnection)) { using (var command = new SqlCommand("PaControlUpdate", connection)) { var sqlParams = new List <SqlParameter>(); SqlHelper.AddReturnPara("@return_value", sqlParams); if (patControl.ControlId > 0) { SqlHelper.AddIntPara(patControl.ControlId, "@Id", sqlParams); } SqlHelper.AddIntPara(patControl.ProjectCount, "@ProjectCount", sqlParams); SqlHelper.AddIntPara(patControl.SampleCount, "@SampleCount", sqlParams); SqlHelper.AddIntPara(patControl.ReviewCount, "@ReviewCount", sqlParams); SqlHelper.AddDecimalPara(patControl.ProjectCompletion, 3, "@ProjectCompletion", sqlParams); SqlHelper.AddDecimalPara(patControl.TotalComplianceIndicator, 3, "@TotalComplianceIndicator", sqlParams); SqlHelper.AddBitPara(patControl.SystemAvailable, "@SystemAvailable", sqlParams); if (patControl.LastBatchRun != new DateTime(1, 1, 1)) { SqlHelper.AddDatePara(patControl.LastBatchRun, "@LastBatchRun", sqlParams); } if (patControl.LastComplianceRun != new DateTime(1, 1, 1)) { SqlHelper.AddDatePara(patControl.LastComplianceRun, "@LastComplianceRun", sqlParams); } SqlHelper.AddVarcharPara(patControl.UpdatedBy, "@UpdatedBy", sqlParams); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(sqlParams.ToArray()); connection.Open(); command.ExecuteNonQuery(); } } }
/// <summary> /// Updates the Compliance indicator. /// </summary> /// <param name="entity">The CI data.</param> public void Update(ComplianceIndicator entity) { var complianceIndicator = entity; Debug.Assert(complianceIndicator != null, "complianceIndicator != null"); using (var connection = new SqlConnection(DbConnection)) { using (var command = new SqlCommand("PaComplianceIndicatorUpdate", connection)) { var sqlParams = new List <SqlParameter>(); var paramReturnValue = new SqlParameter("@return_value", SqlDbType.Int) { Direction = ParameterDirection.ReturnValue }; sqlParams.Add(paramReturnValue); SqlHelper.AddIntPara(complianceIndicator.ComplianceIndicatorId, "@Id", sqlParams); SqlHelper.AddVarcharPara(complianceIndicator.Programme, "@Programme", sqlParams); SqlHelper.AddVarcharPara(complianceIndicator.SubjectTypeCode, "@SubjectTypeCode", sqlParams); SqlHelper.AddVarcharPara(complianceIndicator.Subject, "@Subject", sqlParams); SqlHelper.AddVarcharPara(complianceIndicator.EsaCode, "@EsaCode", sqlParams); SqlHelper.AddVarcharPara(complianceIndicator.Quarter, "@Quarter", sqlParams); SqlHelper.AddDecimalPara(complianceIndicator.Value, 3, "@ComplianceIndicator", sqlParams); SqlHelper.AddVarcharPara(complianceIndicator.UpdatedBy, "@UpdatedBy", sqlParams); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(sqlParams.ToArray()); connection.Open(); command.ExecuteNonQuery(); } } }