If you got upset and closed your account over the phone can you get it re-opened?

Possibly, depending on how "upset" you were :). You would need to write the CCC explaining the situation. If you have a good payment history they would probably restore your account.