Drink Rating System: Difference between revisions

Content deleted Content added

Inline

Latest revision as of 00:51, 14 May 2013

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

Location Screen

top40 Screen

Place Information Screen

Drinks 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

Location Accuracy Comparison Between GPS and WiFi

GPS connects to satellites orbiting the Earth, and figures out where it is compared to the satellites.
Cell tower triangulation connects to nearby cell towers, and performs a similar calculation.
Wi-Fi positioning depends on companies like Skyhook, who record the locations of Wi-Fi networks.
It is known that smartphones with GPS chips find the most accurate location but it costs lots of energy.
But Wi-Fi certainly works better for indoor location needs such as in a mall, large retail store or educational facilities. As a result, both types of geolocation methods are likely to be used in a hybrid form for some time to come.

References

Team Members

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

@@ Line 1: / Line 1: @@
 ==  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 ==
-== Problems in Today's Rating Systems and Our Solution ==
+* 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.
+[[File:main3.jpg]]
+==== 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.
+[[File:top40.jpg]]
+==== Place Information Page ====
+[[File:barinfo.jpg]]
 === 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 ====
 [[File:login.jpg]]
 ==== Main Screen ====
+[[File:main.jpg]]
 ==== Nearby Screen ====
+[[File:nearby.jpg]]
-==== Profile Screen ====
 ==== Location Screen ====
+[[File:location.jpg]]
 ==== top40 Screen ====
+[[File:topfortys.jpg]]
 ==== Place Information Screen ====
+[[File:placeInformation.jpg]]
 ==== Drinks Screen ====
+[[File:drinks.jpg]]
 === 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 [http://www.winhost.com 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.
+[[File:wcf.jpg]]
+== Database of Drink Rating System ==
+[[File:database.jpg]]
+== Location Accuracy Comparison Between GPS and WiFi  ==
+* GPS connects to satellites orbiting the Earth, and figures out where it is compared to the satellites.
+* Cell tower triangulation connects to nearby cell towers, and performs a similar calculation.
+* Wi-Fi positioning depends on companies like Skyhook, who record the locations of Wi-Fi networks.
+* It is known that smartphones with GPS chips find the most accurate location but it costs lots of energy.
+* But Wi-Fi certainly works better for indoor location needs such as in a mall, large retail store or educational facilities. As a result, both types of geolocation methods are likely to be used in a hybrid form for some time to come.
+== References ==
+*[http://msdn.microsoft.com/en-us/library/gg416515(v=vs.108).aspx ASP.NET MVC 4]
+*[http://api.jquery.com/ jQuery]
+*[http://twitter.github.io/bootstrap/components.html Twitter Bootstrap]
+*[http://lesscss.org/#reference Less]
+*[http://msdn.microsoft.com/en-us/library/ms166026(v=sql.90).aspx SQL Server]
+*[http://afnetworking.github.io/AFNetworking/ AFNetworking]
+*[https://github.com/samvermette/SVGeocoder SVGeocoder]
+*[http://msdn.microsoft.com/en-us/library/aa226793(v=sql.80).aspx Stored Procedure]
+== Team Members ==
+These applications are developed by Ercan Gursoy, Cagdas Cihan and Serkan Hizir as senior project.