using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using CenterPointDataBrowser;

namespace CenterPointDataBrowser
{
   public class ReportDataExample
   {
      public DataSet GetReportData()
      {
         string databaseName = "PayrollSample";
         string reportKey = "968465a0-1b3c-47b8-9b80-915ad2888037";

         // Initialize the API
         DataAccessAPI api = new DataAccessAPI();

         // Open the database
         api.OpenDatabase(databaseName); // there is an over-loaded method if you need to supply a user/name password

         // Retrieve the report
         Report report = api.GetReport(reportKey);

         // Uncomment the following line of code line if you do not want any filters 
         // If commented out, then the filters set in CP are applied.
         // report.ClearFilters(); 
         
         // Set filters (optional)
         report.SetFilterText("Filter_FirstName", TextOperators.Contains, "the");
         report.SetFilterText("Filter_LastName", TextOperators.Contains, "the");


         // Uncomment the following line of code line if you do not want any options
         // If commented out, then the options set in CP are used
         // report.ClearOptions(); 

         // Set options (optional)


         // Gather the report's data
         //
         // Note: Some reports only return the data needed to produce the report. If you want
         // to return all data, then change GetReportData(false) to GetReportData(true)
         DataSet ds =  report.GetReportData(false); 

		 // Close the database 
         api.CloseDatabase();
         return ds;
      }
      static void Main(string[] args) {
      }
   }
}

C:\Program Files (x86)\Red Wing Software\CenterPoint\ReflectedDLLs>csc --version

Microsoft (R) Visual C# Compiler version 3.4.0-beta4-19569-03 (82f2e254)
Copyright (C) Microsoft Corporation. All rights reserved.

error CS2007: Unrecognized option: '--version'
warning CS2008: No source files specified.
error CS1562: Outputs without source must have the /out option specified

C:\Program Files (x86)\Red Wing Software\CenterPoint\ReflectedDLLs>csc /r:Center
pointDataBrowser.DLL hello.cs
Microsoft (R) Visual C# Compiler version 3.4.0-beta4-19569-03 (82f2e254)
Copyright (C) Microsoft Corporation. All rights reserved.


C:\Program Files (x86)\Red Wing Software\CenterPoint\ReflectedDLLs>hello.exe

Unhandled Exception: System.BadImageFormatException: Could not load file or asse
mbly 'CenterPointDataBrowser, Version=14.10.6.0, Culture=neutral, PublicKeyToken
=null' or one of its dependencies. An attempt was made to load a program with an
 incorrect format.
   at CenterPointDataBrowser.ReportDataExample.GetReportData()
   at CenterPointDataBrowser.ReportDataExample.Main(String[] args)

C:\Program Files (x86)\Red Wing Software\CenterPoint\ReflectedDLLs>