Gunman 'killed himself' after Texas church massacre