public bool Delete(int id) { MovieRepository movieRepository = new MovieRepository(); movieRepository.DeleteById(id); return(true); }
private static void ImportTitles(string filepath, MovieRepository repo) { var reader = File.OpenText(filepath + "movie_titles.csv"); repo.DeleteGenres(); //repo.DeleteAll(); var titlesimported = 0; int testlimit = 0; while (!reader.EndOfStream && testlimit < Int32.MaxValue) { string line = reader.ReadLine(); var items = line.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); int year, id; if (Int32.TryParse(items[0], out id) && Int32.TryParse(items[1], out year) && !string.IsNullOrEmpty(items[2])) { Movie m = new Movie() { Id = Int32.Parse(items[0]), Year = Int32.Parse(items[1]), Title = items[2] }; OMDBItem o = repo.GetOMDBData(m.Title); if (o != null && o.imdbID != null) { m.IMDBId = o.imdbID; m.PosterUrl = "http://img.omdbapi.com/?i=" + m.IMDBId + "&h=200&apikey=7e6ca2d5"; repo.DeleteById(m); repo.Add(m); repo.AddGenresForMovie(m.Id, o.Genre); titlesimported++; } testlimit++; } } Console.WriteLine(titlesimported + " titles imported"); }
static void Main(string[] args) { // get the configuration from file var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true); IConfigurationRoot configuration = builder.Build(); // now i can access the connection string like this // this will be null if there isn't an appsettings with this connection string Console.WriteLine(configuration.GetConnectionString("MoviesDB")); // ORM: object-relational mapper // our ORM in .NET is: Entity Framework // we will use database-first approach to EF Console.WriteLine("Hello World!"); // provide the connection string to the dbcontext var optionsBuilder = new DbContextOptionsBuilder <MoviesDBContext>(); optionsBuilder.UseSqlServer(configuration.GetConnectionString("MoviesDB")); var repo = new MovieRepository(new MoviesDBContext(optionsBuilder.Options)); var movies = repo.GetMoviesWithGenres(); foreach (var item in movies) { Console.WriteLine($"Name {item.Name}," + $" genre {item.Genre.Name}"); } //edit a movie var aMovie = movies.First(); aMovie.Name = "A New Hope"; repo.Edit(aMovie); repo.AddMovie("Die Hard", DateTime.Now, "action"); repo.DeleteById(aMovie.Id); repo.SaveChanges(); movies = repo.GetMoviesWithGenres(); Console.WriteLine(); foreach (var item in movies) { Console.WriteLine($"Name {item.Name}," + $" genre {item.Genre.Name}"); } }