Inventory system db ,c#

Question

0.00/5 (No votes)

See more:

It is been a month i am working on inventory management system using c#, it has stock managment to so we can add items that how much we have in our hand but when i sell it from purchase form how to cut down its quantity from database.
Sorry for my bad english.

What I have tried:

I tried to select item quantity from database and -1 items and then insert it to database again but i am sure this is not the right way

Posted 9-Mar-16 6:11am

Kho Dam

Updated 9-Mar-16 7:00am

Add a Solution

Comments

CHill60 9-Mar-16 12:29pm

Just update directly on the database. Share the code you used

Kho Dam 9-Mar-16 12:55pm

//Click Button1 Even Code
int quantity=0;
int quantityInHand=0;
mycon.open();
SqlCommand cmd = new SqlCommand("SELECT Quantity FROM ITEMS WHERE NAME1='"+txtproductname.Text+"'" , mycon);
SqlDataReader reader = cmd.ExecuteReader();
quantity = int.Parse.reader["Quantity"];
quantityInHand = quantity - int.Parse(txtquantity.Text);
SqlCommand cmd2 = new SqlCommand("INSER INTO ITEMS (Quantity) Values("quantityInHand") WHERE NAME1='"+txtproductname.Text+"';" , mycon);
cmd2.ExecuteNonQuery();
mycon.close();

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)

ZurdoDev · Accepted Answer · 2016-03-09T07:00:00

Solution 1

To update the quantity, just run an UPDATE sql statement. Very simple:

SQL

UPDATE products
SET quantity = quantity - 1
WHERE product_id = @product_id

Posted 9-Mar-16 7:00am

ZurdoDev

Comments

Kho Dam 9-Mar-16 13:08pm

UPDATE products
SET quantity = quantity - 1
WHERE product_id = @product_id

in this code????

products is table name????
quantity is field????
product_id is product ID number????

right????

ZurdoDev 9-Mar-16 13:22pm

Yes. Just think of it in simple english (or whatever your native language is. :) )

You want to update the quantity in the database to be 1 less.

Kho Dam 9-Mar-16 13:27pm

yes i want to update the quantity in the database to be less according my quantity textbox.

can we use it like:
UPDATE products
SET quantity = quantity - convert.int32(txtquantity.text)
WHERE product_id = @product_id

ZurdoDev 9-Mar-16 13:30pm

Yes, but use a parameter instead so you don't open up your db to security risks.

Kho Dam 9-Mar-16 13:34pm

Thank you very much indeed.
but we can use this code for selling items,
but how we can make these sells report for every items we less from products table.
like inventory softwares.
Thank You : )

ZurdoDev 9-Mar-16 13:34pm

I don't understand your question. It sounds like you want to do a report?

Kho Dam 9-Mar-16 13:43pm

I designed two forms, The first one is for selling items, that we want it to minus from our database quantity, like it shows in a report that we sold and that quantity is gone so that can let us know how much more items we have left in our hand, and second form show reports for selling every transaction
again sorry for my bad english : (

ZurdoDev 9-Mar-16 13:45pm

So, you'll have a table that stores what you have sold. That is where your reports come from.

It sounds like you need to do a lot more research before getting started.

Kho Dam 9-Mar-16 13:49pm

Thanks!
so for button click even, we need two commands first to update and second to insert in report table, so we can see reports. : )

ZurdoDev 9-Mar-16 13:57pm

First off, you need to decide how your code will work. But for me, I do both in the same transaction. Decrement the quantity and save the order.

Kho Dam 9-Mar-16 14:02pm

if we sold‌ more than one items in our one transaction like Bill#10001;
how can we get report for Total Bill# amount, and when we click on bill details we see details for items Contains in the bill.
i mean how can we store sold item in a row more than one. #:-(