Employees Salary Generate Hours Based

karthik ganesh

9y1.3k.NET

The Customers Needs "Hours" based salary calculation in following type, first customer enters employees "Intime" and "outtime" and calculate hours,and finaly view the hours of employees and enter per hours salary amount and calculate total. How to write this type of calculation code in asp.net c#

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
Hi,

first of all I will suggest you to have your table redesigned, because you are storing master and transaction data all in one table

the details which belong to employee like the id, name, designation, etc. which does not change with each and every transaction need to be in a master table

then create a new table which is meant for daily in & out transaction, and store data like intime, etc. in that table

calculation of salary then should be simple, in the same record store total as multiplication of total hours multiplied by wages(I assume wages stores employee's hourly salary, and it should be in employee master table)
that will give you salary of 1 day, at the end of month you need to display monthly salary using group by function based on employeeid and date range.
0
karthik ganesh9y ago
ok sir i understand your opinion but i am not a senior developer !!! i am a fresher so please send the table query...
0
karthik ganesh9y ago
ok sir, but please one help tell us "sql calculation query"..............
This is My Query:

Table:

CREATE TABLE [dbo].[Salary](
[EMPLOYEEID] [int] NOT NULL,
[EMPLOYEENAME] [varchar](100) NULL,
[DATE] [date] NULL,
[DESIGNATION] [varchar](100) NULL,
[EMPLOYEEINTIME] [time](7) NULL,
[EMPLOYEEOUTTIME] [time](7) NULL,
[TOTALHOURS] [datetime] NULL,
[WAGES] [decimal](9, 0) NULL,
[TOTAL] [decimal](9, 0) NULL,
[TYPE] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Salary] ADD DEFAULT (getdate()) FOR [DATE]
GO
ALTER TABLE [dbo].[Salary] ADD DEFAULT (getdate()) FOR [EMPLOYEEINTIME]
GO

Stored Procedure:
CREATE PROCEDURE [dbo].[STO_SALARY]
(
@EMPLOYEEID [int],
@EMPLOYEENAME [varchar](100),
@DATE [date] ,
@DESIGNATION [varchar](100) ,
@EMPLOYEEINTIME [time](7) ,
@EMPLOYEEOUTTIME [time](7) ,
@TOTALHOURS [time](7) ,
@WAGES [decimal](9, 0) ,
@TOTAL [decimal](9, 0) ,
@TYPE [varchar](100)
)
AS
BEGIN
INSERT INTO Salary (EMPLOYEEID,EMPLOYEENAME,DATE,DESIGNATION,EMPLOYEEINTIME,EMPLOYEEOUTTIME,TOTALHOURS,WAGES,TOTAL,TYPE)
VALUES (@EMPLOYEEID,@EMPLOYEENAME,@DATE,@DESIGNATION,@EMPLOYEEINTIME,@EMPLOYEEOUTTIME,@TOTALHOURS,@WAGES,@TOTAL,@TYPE)

END

0
Nilesh Shah9y ago
How to write this type of calculation code in asp.net c#?

I suggest you dont do such calculation in asp.net side, but do it in SQL server, reason being the performance considerations

In SQL, create a calculated field which will derive the salary value based on your logic, or create a trigger which will update the salary field
0