Transcript VTVS_Presentation

VTVS
On-Line Video Store
Vitaly Panor
Tal Joffe
September, 2009
Project Supervisor: Victor Kulikov
Outline
Project Goals
Introduction
Working environment
Design Approach
Data access Layer
Business Logic Layer
Presentation Layer
Summary
Project Goals
Our project goals were:
Creating an easy to use online video store.
Learning how to design and create a
complete web site from bottom to top
Getting familiar with ASP.NET
environment, C# and SQL code, web
service, paging and working with a
relational database.
Introduction
VTVS - Vitaly and Tal’s Video Store - is an
online streaming video store, where users
are able to purchase movies and watch
them on-line.
Our site, unlike the existing similar sites,
focuses on the inexperienced web surfer.
We provide a very simple easy-to-use
interface without any distractions.
Introduction (cont.)
Various features were implemented, such
as providing detailed information for each
movie, searching a movie by different
parameters, uploading and editing a
movie, registering users and more.
Working environment
Application Tier:
.Net Framework 3.5 (C#)
ASP.NET 3.5
Database Tier:
Microsoft Enterprise SQL server 2005.
Development environment:
Microsoft Visual Studio 2008
Design Approach
Three-Tiers Architecture
•Scalability
•Improved Security
•Robustness
Data Access Layer (DAL)
in this layer information is stored and
retrieved from the database
•Database:
we used a local SQL database created in the
visual studio environment
•DAL
we implemented the DAL as a Web Service that
consists of Strongly Typed Dataset and classes
that uses it.
Database
DAL – DataSet
DAL – Web Service
We implemented the DAL in our project as a Web
Service.
We decided to use it since it meets two important
demands in a simple way.
The demands are that:
•It implements the singleton pattern
•It allows the DAL to be completely separated
from the rest of the implementation
DAL – Web Service (cont.)
The alternative of using the Web Service was
creating our own singleton class that will
implement the same methods.
DAL – Web Service (cont.)
In the Web Service Implementation we created
several classes on top of the main class – Service –
that use the DataSet to access the database each
Class access the appropriate table adaptor methods.
DAL – Web Service (cont.)
Business Logic Layer (BLL)
this layer contains the logic of the web application, i.e. command processing,
logical decisions and calculation. the BLL also moves data between the DAL
and the Presentation Layer
Presentation Layer
this layer represents the user interface (UI). Meaning it translates tasks and
results to something the user can understand
Site map
MainForm
NewUserForm
BuyerViewForm
PurchaseCreditForm
LoginForm
AdminViewForm
PlayMovieForm
SearchResultsForm
ModeratorViewForm
EditMovieForm
DisplayMovieForm
UploaderViewForm
About
ContactUs
What we had learned
In our project we had learned how to:
•Design and create a relational database.
•Write SQL queries.
•Write C# code.
•Use ADO.NET objects to access the data in the database.
•Create an ASP.NET Web Service and consume it.
•Create an ASP.NET web site
•Create and Design web forms and master page using
HTML and CSS code along with the visual studio designer.
•Design a web site project using the 3-Tiers approach and
implementing it using all of the above.
What we would have done
differently
• Improving the code design - abstraction, encapsulation,
modularity, design patterns….
• Improving the UI - countless researches have been made
on the subject. We have only covered a small fraction.
•Efficiency – there is always room for improvements. Both
DAL and BLL can be made more efficient.
Thank You!