Drink Rating System

Introduction

A website where users can go and rate different drinks, cocktails and shots in local bars, nightclubs and restaurants.

• To give users an idea about what they should drink in these specific places.
• A membership system so users can have a basic profile page.
• There will be both user and restaurant memberships and people can see what the other people or their friends rated or recommended.
• Give users an idea about the users that share the same opinion with them.

Even though we don't want to fully concentrate on social networking, users will still have a chance to discuss and communicate.

For example if a tourist comes to Binghamton and wants to have a specific beverage, he or she can go online and check which place have the best beverage that the tourist wants to drink in Binghamton area.

Purpose of This Project

• Checking the ratings of local bars & nightclubs or rate them yourself.
• Writing comments about local bars & nightclubs or read what other people thinks about them.
• Checking the rating of a shot or cocktail in a specific bar or nightclub or rate it yourself.
• Checking in which bar or nightclub you should drink your favorite shot or cocktail or which shot or cocktail you should try in a specific bar or nightclub.
• Creating a profile page where you can list your favorite bars or drinks.
• Following profiles of other users', especially who have same taste as you do.

Features of the Project

• Google maps integration with the addresses of clubs, bars, restaurants etc.
• Profile page for both users and places with many features.
• Profile settings page for both users and places.
• Easy access to each link with search shortcut.
• Users can write a comment under the main pages of bars.
• Easy rating system at the main page of bars.
• Easy access to best bars with the Top 40s page.
• News feed

Technical Details

Drink Rating System can be defined in 3 different parts.

• Web Application: ASP.NET MVC 4(C#), jQuery, Twitter Bootstrap, Less, WCF Web Service( MSSQL Server Express Edition )
• iPhone Application : iOS6 Tabbed View Application (Objective-C), AFNetworking, SVGeocoder,MBProgressHUD, WCF Web Service( MSSQL Server Express Edition )
• Web Service : Written in C#, JSON as response, Stored Procedures for connections.

Web Application

In our Web Application, our focus point is creating a simple and user-friendly environment for the users. The purpose of the web application is simple, showing the nearby places to the users when they login to our website. The users have a chance to change the location, search for places, check the top places in United States, rate the places, rate the drinks and read the comments.

• For the web part of Drink Rating System we are using a powerful framework created by Microsoft called as MVC 4 framework. It is a model view controller framework which creates a powerful environment to work on.
• For retrieving data to our application from our Web Service, we are using jQuery ( which is a light-weight framework for this purposes ) to get the JSON response and use it in our application.
• For the design issues, we used Twitter Bootstrap components and also used Less for editing CSS of Twitter Bootstrap framework.
• For getting the location, we are using Google's Map Services.

Main Page

This is the screen that user faces when he or she enters his credentials and logs in. On the right side there is a map and a textbox. When user enters zip code of the area where he or she lives in, the user can see trending bars and clubs near to him or her on this page. 4 spots are shown in every row. When you click on one of the bars’ name, user will be directed to profile page of that bar.

top40's Page

This the page that users can see the most popular 40 cocktails, shots and bars which are chosen by the votes of all users.

Place Information Page

iPhone Application

Just like our Web Application, in our iPhone Application you can do everything which are possible in our Web Application. The power of our Web Service provides us this functionality to use the data in any platform we want.

• For the development of iPhone Application, we are using Xcode as our IDE.
• The iPhone Application requires at least iOS6 to run.
• Tabbed View Controller and Navigation View Controllers are used together to provide an user-friendly experience to our users.
• To consume our Web Service, we are using AFNetworking framework to deserialize JSON response.
• For Location Services, we are using SVGeocoder to provide accurate location.

Login Screen

Main Screen

Nearby Screen

Place Information Screen

Web Service (WCF)

Our Web Service is the heart of our project. Since we are dealing with database and lots of data, we were in need of a Web Service. For this reason we created our WCF RestFul API to provide reliable data to our Applications. Our Web Service is using Stored Procedures to connect to the database and retrieve the related information. Our Web Service is a JSON based Web Service and handles the critical processes like authenticating the user, posting comments, retrieving the list of the places and many others(nearly 15). Our Web Service is hosted under WinHost. We bought this hosting service to provide information to our Web and iPhone Applications.

• An example of the JSON data can be seen below.

Database of Drink Rating System

References

• ASP.NET MVC 4
• jQuery
• Twitter Bootstrap
• Less
• SQL Server
• AFNetworking
• SVGeocoder
• Stored Procedure

Team Members

These applications are developed by Ercan Gursoy, Cagdas Cihan and Serkan Hizir as senior project.