/collegeCompanionApp/collegeCompanionApp/Controllers/HomeController.cs

using collegeCompanionApp.Models;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;
using System.Web.Script.Serialization;
using collegeCompanionApp.Models.ViewModel;
using System.Diagnostics;
using Newtonsoft.Json.Linq;
using System.Xml;
using System.Data.Linq;
using System.Text;
using collegeCompanionApp.Repository;
using Ninject;
using Geocoding;
using System.Web.UI.WebControls;
using Microsoft.AspNet.Identity;
using System.Web.Http;
using System.Web.Http.Description;
using System.Windows.Forms;
using System.Web.UI;

namespace collegeCompanionApp.Controllers
{
    public class HomeController : Controller
    {
        //Global Parameters
        string schoolName = "";
        string state = "";
        string city = "";
        string accreditor = "";
        string ownership = "";
        string finLimit = "";
        string acceptRate = "";
        string degree = "";
        string degreeType = "";
        string isSaved = "";
        int collegeCount = 0;
        //private Page page;


        //Adding in the repository pattern connection
        private readonly ICollegeRepository _repository;

        public HomeController(ICollegeRepository repo)
        {
            _repository = repo;
        }

        //An empty controller so the site will work when not passing in the repository.
        public HomeController(){}

        /// <summary>
        /// Home page of the website. Enables search via javascript: FormSearch.js. 
        /// Also connects to DegreeQuiz via quizForm.js
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult Index()
        {
            return View();
        }

        /// <summary>
        /// DegreeQuiz page of the website. Functionality via quizForm.js
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult DegreeQuiz()
        {
            return View();
        }

        /// <summary>
        /// Error page of the website. 
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult Error()
        {
            return View();
        }

        /// <summary>
        /// Travel page of the website. Enables WalkScore via TravelSearch.js.
        /// Also connects to map via googleSearch.js.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult Travel()
        {
            var userName = User.Identity.Name;
            var userId = User.Identity.GetUserId();
            if (userId == null)
            {
                return RedirectToAction("Login", "Account");
            }
            else
            {
                return View(_repository.GetSavedColleges(userName));
            }
        }

        /// <summary>
        /// SearchesMenu page of the website. Enables an accordion via accordion.js.
        /// Connects to other pages: Travel, Demographic & Yelp.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult SearchesMenu()
        {
            return View();
        }

        /// <summary>
        /// About page of the website. 
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult About()
        {
            return View();
        }

        /// <summary>
        /// Contact page of the website.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult Contact()
        {
            return View();
        }

        /// <summary>
        /// DELETE: api/SearchResults/5
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        [ResponseType(typeof(SearchResult))]
        public ActionResult Delete(int id)
        {
            if (User.Identity.IsAuthenticated)
            {
                SearchResult searchResult = _repository.FindCollege(id);
                if (searchResult == null)
                {
                    Debug.WriteLine("Error for Delete() method.");
                    return RedirectToAction("SaveDataList", "Home");
                }

                _repository.DeleteCollege(searchResult);
                _repository.SaveCollege(searchResult);

                return RedirectToAction("SaveDataList", "Home");
            } else
            {
                return RedirectToAction("Login", "Account");
            }
        }

        /// <summary>
        /// SaveDataList page of the website, it presents the list of saved colleges
        /// for a given user.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult SaveDataList()
        {
            if (User.Identity.IsAuthenticated)
            {
                Debug.WriteLine("SaveDataList() Method!");

                if (ModelState.IsValid)
                {
                    return View(_repository.GetSavedColleges(User.Identity.Name));
                }
                else
                {
                    Debug.WriteLine("Error for SaveDataList() method.");
                    return View();
                }
            }
            else
            {
                return RedirectToAction("Login", "Account");
            }

        }
		
		
		//****************************************************WalkScore*******************************************************//
        /// <summary>
        /// Searches for ratings of Walking, Transit & Bike for a given city using Walk Score API.
        /// </summary>
        /// <returns>
        /// A "Content" result of JSON String with ratings within the requested city.
        /// </returns>
        public ActionResult WalkScoreSearch()
        {
            //Get user input data from Javascript file "TravelSearch.js"
            var street = Request.QueryString["addressInput"];
            var city = Request.QueryString["cityInput"];
            var state = Request.QueryString["stateInput"];
            var zipcode = Request.QueryString["zipInput"];
            var lat = Request.QueryString["latitude"];
            var lon = Request.QueryString["longitude"];
            var location = street + city + state + zipcode;

            location = location.Replace(" ", "%20");

            //User Stringbuilder to make a URL for the request.
            StringBuilder sb = new StringBuilder();
            sb.Append("http://api.walkscore.com/score?format=json&");
            sb.Append("&address=" + location);
            sb.Append("&lon=" + lon);
            sb.Append("&lat=" + lat);
            sb.Append("&transit=1&bike=1");
            sb.Append("&wsapikey=");
            sb.Append(System.Web.Configuration.WebConfigurationManager.AppSettings["WalkScoreAPIKey"]);
            Debug.WriteLine(sb.ToString());

            // Make a web request to get the list of classes.
            WebRequest request = HttpWebRequest.Create(sb.ToString()); //Takes an arguement of the URL of the webserver being targeted.
            // Using a web response process the file returned from the API.
            WebResponse response = request.GetResponse();

            string resultString;
            using (var reader = new StreamReader(response.GetResponseStream()))
            {
                // Get the data from the stream reader to parse data into usable format
                resultString = reader.ReadToEnd();
            }
            //Note: This is completed without a JSON parse action so don't treat it like the other methods! lol
            return Content(resultString, "application/json");
        }


        //****************************************************College Search*******************************************************//

        /// <summary>
        /// SearchForm page of the website. This page presents multiple input/selector fields the user
        /// can alter to get back a college search result on the SearchResults.cshtml page.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult SearchForm()
        {
            return View(_repository.GetFormData());
        }

        /// <summary>
        /// SearchResults page of the website. This page takes the results of the API call and presents
        /// them in a pleasing format via the SearchResults.js file.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult SearchResults()
        {            
            return View(_repository.GetAllUsers());
        }

        /// <summary>
        /// Searches for Colleges via an API call.
        /// </summary>
        /// <returns>
        /// A JSON result of colleges within the requested confines.
        /// </returns>
        public JsonResult Search()
        {
            Debug.WriteLine("SearchForm() Method!");

            //Get Data from Current URL
            schoolName = Request.QueryString["school.name"];
            state = Request.QueryString["school.state"];
            city = Request.QueryString["school.city"];
            accreditor = Request.QueryString["school.accreditor"];
            ownership = Request.QueryString["school.ownership"];
            finLimit = Request.QueryString["school.tuition"];
            acceptRate = Request.QueryString["school.admission_rate"];
            degree = Request.QueryString["school.degree"];
            degreeType = Request.QueryString["school.degreeType"];

            // build a WebRequest
            WebRequest request = WebRequest.Create(CreateURL(schoolName, state, city, accreditor, ownership, finLimit, acceptRate, degree, degreeType));
            WebResponse response = request.GetResponse();
            Stream dataStream = response.GetResponseStream();
            StreamReader reader = new StreamReader(response.GetResponseStream());

            // Read the content.  
            string responseFromServer = reader.ReadToEnd();

            // Clean up the streams and the response.  
            reader.Close();
            response.Close();

            // Create a JObject, using Newtonsoft NuGet package
            JObject json = JObject.Parse(responseFromServer);

            // Create a serializer to deserialize the string response (string in JSON format)
            JavaScriptSerializer serializer = new JavaScriptSerializer();

            // Store JSON results in results to be passed back to client (javascript)
            var data = serializer.DeserializeObject(responseFromServer);

            //saveData(schoolName, state, city, accreditor, ownership, finLimit);

            //return CollegeSearch(college);
            return Json(data, JsonRequestBehavior.AllowGet);
        }

        /// <summary>
        /// Saves selected data into the College Database
        /// If the college already exists it throws a pop up error to the user.
        /// </summary>
        public ActionResult SaveData()
        {
            int userID = Int32.Parse(Request.QueryString["UserID"]);
            string name = Request.QueryString["Name"];
            string stateName = Request.QueryString["StateName"];
            string city = Request.QueryString["City"];
            int zipCode = Int32.Parse(Request.QueryString["ZipCode"]);
            string accreditor = Request.QueryString["Accreditor"];
            string degree = Request.QueryString["Degree"];
            string degreeType = Request.QueryString["DegreeType"];
            int ownership = Int32.Parse(Request.QueryString["Ownership"]);
            int cost;

            int.TryParse(Request.QueryString["Cost"], out cost);

            if (_repository.GetCollege(name, userID) == 0) { 
                SearchResult college = new SearchResult {
                                                            CompanionID = userID,
                                                            Name = name,
                                                            StateName = stateName,
                                                            City = city,
                                                            ZipCode = zipCode,
                                                            Accreditor = accreditor,
                                                            Degree = degree,
                                                            DegreeType = degreeType,
                                                            Ownership = ownership,
                                                            Cost = cost
                };

                if (User.Identity.IsAuthenticated)
                {
                    Debug.WriteLine("saveData() Method!");

                    if (ModelState.IsValid)
                    {

                        collegeCount = _repository.GetSavedColleges(User.Identity.Name).Count();

                        _repository.AddCollege(college);

                        _repository.SaveCollege(college);

                        isSaved = "Not Saved";

                        return RedirectToAction("SaveDataList", "Home");
                    }
                    else
                    {
                        Debug.WriteLine("Error for SaveData() method.");
                        return View();
                    }
                }
                else
                {
                    return RedirectToAction("Login","Account");
                }
            }
            else
            {
                isSaved = "Saved";
                return RedirectToAction("SaveDataList", "Home");
                
            }
        }



        /// <summary>
        /// Creats a URL for the API search based on User Input.
        /// </summary>
        /// <param name="acceptRate">The acceptance rate of the college.</param>
        /// <param name="cityName">The city the college is located in.</param>
        /// <param name="degree">The degree selected by the user.</param>
        /// <param name="accreditor">The accreditory for the school.</param>
        /// <param name="degreeType">The type of degree selected by the user.</param>
        /// <param name="finLimit">The finanicial limit selected by the user.</param>
        /// <param name="ownership">The ownership status of the school: Public, Private For Profit, Private NonProfit.</param>
        /// <param name="schoolName">The school's name.</param>
        /// <param name="stateName">The school's state of location.</param>
        /// <returns>
        /// A URL string.
        /// </returns>
        public string CreateURL(string schoolName, string stateName, string cityName, string accreditor, string ownership, string finLimit, string acceptRate, string degree, string degreeType)
        {
            Debug.WriteLine("createURL() Method!");

            var source = "https://api.data.gov/ed/collegescorecard/v1/schools?"; // Source, Endpoint
            var APIKey = "&api_key=" + System.Web.Configuration.WebConfigurationManager.AppSettings["CollegeScoreCardAPIKey"]; // CollegeScoreCard API Key
            var fields = SetCollegeFields(); // Set Fields
            var values = SetCollegeValues(ownership, acceptRate, finLimit); // Set Values, Parameters

            // Checks for Empty Values
            // If not empty, add to parameters
            if (schoolName != "")
            {
                values = values + "&school.name=" + schoolName;
            }
            if (stateName != "")
            {
                values = values + "&school.state=" + stateName;
            }
            if (cityName != "")
            {
                values = values + "&school.city=" + cityName;
            }
            if (cityName != "")
            {
                values = values + "&school.city=" + cityName;
            }
            if (accreditor != "")
            {
                values = values + "&school.accreditor=" + accreditor;
            }
            if (degree != "" && degree != "Any")
            {
                string theDegree = SetDegree(degreeType, degree); // Set up Degree value
                values = values + AddDegreeValue(theDegree); // Add Degree to Parameters
                fields = fields + AddDegreeField(theDegree); // Add Degree to Fields
            }

            //Set up GET URL to College Scorecard
            string url = source + values + APIKey + fields;
            //Replace spaces with %20 
            url = url.Trim();
            url = url.Replace(" ", "%20");
            Debug.WriteLine("URL: " + url);

            return url;
        }

        /// <summary>
        /// A method to ensure colelge fields are set up correctly in the URL string.
        /// </summary>
        /// <returns>
        /// A string of fields for the URL call.
        /// </returns>
        public string SetCollegeFields()
        {
            // Default Fields to get
            return "&_fields=school.name,school.state,school.city,school.accreditor,school.ownership,school.tuition_revenue_per_fte,2015.admissions.admission_rate.overall,school.school_url,school.zip&_per_page=100";
        }

        /// <summary>
        /// A method to set selected fields to the entered values of the user.
        /// </summary>
        /// <param name="acceptRate">The selected acceptance rate.</param>
        /// <param name="finLimit">The selected financial limit.</param>
        /// <param name="ownership">The selected ownership.</param>
        /// <returns>
        /// A string for the URL call.
        /// </returns>
        public string SetCollegeValues(string ownership, string acceptRate, string finLimit)
        {
            string collegeValues = "school.ownership=" + ownership + "&2015.admissions.admission_rate.overall__range=" + acceptRate
                + "&school.tuition_revenue_per_fte__range=" + finLimit + "&_sort=school.tuition_revenue_per_fte:desc"; // Default Parameters
            return collegeValues;
        }

        /// <summary>
        /// A method to append the degree type to the degree category in the format the API desires.
        /// </summary>
        /// <param name="theDegree">The degree category.</param>
        /// <returns>
        /// A string for the URL call.
        /// </returns>
        public string AddDegreeField(string theDegree)
        {
            string field = "," + theDegree; // Add Degree to fields
            return field;
        }

        /// <summary>
        /// A method to add a range to the degree is necessary.
        /// </summary>
        /// <param name="theDegree">Gets the selected type to append the data around.</param>
        /// <returns>
        /// A string for the URL call.
        /// </returns>
        public string AddDegreeValue(string theDegree)
        {
            string val = "&" + theDegree + "__range=1.."; // Add Degree to parameters
            return val;
        }

        /// <summary>
        /// A method to set up the degree string to set it.
        /// </summary>
        /// <param name="degree">The degree field.</param>
        /// <param name="degreeType">The degree type.</param>
        /// <returns>
        /// A string for the URL call.
        /// </returns>
        public string SetDegree(string degreeType, string degree)
        {
            string aDegree = "2015.academics.program." + degreeType + "." + degree; // Degree to Search
            return aDegree;
        }


        //****************************************************Yelp*******************************************************//

        /// <summary>
        /// Yelp page for the website.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult Yelp()
        {
            var userName = User.Identity.Name;
            var userId = User.Identity.GetUserId();
            if (userId == null)
            {
                return RedirectToAction("Login", "Account");
            }
            else
            {
                return View(_repository.GetSavedColleges(userName));
            }
        }

        /// <summary>
        /// A search method for the Yelp API call. This runs via the YelpSearch.js.
        /// </summary>
        /// <returns>
        /// A JSON result for the API call.
        /// </returns>
        public JsonResult YelpSearch()
        {
            Debug.WriteLine("YelpSearch() Method!");

            //Get Yelp API Key
            string YelpAPIKey = System.Web.Configuration.WebConfigurationManager.AppSettings["YelpAPIKey"];
            YelpAPIKey = IsAPIKey(YelpAPIKey);
            //Get Location
            string location = GetLocation(Request.QueryString["location"]);
            //Get Term
            string term = GetTerm(Request.QueryString["term"]);
            //Get IsOpen
            string isOpen = Request.QueryString["isOpen"];
            //Set Parameters
            string param = SetParam(location, term, isOpen);
            //URL Endpoint
            var url = SetURL(param);

            //URL GET Request
            Debug.WriteLine("URL: " + url);

            // build a WebRequest
            WebRequest request = WebRequest.Create(url);
            request.Headers.Add("Authorization", "Bearer " + YelpAPIKey);
            WebResponse response = request.GetResponse();
            Stream dataStream = response.GetResponseStream();
            StreamReader reader = new StreamReader(response.GetResponseStream());

            // Read the content.  
            string responseFromServer = reader.ReadToEnd();

            // Clean up the streams and the response.  
            reader.Close();
            response.Close();

            // Create a JObject, using Newtonsoft NuGet package
            JObject json = JObject.Parse(responseFromServer);

            // Create a serializer to deserialize the string response (string in JSON format)
            JavaScriptSerializer serializer = new JavaScriptSerializer();

            // Store JSON results in results to be passed back to client (javascript)
            var data = serializer.DeserializeObject(responseFromServer);

            return Json(data, JsonRequestBehavior.AllowGet);
        }


        /// <summary>
        /// A simple method to test if something is an API key or not.
        /// </summary>
        /// <param name="key">The API key being tested.</param>
        /// <returns>
        /// The API key if successful, or "NoKey" if not.
        /// </returns>
        public string IsAPIKey(string key)
        {
            if (key.Length <= 5)
            {
                key = "NoKey";
            }
            return key;
        }

        /// <summary>
        /// A simple method to test if a location if being populated or not.
        /// </summary>
        /// <param name="location">The location being tested.</param>
        /// <returns>
        /// The location if it is not null, otherwise it throws a debug statement that it is null.
        /// </returns>
        public string GetLocation(string location)
        {
            if (location == null)
            {
                Debug.WriteLine("No Location");
            }
            return location;
        }

        /// <summary>
        /// A method to set null term strings to empty strings to avoid errors with the API.
        /// </summary>
        /// <param name="term">The term being tested/converted.</param>
        /// <returns>
        /// An empty string if the term was null.
        /// </returns>
        public string GetTerm(string term)
        {
            if (term == null)
            {
                term = "";
            }
            return term;
        }

        /// <summary>
        /// A method to create a parameter string for the geolocation.
        /// </summary>
        /// <param name="location">The location field.</param>
        /// <param name="term">The term field.</param>
        /// <returns>
        /// The resulting string for the URL.
        /// </returns>
        public string SetParam(string location, string term, string isOpen)
        {
            var param = "term=" + term + "&location=" + location + "&limit=12&sort_by=distance&open_now=";

            if(isOpen == "Open")
            {
                param = param + "true";
            }
            else
            {
                param = param + "false";
            }

            return param;
        }

        /// <summary>
        /// A simple method to set the URL for the yelp search.
        /// </summary>
        /// <param name="param">A parameter upon which the search is run.</param>
        /// <returns>
        /// The resulting parameter URL string.
        /// </returns>
        public string SetURL(string param)
        {
            return "https://api.yelp.com/v3/businesses/search?" + param;
        }

        

        //****************************************************Demographic*******************************************************//

        /// <summary>
        /// The demographic search page. Runs with the DemographicSearch.js.
        /// </summary>
        /// <returns>
        /// A view.
        /// </returns>
        public ActionResult Demographic()
        {
            var userName = User.Identity.Name;
            var userId = User.Identity.GetUserId();
            if (userId == null)
            {
                return RedirectToAction("Login", "Account");
            }
            else
            {
                FormdataDB fd = new FormdataDB();
                LifeStyle lifeStyle = _repository.GetLifeStyleVM();
                lifeStyle.SearchResults = _repository.GetSavedColleges(userName);
                lifeStyle.DemoAges = _repository.GetFormData().DemoAges;
                lifeStyle.DemoRaces = _repository.GetFormData().DemoRaces;
                return View(lifeStyle);
            }
        }

        /// <summary>
        /// The DemographicSearch method to run the API call to Demographics Inquiry.
        /// </summary>
        /// <returns>
        /// A JSON result for the API call.
        /// </returns>
        public JsonResult DemographicSearch()
        {
            Debug.WriteLine("DemographicSearch() Method!");

            //Get Demographic API Key
            string DemoAPIKey = System.Web.Configuration.WebConfigurationManager.AppSettings["DemographicAPIKey"];
            //Gets the latitude & longitude
            string coordinates = GetCoordinates(Request.QueryString["latitude"], Request.QueryString["longitude"]);
            //Set parameters with coordinates & variables
            string param = SetDemoParams(coordinates, Request.QueryString["variables"]);// + "/" + variables);
            //Endpoint Description Link: https://market.mashape.com/mapfruition/demographicinquiry#inquire-by-point
            //Set up url endpoint with parameters
            var url = SetDemoURL(param);

            //URL GET Request
            Debug.WriteLine("JSon URL Call: " + url);

            // build a WebRequest
            WebRequest request = WebRequest.Create(url);
            //Add Header with API Key
            request.Headers.Add("X-Mashape-Key", DemoAPIKey);
            WebResponse response = request.GetResponse();
            Stream dataStream = response.GetResponseStream();
            StreamReader reader = new StreamReader(response.GetResponseStream());

            // Read the content.  
            string responseFromServer = reader.ReadToEnd();

            // Clean up the streams and the response.  
            reader.Close();
            response.Close();

            // Create a JObject, using Newtonsoft NuGet package
            JObject json = JObject.Parse(responseFromServer);

            // Create a serializer to deserialize the string response (string in JSON format)
            JavaScriptSerializer serializer = new JavaScriptSerializer();

            // Store JSON results in results to be passed back to client (javascript)
            var data = serializer.DeserializeObject(responseFromServer);

            return Json(data, JsonRequestBehavior.AllowGet);
        }


        /// <summary>
        /// A method to set up the URL starting parameters being serarched on.
        /// </summary>
        /// <param name="param">The parameter being appended by the user.</param>
        /// <returns>
        /// A string for the URL.
        /// </returns>
        public string SetDemoURL(string param)
        {
            string url = "https://mapfruition-demoinquiry.p.mashape.com/inquirebypoint/" + param;

            return url;
        }

        /// <summary>
        /// A method to put a slash between the coordinates and the variables.
        /// </summary>
        /// <param name="coordinates">The coordinates provided.</param>
        /// <param name="variables">The variables selected.</param>
        /// <returns>
        /// A string for the URL call.
        /// </returns>
        public string SetDemoParams(string coordinates, string variables)
        {
            string param = coordinates + "/" + variables;

            return param;
        }

        /// <summary>
        /// A method to get coordinates based on a latitude and longitude.
        /// </summary>
        /// <param name="lat">The Latitutde</param>
        /// <param name="lon">The Longitude</param>
        /// <returns>
        /// A string for the URL.
        /// </returns>
        public string GetCoordinates(string lat, string lon)
        {
            string cord = lat + "," + lon;

            return cord;
        }
    }
}