I need a blazor application that meets the following conditions: Create a web Server Blazor application called A$23$ with Individual Account authentication. We will configure the authentication to use the database used in Database Review $1($see point $4).$ Edit the navmenu.razor file to ONLY show the $3$ pages of our Final and the default Home page $.$ I will leave the naming of the links to you. All three pages need to have different icons and they must be different from the default icons already there $($only home will be left with its default icon$).(10$ Points$)$

Edit the index.razor file in the pages folder to create your own home page. At a minimum it must contain your name, and the date you created it on the page. $(5$ Points$)$

Numbers Review $$ You will have $2$ files for the Numbers Review section. File one will be a razor page. File two will be a Razor Component which uses three variables Start, End and divide to print all the whole numbers in the Start to End range that can be divided by the divide value $($e$.$g Start is $1,$ end is $150,$ divide is $4,$ the count would be $4,8,12,16,...).$ I will be testing a couple of different values.

Show the Start, End and Step values and add a button called $$Display Numbers$.$ You will also display a count of the numbers being printed called NumCount. This will utilize $2-$way binding and the initial NumCount value will be $0.$ Once you click the button to print the values it will output the count.

You will include the component within the razor page, pass the parameters when calling it where the first $3$ set the start, end, and divide values and the final value implements the $2-$way binding above. $(15$ Points$)$

Database review $1$ Review $1$ will cover the concepts covered in Module $5.$ Create a Databasecalled $23.$ Once the database is created you will want to create $2$ tables. Table one will be the customer table it will contain the customer ID$,$ Customer name, Customer address, Customer Zip, Customer phone number and customer email address. You will need to create $10$ unique records in this database, the second table will be an orders table, this table will contain Order ID$,$ Customer ID$,$ date of purchase, shipped date, and total amount spent. For this table I want $30$ unique records. You can have multiple for one user but I require at least $7$ users to have at least $1$ order tied to them. For the DB creation you must submit the SQL scripts you use to create the tables and data or you will lose all points for the DB sections of the final. $(10$ Points$)$

Once the database is created you will then create the Database Review $1$ page, connect the database to visual studio, install the SQLServer and tools packages and then use the database scaffold command to create the Model and DBContext files as well as configure it to use authentication.

I want you to display all the customer information on the load of the page. There will also be a radio button on each customer row so that the user can select the customer and view the orders placed by the customer. Below the customer records, when the page first loads, you will have a message indicating $$No orders available to view!!!!$$ and this will stay till a customer is selected.

When a customer is selected it will display all the orders from that customer below the customer list. All information about each order should be displayed on the page. $(20$ Points$)$

Database Review $2$ review $2$ will cover the concepts covered in Module $6.$ Using the Customer table you created on part $4$ you will need to create a stored procedure for this page. As with prior examples you will be creating $2$ search boxes and a search button to look for records containing the information entered in one or both of the search boxes. You will do the searching on the customer zip and customer phone number. You will need to submit the stored procedure script along with the other scripts in part $4.$

As with the prior class examples you will need to create a service class to execute the stored procedure for this page