Hey how can I develop an app to scan QR code of the goods and register it in database using C#

Question

0.00/5 (No votes)

See more:

Hey,

My name is Mubarek Omar

I'm trying to develop an app to scan QR code and store information of any item that have QR code and another time when i scan the QR code i want to retrive that whole information out .

I wish i'll get help

Thank you in advance

What I have tried:

i tried using Visual studio 2015 but i need some help

Posted 23-Dec-19 3:06am

Member 14697968

Updated 23-Dec-19 3:28am

v2

Add a Solution

2 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)

AFell2 · Answer 1 · 2019-12-23T07:21:00

Richard has good advice. You will want to concentrate on the back end needs first. The database and API you will need to store the information and then reverse the lookup when the barcode is scanned again to bring back the relevant information.

From there, you can look at several options. For instance, if this is a merchandise store front, instead of buying specialized QR readers, you may want to consider a mobile application that can use a phone or tablet camera to take a picture of the QR barcode and serialize it.

Since your back end will be an API backed by a database, all you would need to do is write a mobile application that correlates the serialized QR scan from the camera with the API method that best suits your task.

So, for instance, you have someone scanning new item to be stocked. Your method would be to post a new item. Your payload would be the QR barcode, the item description, location and quantity. Once the post command is made to the api, the new item is added to the database, ready for you to deplete its quantity from inventory.

So, every time you sell an item and read the QR barcode, a description of the item is brought back to the device by a get command. And once the sale transaction is complete, the inventory quantity is modified by either a put or patch command.

For developing the mobile application, you can either use Android Studio (for Android devices) or XTools (for iPhones) or you can look at using Xamarin for C#/Visual Studio to develop for both platforms. I've had good success using Xamarin myself.

Richard MacCutchan · Answer 2 · 2019-12-23T03:28:00

Solution 1

Forget Visual Studio until you have a system design in place.
The first thing you probably need is some type of database to hold the information about these products. So decide what information you wish to keep and design an appropriate database schema. Next, you probably need some device that can read QR codes, but that is something you will need to find for yourself, as there are many such devices available. From there it is just a matter of writing the application to read the information from the QR device and find or add the products in the database.

Posted 23-Dec-19 3:28am

Richard MacCutchan

Comments

Member 14697968 23-Dec-19 13:22pm

Richard MacCutchan
Thank you so much for your advice ..
I'm Using SQL server as a database and i'm thinking to use my laptop webcam to scan the QR code what do you suggest me

Richard MacCutchan 24-Dec-19 3:26am

I suggest exactly what I stated above.

AFell2 26-Dec-19 12:02pm

I need to reinforce Richard's good advice. Your best plan of attack is to design the system without writing any code FIRST. You should document which tools/frameworks your would like to use, but describing the ecosystem before you build anything will let you see the missing pieces and save you tons of time reconfiguring down the road. Once you have your design documented, you an then start breaking up the work so you can tackle the key infrastructure pieces first before you get bogged down in the detail pieces.