$1.$ Make a WPF App $(.$NET application$)$ in Visual Studio and name it as FinalFirstnameLastname.

$2.$ The app should be able to display and add products from the Northwind database.

$3.$ Download the Northwind$-$Sample$-$Database$-$for$-$LocalDB.sql file and use the SQL script it contains

to create and populate the database.

$$ When creating a new database, it must be named Northwind, otherwise, the script will not

run properly.

$$ Use LocalDB $($meaning like MSQLLocalDB$)$ as database source unless you$$ve got written

permission from your professor to use a different data source such as SQL Server or MDF file.

Page $2$ of $5$

Faculty of Applied Science & Technology

$4.$ You can use Connected, Disconnected or typed dataset for this.

$5.$ The application should have two windows:

$$ Home $|$ Add Product

$1.$ This window has:

$$ Buttons: six buttons to get all products, clear fields, search product, add new product, edit

product, and delete product.

$$ ComboBox: to display list of categories.

$$ TextBox: to enter the product name to search for it$.$

$$ DataGrid: to display the fetched data of products from the Products table.

$2.$ When the user clicks the $$Get All Products$$ button, fetch all the products data from the Products

table and display it in the DataGrid. Also, populate the categories ComboBox with categories.

$3.$ The $$Clear Data$$ button clears all the data from the window, that is$,$ it clears the DataGrid, the

ComboBox and any text from the TextBox.

$4.$ The user can get all the products from a selected category. When the user selects a category name

from the categories ComboBox, fetch and display all the products that belong to the selected category

in the DataGrid.

$5.$ The user can also search for a product by name. Fetch and display all the products in the DataGrid

that match the name entered by the user.

$$ Partial name matches should also fetch the products.

$6.$ On clicking the $$Add New Product$$ button, a new window should be displayed which can add a new

product to the Products table.

$$ Display the Add window as a dialog box. User should not be allowed to go back to the Home

window as long as the Add window is open.

Page $3$ of $5$

Faculty of Applied Science & Technology

Add New Product Window:

$1.$ This window has:

a$.$ Two TextBoxes: to enter the product name and price.

b$.$ ComboBox: to display the list of categories.

c$.$ Buttons: to add the above information to the database and to close the window.

$2.$ On the initial window load, the categories ComboBox is filled with category names.

$3.$ The user can type the name of the product and its price in the textboxes.

$4.$ Select the category from the category ComboBox.

$5.$ Then, clicking the $$Add Product$$ button adds the information to the Products table.

Continue to the next page!

Page $4$ of $5$

Faculty of Applied Science & Technology

$7.$ On clicking the $$Edit Product$$ button, a new window should be displayed which can edit the selected

product from the Product table and then show the edited product to the Products table.

$$ Display the Edit window as a new page. User should not be allowed to go back to the Home

window as long as the Edit window is open.

$$ Your Edit window should display the selected data in the fields appropriately.

$$ If user did not select any product from the Product table then your Edit window should not

open and show a message to the user to select a product first it wants to update$/$Edit

$1.$ This window has:

a$.$ Two TextBoxes: to enter the product name and price.

b$.$ ComboBox: to display the list of categories.

c$.$ Buttons: to add the above information to the database and to close the window.

$2.$ On the initial window load, the categories ComboBox is filled with category names.

$3.$ On the initial window load, the data selected from the Product table from Home window.

$4.$ The user can type the name of the product and its price in the textboxes.

$5.$ Select the category from the category ComboBox.

$6.$ Then, clicking the $$Save$$ button updates the information to the Products table.

$7.$

$8.$ One clicking $$Delete product$$ button, the selected product from the Products table should be

deleted.

$$ Your application should show an error if the delete button is pressed without selecting any

product from the Product table.

Page $5$ of $5$

Faculty of Applied Science & Technology

Marks Breakdown:

$5\%-$ for correct submission.

$10\%-$ for proper implementation of EF$.$

$35\%-$ home window.

$20\%-$ add product window.

$20\%-$ edit product window.

$10\%-$ delete product.

Submission:

$1.$ Once done, ZIP the solution folder and upload it to Assignments on SLATE.

a$.$ Double$-$check your submission by downloading it and running it$.$

$2.$ You are to submit $.$ZIP and $.$TXT files, separately:

a$.$ Upload the $.$ZIP file of your assignment to SLATE.

b$.$ Upload the $.$TXT files to SLATE.

$3.$ You must copy and paste all of your source code from your C# files into separate plain text files.

a$.$ You can copy and paste the source code into Notepad.

b$.$ Create a separate $.$TXT file