Personnel Advance Payments Manager for a small company (< 100 employees)
Along the month, each employee is allowed to ask for an advance payment.
The purpose of this SMALL piece of software is to manage those payments, issue payment tickets and summarize all payments fom date to date.r
This is a small piece of software with the following requisite:
Language: Visual Basic Express 2008
Database: SQL Server Express 2008
? pCode varChar(12)
? pName varChar(40)
? pSalary Decimal(12,2)
? pCode varChar(12)
? paymentDate Date
? paymentAmount Decimal(12,2)
1 - Personnel Table Updating
We must read data from an external MS Access Personnel file
SELECT pCode, pName from Personnel
And compare the result against the SQL Server local Personnel table, in order to ADD the newly created records (Those that doesn't already exist in the SQL Server table).
2 - Personnel Table? Maintenance:
Edit, Delete and enter the monthly salary per person.
3 - Create Advance Payment records:
From a dedicated VB Form, display a list (non editable datagrid) of all persons (Less than 100) in a grid:
pCode? ? ? pName? ?
1234? Doe John? ? ?
When the user clicks on a Person, display the pCode, the Name and the Max Payment Allowed for that person on the right side of the form.
A secondary datagrid will also display the list of already paid amounts for that person within the same month, and the total below.
Rule: Anyone cannot obtain an Advance Payment greater then 80% of the due salary, calculated from the 1st day of the month to the present date.
Payments and max are rounded to the Euro.
Accept (enter) the required Advance Payment Amount. Check that it is allowed, display an error message if not.
Let the user click on a Validate button (or Cancel button to dismiss that person and get ready to click on another person's name.
Of course, while displaying one person, do not allow the user to click on another person's name in the datagrid, unless the user clicks Accept? ( with Amount > 0) or cancel.
Once validated, create a new AdvPayments record.
Once the new AdvPayments record saved, prepare and print an Advance Payment Ticket (We will use a 40 columns small printer)
With a Header:? The Name and Address of the company
? ? The Day Date abd Time
And the payment detail:
? ? The pCode and Name
? ? The Payment Amount?
Dismiss the person's details once done and re-allow clicking on another Name.
4 - AdvPayments listing
Prepare a list of all AdvPayments records for any given period, using 2 calendars: From Date and Until Date.
Print that list by pages on screen
Allow paper printing as well