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.

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

top40's Page

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.