Job order transaction. Visual studio and SQL server

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

My thesis is an Inventory Management System for a service firm. so I have done the profiling and the sales order. I'm almost done with the Job Ordering transaction but I just can't seem to get it right. the theory is that the Materials cost and the employee's labor fee should add to the default service fee. I've finished the materials but I just can't seem to get the Service and the Labor Fee to add up. technically I am very ill equipped with programming and a complete novice. I really need an idea on how I can code this so the Labor fee and the Service fee would add up and appear on the data grid view.

What I have tried:

I tried using the same codes I used for adding the materials but because the service fee and labor fee have no quantity unlike Materials. it's not working.

Posted 11-Mar-16 20:29pm

Member 12386816

Updated 12-Mar-16 3:54am

Add a Solution

Comments

[no name] 12-Mar-16 4:22am

What did you try with code?

Richard MacCutchan 12-Mar-16 4:32am

Assuming that both Service Fee and Labour Fee are numeric quantities, what exactly is the problem?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2016-03-12T03:54:00

Hard to say without seeing your code, but maybe you can first create a view in SQL Server Management Studio and make sure this displays the right totals and then use that view as the data source of your grid view.

Some examples of using the SUM() function: SUM (Transact-SQL)[^]

Interesting example: Calculating simple running totals in SQL Server[^]