Question: Employee Component. Admin should be able to register employee details to the system (including monthly salary, overtime rates-hourly, allowances). Admin should be able to update

Employee Component.

Admin should be able to register employee details to the system (including monthly salary, overtime rates-hourly, allowances).

Admin should be able to update all employee details in the system (Update and Delete including monthly salary, overtime rates-hourly, allowances).

Admin should be able to view individual employee details, view all employees details, search employees.

Salary Component

Admin should be able to input the date range to calculate the salary. Salary cycle begin date and the end date should be given to calculate the monthly salary. Salary cycle begin date and end date will be defined in the settings component and if the user enters something else the system should display an error message.

The admin should be able to enter the no of leaves an employee has taken with number of absent days, no of holidays for the given date range. If an employee has worked any overtime hours the admin should be able to enter that also when calculating the Base pay value.

Base Pay need to calculate based on the following points,

Base Pay (Monthly Salary: salary_cycle_date_range, eg: 30 days): Each employee will be paid monthly

If any employee couldnt cover salary_cycle_date_range (eg:-30 days) attendance the system should calculate the no-pay value according to the below mention formula,

No-pay-value = (Total_Salary/salary_cycle_date_range) *No_of_absent_days

Base Pay need to calculate according to the below mentioned formula

Base Pay value = Monthly_Salary + Allowances + (Over_time_rate*no_of_overtime_hours)

Gross Pay need to calculate according to the below mentioned formula

Gross Pay = Base_Pay_value (No_pay_value + Base_Pay_value*government_tax_rate)

All the calculated No-pay-value, Base-pay-value and Gross pay value should record in the database under each employee for each month. This component should generate reports such as monthly salary report for an employee, overall salary summary for couple of months for an employee, No-pay-value, base-pay-value, and gross pay value of all the employees for a given month range.

Settings Component

This component should allow the admin to change parameter values such as

Date Range for a salary cycle. Eg:- 30 days

Salary cycle begin date

Salary cycle end date

No of leaves for an employee for a year.

Use the visual studio IDE (using C#.net) to implement three components in a payroll system. Ideally there should be three separate classes for the three components and the developer can decide the methods which need to include in those classes. Design the suitable database structure for keeping the data of the above system.

I do understand the logic of the question, I need see the C# code for the 3 classes and the database connection.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!