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}]
