private static void Create(MoviesDbContext db) { System.Console.WriteLine("Escriba el nombre de la película:"); var name = Console.ReadLine(); System.Console.WriteLine("Escriba el año de estreno:"); var year = Console.ReadLine(); var newMovie = new Movie(); newMovie.Name = name; newMovie.Year = int.Parse(year); db.Movies.Add(newMovie); var result = db.SaveChanges(); if (result == 1) { System.Console.WriteLine("La película ha sido guardada exitosamente"); } else { System.Console.WriteLine("Error"); } ShowMenu(db); }
static void Main(string[] args) { var db = new MoviesDbContext(); ShowMenu(db); System.Console.WriteLine("Presione cualquier tecla para salir..."); Console.ReadLine(); }
private static void Show(MoviesDbContext db) { var all = db.Movies.ToListAsync().Result; if (all != null) { foreach (var movie in all) { System.Console.WriteLine(movie.Name); } } ShowMenu(db); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. // public void Configure(IApplicationBuilder app, IHostingEnvironment env, MoviesDbContext moviesDbContext) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } //serves assets from wwwroot folder app.UseStaticFiles(); //Generate data if it doesen't already exist. //moviesDbContext.Database.EnsureDeleted(); app.UseMvc(); }
private static void ShowMenu(MoviesDbContext db) { Console.ForegroundColor = ConsoleColor.Yellow; System.Console.WriteLine(); System.Console.WriteLine("Presione la opción deseada"); System.Console.WriteLine("1.- Consultar las películas"); System.Console.WriteLine("2.- Crear película"); System.Console.WriteLine(); var option = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Gray; if (option == "1") { Show(db); } else { Create(db); } }
public static void Initialize() { Database.SetInitializer(new MigrateDatabaseToLatestVersion <MoviesDbContext, Configuration>()); MoviesDbContext.Create().Database.Initialize(true); }
public static void Config() { Database.SetInitializer(new MigrateDatabaseToLatestVersion <MoviesDbContext, Configuration>()); MoviesDbContext.Create().Database.CreateIfNotExists(); }