o 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.
Get all items includes all WatercolorsPainting information and StyleName.
Search all items WatercolorsPainting table with 2 conditions: PaintingAuthor or Publish Year (usingrelative search)
Part 02 (3.0 marks).
Student can choose one of these options for client application
ASP.NET Core Web App with MVC
ASP.NET Core Razor Pages
Windows Forms
Windows Presentation Foundation
1. Authentication function
If user with a manager role or staff role logs in successfully, save this information to a temporary parameter.
All CRUD actions are required with manager role
Search information is required with manager role or staff role.
In the case login unsuccessfully, display "You are not allowed to access this function!"
2. Check if login successfully, search all items with 2 conditions: PaintingAuthor or Publish Year (using relative
search)
3. Check if login successfully, delete the selected item with the confirmation then update the list of items.
1
Zoom
100%
Close
