C#

Paul Conrad wrote:

.NET Book Zero

public class Contract
{
    int employeeId;
    string agency, role, contractType, startDate, endDate, lineManager, reportTo;
    string costCenter, functionEng, atrNo, atrDate, prNo, prDate, poNo, poDate;
    string comments;
    decimal duration, workRatePercent;
    string currency;
    decimal hourlyRate, value;

    public Contract()
    {
        // whatever you need in the constructor...
    }

    public int EmployeeId
    {
        get
        {
            return employeeId;
        }
        set
        {
            employeeId = value;  // this just populates with no actual checks
                                 // if employeeId is a primary key, could always check
                                 // against database to make sure it doesnt already exist.
        }
    }

    // ... properties for all the other instance variables go here, with any respective
    // checks they require

    public static void createNewContract()
    {
        // invoke your insert query here
    }

}