I've changed my name for this thread.
I don't know this person well enough to say he's a friend but he seems like a pleasant enough man (just a drinker). I'll call him John for the purpose of the thread.
John got chatting to my partner when he saw him working in the front garden last year and ever since then he'll stop and chat when he passes. He doesn't live round here but is down our street fairly often as he comes to do bits and bobs for his elderly mum.
DP works nights and had been up for about half an hour when we had a knock at the door from John. I was cooking at the time but stopped what I was doing and opened the door. John asked if I could get DP.
DP goes to the door and John's visibly drunk and upset, he tells DP that his adult daughter has just died 
I'm still sorting food at this point and both our children are awake and in the front room so we were all caught off guard.
DP tells him he's really sorry to hear that and what terrible news it is, then John said he just needed somebody to talk to.
DP doesn't know what to say at this point (he's very socially awkward) and after a few seconds silence John says he'll be on his way then and walks off. DP calls after him to say are you going to be ok John but he doesn't reply.
I don't know him well enough to feel comfortable inviting him into our house when he's clearly intoxicated. The children were awake, we were about to eat and DP has work shortly.
We both feel terrible for him but what would you have done in this situation?