I agree with the wise one.
Honestly,some relationships can survive infidelity (or any severe breach of trust). Some can not.
You need to decide if your relationship with this man can survive a breach of trust such as this one. You need to decide if you would ever be able to forgive him, and if you would be able to let him build trust back up.
Will you ever be able to let this go? Will you hold it against him and use it against him if you get into fights?
Only you can (and should) be able to decide these things for yourself.
Good luck.