Full Stack Web Development – S1 – 2022, School of Digital Technologies, MIT, NZ. Page 1 of 2





School of Digital Technologies:
BDT – Bachelor of Digital Technologies
502.632 - Full-Stack Web Development
Practice Test
Course 502.632 - Full-Stack Web Development
Assessment name Practice Test


Use the ASP.NET Core 3.1 framework or above unless you have a software / technical issues which you
must inform the lecturer immediately.
The task of the assessment is to create a ASP.NET Web App that is capable of providing an UI for create,
update and delete data from SQL Server. For Each addition / modification / deletion of code you must
provide detailed comments with
// - Date ,
// Question Number :
// Reason for changing the code
Use the following connection string
"Server=citizen.manukautech.info,6305;Database=yourDatabase;UID=youruserid;
PWD=yourpassword;encrypt=true;trustservercertificate=true "


Replace the Database, UID (UserID) and PWD (password) with the credentials provided to you by the
lecturer.


In case you have trouble connecting to manukautech server, a SQL Server script will be provided to run on
desktop. However, make sure you type your IDs and passwords properly before asking for script.
Full Stack Web Development – S1 – 2022, School of Digital Technologies, MIT, NZ. Page 2 of 2
QUESTION1 :

SNO Tasks
1 Create a new ASP.NET Web APP with Authentication selected
2 Update the connection string in your ASP.NET Web App
3 Create a new Scaffold-DbContext using Power Shell and load databases
5 Remove – Delete irrelevant code from dbcontext and startup.cs etc.
6 Create a new Scaffold-Controller for Customer(s)
7 Create a new menu item for Customer(s)
8 Add an Identity Scaffold to the project: and perform necessary code changes
9 Add PaswordHint to the RegistrationPage
10 Change UI of registration page to reflect newly added attributes

QUESTION 2:
Supplied below is a test string giving input of OrderDetails in JSON format.
Add a new controller called OrderDetails and add a method to calculate and display the total amount for
the product BPRECISE00

Sample output:
Total Sales for Product BPRECISE00 - Amount : XXX


Attribute Name Datatype
OrderID Integer
ProductID String
Quantity double
Unitcost double
order String
Product String


Json Input:
/Calc/Ord?j=[{"OrderId":1187,"LineNumber":1,"ProductId":"1MOR4ME","Quantity":1,"UnitCost"
:69.9900,"Order":null,"Product":null},{"OrderId":1188,"LineNumber":1,"ProductId":"1MOR4ME
","Quantity":1,"UnitCost":69.9900,"Order":null,"Product":null},{"OrderId":1198,"LineNumbe
r":1,"ProductId":"BPRECISE00","Quantity":1,"UnitCost":11.9900,"Order":null,"Product":null
},{"OrderId":1200,"LineNumber":1,"ProductId":"BPRECISE00","Quantity":1.5,"UnitCost":11.99
00,"Order":null,"Product":null},{"OrderId":1203,"LineNumber":1,"ProductId":"BPRECISE00","
Quantity":2.5,"UnitCost":11.9900,"Order":null,"Product":null}]