Click here to Skip to main content

Design and Architecture

 
GeneralRe: windows 8 desktop application PingroupEgomedia3-Nov-12 20:32 
GeneralRe: windows 8 desktop application PingroupEgomedia3-Nov-12 20:36 
AnswerRe: windows 8 desktop application PinprotectorPete O'Hanlon31-Oct-12 2:03 
GeneralRe: windows 8 desktop application PinmemberMenelaos Vergis31-Oct-12 2:37 
GeneralRe: windows 8 desktop application PinprotectorPete O'Hanlon31-Oct-12 2:42 
GeneralRe: windows 8 desktop application PinmemberMenelaos Vergis31-Oct-12 3:13 
GeneralRe: windows 8 desktop application PinprotectorPete O'Hanlon31-Oct-12 3:54 
QuestionInventory Control App. - Looking For Suggestions PinmemberMatt U.30-Oct-12 9: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 Pinmemberjschell30-Oct-12 11:16 
GeneralRe: Inventory Control App. - Looking For Suggestions PinmemberMatt U.31-Oct-12 2:54 
GeneralRe: Inventory Control App. - Looking For Suggestions Pinmemberjschell31-Oct-12 9:49 
GeneralRe: Inventory Control App. - Looking For Suggestions PinmemberMatt U.31-Oct-12 10:01 
GeneralRe: Inventory Control App. - Looking For Suggestions Pinmemberjschell1-Nov-12 8:49 
GeneralRe: Inventory Control App. - Looking For Suggestions PinmemberMatt U.1-Nov-12 9:13 
AnswerRe: Inventory Control App. - Looking For Suggestions PinmemberVivic16-Dec-12 6:36 
GeneralRe: Inventory Control App. - Looking For Suggestions PinmemberMatt U.17-Dec-12 2:49 
GeneralRe: Inventory Control App. - Looking For Suggestions PinmemberVivic17-Dec-12 5:14 
GeneralRe: Inventory Control App. - Looking For Suggestions PinmemberMatt U.17-Dec-12 5:17 
QuestionASP.NET - using microsoft enterprise library for heavy traffic sites PinmemberSandeep Bhatti29-Oct-12 22:33 
AnswerRe: ASP.NET - using microsoft enterprise library for heavy traffic sites PinmemberEddy Vluggen30-Oct-12 2:09 
GeneralSuggestions for Windows 8 application [modified] PinmemberSaif Al Falah23-Oct-12 23:37 
GeneralRe: Suggestions for Windows 8 application PinmvpRichard MacCutchan24-Oct-12 2:11 
GeneralMessage Removed PinmemberSaif Al Falah24-Oct-12 2:34 
GeneralRe: Suggestions for Windows 8 application PinmvpRichard MacCutchan24-Oct-12 2:41 
RantUnwanted Calls / Spoofed Numbers PinmemberpdelayCA18-Oct-12 12:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web01 | 2.8.150326.1 | Last Updated 27 Mar 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid