Visual Programming

Semester Credit Hours Prerequisite

[BSCS-6] [2+1] [OOP, DBMS]

Course Description
The purpose of this course to provide the foundational knowledge of visual programming and skills for
event driven application building. Introduce the students to Graphical User Interfaces and applications
in a Windows as well as in Web environment. To enable them to plan, design, construct, and integrate
applications by using C#, ASP.Net and their frameworks.
Course Learning Outcomes (CLOs)
The course learning outcome along with domain and taxonomy level are listed below

S. # CLO Statement Domain Taxonomy

Level
CLO-1 Implement the solution for windows application. C C5-Synthesis
CLO-2 Design Asp.NET base web solution for dynamic C C5-Synthesis
content delivery and e-commerce solutions.
CLO-3 Adapt an Asp.NET Core to enable applications to C C5-Synthesis
exchange data easily and securely using Model View
Controller Model.
CLO-4 Design and implement the window forms based P P7-Organization
applications for a given scenario.
CLO-5 Construct a fully functional Asp.NET based solution P P7-Organization
for a given scenario.
CLO-6 Design a solution based on MVC based Asp.NET P P7-Organization
applications for a given scenario.
* BT= Bloom’s Taxonomy, C=Cognitive domain, P=Psychomotor domain, A= Affective domain

Course Materials
This course introduces the following topics to students:
 Introduction to Visual Programming
 C# and Windows Applications
 ADO.Net
 ASP.Net (Form, Master page etc.)
 Three layer architecture
 Stored Procedures
 LINQ

Page 1
  Entity Frame Work
 Model View Controller
 Windows Communication Foundation
 ASP.Net Core
Course Weekly Schedule
The course schedule for 16 weeks are detailed below

Week Topic
Topics Chapters
1 Visual Programming Basics, Introduction to Events; Book 1, Chapter: 14,15
Fundamentals of Event-driven Programming Section: 14.2,3,4,5,6,7,11,12
Message handling, user interfaces, graphics device Section: 15.3,4,5
interface, Common Controls, Windows Management
Introduction to Windows Form Application using Visual
Studio. Simple Calculator and Scientific Calculator
using Windows Form Application.
2 Database Connectivity of Windows Form application Book 1, Chapter: 22
with SQL server. Use of ADO.Net for Insert, Update Section: 22.1,2,3,4,5,6,7
and Delete Records.
Book 2, Chapter: 21
Entity Data Model, Querying Database using LINQ to
SQL, Data binding, Use of Data Grid View. Retrieving Pages: 817 to 824, 840-842
data from multiple tables.
3 Designing Centralized Database operations using Book 2, Chapter: 22
DbConn class Section: 22.1, 2, 3, 10
Search records using Connection-less approach
Using Data Set, Data Table and Data Adapter using
Connection-less Approach
4 Web Applications, Master Page, Web Pages Online link for Master Pages
Introduction to ASP.net Life Cycle, Web Form
Application Development
Overview of Front-end pages and applying a template
using Master pages
5 Dynamic link libraries, Building Class Libraries, Using Online link for 3-tier
References
Three-tier architecture including Properties,
Presentation Layer, Business Layer, Data Access Layer
6 Creating Stored Procedures for CRUD operations and Online link for stored procedure
calling in visual application. Ch-21, Page: 835-840, 845-846
Populating List boxes and Combo boxes with data Online sources
tables

Page 2
Week Topic
Using Data Readers with Connection Oriented
Approach
7 Assemblies, Private Assembly, Shared Assembly, Book 2, Ch-14, Pages 516 to 540
Configuration Overview Online Links for Login page
Reporting mechanism using RDLC reports
Login and Signup using Web Form development
Mange the User Access Level and design appropriate
Master page and webpages.
Session Management on multiple forms
8 Dynamically display product catalogue Online link for shopping Cart
Add functionality for Shopping Cart along with Add to
Cart, View cart and delete item Validation for
Required fields and formats. Validation Summary
9 Entity Framework, Code first approach, Add/Update Book 2, Chapter 22
Model classes Pages: 857 to 892
EF Migrations, Retrieve, edit, insert and delete
records.
10 Threading and Synchronization, Book 1, Chapter: 21
Delegates, Lambda Expressions, State Management Section: 21.8, 21.9
Debugging application, Tracing Event Logs, Using the Book 2, Chapter 15,
Boolean Switch and Trace Switch Classes Pages: 566-569
Using Listeners, and Implementing Custom Listeners
11 Model View Controller Chapter29
Designing classes and properties in Model to generate Pages: 1179 to 1204
Database using code first approach
Index, Create, edit, delete and Details Actions
Model binding
12 Collection Framework Book 3, Chapter 7
Use of LINQ to take data from collections and Book 1, Chapter22
populate on Grid or List View. Online Links

13 Load json data from any Web API and use LINQ to Online Links
JSON to read and display on grid. Save the record to Book 2, Chapter: 23
database Table
WCF / Web Service creation, deployment, debugging
and calling at client side
14 Dot net Core, Entity Framework Core, Asp.NET Core Book 2, Chapter: 31, 32, 33
web applications, applications and request life cycle Online Links

Page 3
Week Topic
with MVC and code-first approach
15 ASP.net Core Web APIs and its applicability for cross Book 2, Chapter: 34
platform applications Online Links
Introduction to Graph Query Language and its
applicability
16 Introduction to Micro Service and its application Online Links
scenarios
Introduction Containerization (Docker)

Recommended Textbooks
1. Deitel, Harvey, and Paul Deitel. Visual C# How to Program. Prentice Hall Press, 6th Edition,
(2016)
2. Pro C# 7 With .NET and .NET Core — Eighth Edition — Andrew Troelsen Philip Japikse, 2017.
3. Joseph Albahari, C# 10 in a Nutshell The Definitive Reference. " O'Reilly Media, Inc.", 2022.

Page 4