Here are the requirements for the project. I have also included the other project that I am working on and is also giving me some problems. i need code examples.
Project 1
This program actually has 4 parts that I have to do.
There is a master database and an excel file that has to be downloaded from the server once a week
1.design a piece of code that will make this program run or download the file from the server once a week, let’s say Friday at nine in the evening(scheduler). And perform actions 2 to 4.
2. compare the records in the database with the once in the file download. If an employee exists in the download but not the database, add that employee to the database.
3.if an employee exists in the database but not the download file, flag the employee as not existent, meaning the employee is no longer in service.
4.if a field from the download file has changed, e.g the marital status of an employee changes, make the changes in the database.
Project 2
This project uses a text file and 2 databases. These files are in the bin folder of the project.
A log-in screen for all the users, if the user is not a master and the entered info is the same as the one in the Passwords table, redirect the user to the users form with is a GUI where the user enters/select 4 things:
1. Select the mine code from a drop-down list
2. Select the payroll code from a drop-down list
3. Enter the start date
4.Enter the end date
A text file has to be created on the hard drive and filtered according to the input from the screen.
For an Example:
Mine/Shaft = BE
Payroll = HA
From Date = 0202(mm/dd)
To Date = 0208(mm/dd)
This new file should only contain records with a mine code of BE, payroll code HA. The range of the date is between 0202 and 0208
Please help me, I really need help