SoftLab Project Winter 2008 Supervisor : Victor Kulikov Students : Dmitry Kanevsky Nir Lev-Ari

SoftLab Project Winter 2008 Supervisor: Victor Kulikov Students: Dmitry Kanevsky Nir Lev-Ari

Project goals • Design and implement a modern end-to-end Web Project. • Learn C# and the .NET framework. • Get acquainted with the Microsoft Web Development environment: • Visual Studio • ASP.NET • ADO.NET • Ajax • SQL server

Project description • “Collections” website which allows users to create and organize their own privet and public collections. • Registered users can manage and present their collections in galleries. • All users can view public galleries and items of others.

Website functionality • User management - Registering, password changing, “deleting”*, updating, adding/removing friends and permissions*. • Group management - Creating*, deleting*, updating*, adding/removing users (for group messages). • Galleries management - Creating, deleting, updating adding/removing items. • Items management - Creating, deleting, searching, updating rating and adding/removing files. *Administrator

Relationship diagram

3-Layer Design • Reasons for choosing 3-Layer design: • Divide design into layers that have different purposes. • Each layer can be independently maintained and improved, while the connecting interfaces remain unchanged.

3-Layer Design • DataBase: • Consists of the DBMS (SQL Server), the table data and structure. • Responsible for data type validation, relationship validation, etc. • SQL Server

3-Layer Design • Relationship diagram: • SQL Server

3-Layer Design • StoredProcedure: • Interface to the database. • Precompiled  better performance. • Transactions  prevent data corruption. • Return parameters  reduce number of database accesses. • Easy DB access. • SQL Server

3-Layer Design • Data Access Layer: • Abstraction layer between BLL and DB. • Support for multiple DBMSs. • Automated data auditing. • Connection management. • Hiding of connection strings. • ADO.NET

3-Layer Design • Business Logic Layer : • Intermediate layer between DAL and PL. • ASP.NET

3-Layer Design • Presentation Layer: • Ajax Master pages – homogenous look & refresh-less update. • Ajax extensions – dialogs and popup. • User controls – reuse, page replacement. • ASP.NET

Improvements • New media types – we handle only picture types. • Security – add password encryption. • Ajax – file upload, download, popup login… • Item trade – drag & drops Ajax functionality. • Improved Image handling –thumbnail creation. • Email notifications – adding an email authentication. • Cookies – supporting user recognition (preferences). • ASP.NET

Thanks Thanks to softlab staff, Viktor Kulikov and Ilana David - The End -

SoftLab Project Winter 2008 Supervisor : Victor Kulikov Students : Dmitry Kanevsky Nir Lev-Ari