Technical Overview

Click Program Structure Diagram, to see an overview of the program..

KPPayroll Executable

Contains all the user interface forms.

KPPayObj Object

Contains all the collection classes and objects to support the user interface and intranet forms. There is a separate class for the collection and object of each object that can be maintained through the user interface, plus a single class, ReportData which contains the SQL to retrieve the data for all reports.

The main payroll calculations are processed automatically as payslip items are created and the main payslip object is saved.

Each object only accepts changes after a 'BeginEdit' or a 'BeginChildEdit' method is executed. To cancel all changes, a 'CancelEdit' or 'CancelChildEdit' method can be called, or an 'ApplyEdit' or 'ApplyChildEdit' method called to keep the changes. The 'Child' methods are used for the child objects in an object heirarchy, and simply control the editing state. The parent's 'ApplyEdit' method must be called to save the whole object heirarchy to the database.

Many of the methods available require Server and Connection strings as parameters. The Server string contains the name of the network server machine that hosts the Kwik-Pay database interface. If the local database interface is required, leave the Server string empty (""). The Connection string is an ADO connection string which will connect to the required Kwik-Pay database. The default Connection string is "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=My Documents\Kwik-Pay\Payroll\Kwik-Pay.mdb". When a UDL file is selected in the Kwik-Pay open payroll process, the Connection string is created in the form: "File name=fullpath.UDL", where full path is the full path name of the selected UDL file.

Note that the Connection string is always the Connection from the database server (or local work station if Server is "") to the database. Any path names are the path from the server to the database.

KPPayObj Classes

KPPayRpt Object

Contains all the collection classes and objects to support the maintenance and execution of reports, and includes the default layout for all reports.

KPPaySrv Object (dll)

Contains all the collection classes and objects to handle the interface to the database.

Kwik-Pay Databases

The Kwik-Pay data is held in a Microsoft Access or SQL Server database. Each object in the KPPayObj object dll uses ADO to create the recordsets. The MSDataShape provider is used for some report data sources, with 'Microsoft.Jet.OLEDB.4.0' as the data provider for Access databases and 'SQLOLEDB.1' for SQL Server.

Installation Files

The Kwik-Pay set up package installs in the following folders within a sub folder called Kwik-Pay Payroll:

The Kwik-Pay update package always replaces all the Kwik-Pay executables in the program files folder, and template database and demonstration data files in the common application files folder.