Write code using C/C++ which performs following tasks:
Demonstration of ASP.NET Page Processing Develop a page to demonstrate various events which are raised and handled during ASP.NET Page processing once the page object has been created? Develop a story about it?
Consider the Pine Valley Furniture Company database designed and implemented using structured query language
during previous semester. Try to recall major relations in the database (CUSTOMER_T, ORDER_T, ORDER_LINE_T, and
PRODUCT_T).
There is a need to implement a web based solution for above mentioned database. The web based solution must
incorporate following functionalities:
i) New Customer Registration
ii) Searching of Products
iii) Products Selection and Order Placement
iv) Product Catalog Update
v) Payment Provision
As a first step design above mentioned (i) to (v) user interfaces using paper and pencil.
Next write appropriate html for creating (i) to (v) user interface prototypes.
Create links for navigation among above pages.
Design a menu using list and styles.
Add help pages for user guidance.
Either use table for layout or may opt for flow based layout.
Test user interface prototypes in browser.
Experiment with style sheets.
Moving towards Business Intelligence
i) Try to transform order processing system into a customer segmentation analysis platform.
ii) How user profiling can be added into basic order processing system?
iii) How targeted marketing can be realized?
Task 1) Open website: https://visualstudio.microsoft.com/downloads/ and download Visual Studio 2022 Community
edition (if not installed).
In case of limited resources available on your PC/laptop/notebook you may check
https://visualstudio.microsoft.com/vs/older-downloads/ for previous versions.
Run the installer for Visual Studio.
Select ASP.NET and Web Development. Also select .NET Framework project and item templates, .NET Framework
4.6.2-4.7.1 development tools and Additional project templates (previous versions).
Task 2) Go to https://www.microsoft.com/en-us/sql-server/sql-server-downloads and download SQL Server Developer
or SQL Server Express edition, follow its instructions for installation.
SQL Server 2022 Developer is a full-featured free edition, licensed for use as a development and test database
in a non-production environment.
SQL Server 2022 Express is a free edition of SQL Server, ideal for development and production for desktop, web,
and small server applications.
In case of limited resources check https://learn.microsoft.com/en-us/previous-versions/sql/.
Task 3) Go to website: https://aka.ms/ssmsfullsetup to download SQL Server Management Studio. Install SQL Server
Management Studio SSMS by executing SSMS-Setup-ENU file.
Task 4) Consider the project database designed and implemented during previous semester i.e. Fall 2024. Its
implementation was done using structured query language during previous semester. Try to recall major relations
in your project database. You already have its report in printed form.
Create a website project using a blank folder as demonstrated in class.
Add a web form with separate code to the project.
Test the web form by running it in browser.
Write code to retrieve data from any of your project table. Display a few fields in browser.
Task 5) Connect and query a SQL Server instance using Visual Studio.
Follow the instructions https://learn.microsoft.com/en-us/ssms/quickstarts/ssms-connect-query-sql-server
Consider the database development project developed during previous semester. A complete database design and development was carried out in previous semester project as detailed in your project report in printed form.
In addition during one of previous labs (see reference below) you were required to develop web interfaces on paper and then develop html prototypes for various functionalities of your database project mentioned as above.
Now the next task is to transform paper based and html based prototype interfaces into full scale working web forms for realization of various functionalities of your project. Ideally you are required to develop all web forms for implementing various project functionalities.
Reference: Lab 3 Q1) Consider the project database designed and implemented during previous semester i.e. Fall 2024. Its implementation was done using structured query language during previous semester. Try to recall major relations in your project database. You already have its report in printed form.
There is a need to implement a web based solution for above mentioned database. The web based solution must incorporate various functionalities of your project.
(1) Registration of Student/Patient/Passenger/Customer, or whatever is applicable in your project.
(2) Search facilities including partial matches
(3) Any other project specific functionalities
(4) Role based access control
(5) Payment system (if required)
As a first step design above mentioned (i) to (v) user interfaces using paper and pencil.
Next write appropriate html for creating (i) to (v) user interface prototypes.
Create links for navigation among above pages.
Design a menu using list and styles.
Add help pages for user guidance.
Either use table for layout or may opt for flow based layout.
Test user interface prototypes in browser.
Experiment with style sheets.
You are strictly advised to refrain from using any AI tool during lab work. (0 score will be given for any such effort). Just follow codes as listed in book or as demonstrated in class from time to time.
Q1) Write code (code behind only) for any two of the interfaces below?
Q2) Draw corresponding graphical user interface as rendered in browser?
Problem 1) Implement a simple program that uses viewstate to store and retrieve counter value. Whenever
Increment button is clicked counter should be incremented by 2? Write code behind below?
If this page is accessed using different browser windows, or from more than one clients, whether the counter
value would be same, or it would be different at different time instants? Give reason for the observation?
Problem 2) Extend the program implemented above and make the View State secure? Refer to the textbook for the
technique of securing?
Problem 3) Consider the following definition of customer class. Develop a web form that stores three objects of
customer in viewstate. Implement the code for retrieving customer objects also?
Web Hosting
All students are requested to search for Web Hosting options on Internet.
For all lab tasks done so far and will be done in future, develop a suitable portal which contain
a. Problem Statement of Lab
b. Code implementation report.
c. Sample outputs (Screen shots)
d. Demonstration pages for each task/problem
Web Controls and Quiz
Task 1: Selected items in checkbox list will be displayed in the section below.
Task 2: dynamically generate table with the check box option to add the border.
Quiz in Lab 09: dynamically generate table with the check box option to add the border.
Web Controls and Quiz
Task 1: SelWhat are the necessary security features of your semester project? After identifying the security features of your project, prepare a list of at least 07 security features and write a brief description about each of them?
Task 2: Implement identified security features for your project and make a live demonstration available.
Task 3: Develop test cases for all security features and prepare a report about testing of security features?
Q1) Draw web services execution model?
Q2) Develop a web service with four web methods as follows:
(a) Add
(b) Subtract
(c) Multiply
(d) Divide
Assume all above methods need two parameters and return a single value as string value.
Q3) Test the web service using browser on local pc.
Install Internet Information Services on your laptop/pc (if not installed)
Using IIS manager create two separate applications as follows:
(a) MathLibService
(b) ServiceClient
Q4) Implement a web application “ServiceClient” which will use the MathLibService as a web service. Develop a suitable web page for its demonstration. Use some text boxes to take input from user. Use proxy class to get answer (response from web service) and display it on page to user.
