Example #1
0
        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();
        }
Example #2
0
 public HomeController()
 {
     _movieAccess = new OMDBDataAccess();
     _context     = new ApplicationDbContext();
 }