public ActionResult Create([Bind(Include = "ID,Title,ReleaseDate,Genre,Price,Rating")] Movie movie) { if (ModelState.IsValid) { db.Movies.Add(movie); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(movie)); }
/// <summary> /// Insert a new movie into Database /// </summary> /// <param name="movie">movie details</param> /// <returns>inserted status</returns> public int AddMovie(Movie movie) { try { _dbContext.Movies.Add(movie); var saveChangesStateValue = _dbContext.SaveChanges(); return(saveChangesStateValue); } catch (Exception) { return(0); } }
public string Execute(IList <string> parameters) { var username = parameters[0]; var password = parameters[1]; var firstName = parameters[2]; var lastName = parameters[3]; var newUser = new User(); newUser.Username = username; newUser.Password = password; newUser.FirstName = firstName; newUser.LastName = lastName; newUser.Authorization = Authorization.NormalUser; var account = AccountCreator.CreateAccount(newUser); newUser.Account = account; this.dbContext.Users.Add(newUser); dbContext.SaveChanges(); this.authProvider.CurrentUsername = newUser.Username; return($"{newUser.Username} has successfully registered! You are now logged in.\n100 have been added to your account.\n Type a command or 'help logged user' for help to see your options."); }
public string Execute(IList <string> parameters) { var amount = int.Parse(parameters[0]); var usernameToRecharge = parameters[1]; var user = this.dbContext.Users .Where(x => x.FirstName == usernameToRecharge) .First(); user.Account.Ammount += amount; dbContext.SaveChanges(); return($"{usernameToRecharge}'s account has been recharged with {amount}!"); }
public string Execute(IList <string> parameters) { var awardName = parameters[0]; var award = new Award { Name = awardName }; dbContext.Awards.AddOrUpdate(a => a.Name, award); dbContext.SaveChanges(); return($"{award.Name} has been successfully added!"); }
public string Execute(IList <string> parameters) { var movieName = parameters[0]; var rating = float.Parse(parameters[1]); var publishDate = DateTime.Parse(parameters[2], new CultureInfo("en-CA")); var length = int.Parse(parameters[3]); var directorToAdd = utils.FindCurrentArtist(parameters[4], Profession.Director); var countryToAdd = utils.FindCurrentCountry(parameters[5]); var genreToAdd = utils.FindCurrentGenre(parameters[6]); var movie = new Movie { Name = movieName, Rating = rating, PublishDate = publishDate, Length = length, Director = directorToAdd, Coutry = countryToAdd, Genre = genreToAdd }; while (true) { this.writer.WriteLine("Enter actor (or type end to terminate) : "); var input = this.reader.Read(); if (input.ToLower() == "end") { break; } else if (string.IsNullOrEmpty(input)) { this.writer.WriteLine("Enter an actor or terminate process"); } var actorToAdd = utils.FindCurrentArtist(input, Profession.Actor); movie.Actors.Add(actorToAdd); } dbContext.Movies.AddOrUpdate(m => m.Name, movie); dbContext.SaveChanges(); return($"{movie.Name} has been successfully created!"); }
public DatabaseFixture() { var options = new DbContextOptionsBuilder <MovieDbContext>().UseInMemoryDatabase(databaseName: "MovieCruiser").Options; dbContext = new MovieDbContext(options); // Mock data dbContext.MovieList.Add(new MovieList { Id = 10, Title = "Kaala", Comments = "Good" }); dbContext.MovieList.Add(new MovieList { Id = 11, Title = "Jurasic Word", Comments = "Better" }); dbContext.MovieList.Add(new MovieList { Id = 12, Title = "2.0", Comments = "Best" }); dbContext.SaveChanges(); }
public string Execute(IList <string> parameters) { var firstName = parameters[0]; var lastName = parameters[1]; var dateOfBirth = DateTime.Parse(parameters[2], new CultureInfo("en-CA")); var profession = (Profession)Enum.Parse(typeof(Profession), parameters[3]); var country = this.utils.FindCurrentCountry(parameters[4]); var artistToUpdate = dbContext.Artists .Where(n => n.FirstName == firstName && n.LastName == lastName) .First(); artistToUpdate.DateOfBirth = dateOfBirth; artistToUpdate.Profession = profession; artistToUpdate.Country = country; dbContext.SaveChanges(); return($"{artistToUpdate.FirstName} {artistToUpdate.LastName}'s info has been successfully updated!"); }
public string Execute(IList <string> parameters) { var artistFirstName = parameters[0]; var artistLastName = parameters[1]; var dateOfBirth = DateTime.Parse(parameters[2], new CultureInfo("en-CA")); var profession = (Profession)Enum.Parse(typeof(Profession), parameters[3]); var countryToAdd = utils.FindCurrentCountry(parameters[4]); var artist = new Artist { FirstName = artistFirstName, LastName = artistLastName, DateOfBirth = dateOfBirth, Profession = profession, Country = countryToAdd, }; dbContext.Artists.Add(artist); dbContext.SaveChanges(); return($"{artist.FirstName} {artist.LastName} has been successfully added!"); }
public DatabaseFixture() { var options = new DbContextOptionsBuilder <MovieDbContext>() .UseInMemoryDatabase(databaseName: "MovieDB") .Options; dbcontext = new MovieDbContext(options); dbcontext.Movies.Add(new Movie { Id = 123, Budget = 100000, Title = "Iron Man1", PosterPath = "IronMan1.jpg", VoteAverage = 25, VoteCount = 25 }); dbcontext.Movies.Add(new Movie { Id = 124, Budget = 100000, Title = "Iron Man2", PosterPath = "IronMan2.jpg", VoteAverage = 25, VoteCount = 25 }); dbcontext.Movies.Add(new Movie { Id = 125, Budget = 100000, Title = "Iron Man3", PosterPath = "IronMan3.jpg", VoteAverage = 25, VoteCount = 25 }); dbcontext.Movies.Add(new Movie { Id = 126, Budget = 100000, Title = "Iron Man4", PosterPath = "IronMan4.jpg", VoteAverage = 25, VoteCount = 25 }); dbcontext.SaveChanges(); }
public string Execute(IList <string> parameters) { var title = parameters[0].ToLower(); var currentUsername = this.authProvider.CurrentUsername; var movie = this.dbContext.Movies .Where(x => x.Name.ToLower() == title) .FirstOrDefault(); var user = this.dbContext.Users .Where(x => x.Username == currentUsername) .FirstOrDefault(); Validator.IsUserAmoutEnough(user, PriceOfOneMovie); user.Movies.Add(movie); user.Account.Ammount -= user.Account.Ammount - PriceOfOneMovie; dbContext.SaveChanges(); return($"{currentUsername} has successfully added the movie {movie.Name} to their list!"); }