Simple web based management system for approving new products and storing product information.

Question

0.00/5 (No votes)

See more:

I need a simple solution for the following issue:

Currently at work we are tasked with reviewing new products and approving them (products being various electronic components for traffic signals). If a product is approved it gets maunually entered into a database (currently using Microsoft Access). The approval process is handled manually by a co-worker. We would like to develop a simple web based application where we can enter in new product information along with supporting documents into a master database and be able to search or query that database.

Also, we would like the ability to track the approval process. In a nutshell a manufacturer would fill out a form for their product, send it to us, we would review, if approved the information on the form gets dumped to a database, if non-approved then the product info is moved to a non-approved list.

Another question would be what is the best way to set this up from a coding stand point? I only have a strong background in front end web development with basic skills in JavaScript and VB. I started this project using ASP.NET using Razor syntax just to try it out and while I am making progress I do not want to have to overwork building a framework for something that might be already available. Also what type of database would be best (SQL, local storage???) I anticipate no more then 5,000 records.

Any insight would be appreciated.

Posted 14-May-14 7:06am

Member 10790982

Add a Solution

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2014-05-14T09:16:00

The answer is mostly contained in your question. Of course, if you can have ASP.NET hosting, using it would be the best.

As to the data storage, even for small volume of data, it's hard to imagine that you have enough experience and resources to develop some alternative to relational databases. Only if your data can be totally stored on the computer RAM with ease, having your own storage could provide some benefits (like OOP, no problems with object mapping, easy application-oriented design), so you could use, say, Data Contract, and single-file storage. I don't think this is your case. Anything bigger than that rather calls for some relational database. To make a choice, please review:
http://en.wikipedia.org/wiki/List_of_relational_database_management_systems[^],
http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems[^].

Then you will also need ADO.NET:
http://en.wikipedia.org/wiki/ADO.NET[^],
http://msdn2.microsoft.com/en-us/library/aa286484.aspx[^].

This simple and good CodeProject article can make you get started in no time: Using ADO.NET for beginners[^].

What else? Perhaps, consider http://www.asp.net/mvc[^].

I would say, that's pretty much all. Your requirements are not anything special and are pretty modest.

Good luck,

—SA