C # adding a transaction in the data layer

Example public bool save (projectmodel project) {int result = 0;Sqlconnection Conn= New sqlconnection (sqlhelper. connectionstring); Conn. open (); sqltransaction trans; Trans = conn. begintransaction ();Try {sqlparameter [] sqlparameter1 = new sqlparameter [] {New sqlparameter {parametername = "@ employeeid", value = project. employeeid }}; int projectid = convert. toint16 (sqlhelper. executescalar (trans, commandtype. storedprocedure, "saveproject", sqlparameter1); If (projectid! = 0) {If (project. linkmaninfolist. count> 0) {string sqltext = ""; for (INT I = 0; I <project. linkmaninfolist. count; I ++) {sqltext = "insert into customer (projectid) values ('" + projectid + "')"; Result + = sqlhelper. executesql (sqltext) ;}} if (! String. isnullorempty (project. projectstage) {string sqltext2 = "insert into projectstagecondition ()"; sqlparameter [] sqlparameter3 = new sqlparameter [] {New sqlparameter {parametername = "@ projectstagedesc", value = project. projectstage} result + = sqlhelper. executesql (sqltext2, sqlparameter3);} else {result ++ ;}}Trans. Commit ();} Catch (exception ex ){Trans. rollback ();} Finally {Conn. Close ();} Return result = project. linkmaninfolist. Count ;}