public string Register(string user, string password, string defaultlocation) { int userId; double lat, loong; if (!LocationHelper.IsPostcode(defaultlocation) && !(LocationHelper.IsLatLong(defaultlocation, out lat, out loong))) { return(""); } // check if user already exists using (var db = new whatshotEntities1()) { var userExists = (from User in db.Users where User.UserName == user select User).Any(); if (userExists) { return(""); } var newUser = new User() { UserName = user, HashedPassword = password, DefaultLocation = defaultlocation }; db.Users.Add(newUser); db.SaveChanges(); userId = newUser.Id; } return(_tokenHelper.CreateToken(userId)); }
public string GetUserProfile(string token) { // check if valid token & get user id int userId; if (!_tokenHelper.IsTokenValid(token, out userId)) { return("Invalid token"); } using (var db = new whatshotEntities1()) { var query = from u in db.Users where u.Id == userId select u; var user = query.FirstOrDefault(); if (user == null) { return("No user"); } return(user.DefaultLocation); } }
public string PopulateRandomData() { using (var db = new whatshotEntities1()) { // MakeSomePoints(51.62, -0.3, 0.15, db, 50); //MakeSomePoints(51.46, 0.106, 0.2, db, 50); //MakeSomePoints(51.46, 0.106, 0.4, db, 75); //MakeSomePoints(51.46, 0.106, 0.6, db, 100); //double latitude; //double longitude; //for (var i = 0; i < 50; i++) //{ // var angle = r.NextDouble() * Math.PI * 2; // var distance = r.NextDouble() * 0.2; // latitude = Math.Cos(angle)*distance + 51.46; // longitude = Math.Sin(angle) * distance + 0.106; // var newvote = new Location() // { // Lat = latitude.ToString(), // Long = longitude.ToString(), // TimeAdded = DateTime.Now, // User_Id = -1//userId // }; // db.Locations.Add(newvote); //} db.SaveChanges(); } return("success"); }
public void SetUserProfile(string token, string defaultlocation) { // check if valid token & get user id int userId; if (!_tokenHelper.IsTokenValid(token, out userId)) { return; } // check if default location is a valid location double lat, loong; if (!LocationHelper.IsPostcode(defaultlocation) && !LocationHelper.IsLatLong(defaultlocation, out lat, out loong)) { return; } using (var db = new whatshotEntities1()) { var query = from u in db.Users where u.Id == userId select u; var user = query.FirstOrDefault(); user.DefaultLocation = defaultlocation; db.SaveChanges(); } }
public string PostDestination(string token, string lat, string @long) { // check if valid token & get user id //int userId; //if (!_tokenHelper.IsTokenValid(token, out userId)) return "Invalid token"; double latitude, longitude; if (!LocationHelper.IsLat(lat, out latitude) || !(LocationHelper.IsLong(@long, out longitude))) { return("Invalid lat/long"); } using (var db = new whatshotEntities1()) { var newvote = new Location() { Lat = latitude.ToString(), Long = longitude.ToString(), TimeAdded = DateTime.Now, User_Id = -1//userId }; db.Locations.Add(newvote); db.SaveChanges(); } return("blah"); }
/// <summary> /// delta 1 lat / long is roughly 110km = 110000m. We want roughly 10 meter increments /// </summary> /// <param name="token"></param> /// <param name="lat"></param> /// <param name="long"></param> /// <returns></returns> public HeatmapList GetHeatmapData(string token, string lat, string @long) { //int userId; //if (!_tokenHelper.IsTokenValid(token, out userId)) return dataForUser.ToArray(); double latitude, longitude; if (!LocationHelper.IsLat(lat, out latitude) || !(LocationHelper.IsLong(@long, out longitude))) { return(null); } using (var db = new whatshotEntities1()) { var locations = (from Locations in db.Locations select Locations).ToList(); var list = new HeatmapList { Locations = (from loc in locations.AsParallel() select new HeatmapData() { Latitude = loc.Lat, Longitude = loc.Long, Weight = 1 }).ToArray() }; var num = list.Locations.Count(); foreach (var l in list.Locations.Skip(num - 10)) { l.Weight = 10; } return(list); } }
/// <summary> /// delta 1 lat / long is roughly 110km = 110000m. We want roughly 10 meter increments /// </summary> /// <param name="token"></param> /// <param name="lat"></param> /// <param name="long"></param> /// <returns></returns> public HeatmapList GetHeatmapData(string token, string lat, string @long) { //int userId; //if (!_tokenHelper.IsTokenValid(token, out userId)) return dataForUser.ToArray(); double latitude, longitude; if (!LocationHelper.IsLat(lat, out latitude) || !(LocationHelper.IsLong(@long, out longitude))) return null; using (var db = new whatshotEntities1()) { var locations = (from Locations in db.Locations select Locations).ToList(); var list = new HeatmapList { Locations = (from loc in locations.AsParallel() select new HeatmapData() { Latitude = loc.Lat, Longitude = loc.Long, Weight = 1 }).ToArray() }; var num = list.Locations.Count(); foreach (var l in list.Locations.Skip(num - 10)) l.Weight = 10; return list; } }
public string GetData(string value) { using (var db = new whatshotEntities1()) { var userCount = db.Users.Count(); var newuser = new User() { Id = userCount + 1, UserName = "******", DefaultLocation = "", HashedPassword = "" }; db.Users.Add(newuser); db.SaveChanges(); return "success"; } }
public string Authenticate(string user, string password, string method) { int userId; using (var db = new whatshotEntities1()) { var theuser = (from User in db.Users where User.UserName == user && User.HashedPassword == password select User).FirstOrDefault(); if (theuser == null) return ""; userId = theuser.Id; } return _tokenHelper.CreateToken(userId); }
public string GetData(string value) { using (var db = new whatshotEntities1()) { var userCount = db.Users.Count(); var newuser = new User() { Id = userCount + 1, UserName = "******", DefaultLocation = "", HashedPassword = "" }; db.Users.Add(newuser); db.SaveChanges(); return("success"); } }
public string Authenticate(string user, string password, string method) { int userId; using (var db = new whatshotEntities1()) { var theuser = (from User in db.Users where User.UserName == user && User.HashedPassword == password select User).FirstOrDefault(); if (theuser == null) { return(""); } userId = theuser.Id; } return(_tokenHelper.CreateToken(userId)); }
public string PopulateRandomData() { using (var db = new whatshotEntities1()) { // MakeSomePoints(51.62, -0.3, 0.15, db, 50); //MakeSomePoints(51.46, 0.106, 0.2, db, 50); //MakeSomePoints(51.46, 0.106, 0.4, db, 75); //MakeSomePoints(51.46, 0.106, 0.6, db, 100); //double latitude; //double longitude; //for (var i = 0; i < 50; i++) //{ // var angle = r.NextDouble() * Math.PI * 2; // var distance = r.NextDouble() * 0.2; // latitude = Math.Cos(angle)*distance + 51.46; // longitude = Math.Sin(angle) * distance + 0.106; // var newvote = new Location() // { // Lat = latitude.ToString(), // Long = longitude.ToString(), // TimeAdded = DateTime.Now, // User_Id = -1//userId // }; // db.Locations.Add(newvote); //} db.SaveChanges(); } return "success"; }
private void MakeSomePoints(double latCentre, double lonCentre, double distanceRand, whatshotEntities1 db, int number) { var r = new Random(); double latitude; double longitude; for (var i = 0; i < number; i++) { var angle = r.NextDouble() * Math.PI * 2; var distance = r.NextDouble() * distanceRand; latitude = Math.Cos(angle) * distance + latCentre; longitude = Math.Sin(angle) * distance + lonCentre; var newvote = new Location() { Lat = latitude.ToString(), Long = longitude.ToString(), TimeAdded = DateTime.Now, User_Id = -1,//userId }; db.Locations.Add(newvote); } }
public string PostDestination(string token, string lat, string @long) { // check if valid token & get user id //int userId; //if (!_tokenHelper.IsTokenValid(token, out userId)) return "Invalid token"; double latitude, longitude; if (!LocationHelper.IsLat(lat, out latitude) || !(LocationHelper.IsLong(@long, out longitude))) return "Invalid lat/long"; using (var db = new whatshotEntities1()) { var newvote = new Location() { Lat = latitude.ToString(), Long = longitude.ToString(), TimeAdded = DateTime.Now, User_Id = -1//userId }; db.Locations.Add(newvote); db.SaveChanges(); } return "blah"; }
public string GetUserProfile(string token) { // check if valid token & get user id int userId; if (!_tokenHelper.IsTokenValid(token, out userId)) return "Invalid token"; using (var db = new whatshotEntities1()) { var query = from u in db.Users where u.Id == userId select u; var user = query.FirstOrDefault(); if (user == null) return "No user"; return user.DefaultLocation; } }
public void SetUserProfile(string token, string defaultlocation) { // check if valid token & get user id int userId; if (!_tokenHelper.IsTokenValid(token, out userId)) return; // check if default location is a valid location double lat,loong; if (!LocationHelper.IsPostcode(defaultlocation) && !LocationHelper.IsLatLong(defaultlocation,out lat, out loong)) return; using (var db = new whatshotEntities1()) { var query = from u in db.Users where u.Id == userId select u; var user = query.FirstOrDefault(); user.DefaultLocation = defaultlocation; db.SaveChanges(); } }
public string Register(string user, string password, string defaultlocation) { int userId; double lat, loong; if (!LocationHelper.IsPostcode(defaultlocation) && !(LocationHelper.IsLatLong(defaultlocation,out lat, out loong))) return ""; // check if user already exists using (var db = new whatshotEntities1()) { var userExists = (from User in db.Users where User.UserName == user select User).Any(); if (userExists) return ""; var newUser = new User() { UserName = user, HashedPassword = password, DefaultLocation = defaultlocation }; db.Users.Add(newUser); db.SaveChanges(); userId = newUser.Id; } return _tokenHelper.CreateToken(userId); }