Role
Price
PublishYear
Styleld
Created Date
Note that: Member role: Administrator = 1; Staff = 2; Manager=3; Customer = 4,. A Style will have many watercolors paintings, one watercolors painting will belong to only one Style.
Part 01 (7.0 marks). Create an API using ASP.NET Core Web API with Entity Framework Core. A MS SQL Server database will be created to persist the data and it will be used for reading and managing data.
1. Check authentication/authorization with the ASP.NET Core Web API with JSON Web Token (JWT)
Manager role will have a permission to to all actions (CRUD and search).
Staff role will have only permission to searh information.
Note that the permission for Login process is using UserEmail and UserPassword.
2.
You must use OData to implement the ASP.NET Core Web API. CORS is using in this case.Implement CRUD actions with Watercolors Painting table. Add new item with the requirements:
All fields are required.
• Value for PaintingName includes a-z, A-Z, space and digit 0-9. Each word of the PaintingName must begin with the capital letter.
Value for Publish Year>=1000 and CreatedDate = current date.
• The value for Price must be >= 0.
Zoom
+ 100%
Get all items includes all WatercolorsPainting information and StyleName.
Close
