Asp.net mvc application with sql as database

You need to create 2 screens with specifications mentioned below.
1. Screen 1 – Listing screen
a. List down all products with pagination of size 10
b. Show all columns as per point #3.
c. Option to navigate the listing records (Next & Previous options)
d. Show recently added record on the top
e. Add Product button on the top of the listing screen
f.
Use stored procedure to display records on the screen
g. It does not need pagination, sorting, searching
2. Screen 2 – Product add screen
a. Create a form with the fields mentioned under point 3.
b. All fields are mandatory
c. Save button should validate the fields.
d. The product code should not be duplicated. Validate using stored procedure.
e. Trim white space from the entered values
f.
Use specific control only like textbox, text area, dropdown, radio buttons and file upload
g. Use stored procedure to add records in the database.
h. Once records is saved, redirect user to products listing screen

3. There will be following fields
1. Product Id – Auto generated table primary key. Do not display on the product creation
page. Display only on the listing screen.
2. Code – It has to be entered by the user and should not be duplicated.
3. Name – Allow up to 250 characters
4. Description – Allow up to 4000 characters
5. Expiry date – date picker and it should be future date
6. Category – Option to select categories hard coded (Options would be Category A,
Category B, Category C, Category D, Category E), By default Select Category with
validation to select one from category A to E
7. Image – Allow jpg or jpeg file upto 5 mb max
8. Status – Radio selection Active or Inactive – By default Active
9. Creation date – This is the default creation date & time. No input required on the screen.
Expected actions:
1. Create a new project from the visual studio.
2. Create a new database table with the mentioned fields. The field data type has to be meaningful
and proper.
3. Add controller, model, view to create screen 1 and 2.
4. Add validations using javascript or validators or any other way you know.
5. Create required stored procedures.

System Requirement:
Visual Studio 2019 or 2022
SQL Server to create new database and table
SQL Server Management studio
.Net 5.0 or .Net 6.0