First In First Out Solution

Question

1.50/5 (2 votes)

See more:

HI i am creating a software in c#.net there Sold and Purchese function with FIFO function Like Inventory System with FIFO save that data in any Database (Access or mysql or sql server) after savine in the end of month we must calculating cost of good sold ...is any one know sample Coding in any site

Posted 12-Jul-11 0:20am

vanishangar

Updated 12-Jul-11 0:48am

v3

Add a Solution

Comments

musefan 12-Jul-11 6:22am

Can you explain some more of your requirements. Currently they are not clear.

Are you saying that you want to store the data stored in your FIFO implementation (i.e. the current queue) into a database?

vanishangar 12-Jul-11 6:43am

HI i am creating a software in c#.net there Sold and Purchese function with FIFO function Like Inventory System with FIFO save that data in any Database (Access or mysql or sql server)

vanishangar 12-Jul-11 6:42am

HI i am creating a software in c#.net there Sold and Purchese function with FIFO function Like Inventory System with FIFO save that data in any Database (Access or mysql or sql server)

3 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 · 2011-07-12T00:34:00

Solution 1

VB6 is a joke. Why would you even ask that if you can use .NET.

What on earth do you mean ? Do you mean store data in the DB ? Or in memory ? Either way, you do what it says. Pull out objects in the order they were put in, which means knowing that order.

Posted 12-Jul-11 0:34am

Christian Graus

CPallini · Answer 2 · 2011-07-12T00:37:00

Solution 2

If you need to retrieve the items in the same order you stored them, then you may use an autoincrement counter to mark each item (how to depends on the technology you are using).

Posted 12-Jul-11 0:37am

CPallini

Manfred Rudolf Bihy · Answer 3 · 2011-07-12T00:43:00

Since you mentioned database in your question I'll assume you want to store data into a table and fetch it in a FIFO manner. For that you can utilize the auto increment column feature that most databases posses. So when you insert a record into your table the next higher value will be assigned to that column. For the rest of this answer let's call this auto increment column id. If the last row from your table has been processed it will be deleted from you table. So the workflow will be as follows:

Insert (a) record(s) into your table.

Fetch records in a FIFO manner:

SQL

SELECT TOP 1 * FROM YourTable ORDER BY id ASC

After processing of record is done delete the record in FIFO manner:

SQL

DELETE FROM YourTable WHERE id = (SELECT TOP 1 id FROM YourTable ORDER BY id ASC)

Cheers!

—MRB