efonsecab / blazorrestaurant Goto Github PK

Add a new table to the database project. Table name must be "Profile"
Table must have the following columns

• ProfileId
• LocationId
• IOriginatorInfo interface columns

Administrators must be able to see a list of the Orders which have been created in the system

• Create a OrderController
• Create a ListOrders endpoint
  • Sort by RowCreationDateTime desc
• Create the page "/Admin/Orders/List"

• Create a LocationConroller
• Add a new endpoint named "AddLocation"

The endpoint must receive a LocationModel.
The endpoint must not allow to have more than one Location with IsDefault=true

Add a new page using the following folder structure "/Admin/Products/List"
Page must be accessible only to users with the "Admin" role.
Page must display products in a two column cards grid, similar to the List of Promos.
Cards must allow show the icons for edit and delete.
Edit will make use navigating to the "Edit Product" page
Delete will show a confirmation window with two buttons 1 for Cancel and one for Delete

Currently the Add Order functionality is under the Admin users section.

• Move the Add Oder to the Users section, keep a similar folder and namespace structure
• Change the Add Order page authorization to allow only non-admin users to access it.

Non-admin users must be able to List the orders they have created themselves.

• Create the page "User/Orders/List"
• Create a ListOwnedOrders endpoint in the OrderController
  • Receives the user's azureObjectId
  • Filters the orders created by the specified user

When in the "List Products" page, admin users must be able to delete a product.
A "Delete" icon must be displayed next to each product.
When hitting the icon, users must be shown a confirmation window with "Cancel" and "Delete" buttons.
Cancel will just close the window a related variables.
Delete will delete the product, clean the variables and reload the data.

1. Log in with an admin user
2. The user will be redirected to the admin page
3. Log Out.
4. Log in again with the same user
5. The admin menu is not visible

Expected:
The admin should be able to see the admin menu after login back in

Add a new table to the database project.
Table name must be "OrderDetail"
Table must include the following columns

• OrderDetailId
• OrderId
• ProductId
• ProductQty
• LineNumber
• LineTotal
• IOriginatorInfo interfaces columns

Allow for a points-based system.
The points will be exchangeable for discounts in orders.
Use a x10 rate for exchanging points.
The points must expire every 6 months, static datetime. June 1, every year. December 1st every year.

The must must log all of the errors that occur in the client-side.
The log must have the following information:

• ExceptionMessage
• StackTrace
• PageUrl
• ApplicationUserId
• DateTimeOffset (UTC)
• IOriginatorInfo interface columns

Create a new controller named "ProductController"

Add the "AddProduct" endpoint to the controller.
Endpoint must receive a "ProductModel"

The system must log all of the visits to pages.
The system must log the following information:

• PageUrl
• ApplicationUserId
• IpAddress
• DatetimeOffset (UTC)
• IOriginatorInfo interface columns

Currently, the app does not have authorization enabled for Swagger UI,
this means only endpoints with AllowAnonymous would work.
We need to enable Authorization from Swagger UI, in order to retrieve the Bearer Token required by tthe API.
Ideal solution:
After clicking the Authorize button in Swagger UI, the window will use an implicit flow and only require you to input
the Username and Password.

Useful links:
https://www.taithienbo.com/configure-oauth2-implicit-flow-for-swagger-ui/
https://jpda.dev/using-nswag-and-swagger-ui-with-b2c
https://joonasw.net/view/testing-azure-ad-protected-apis-part-1-swagger-ui
https://skycliffs.com/2017/10/08/swagger-ui-authentication-with-azure-ad-b2c-on-service-fabric-net-core/
https://stackoverflow.com/questions/40179409/test-a-web-api-aspnetcore-with-swagger-ui-and-azure-ad-b2c
https://daniel-krzyczkowski.github.io/Cars-Island-ASP-NET-Core-API-Secured-By-Azure-AD-B2C/

The system must allow users to see a map with the orders delivery route.
The map must show the correct weather icon for each of the points in the route.

The system must allow users to select the language in which they want the site to be displayed.

Make sure all of the requests to the server side, have the correct language header, corresponding to the user selected language.
Make sure the server side changes the thread culture to the culture/language selected by the user in the client-side application.
Make sure all of the text data from the server api is returned in the language selected by the user.

The system must log all of the API Requests.
The Log must include the following information

• Client IP Address
• DateTimeOffset (UTC)
• RequestUrl
• RequestHeaders
• RequestBody
• ApplicationUserId
• IOriginatorInfo interace columns

Create the page page to add products.
Page must be created in the following folder "/Admin/Products/Manage"
Page must be accessible using these routes

• "/Admin/Products/Manage"
• "/Admin/Products/Manage/{ProductId:long}"

Restrict the page to be accesible only to uses with the "Admin" role.

• Create a new controller named CountryController
• Add an endpoint named ListCountries
  • Must received a parameter named searchTerm. The search will be using StartsWith(searchTerm)
  • Must return the data ordered by Name
• Create the corresponding Test method for the created endpoint

Add a new table to the database project. Table name must be "Location"

Table must include the following columns

• LocationId
• Name
• Description
• FreeFormAddress
• Latitude
• Longitude
• ImageUrl
• IsDefault
• IOriginatorInfo interface columns

Generate the related entities

Table must have the following columns

• CountryId
• Name
• ISOCode

• Extend the Azure Maps control to support HTML Markers: https://docs.microsoft.com/en-us/azure/azure-maps/map-add-custom-html
• When adding orders, after the user clicks a POI (Point of Interest), show a marker reflecting the item clicked.

Currently the system is returning all the data as it is, however, as data grows, paging will be required.

• Create reusables classes for the paging parameters as well as for the paged endpoints results

Add a new endpoint in the ProductController.
Endpoint must be named "ListProducts" and must return a ProductModel[]

System is currently using secrets.json for development and appsettings.json for release.

• Make the server app support AzureKeyVault
  • Support both Certification authentication and Secrets-based authentication.
• Remove the need to use secrets.json and appsettings.json except for the AzureKeyVault required configuration

Orders will be stored in a table named "Order"

• Add an "Order" table to the database project. Must include the following columns
  • OrderId
  • DestinationFreeFormAddress
  • DestinationLatitude
  • DestinationLongitude
  • IOriginatorInfo interface columns
• Create the respective partial class in a file named Order.partial.cs, the class must implement IOriginatorInfo

Add the table "Product" to the database project

Table must have the following columns

• ProductId
• Name
• Description
• ProductTypeId
• UnitPrice
• IOriginatorInfo interface columns

The system automatically fills the Autiding columns defined in the IOriginatorInfo interface.

The class "BlazorRestaurantDbContext.partial.cs" has method "ValidateAndSetDefaults" which is in charge of fill the respective data,
the RowCreation user is retrieved from the Thread, however, the CurrenPrincipal is always set to null, even if the user is
Authenticated.

Expected Result:
The Thread.CurrentPrincipal object has the authenticated user information, including the claims.

Add the logic for creating the initial data for ProductType into the existent Post-Deployment script.

The initial Product Types must be

• Beverage
• Pasta
• Pizza
• Meat
• Fish
• Dessert

ErrorLog table now implements IOriginatorInfo, therefore, the CreatedAt is no longer required.

• Remove the column from the table, and respective entities and models
• Regenerate the entities.
• Remove the column from the models

Currently the server project only make use of [Authorize] without using Roles.
There is currently an issue when using [Authorize(Roles="RoleName")], probably because the Roles Claims are not been filled

Expected Result

• The ErrorController must be marked with [Authorize(Constants.Roles.Admin)]
• The endpoints in that controller must be accessible only to admin users

Add a "ProductType" table to the database project.

Table must include the following columns

• ProductTypeId
• Name
• Description

Generate the related entities