Using SQLHELPER, how to make it roll back, how to retrieve the return value

SqlConnection CS; cs = new sqlconnection; sqltransaction dbtransaction = null; string p_strreturnMessage = ""; int p_intoutput = 0;

Try {#region populate parameters system.data.sqlclient.sqlparameter [] arparams = new system.data.sqlclient.sqlparameter [4];

arParams [0] = new System.Data.SqlClient.SqlParameter ( "@ intOrganizeID", System.Data.SqlDbType.Int); arParams [1] = new System.Data.SqlClient.SqlParameter ( "@ strMacAddress", System.Data . Sqldbtype.varchar, 256); Arparams [2] = new system.data.sqlclient.sqlparameter ("@ strmaccheck", system.data.sqldbtype.varchar, 256); arparams [3] = new system.data.sqlclient. SqlParameter ("@ INTOUTPUT", System.Data.sqldbtype.It);

Arparams [3] .direction = system.data.parameterDirection.output;

Arparams [0] .Value = 1; arparams [1] .value = "111"; arparams [2] .Value = "111"; arparams [3] .value = p_intoutput; #ndregion #Region Execute SQL CS.Open ); Dbtransaction = cs.begintransaction (); SQLHELPER.EXECUTENONQUERY (DBTransaction, CommandType.StoredProcedure, "Pro_T_Accredit_create", ARPARAMS);

P_intoutput = Convert.Toint32 (ARPARAMS [3] .Value.toString ()); #ENDREGION

#REGION CHECK RESULT IF (p_intoutput <0) {dbtransaction.rollback (); // - Retreat} else {dbtransaction.commit (); // - Submit transaction} #ENDREGON} catch (System.nullReferenceException Nullex) {DBTRANSACTION.ROLLBACK (); // - Retreat} catch (exception ex) {dbtransaction.rollback (); // - Retreat}