Close connection

try
{
      // This creates an Instance of the API. 
      VismaLön600.Application lon = new VismaLön600.Application();

      // Initialize the server
      // For Lön 2018.1 or later, use Init (with APIversion 2.0) instead of InitServer
      if (lon.Init(“2.0”, null) != 0)
      {
          return false;
      }

          // Login with a API-user. Username, password and the name of the company in the database
      string Login_Signature = "api";
      string Login_Pwd = "se";
      string DBCompanyName = "SPCS_Lön_Ftg1";

      int returncode = lon.Logon (Signature , Login_Pwd , DBCompanyName);

      if (returncode != 0)
      {
                  Console.WriteLine("Error when trying to login." + returncode);
                  return false;
      }

      // You are now logged in
      return true;
  }

       catch (System.Runtime.InteropServices.COMException ex)
       {
           // When something unexpected happens, like the database could not be Initialized,
           // then the API thows an exception.
           Console.WriteLine("COMException when trying to login." + ex.ErrorCode);
       }

Select allOpen in new window

try
{
      // Creates a TableObject that contains the records of Employees
    EmployeeTableObject employeeTableObject = lon.CreateTableObject((int)Tables.Table_Employee);

    // Reads all the Records Id and put them in the employeeTableObject              
    employeeTableObject.Fetch();

    // IsEOF is true as long as the position in the table is inside the boundaries.
    while (!employeeTableObject.IsEOF())
    {
            // Reads the current record.
            String firstname = employeeTableObject.GetString((int)Employee_Properties.EMP_FirstName);
            Console.WriteLine(firstname);

          // When moving to a new record, the record is read into the current record.
            TestMain.EmployeeTO.MoveNext();
    }
    catch (System.Runtime.InteropServices.COMException ex)
    {
            Console.WriteLine("COMException:" + ex.ErrorCode);
    }
}

Select allOpen in new window