A cancer patient was forced to spend a “bloody inhumane” night in a chair at the Grange hospital, only getting a bed after collapsing on the floor, the Senedd has heard.