Stock control System

Question

1.00/5 (1 vote)

See more:

I am trying to make a stock control system for a electrical store. The basic idea is that there are a bunch of electrical goods with a certain quantity and once passed through sales system that exact quantity is reduced from the amount in stock. e.g the store has 200 iPhones but in one days 175 get sold and therefore the quantity should reduce from 200 to 25. I want to know how to do this. Also since goods are being sold i want the program to calculate how much revenue being generate everyday etc and how much profit is being made and losses etc.
I really need help this is for my own progress only as i wish to see how much i enjoy programming and would it be worth pursuing a degree in this field.
Please can someone guide me. Also if there are any sample work similar to this please do send me a link so i can look at it and get a rough idea.

Please do try and contribute and all help will be appreciated.

Thank You

Posted 5-Feb-12 11:45am

alom_93

Add a Solution

4 solutions

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)

Christian Graus · Answer 1 · 2012-02-05T11:58:00

Solution 1

I think your best way to learn, is to do something more basic first and learn enough that you can approach something like this with at least an idea of how it is done. Your data will be SQL, so you need to learn some SQL, unless you learn Entity Framework, and LINQ.

Posted 5-Feb-12 11:58am

Christian Graus

Comments

alom_93 5-Feb-12 18:06pm

my plan was for the data to be stored in a MS access database and then work from there. I have a rough idea how it should work but i needed to be guided

Espen Harlinn 5-Feb-12 18:29pm

MS access database
That underscores why you need study this a lot more.

alom_93 5-Feb-12 18:38pm

What do you mean by that?

Espen Harlinn 5-Feb-12 18:42pm

MS access is not what I would choose as a storage engine - it's not robust enough for valuable data. You can use MS SQL Server Express, it's free, powerful and reliable.

alom_93 5-Feb-12 18:43pm

Oh ok, i would need to learn that and how to connect my task to the sever etc.

Can you estimate roughly how long it will take to complete this task?

Espen Harlinn 5-Feb-12 18:48pm

This should get you started:
http://www.daniweb.com/software-development/vbnet/code/216920

Microsoft has quite a number of tutorials that I'm sure will help.

Christian Graus 5-Feb-12 20:00pm

Me - a week. You ? I have no idea.

Espen Harlinn 5-Feb-12 18:29pm

Good points

Espen Harlinn · Answer 2 · 2012-02-05T12:36:00

Solution 3

Have a look at the Apache OFBiz[^] project. It's a bit more than you need, but it's well worth studying.

There is just so much to learn before you can have a go at your task, but you need to start somewhere.

Best regards
Espen Harlinn

Posted 5-Feb-12 12:36pm

Espen Harlinn

Comments

alom_93 5-Feb-12 18:51pm

What do i require to run this?

Espen Harlinn 5-Feb-12 18:54pm

Java Enterprise Edition and an RDBMS like Oracle RDBMS or MS SQL Server.
I use Oracle RDBMS when I work with OFBiz, but many other database management systems are supported too.

Christian Graus 5-Feb-12 20:36pm

The guy is using VB, he doesn't want to learn Java

Espen Harlinn 6-Feb-12 4:17am

As far as I know, nobody has put together an open source VB solution that is actually legal to use. An inventory system has legal requirements too.

alom_93 6-Feb-12 11:01am

Do you know any examples using VB?

Espen Harlinn 6-Feb-12 11:05am

Not that I would inflict on end users ... try:
http://lmgtfy.com/?q=open+source+inventory+visual+basic

Simon_Whale · Answer 3 · 2012-02-05T12:33:00

Solution 2

I would start having a read of these

MSDN : Learning center[^]
Data Conenctivitey ADO.NET[^]

I would also read some of the articles here on CP too, they are written with better real world examples

Posted 5-Feb-12 12:33pm

Simon_Whale

Comments

alom_93 5-Feb-12 18:40pm

Can you send me some links please.
Thanks

Isuru Nanayakkara · Answer 4 · 2012-02-05T18:42:00

We cannot tell you how to write a program like that line by line. Its impractical. If you're new to programming, don't just jump into developing CRUD applications just like that. Spend some time with a couple of good books/tutorials and get a firm hold of the basics. And if you're writing a stock control system, there will be a backend database where you store the data. You'll need to learn SQL upto some extent. (how to create tables, set relationships between them, writing SPs, Functions etc) I suggest you choose Microsoft SQL Server 2008 as the database server. You can download a free version of it from here.

Spend some time learning and you'll find it easier to develop a simple CRUD application like that. If you get stuck somewhere, post that exact problem here with the code you have written for that. Then we can help you with that.

Good Luck!