Department of Computer Graphics

CGT 456 Hypermedia Authoring II

Locator Application

Instructions

This lab will give you more experience with database connectivity in ASP.NET Mobile Forms.

Procedures

1. Download this SQL Script and execute it using Query Analyzer.
   • Here is an ERD of what you just created.
      
2. Food Locator
   • Create default.aspx and its corresponding Code Behind page.
   • C# code should be contained in the Code Behind page.
   • The pages should be constrained to 220 pixels wide.
   • You should utilize controls that have been taught up to this point, including DeviceSpecific and Choice.
   • When default.aspx loads, it should take this general form, although you have some freedom to change it if you think of a better layout.
     • Use of the Command buttons is up to you. You could alternatively use AutoPostBack.
     • List the 3 primary ways to search for food / food items:
       • By location / section within the stadium. See the map here.
       • By Food Item
       • By Food Stand
   • Selecting a location will yield something similar to this, again you have freedom to change it.
     • Show all food stands within +/- 5 sections of the one chosen.
   • Selecting a food item will yield something similar to this, again you have freedom to change it.
     • Show all of the food stands that serve that particular food item.
   • Selecting a food stand will yield something similar to this, again you have freedom to change it.
     • Show all of the food items that particular stand serves as well as all the locations of that stand.
   • Provide navigation back to the main page such that the user does not have to use the Back button.
      
3. Above & Beyond
   • In addition to the above - not replacing the above
     • Tie the location selection to the second & third selections such that searching for a food stand / food item yields results that are divided into headings such that results
       • under heading one are within +/- 5 sections of the location selected
         • If there is nothing available, state that nothing was found within +/- 5 sections of you
       • and under heading two are within +/- 10 sections of the location selected
         • If there is nothing available, state that nothing was found within +/- 10 sections of you
       • which gives the user options, growing increasingly outward from their current location.
     • State the location of the nearest one to the user.
   • You may choose to do this in a separate aspx or in the same aspx.
      
4. Send your instructor an email with a link to your lab in your server space.
• Please make sure the links are correct by checking them yourself before you send

Grading