Scribd
Upload
47 views1 page

Developer Task

An XYZ company requested a web application to store product details, allowing users to view, add, delete, and modify products. The application must use ASP.NET Core and SQL Server, with products having a unique product code and details like description, price, and category. Users can list all products or filter by category, and adding/updating requires validating fields and showing categories in a dropdown before submitting.

Uploaded by

Kaiji Kurogane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
47 views1 page

Developer Task

An XYZ company requested a web application to store product details, allowing users to view, add, delete, and modify products. The application must use ASP.NET Core and SQL Server, with products having a unique product code and details like description, price, and category. Users can list all products or filter by category, and adding/updating requires validating fields and showing categories in a dropdown before submitting.

Uploaded by

Kaiji Kurogane
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Requirements:

An XYZ company comes up with request to build a simple web application to store details of
their Products that allow users to view/add/delete/modify the products details.

Functional requirements:
1) A Product is identified by ProductCode (integer - Unique) and has additional columns
Description (nvarchar), UnitPrice (decimal) and Category (Integer) to store the product
details
2) Each Product belongs to one or more categories. Categories are defined simply by their
Name: "Beverages", "Diary Products", "Grains", “Seafood” etc.
3) The Web application should allow the user to add, delete, modify and view the products.
4) When adding or updating a Product, Categories must be shown as (Dropdown List)
5) The Web application should allow listing all Products in a system or filter the Products by
Category.

Technical requirements:
1) Use ASP.NET Core (C# language) (MVC) or any front end framework and
ADO.NET/Entity Framework for development.
2) Create table(s) in SQL Server with appropriate Primary and Foreign Keys
3) For Insert or Update, please implement validations as follows.
 Description should not be empty.
 UnitPrice must be a numeric value.
 The user should be warned of possible errors before submitting form to server for
processing.
4) Use Exception handling wherever appropriate
5) Log any unhandled exceptions on server side in a text file.

You might also like