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();
}
