public bool ChangeSetting(ChangeSettingRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Update_Settings", conn); AddInParameter(commandWrapper, "@SettingId", DbType.Int16, request.Setting.Id); AddInParameter(commandWrapper, "@IncludeInCalculation", DbType.String, request.Setting.IncludeInCalculation); AddInParameter(commandWrapper, "@Amount", DbType.String, request.Setting.Amount); AddInParameter(commandWrapper, "@ERROR", DbType.String, 1000); AddInParameter(commandWrapper, "@ERROR_CODE", DbType.String, 4); try { conn.Open(); int results = commandWrapper.ExecuteNonQuery(); var isProcedureSucced = Convert.ToBoolean(results); MakeDboLog(request.ToString(), isProcedureSucced.ToString(), "dbo.Update_Settings"); var errorObject = GetParameterValue(commandWrapper, "@ERROR"); var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE"); return(Convert.ToBoolean(results)); } finally { commandWrapper.Dispose(); conn.Close(); } }