Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

5. Reduce the block diagram and find C(s)/R(s)

Answered: 1 week ago

Question

Determine the amplitude and period of each function.

Answered: 1 week ago

Question

Explain the key areas in which service employees need training.

Answered: 1 week ago

Question

Understand the role of internal marketing and communications.

Answered: 1 week ago