private static void ImportVenus(string section, string[] categories, string keyword)
{
using (var dbContext = new DistrictsInTownModelContainer())
{
int chunkSize = 50;
int offset = 0;
ForesquareVenueResult result;
do
{
result = ExploreVenues(offset, chunkSize, "Berlin, DE", section, categories, keyword).Result;
offset += chunkSize;
WriteVenues(result.Venues);
foreach (var venue in result.Venues)
AddVenueToDatabase(dbContext, venue);
try
{
dbContext.SaveChanges();
}
catch (Exception error)
{
}
Console.WriteLine("Total results: {0}", result.TotalResults);
}
while (offset < result.TotalResults);
}
}
/// <summary>
/// Saves <see cref="Place" /> items with new zip codes.
/// </summary>
/// <param name="places">The <see cref="Place" /> items that should be saved.</param>
public void This(IEnumerable<Place> places)
{
using (var container = new DistrictsInTownModelContainer())
{
foreach (var place in places)
{
var placeToUpdate = container.Places.SingleOrDefault(p => p.Source == place.Source);
if (placeToUpdate == null)
{
continue;
}
placeToUpdate.Zip = place.ZipCode;
}
container.SaveChanges();
}
}
public void Save(Dictionary<string, List<News>> news)
{
decimal min = news.Min(n => n.Value.Min(m => m.RawScore));
decimal max = news.Max(n => n.Value.Max(m => m.RawScore));
using (var dbContext = new DistrictsInTownModelContainer())
{
foreach (var district in news)
AddArticlesToDB(dbContext, district, min, max);
try
{
dbContext.SaveChanges();
}
catch (Exception error)
{
Console.WriteLine(error.StackTrace);
}
Console.WriteLine("Total results: {0}", news.Sum(n => n.Value.Count));
}
}
