Transcript Labadmin Monitoring System - Main | Networked Software

Labadmin Monitoring
System
Final Presentation
Supervisor:
Victor Kulikov
Studnets:
Jameel Shorosh
Malek Zoabi
Outline
Project Goals 
Background & Motivation 
Technology Overview 
Project Design 
Supported Statistics 
Integration with Labadmin 
Summary 
Bibliography 
Project Goals
The main goal is to create a web based 
application which performs various statistics on
Labadmin system.
The statistics application performs statistics
over students, projects and supervisors in all
the laboratories in Labadmin System.
Show the statistics in two different ways,
Graphs and Reports.


cont. Project Goals
Learning and Implementation of Web based 
information system.
The system implementation is based on .NET
technology (ASP.NET), C# programming
language and MS SQL Server (ADO.NET)

Background & Motivation
The Labadmin System is a web application 
for projects registration and managing in the
EE laboratories.
There is a need for Monitoring System for 
Labadmin that gives the ability to view and
save statistical information including
comparison between semesters, supervisors
and laboratories.
Technology Overview
.NET Framework 
Microsoft's programming framework for
developers.

.NET Framework class library provides the
foundation services, including ASP.NET,
ADO.NET, Web Forms (for building GUIs).

Technology Overview cont.
ASP.NET 
A programming framework that runs on a Web
server to dynamically produce and manage Web
Forms pages.
ADO.NET 
provides access to data sources such as
Microsoft SQL Server to retrieve, manipulate and
update data.
Project Design
Presentation Layer in order to
show theN
result
of themodel
– tier
statistics chosen by the user
GUI Layer
Using ADO.NET to access and
retrieve the required data from
the Database Layer
Data Access Layer
The statistics is based on the
data of Labadmin tables
Database Layer
Database Layer
Data Access Layer
Retrieving the data from the DB using ADO.NET 
Work with SqlDataAdapter class to get the data
in the containers DataTable,DataSet…
Work in disconnected mode


Define classes in hierarchal structure (inheritance) in 
order to get the relevant data
Every class is responsible to get some kind of data.

Data Access Layer – Class Diagram
SqlRunner
Base Class for all the
statistics classes. It manages
the connection to the DB and
defines some “select”
methods
runs
in
Base
Classthat
for all
thequires
classes
the DB.
which
perform statistics. It
+select() : object
+select() : DataSet
+select() : DataTable
«extends»
StatisticsHelper
+getLabId() : string
: string
This class is responsible of +getSemesterId()
+getSemestersPerYear() : DataTable
+getSupervisorId() : string
performing various statistics on
+getAllLabNames() : DataTable
+getAllSupervisors() : DataTable
projects.
+getAllSemesters() : DataTable
+getAllYears() : DataTable
«extends»
defines common statistics
This
class is responsible of
methods.
performing various statistics
on students.
«extends»
PerStudentsStatistics
PerProjectsStatistics
+projectsPerLabPerSemester() : int
+projectsPerLabPerYear() : int
+projectsPerLabPerSemesterPerSuperVisor() : int
+projectsPerLabPerSemesterReport() : DataTable
+studentsPerLabPerSemester() : int
+studentsPerLabPerYear() : int
+studentsPerSemester () : int
+studentsPerYear () : int
+studentsPerLabPerSemesterPerSuperVisor() : int
+studentsPerLabPerYearPerSuperVisor() : int
+studentsPerLabPerSemesterReport() : DataTable
+studentsPerSemesterPerSuperVisorReport() : DataTable
+studentsPerYearPerSuperVisorReport() : DataTable
+studentsPerYearReport() : DataTable
GUI Layer
This layer defines the screens that enables 
the user to do some kinds of actions.
kinds of screens: 
Generating graph screen
Generating report screen
Resulted report screen
Resulted graph screen




GUI Layer- Generating graph screen
GUI Layer- Resulted graph screen
GUI Layer- Generating report screen
GUI Layer- Resulted report screen
There is an option to save the resulted report as
Excel, PDF or Doc file in addition to the printing
option.
Supported Statistics
Graph Statistics 
Students 2 Labs per year
Students 2 Labs per Semester
Projects 4 Labs per year
Projects 4 Labs per semester
Students 2 Lab per years
Students 2 Lab per semesters
Projects 2 Lab per years
Projects 2 Lab per semesters
Students per supervisor per semester/s
Students per Supervisor per year/s










Supported Statistics cont.
Report Statistics 
Students per labs per semester
Students per supervisor per semester
Students per supervisor per year
Students per year
Projects per lab per semester





Integration with Labadmin
Labadmin Statistics is embedded with 
Labadmin system as a new tab.
The Statistics web application is implemented 
as a user control in Labadmin system.
The Statistics system layout suits Labadmin 
layout using the same CSS (cascade style
sheet)
Summary
Labadmin statistics system is a user friendly 
application which provides many statistics
options.
User can use it to compare different statistics 
in the same laboratory in different periods.
User can use it to compare different statistics 
between some laboratories or supervisors.
User can save or prints the reports/graphs. 
Summary
What have we learned ? 
Working with .Net Framework
C# Programming language
ADO.NET
ASP.NET
Web Programming
HTML
Working with MS-SQL Server







Bibliography
Web Resourses 
http://google.com
http://www.w3schools.com
http://msdn.microsoft.com
http://www.asp.net
http://www.codeproject.com
Thank you
End