Create a employee maintenance C# program. The employee database and an executable of the example application are located on blackboard. Use single-document interface (SDI). Make the following changes:
When a new employee is added, the user should enter the information contained in the empContact and the empPay tables. Insert the information into the appropriate table using the appropriate SQL.
When the modify button is clicked, display the employees contact and pay information in textboxes on a modify form. The new form should have the same functionality as the example. Use appropriate SQL.
When the delete button is clicked, delete the employee from the database. Use appropriate SQL.
Add a Display button that when clicked will open a new form. Display all employees contact information in a DataGridView control along with the navigator control. Provide the necessary means to close this form.
The employee database contains the following tables:
empPay -> ID, fName, lName, hrsWorked, hourlyPay
empContact-> recID, empID, eTitle, fName, mName, lName, addr1, addr2, city, state, zip, wPhone, hPhone,
fax, email1, email2
Requirements
1) Name your solution file LnameFnameLab07, where Lname is your last name and Fname is your first name.
2) The UI (user interface) for this program should match the demo with (your name) ‘s Lab 07 in the title bar.
3) Name your main form [login to view URL]
4) Be sure to use correct data types for all variables and follow all class standards (required documentation, proper indentation, correct naming standards, etc.)
5) Include comments at the very top of the source code that contain your first and last name.
Dear Sir,
I am Professional Software Developer,
I am Linux Advanced Developer,
I am Database Developer and designer.
I can Handle your job and do everything extremely Grate.
Regards,