private void RefreshPhotos() { if (!SelectedMovieId.HasValue) { return; } var movie = Movies[SelectedMovieId.Value]; var containerName = GetMovieContainerName(movie); AzureContainer azureContainer = new AzureContainer("StorageConnectionString"); var files = azureContainer.GetListFiles(containerName); CheckBoxList1.DataSource = files.Select(f => System.IO.Path.GetFileName(f.OriginalString)).ToList(); CheckBoxList1.DataBind(); }
protected void btnSyncMoviePhotos_OnClick(object sender, EventArgs e) { AzureContainer azureContainer = new AzureContainer("StorageConnectionString"); using (var dataContext = new ProjectManhattanEntities1()) { var movies = dataContext.Movies .Include("MoviePhotoes") .ToList(); bool isNewMoviePhotosAvailable = false; foreach (var movie in movies) { var containerName = GetMovieContainerName(movie); var existingPhotosInDB = new HashSet <string>(movie.MoviePhotoes.Select(m => m.MoviePhotoURL)); foreach (var uri in azureContainer.GetListFiles(containerName)) { var photoURL = uri.OriginalString; if (!existingPhotosInDB.Contains(photoURL)) { //Insert the missing movie photo MoviePhoto moviePhoto = new MoviePhoto() { MovieId = movie.MovieId, MoviePhotoURL = photoURL, }; dataContext.MoviePhotoes.AddObject(moviePhoto); isNewMoviePhotosAvailable = true; } } } if (isNewMoviePhotosAvailable) { dataContext.SaveChanges(); } } }