I need help with C# Asp.Net with Sql Database. Answer is very small but explaining the question is long. So please don't
Posted: Thu Jun 02, 2022 8:04 am
I need help with C# Asp.Net with Sql Database.
Answer is very small but explaining the question is long. So
please don't mind.
So I'm creating a webform where I have a database of employees
and I have successfully worked functions like Insert, Delete,
Update
For the second part of my webform. I want to calculate my
employee's paycheck.
First have a look at my Edit Employee Page
And this is my Payroll Calculator page
What I want is:
Say, I enter Employee ID: 2
I want the function to take value from Employee ID 2 for Deliveries
and display it in Deliveries Textbox. And the same thing with
Overtime (Hours)
After it displays those values in their respective textboxes. I
want the calculator to Multiply Delivery with 5 and Overtime
with 10 and then add both.
So for this Employee ID: 2
This should be the result:
Deliveries 36
Overtime Hours 2
Pay $200
Please help me. Much Appreciated. Also, if you are working on my
question please notify by adding a comment. So I know that someone
is working on it.
THANKS A LOT!
Id Name Age Deliveries Overtime Insert ID Name Age Deliveries Overtime (Hours) 1 Alex 23 50 3 2 Tim 25 36 2 3 Jack 28 45 5 4 John 29 22 2 Edit Employee Data Update Go Back To Home Page Delete Search
Calculate Payroll Enter Employee ID Calculate Deliveries Overtime Hours Pay Note: Per Extra Hour $10 Per Delivery $5
Answer is very small but explaining the question is long. So
please don't mind.
So I'm creating a webform where I have a database of employees
and I have successfully worked functions like Insert, Delete,
Update
For the second part of my webform. I want to calculate my
employee's paycheck.
First have a look at my Edit Employee Page
- I Need Help With C Asp Net With Sql Database Answer Is Very Small But Explaining The Question Is Long So Please Don T 1 (30.66 KiB) Viewed 19 times
- I Need Help With C Asp Net With Sql Database Answer Is Very Small But Explaining The Question Is Long So Please Don T 2 (12.38 KiB) Viewed 19 times
Say, I enter Employee ID: 2
I want the function to take value from Employee ID 2 for Deliveries
and display it in Deliveries Textbox. And the same thing with
Overtime (Hours)
After it displays those values in their respective textboxes. I
want the calculator to Multiply Delivery with 5 and Overtime
with 10 and then add both.
So for this Employee ID: 2
This should be the result:
Deliveries 36
Overtime Hours 2
Pay $200
Please help me. Much Appreciated. Also, if you are working on my
question please notify by adding a comment. So I know that someone
is working on it.
THANKS A LOT!
Id Name Age Deliveries Overtime Insert ID Name Age Deliveries Overtime (Hours) 1 Alex 23 50 3 2 Tim 25 36 2 3 Jack 28 45 5 4 John 29 22 2 Edit Employee Data Update Go Back To Home Page Delete Search
Calculate Payroll Enter Employee ID Calculate Deliveries Overtime Hours Pay Note: Per Extra Hour $10 Per Delivery $5