Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.x and 2.0 Application Design section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 3rd, 2006, 09:05 AM
Authorized User
 
Join Date: Apr 2006
Location: Virginia Beach, VA, USA.
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default Design Strategy

I am having ‘architectural problems’. My requirement seems to be quite simple. I have a database table ZipInfo with five involved fields StateAbbreviation, CityName, ZipCode, ZipID (pkey), and ZipPopulation.



I need a web page that allows a client to:



1) select a State (I am using standard dropdown list and passing parameter to SQL database Select statement)

2) After client selects state and clicks to execute I want to display all zip codes in the selected state. Each row will contain: ZipCode, CityName, ZipPopulation and a check box where the user can add it to his collection.

3) As client selects one or more rows using the checkboxes a textbox monitors the total ZipPopulation of all ZipCodes that have been checked by the client adding to the total when another row’s checkbox is set true.

4) When the client is finished checking checkboxes the textbox will show the total population for all ZipCodes selected. The client will click to finalize their selection and I then need to pass all ZipID’s for the ZipCodes selected by the client to a ClientInfo table in the same database (ClientInfo.SelectedZips where ClientID = active client).



My questions are what is an appropriate strategy for this problem? Can and should I use existing controls that I find in Visual Studio 2005 or will I need to develop my own classes and methods? I can easily pull the data needed using GridView but am having trouble adding the checkboxes. I do not know if I should be loading up a custom array. I need some design strategy guidance that will allow me to create and monitor the checkboxes as the client selects them and to simultaneously display the total mailing population (ZipPopulation) represented by their selection and possible de-selections and then pass the final ZipID’s back to a field in the ClientInfo table.



I have done this in ASP.Net but it was not pretty. Rather than just forcing a solution I want to code an appropriate and reasonably efficient Web 2.0 solution. I come from an ASP.Net background and the new 2.0 tools are somewhat overwhelming. I am using C# for the code behind.



Thank you
Reply With Quote
  #2 (permalink)  
Old October 3rd, 2006, 10:59 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

Zoltac007:

I have a couple of questions that crossed my after reading your topic:
1-Having some experience with zipcode info (especially from Census Bureau), in your ZipInfo table are there multiple zip codes per city and/or multiple cities per zipcode?;
2-Is there a seperate client table with just clientID and clientName?. Are we talking 3-DB Table, zipInfo, State, and ClientZipInfo, or 4 DB tables?;
3-When the client builds the clientinfo table, is client adding one entry per zipcode? If so, what happens if client adds an existing zip, which creates a duplicate entry?
4- Is the objective here is for the client to know the total mail distribution in his/her assigned area, being state?

Outside of the above questions, I really dont envisioned the need to establish a seperate class. However I am just looking at the design for now.
Reply With Quote
  #3 (permalink)  
Old October 3rd, 2006, 11:56 AM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 63 Times in 63 Posts
Send a message via AIM to dparsons
Default

I have to ask the question of usability here because there are over 42,500 UNIQUE zip codes in the united states so that is an average of about 850 rows of data per state.

Is it logical to think that a user will wade through that many records just to select X number of check boxes?

Would it make more sense to make a sphereical geometery calculation based off of X origin zip code and return only those zip codes that fall within X miles of the orign?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.  
Unless, of course, you want to hire me to do work for you.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP - Design Strategy snufse ASP.NET 2.0 Basics 1 March 27th, 2008 02:17 PM
Design patterns for web design ceadge HTML Code Clinic 0 June 19th, 2006 11:26 AM
Design help j.gonsalves@ntlworld.com Access 2 August 16th, 2004 10:01 AM
Java Design issue with UML and Design Patterns the_logical_way Apache Tomcat 0 May 31st, 2004 04:02 AM
Applications Infrastructure and Dev. Strategy. azharmateen PHP How-To 2 August 20th, 2003 11:37 AM



All times are GMT -4. The time now is 03:49 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.