What should I do?! He melted down last night and he's a wreck?

Ok, PLEASE answer?! My fiance, Patrick, is an independent singer/guitarist and he played a huge local charity concert last night and I'm his vocal coach... Well, he's been through a lot lately... His best friend Andy tried to hang himself a couple weeks ago, and he's in the hospital... a couple days ago, he tried killing himself AGAIN by overdosing on his depression meds... he's ok, but Patrick's way down... Patrick's music that he writes is very deep... it's about personal experiences, like this... it's emotional, but not "emo." All week in the studio, he hasn't been able to get through these songs without falling apart... him and Andy are 26 and have been friends since they were 10... I was worried that he would meltdown onstage, and he did. I heard him out there apologizing to the audience, saying that he's going through a rough patch, and said he'd be back in a few minutes... I tried to console him and told him that no one would mind that he messed up... He wouldn''t listen. He was a wreck backstage, basically freaking out, beating himself up for messing up like that... I tried to calm him down, but he locked himself in the bathroom, probably in there trying to calm himself down... It killed me seeing him like that... He was a hot mess, and I didn't know what to do... So I asked him if he wanted me to go back onstage with him, and he said ok, and since I'm his vocal coach, I know his songs too, and we cut it a little short, and I sang about 5 songs with him... Well, he's TOTALLY down now... I think he feels like less of a man because of last night... I mean, he broke down onstage and they all saw him crying, and he just rushed offstage... Going back out was SO hard for him... What can I do to make him feel better?