The mess of an affair.

Please can I ask for people's advice? I have been in an affair for 8months with someone from work he is married and has two children. He told me he loved and wanted to be with not his wife and even put in an offer for a house for us to live together in. But then he told me he couldn't leave his children. I excepted this. Last week there was a work do I asked him to come but he said he wouldn't but then he did. All night he lead me on telling me how much he loved me, wanted to be with me, go away with him this year and when it came to the end of the night he wanted to go home but I persuaded him to come back to mine. He didn't go back home so his wife had had enough and threw him out. she encouraged him to go out because she knew what would happen. He had no where else to go so he came to mine and went back to see his children when he can. He is unhappy now because he isn't with his children and blames me saying I got what I wanted. He hasnt been happy for a long time and only stayed for his children and all I wanted was for him to be happy because I love him so much and I believed him. He didn't come back last night and isn't talking to me. He has stuff here so still needs to come back but I don't know what to do or say to him? Was he just using me the whole time and now everything has become a complete and I don't know how to sort it?