public int SaveUserDetail(UserUI objUI, System.Data.SqlClient.SqlTransaction objTrans) { int UserID = 0; bool flagTransation = true; UserDB objDB = new UserDB(); objDB.UserID = objUI.UserID; //objDB.LevelID = objUI.LevelID; objDB.dRegionID = objUI.dRegionID; objDB.ReportsToID = objUI.ReportsToID; objDB.CheckID = objUI.CheckID; DataAccessLayer objDataAccess = new DataAccessLayer(); try { if (objTrans == null) { flagTransation = false; objDataAccess.GetConnection.Open(); SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction(); objTrans = objTransaction; } UserManager objManager = new UserManager(); UserID = objManager.SaveUserDetail(objDB, objTrans); if (!flagTransation) objTrans.Commit(); return UserID; } catch (Exception ex) { if (!flagTransation) objTrans.Rollback(); throw ex; } finally { objDataAccess.GetConnection.Close(); } }