Click here to Skip to main content
15,891,136 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: windows 8 desktop application Pin
WebMaster3-Nov-12 19:36
WebMaster3-Nov-12 19:36 
AnswerRe: windows 8 desktop application Pin
Pete O'Hanlon31-Oct-12 1:03
mvePete O'Hanlon31-Oct-12 1:03 
GeneralRe: windows 8 desktop application Pin
Menelaos Vergis31-Oct-12 1:37
Menelaos Vergis31-Oct-12 1:37 
GeneralRe: windows 8 desktop application Pin
Pete O'Hanlon31-Oct-12 1:42
mvePete O'Hanlon31-Oct-12 1:42 
GeneralRe: windows 8 desktop application Pin
Menelaos Vergis31-Oct-12 2:13
Menelaos Vergis31-Oct-12 2:13 
GeneralRe: windows 8 desktop application Pin
Pete O'Hanlon31-Oct-12 2:54
mvePete O'Hanlon31-Oct-12 2:54 
QuestionInventory Control App. - Looking For Suggestions Pin
Matt U.30-Oct-12 8:36
Matt U.30-Oct-12 8:36 
AnswerRe: Inventory Control App. - Looking For Suggestions Pin
jschell30-Oct-12 10:16
jschell30-Oct-12 10:16 
Matt U. wrote:
but I need to figure out the most efficient way (both from a development
standpoint as well as from an end-user standpoint)


Then you really need to have some more requirements.

For example will 100,000 users access this?
Will there be 100 billion of these?
Will there be 1000 retail locations attempting to access it?

Questions like that impact the design.


Matt U. wrote:
So is there a way I can keep from creating 25 UserControls, one for each type?


Yes.

Is it ideal in terms of your actual business requirments? I have no idea.

But the idea is simple you have a inventory item with "properties". In the simplist scenarios there business needs for the properties are very simple so consequently one can store them in a property table.

That table would look like this

Property (primary key id is assumed)
- inventory_id
- name
- type
- value

That table would have a row like the following
<some inventory="" id="">, "Clock Speed", "Decimal", "2.66"

There are many variations on the above. For example instead of "Clock Speed/"Decimal" you could have an enumeration table that define a 'type' and then the property id would tie to that type via the type id.
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.31-Oct-12 1:54
Matt U.31-Oct-12 1:54 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
jschell31-Oct-12 8:49
jschell31-Oct-12 8:49 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.31-Oct-12 9:01
Matt U.31-Oct-12 9:01 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
jschell1-Nov-12 7:49
jschell1-Nov-12 7:49 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.1-Nov-12 8:13
Matt U.1-Nov-12 8:13 
AnswerRe: Inventory Control App. - Looking For Suggestions Pin
Vivi Chellappa16-Dec-12 5:36
professionalVivi Chellappa16-Dec-12 5:36 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.17-Dec-12 1:49
Matt U.17-Dec-12 1:49 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Vivi Chellappa17-Dec-12 4:14
professionalVivi Chellappa17-Dec-12 4:14 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.17-Dec-12 4:17
Matt U.17-Dec-12 4:17 
QuestionASP.NET - using microsoft enterprise library for heavy traffic sites Pin
Sandeep Bhatti29-Oct-12 21:33
Sandeep Bhatti29-Oct-12 21:33 
AnswerRe: ASP.NET - using microsoft enterprise library for heavy traffic sites Pin
Eddy Vluggen30-Oct-12 1:09
professionalEddy Vluggen30-Oct-12 1:09 
GeneralSuggestions for Windows 8 application Pin
WebMaster23-Oct-12 22:37
WebMaster23-Oct-12 22:37 
GeneralRe: Suggestions for Windows 8 application Pin
Richard MacCutchan24-Oct-12 1:11
mveRichard MacCutchan24-Oct-12 1:11 
GeneralRe: Suggestions for Windows 8 application Pin
Richard MacCutchan24-Oct-12 1:41
mveRichard MacCutchan24-Oct-12 1:41 
RantUnwanted Calls / Spoofed Numbers Pin
pdelayCA18-Oct-12 11:42
professionalpdelayCA18-Oct-12 11:42 
GeneralRe: Unwanted Calls / Spoofed Numbers Pin
jschell19-Oct-12 9:27
jschell19-Oct-12 9:27 
QuestionCreating v2.0 of a legacy client/server application Pin
sephus617-Oct-12 10:00
sephus617-Oct-12 10:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.