public async Task UpdateMovieSet(MovieStore.Web.Models.ApplicationDbContext context) { var dataAccess = new OMDBDataAccess(); var data = await dataAccess.GetTop100Movies(); await context.Movies.ForEachAsync(m => { context.Movies.Remove(m); }); context.SaveChanges(); foreach (var movie in data) { context.Movies.Add(movie); context.SaveChanges(); } var updateDate = new MovieUpdateHistory { LastUpdate = DateTime.Now }; var existingDate = context.MovieUpdateHistory.ToList(); if (existingDate.Count < 1) { context.MovieUpdateHistory.Add(updateDate); } else { existingDate[0].LastUpdate = DateTime.Now; context.Entry(existingDate[0]).State = EntityState.Modified; } context.SaveChanges(); }
public HomeController() { _movieAccess = new OMDBDataAccess(); _context = new ApplicationDbContext(); }