The use of C*-algebras in singular foliations and their representation theory