Need to programatically get the Stored Procedure and DB CPU details

I need to programatically get the Stored Procedure and DB CPU details using SQL Diagnostic Manager.

Any API's / queries/Stored Procedures  that I can use to get the below Statistics

1) DatabaseCPU

2) Top 20 slow queries/SPs by AvgTiming

3) Top 20 queries/SPs by Execution count

4) Top 20 CPU Intensive  queries/SPs