Click here to Skip to main content
12,354,330 members (68,903 online)

Design and Architecture

 
GeneralRe: windows 8 desktop application Pin
Egomedia3-Nov-12 19:32
groupEgomedia3-Nov-12 19:32 
GeneralRe: windows 8 desktop application Pin
Egomedia3-Nov-12 19:36
groupEgomedia3-Nov-12 19:36 
AnswerRe: windows 8 desktop application Pin
Pete O'Hanlon31-Oct-12 1:03
protectorPete O'Hanlon31-Oct-12 1:03 
GeneralRe: windows 8 desktop application Pin
Menelaos Vergis31-Oct-12 1:37
memberMenelaos Vergis31-Oct-12 1:37 
GeneralRe: windows 8 desktop application Pin
Pete O'Hanlon31-Oct-12 1:42
protectorPete O'Hanlon31-Oct-12 1:42 
GeneralRe: windows 8 desktop application Pin
Menelaos Vergis31-Oct-12 2:13
memberMenelaos Vergis31-Oct-12 2:13 
GeneralRe: windows 8 desktop application Pin
Pete O'Hanlon31-Oct-12 2:54
protectorPete O'Hanlon31-Oct-12 2:54 
QuestionInventory Control App. - Looking For Suggestions Pin
Matt U.30-Oct-12 8:36
memberMatt U.30-Oct-12 8:36 
Hello, CP. So I am working on this application here at work and the current piece involves inventory management. First, I will list the tools I use:

Visual Studio 2010 Ultimate
C#, .NET 4.0
Microsoft SQL Server 2008 Enterprise
LINQ To SQL

Now, what I have are various types of items which need to be tracked. They are referred to as "RPCs" (and they are all computer parts). I have been thinking on this for a while but I need to figure out the most efficient way (both from a development standpoint as well as from an end-user standpoint) to input data and store these items in the database.

What I have done so far, for the first three types of RPCs, is I have created a UserControl. On that control are the fields necessary for that particular RPC type. Each RPC has various attributes which are not shared among other types. For example, a Hard Drive has Marketed Size, Physical Size (2.5" or 3.5"), RPM while a CPU has Clock Speed, Cache Size, # of Cores. I think you get the idea.

Well, I started out with these three UserControls as well as three tables in the database, one for each type. However, the issue really becomes known when I say this: to start with, I have roughly 25 diferent RPC types.

So is there a way I can keep from creating 25 UserControls, one for each type? Or 25 tables in the database just for RPCs? I thought about creating a single table with the specs that each type does have in common (e.g. Manufacturer, Model) an storing the specs in a specific format (e.g. XML) in a column and having the application manipulate the specs data as necessary. However, the performance issue arises when I think about the fact that I must be able to search various RPC types by one or more specs. For example, the application needs to be capable of finding all 500GB/7200RPM hard drives. That wouldn't work so well when using XML for all of the specs would it?

Maybe I am going about this whole thing all wrong. But then again, maybe I am better off going with the numerous tables and user controls. If that's what it takes, I'll do it. I just started thinking about it early on and realized that maybe I am not being entirely efficient with it.

Any suggestions? Big Grin | :-D
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.

AnswerRe: Inventory Control App. - Looking For Suggestions Pin
jschell30-Oct-12 10:16
memberjschell30-Oct-12 10:16 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.31-Oct-12 1:54
memberMatt U.31-Oct-12 1:54 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
jschell31-Oct-12 8:49
memberjschell31-Oct-12 8:49 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.31-Oct-12 9:01
memberMatt U.31-Oct-12 9:01 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
jschell1-Nov-12 7:49
memberjschell1-Nov-12 7:49 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.1-Nov-12 8:13
memberMatt U.1-Nov-12 8:13 
AnswerRe: Inventory Control App. - Looking For Suggestions Pin
Vivic16-Dec-12 5:36
memberVivic16-Dec-12 5:36 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.17-Dec-12 1:49
memberMatt U.17-Dec-12 1:49 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Vivic17-Dec-12 4:14
memberVivic17-Dec-12 4:14 
GeneralRe: Inventory Control App. - Looking For Suggestions Pin
Matt U.17-Dec-12 4:17
memberMatt U.17-Dec-12 4:17 
QuestionASP.NET - using microsoft enterprise library for heavy traffic sites Pin
Sandeep Bhatti29-Oct-12 21:33
memberSandeep Bhatti29-Oct-12 21:33 
AnswerRe: ASP.NET - using microsoft enterprise library for heavy traffic sites Pin
Eddy Vluggen30-Oct-12 1:09
memberEddy Vluggen30-Oct-12 1:09 
GeneralSuggestions for Windows 8 application Pin
Saif Al Falah23-Oct-12 22:37
memberSaif Al Falah23-Oct-12 22:37 
GeneralRe: Suggestions for Windows 8 application Pin
Richard MacCutchan24-Oct-12 1:11
mvpRichard MacCutchan24-Oct-12 1:11 
GeneralMessage Removed Pin
Saif Al Falah24-Oct-12 1:34
memberSaif Al Falah24-Oct-12 1:34 
GeneralRe: Suggestions for Windows 8 application Pin
Richard MacCutchan24-Oct-12 1:41
mvpRichard MacCutchan24-Oct-12 1:41 
RantUnwanted Calls / Spoofed Numbers Pin
pdelayCA18-Oct-12 11:42
memberpdelayCA18-Oct-12 11:42 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 11 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid