Mr Macaskill , who works for South Yorkshire Passenger Transport Executive as an administrator , believes thieves sprayed the family with a substance to make sure they remained asleep while the robbery took place .