1 / 22

T he Jukebox

T he Jukebox. Orian Paz & Yair Cleper. Instructor: Viktor Kulikov Semester: Spring 2009 Final Presentation. Motivation. Several websites today are developed to let their users listen to the music of their choice from an existing data base.

rduell
Download Presentation

T he Jukebox

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Jukebox Orian Paz & Yair Cleper Instructor: Viktor Kulikov Semester: Spring 2009 Final Presentation

  2. Motivation • Several websites today are developed to let their users listen to the music of their choice from an existing data base. • None of them allow users to broaden the data base by uploading their own audio files. • A combination of these two is needed!

  3. Goals • Building a website in the .Net environment • Building a large database and manage the connections within the web site • Creating a friendly user interface which allows uploading files to the database • Understanding and using the latest technologies of Microsoft

  4. Technologies & Languages • LINQ • AJAX • Java Script • Silverlight • .NET 3.5 Framework • Microsoft Visual Studio 2008 • C# • SQL • ASP.NET

  5. General Requirements • Clients: registration, login, rate songs, hits mode, block songs, report song, upload song, change profile & music genres. • Administrator: view reports, change songs details, change users details, create new administrators, change text in the web site.

  6. Design

  7. N-Tier Gui ASP.NET, Ajax Business Logic C# Data Access LINQ Data Base SQL

  8. Implementation

  9. The Database • SQL • Microsoft SQL server • Tables: • Uniquidentifiers • Use tables that connects two other tables to save space and for flexibility. • Views • Stored Procedures: • Transactions

  10. The Database Tables:

  11. The Database View Example:

  12. Data Access Layer DAL options LINQ to Stored Procedures Data Sets • not automatic, meets the exact applications needs • Automatic Microsoft’s tool • One connection in a session • Open new connection several times in a session • Caching • useful when application saves small amount of data during a session that needs to be updated live • Useful when application saves a lot of data in a session

  13. Data Access Layer • LINQ • Interface • SQL provider • Method overloading

  14. Data Access Layer

  15. Business Logic • C# • Containers of objects: has-a relation • No in heritance needed • Separation of user’s properties and user’s operations.

  16. Business Logic • User’s operations • Authenticate user’s authorization at login • Play next song for user in play mode & hit mode • Get user’s information • Store new information from user

  17. Business Logic

  18. Business Logic

  19. GUI • ASP.NET web forms • Separation of code and aspx files • AJAX • The media player is a Silverlight add-on • JavaScript • Different GUI for administrator and client

  20. Self Achievements During the work on this project we gained a great amount of knowledge: • Design a well-constructed database. • Write SQL queries. • Views. • Write C# code. • Choose the most suitable classes for a specific goal. • Create an ASP.NET web site

  21. Self Achievements • Use LINQ. • AJAX. • JavaScript. • .Net. • Design a web site project using the 3-Tiers architecture. • Separate design and it’s implementation • Gather professional information in the internet. • Team work.

  22. Thank You!

More Related