PROG37721 Hockey League Website

Instructions:

1. Make a web application in Visual Studio and name it as A3FirstnameLastname.

2. Create a web application that displays the hockey league statistics.

• You need to create a SQL Server database as a MDF file.
• Then download the HockeyLeague-SQL-Query.txt file from SLATE, and run the SQL queries in Visual Studio to create the database tables.
• There are two tables:
  • Player
  • Statistic
• The PlayerId column of the Player table is a foreign key in Statistic table.

3. The application should have three webforms, derived from a master page:

• Home | Add Player | Add Stats

4. Refer to the images at the end of this document to get some hints.

• Your pages do not need to look similar to my design.
• Use you own imagination to design and style the pages.
• However, all the required information, as seen in the screenshots below, must be displayed.

Home WebForm:

1. This webform has:

• GridView: to display the player stats.
• Labels: to display the players with lowest points and highest points.

2. On the initial page load, fetch and display the player stats in the GridView.

• Use INNER JOIN to print player names along with their stats.
• Do not print ID columns.

3. Find players with the lowest and highest points, and display their names along with the points, somewhere underneath the GridView.

Add Player WebForm:

1. This webform has:

• Two TextBoxes: to type the player's name and jersey number.
• Button: to add the player's information to the database.
• RequiredValidationControls: to add the validations.

2. This webform adds the player's name and jersey number to the database table.

3. Add validation controls so that the text fields cannot be left blank.

Add Stats WebForm:

1. This webform has:

• DropDownList: to display player names.
• Four TextBoxes: to enter the matches played, won, assists and goals.
• Button: to add the above information to the database.
• Validation Controls: to handle any validations that may occur.

2. On the initial page load, the player DropDownList is filled with their names, along with the first item as "Select player".

3. Then the user can enter the other data in the textboxes.

4. Before adding the data to the database table, calculate the player's points.

• Assist is 1 point each and goal is 2 points each.

5. No field could be left blank or unselected.

• Add the necessary validation controls.

App Design:

1. Use a master page to design the layout of the application.

• Your application should have a header that displays the website title. Add a background image to the header.
• A navigation bar, either under the header, or in a sidebar having these links:
  • Home | Add Player | Add Stats
• A main content section that will change its content from page to page.
• A footer that display's your name and student ID.

2. Give proper names to all the ASP.NET server controls.

3. Create all your webforms using the master page.

4. There should be no compile-time errors or run-time exceptions in your application.