// Example of using the EmployeePresenter class
using System;
using RedWingSoftware.CenterPoint.Api;

class Sample
{
  public static void Main()
  {
     var presenter = new EmployeePresenter();

     // Get a list of employees
     var employeeList = presenter.GetList();

     // Retrieve data for the first employee in the list
     var id = employeeList.First().Id;
     var employee = presenter.LoadEmployee(id);

     Console.WriteLine("Employee name before change: {0}", employee.FirstLast());

     employee.LastName = "Smith";

     Console.WriteLine("Employee name after change: {0}", employee.FirstLast());

     presenter.SaveEmployee(employee);

     // Reload the employee
     employee = presenter.LoadEmployee(id);

     Console.WriteLine("Employee name after reload: {0}", employee.FirstLast());
  }
}

         // Initialize api and Open Database
         var api = new CenterPointExternalAPI();
         api.Initialize();
         api.OpenDatabaseByName("PayrollSample"); // There's an overloaded method in case your database is password-protected for which you would need to 

A connection to the database could not be established, the database or your connection to the server may no longer be valid.

Please check your database and server configuration then try again

Error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

Parameter name: databaseName</Message><StackTrace>   at RedWingSoftware.CenterPoint.ExternalAPI.BaseExternalAPI.OpenDatabaseByName(String databaseName, String userName, String password)
   at RedWingSoftware.CenterPoint.ExternalAPI.BaseExternalAPI.OpenDatabaseByName(String databaseName)
   at PayrollScript.Program.Main(String[] args) in C:\Users\aharbison\Desktop\PayrollScript\PayrollScript\Program.cs:line 18</StackTrace><ExceptionString>System.ArgumentException: The database PayrollSample could not be opened.
Parameter name: databaseName
   at RedWingSoftware.CenterPoint.ExternalAPI.BaseExternalAPI.OpenDatabaseByName(String databaseName, String userName, String password)
   at RedWingSoftware.CenterPoint.ExternalAPI.BaseExternalAPI.OpenDatabaseByName(String databaseName)
   at PayrollScript.Program.Main(String[] args) in C:\Users\aharbison\Desktop\PayrollScript\PayrollScript\Program.cs:line 18</ExceptionString></Exception></TraceRecord>
An unhandled exception of type 'System.ArgumentException' occurred in RedWingSoftware.ExternalAPI.L0.V1.dll
The database PayrollSample could not be opened.

'PayrollScript.exe' (CLR v4.0.30319: PayrollScript.exe): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\PrivateAssemblies\Runtime\Microsoft.VisualStudio.Debugger.Runtime.dll'. Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
The program '[12088] PayrollScript.exe' has exited with code 0 (0x0).

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using RedWingSoftware.CenterPoint.Api;
using RedWingSoftware.CenterPoint.ExternalAPI;

namespace PayrollScript
{
    class Program
    {
        static void Main(string[] args)
        {
            // Initialize api and Open Database
            var api = new CenterPointExternalAPI();
            api.Initialize();
            api.OpenDatabaseByName("PayrollSample");

            var presenter = new EmployeePresenter();

            // Get a list of employees
            var employeeList = presenter.GetList();

            // Retrieve data for the first employee in the list
            var id = employeeList.First().Id;
            var employee = presenter.LoadEmployee(id);

            Console.WriteLine("Employee name before change: {0}", employee.FirstLast());

            employee.LastName = "Smith";

            Console.WriteLine("Employee name after change: {0}", employee.FirstLast());

            presenter.SaveEmployee(employee);

            // Reload the employee
            employee = presenter.LoadEmployee(id);

            Console.WriteLine("Employee name after reload: {0}", employee.FirstLast());

            api.CloseDatabase();
        }
    }
}

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)


         // 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;
      }
   }
}