Hello, I have one assignment on C# need to be completed urgently for tomorrow. Need to create a WPF. Full description of the assignment is given in the attached file.

Page 1 of 10 COMP212 Programming 3 20 20M - Lab Assignment 5 Implement WPF app to manipulate data within Database Du e Date : Tue , Week 11 Goals: In this assignment, you will learn how to use the WPF controls DataGrid, ComboBox, Button . You will also learn how to make your WPF app create and interact with a database by exploiting two classes DbContext and DbSet of Entity Framework (specifically Entity Framework 6 (EF6). Y ou can think EF 6 to be a restricted version of EF Core) . Rubric: (Total marks = 10, Weight = 10%) Cases Three DataGrid, two ComboBox es , six Button s are present in the GUI layout. When you select an item in F ruit ComboBox , t he selected item shows up in a row in DataGrid -1 (left DataGrid). When y ou select an item in Planet ComboBox , t he selected item shows up in a row in DataGrid -2 (middle DataGrid). When you select an item in the DataGrid -1, the selection (if any) at DataGrid -2 should get unselected. When you select an item in the DataGrid -2, the selection (if any) at DataGrid -1 should get unselected. An element in DataGrid (i.e. a grid location) should not be editable. On clicking button “ LINQ Project QS ” shows relevant rows in DataGrid -3 (right DataGrid). On clicking button “ LINQ Filter QS ” shows relevant rows in DataGrid -3. On clicking button “ LINQ Order Ascending QS ” shows relevant rows in DataGrid -3. On clicking button “ LINQ Inner Join QS ” shows relevant rows in DataGrid -3. Button “Clear” clears all three DataGrids, clears the selections in every Com- boBox Button “Delete selected row” deletes the selected row in DataGrid -1 (left Data- Grid) or the selected row in DataGrid -2 (middle DataGrid). Button “Delete selected row” shou ld not delete any selected row in DataGrid -3 (right DataGrid). When DataGrids are empty (i.e. they have no rows of items), ComboBoxes should be in reset condition (i.e. they should have no item selected) When DataGrids are empty, clicking any button sh ould have no effect on the GUI. Page 2 of 10 Submission of Assignment: 1. Slides/Code related to lectures on WPF, LINQ may be useful. 2. M ake sure that there is one project folder Pro j1 under the Visual Studio 2019 solution folder Lab5 . 3. Make sure your code compiles (and runs) in Visual Studio 2019 installed in a Windows 10 com- puter before submission. 4. In Visual Studio, in Solution Explorer, r ight -click on the solution Lab 5 and choose Clean Solu- tion . 5. Compress the Visual Studio solution folder Lab 5 and all its contents into a single zip file. This will be your submission file. You MUST name your submission file according to the following rule: YourFirstname_YourLastname_COMP212 _Labnumber.zip Example: John _Smith _COMP2 12 _Lab 5.zip 6. Next , submit above zip file on eCentennial through the assignment link. Develop a WPF application that interacts with database through Entity Framework 6. 1. Below are several pictures of how your GUI should look. The rubric in Page 1 of this document tells how your application should work. Read the figure captions carefully as well . They also provide hint on how the GUI should work. Page 3 of 10 2. There are Three DataGrid s (in top row) , two ComboBoxes (in middle row) , six Buttons (in bottom row) present in the GUI layout. Refer to the rubric for more information . Figure 1. The GUI when launched. Page 4 of 10 Figure 2. Items in Fruit ComboBox. Page 5 of 10 Figure 3. Items in Planet ComboBox. Page 6 of 10 Figure 4. A sample set of items in DataGrid -1 (left datagrid) and DataGrid -2 (middle datagrid). Note : The FruitId MUST NOT be set by you. It should be automatically created for you when a Fruit object is saved in the database as a row. Same argument holds for the PlanetId of a P lanet object. Page 7 of 10 Figure 5. The relevant items in DataGrid -3 (right datagrid) on clicking button “LINQ Project QS ”. Page 8 of 10 Figure 6. The relevant items in DataGrid -3 (right datagrid) on clicking button “LINQ Filter QS ”. Here the “filter” is the color red . Page 9 of 10 Figure 7. The relevant items in DataGrid -3 (right datagrid) on clicking button “LINQ Order Ascending QS ”. Page 10 of 10 Figure 8. The relevant items in DataGrid -3 (right datagrid) on clicking button “LINQ Inner Join QS ”.