Reference no: EM132271223
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 Inventory-SQL-Query.txt file from SLATE, and run the SQL queries in Visual Studio to create the database tables.
- There are two tables:
- Category
- Product
- The CategoryId column of the Category table is a foreign key in Product table.
3. The application should have three webforms, derived from a master page:
- Home | Add Category | Add Product
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:
- DropDownList: to display list of categories.
- GridView: to display the products belonging to the selected category.
2. On the initial page load, the DropDownList is populated with category names, along with the first item as "Select category".
3. On selecting a category, the products belonging to that category are displayed in the GridView.
- Use INNER JOIN to print category names instead of category id.
4. If a new category is selected in the DropDownList, update the products GridView accordingly.
5. If user selects "Select Category" again, clear the GridView and display a message advising the user to select a category.
6. There should not be any button on this webform.
Add Category WebForm:
1. This webform has:
- TextBox: to type the category's name.
- Button: to add the category's name to the database.
- RequiredValidationControl: to add the validation.
2. This webform adds the category's name to the database table.
3. Add validation control so that the text field cannot be left blank.
Add Product WebForm:
1. This webform has:
- Three TextBoxes: to enter the product's name, price and quantity.
- DropDownList: to display categories.
- 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 category DropDownList is filled with their names, along with the first item as "Select category".
3. Then the user can enter the other data in the textboxes.
4. 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:
i. Home | Add Category | Add Product
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.
Attachment:- Assignment.rar