Theoretical studies in dye-sensitized solar cells and photo-catalysis at metal oxide interfaces.