public ActionResult venues() { SharpSquare sharpSquare = new SharpSquare(clientId, clientSecret); BancoContext db = new BancoContext(); int lastid = 0; Dictionary<string, string> parametros = new Dictionary<string, string>(); List<Banco.Models.Venue> lisVenue = db.Venues.Where(w => w.updated.Year < 1950).ToList(); foreach (Banco.Models.Venue ven in lisVenue) { try { FourSquare.SharpSquare.Entities.Venue v = new FourSquare.SharpSquare.Entities.Venue(); lastid = ven.Id; v = sharpSquare.GetVenue(ven.SquareId); ven.checkincount = (int)v.stats.checkinsCount; ven.tipcount = (int)v.stats.tipCount; ven.rate = v.rating; if (v.price != null) ven.tier = v.price.tier; ven.likes = (int)v.likes.count; ven.updated = DateTime.Now; db.SaveChanges(); } catch (Exception e) { if (e.Message == "O servidor remoto retornou um erro: (403) Proibido.") { ViewBag.Message = e.Message; break; } } } return View(); }
public ActionResult PreencherUsuarios() { SharpSquare sharpSquare = new SharpSquare(clientId, clientSecret); BancoContext db = new BancoContext(); int lastid = 13027; Dictionary<string, string> parametros = new Dictionary<string, string>(); List<Banco.Models.User> lisUser = db.Users.Where(w => w.Sexo == null && w.Id > lastid).ToList(); foreach (Banco.Models.User usuario in lisUser) { try { FourSquare.SharpSquare.Entities.User us = new FourSquare.SharpSquare.Entities.User(); lastid = usuario.Id; us = sharpSquare.GetUser(usuario.SquareId); usuario.Sexo = us.gender; usuario.countAmigos = (int)us.friends.count; usuario.countCheckin = (int)us.checkins.count; usuario.countTip = (int)us.tips.count; usuario.cidadeNatal = us.homeCity; db.SaveChanges(); } catch (Exception e) { if (e.Message == "O servidor remoto retornou um erro: (403) Proibido.") { break; } } } return View(); }