Example #1
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            movrepo = new MovieRepository();
            movie   = new MovieTable();

            movie.MovieName      = TextBox11.Text;
            movie.LanguageID     = Convert.ToByte(DropDownList6.SelectedValue);
            movie.GenreID        = Convert.ToByte(DropDownList7.SelectedValue);
            movie.QualityID      = Convert.ToByte(DropDownList8.SelectedValue);
            movie.ReleaseDate    = Convert.ToDateTime(TextBox12.Text);
            movie.Availability   = Convert.ToByte(TextBox13.Text);
            movie.Discontinue    = Convert.ToBoolean(TextBox3.Text);
            movie.DateOfAddition = Convert.ToDateTime(TextBox4.Text);
            movie.Price          = Convert.ToDecimal(TextBox5.Text);
            movie.Fine           = Convert.ToByte(TextBox6.Text);
            movie.Producer       = TextBox7.Text;
            movie.Director       = TextBox8.Text;
            movie.Cast           = TextBox9.Text;
            movie.Certificate    = DropDownList4.SelectedValue;
            movie.Rating         = Convert.ToByte(TextBox9.Text);
            movrepo.AddMovie(movie);



            Response.Redirect("SucessMovieAdd.aspx");
        }
        public void It_Should_Be_Able_To_Search_Movies()
        {
            // arrange
            Mock <MoviesContext> mockContext = new Mock <MoviesContext>();
            var movie = new Movie {
                Title = movieTitle
            };

            mockContext.Setup(context => context.SearchMovie(movieTitle)).Returns(new List <Movie> {
                movie
            });
            var repo = new MovieRepository(mockContext.Object);

            // act
            var testMovie = new Movie {
                Title = movieTitle
            };

            repo.AddMovie(testMovie);
            int expectedCount = 1;

            // act
            IEnumerable <Movie> result = repo.SearchMovies(movieTitle);

            // assert
            Assert.AreEqual(expectedCount, result.Count());
            Assert.AreEqual(movieTitle, result.ToList()[0].Title);
        }
        public void AddOrUpdate(MovieDTO movie)
        {
            var movy = new Movy()
            {
                Id           = movie.Id != Guid.Empty ? movie.Id : Guid.NewGuid(),
                Rating       = movie.Rating,
                AverageScore = movie.AverageScore,
                Length       = movie.Length,
                ReleaseDate  = movie.ReleaseDate,
                Title        = movie.Title,
            };

            if (!string.IsNullOrEmpty(movie.CategoryName))
            {
                var categoryRepo     = new CategoryRepository();
                var existingCategory = categoryRepo.GetCategory(movie.CategoryName);
                if (existingCategory != null)
                {
                    movy.CategoryId = existingCategory.Id;
                }
            }

            if (movie.Id != Guid.Empty)
            {
                //updates movie
                _movieRepo.UpdateMovie(movy);
            }
            else
            {
                //adds new movie
                _movieRepo.AddMovie(movy);
            }
        }
Example #4
0
        public void AddorUpdate(MovieDTO movie)
        {
            var movy = new Movie
            {
                Id           = movie.Id != Guid.Empty ? movie.Id: Guid.NewGuid(), //inline if
                Title        = movie.Title,
                AverageScore = movie.AverageScore,
                Length       = movie.Length,
                Rating       = movie.Rating,
                ReleaseDate  = movie.ReleaseDate
            };

            if (!string.IsNullOrEmpty(movie.CategoryName))
            {
                var categoryRepo     = new CategoryRepository();
                var existingCategory = categoryRepo.GetCategorybyName(movie.CategoryName);
                if (existingCategory != null)
                {
                    movy.CategoryId = existingCategory.Id;
                }
            }

            if (movie.Id != Guid.Empty)//movie exists => update
            {
                _repo.updateMovie(movy);
            }

            else//movie doesn't exist => add
            {
                _repo.AddMovie(movy);
            }
        }
Example #5
0
        public void AddOrUpdate(MovieDTO movie)
        {
            var movy = new Movy
            {
                Id           = movie.Id != Guid.Empty ? movie.Id: Guid.NewGuid(), //inline if
                Title        = movie.Title,
                AverageScore = movie.AverageScore,
                Length       = movie.Length,
                Rating       = movie.Rating,
                ReleaseDate  = movie.ReleaseDate,
            };

            //category is a bit tricky
            //if we have something in our MovieDTO model ( movie ), then we need to search for the category with that name and get its Id in order to assign it to our movie
            //so let's define a search by name in category
            if (!string.IsNullOrEmpty(movie.CategoryName))
            {
                var categoryRepo     = new CategoryRepository();
                var existingCategory = categoryRepo.GetCategoryByName(movie.CategoryName);
                if (existingCategory != null)
                {
                    movy.CategoryId = existingCategory.Id;
                }
            }

            if (movie.Id != Guid.Empty) //movie exists => update
            {
                _repo.UpdateMovie(movy);
            }
            else //movie doesn't exist => add
            {
                _repo.AddMovie(movy);
            }
        }
Example #6
0
        public IActionResult Create(Movie m)
        {
            if (ModelState.IsValid)
            {
                MovieRepository.AddMovie(m);
                return(RedirectToAction("index"));
            }

            return(View(m));
        }
        public async Task <IHttpActionResult> Post([FromBody] Movie movie)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            await _movie.AddMovie(movie);

            return(CreatedAtRoute("DefaultApi", new { id = movie.Id }, movie));
        }
Example #8
0
        public async void MovieRepository_Create_NullUser_Failure()
        {
            // Arrange
            Movie _movie = null;

            //Act
            _mockContext.Setup((p => p.MoviesCollectionName)).Returns("movies");
            _mockContext.Setup((p => p.ConnectionString)).Returns("mongodb://localhost:27017");
            _mockContext.Setup((p => p.DatabaseName)).Returns("MovieCatalog");
            var movieRepository = new MovieRepository(_mockContext.Object);

            // Assert
            await Assert.ThrowsAsync <ArgumentNullException>(() => movieRepository.AddMovie(_movie));
        }
Example #9
0
        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}");
            }
        }
Example #10
0
        protected void ButtonSave_Click(object sender, EventArgs e)
        {
            ViewMovie newMovie = new ViewMovie();

            newMovie.MovieName    = TextBoxMovieName.Value;
            newMovie.DirectorName = DropDownListDirectorName.SelectedItem.Text;
            newMovie.GenreName    = DropDownListGenre.SelectedItem.Text;
            newMovie.Description  = TextBoxDescription.Value;
            newMovie.ReleaseDate  = int.Parse(TextBoxReleaseDate.Value);
            newMovie.Score        = decimal.Parse(TextBoxScore.Value);
            newMovie.TotalScore   = newMovie.Score;
            newMovie.ScoreCounter = 1;

            MovieRepository.AddMovie(newMovie);

            Response.Redirect("ListOfMovies.aspx");
        }
        public void It_Should_Be_Able_To_Add_Movies()
        {
            // arrange
            var testMovie = new Movie {
                Title = movieTitle
            };
            Mock <MoviesContext> mockContext = new Mock <MoviesContext>();

            mockContext.Setup(ctx => ctx.AddMovie(testMovie)).Returns(testMovie);
            var repo = new MovieRepository(mockContext.Object);

            // act

            var result = repo.AddMovie(testMovie);

            // assert
            mockContext.Verify(m => m.AddMovie(testMovie), Times.Once());
            Assert.AreEqual(testMovie, result);
        }
Example #12
0
 public IActionResult Post([FromBody] Movie movie)
 {
     try
     {
         if (movie != null)
         {
             repository.AddMovie(movie);
             return(Created(Url.Link("GetMovies", new { }), movie));
         }
         else
         {
             return(NotFound("No Customer info retrieved..."));
         }
     }
     catch (Exception e)
     {
         return(BadRequest($"O oh, something ({e.Message}) went wrong"));
     }
 }
Example #13
0
        public void AddOrUpdate(MovieDTO movie)
        {
            var movy = new Movy
            {
                id           = movie.Id != Guid.Empty ? movie.Id : Guid.NewGuid(), //checking if passed movie object ID already exists, if not then we create a new ID.
                Title        = movie.Title,
                ReleaseDate  = movie.ReleaseDate,
                AverageScore = movie.AverageScore,
                Length       = movie.Length,
                Rating       = movie.Rating,
            };

            //category needs to be set differently. If we have something in our MovieDTO model (movie), we need to search category table for the name and get the ID of the category in order to assign it to the object.

            if (!string.IsNullOrEmpty(movie.CategoryName))
            {
                var categoryRepo     = new CategoryRepository();
                var existingCategory = categoryRepo.GetCategoryByName(movie.CategoryName);
                if (existingCategory != null)
                {
                    movy.CategoryID = existingCategory.id;
                }
            }


            if (movie.Id != Guid.Empty)
            {
                //movie exists => update
                _repo.UpdateMovie(movy);
            }
            else
            {
                //movie doesn't exist => add
                _repo.AddMovie(movy);
            }
        }
Example #14
0
 public Movie AddMovie(AddMovieCommand movieToAdd)
 {
     return(_repo.AddMovie(movieToAdd));
 }
Example #15
0
 public static Movie Create(MovieRepository movieRepository, Movie movie)
 {
     return(movieRepository.AddMovie(movie));
 }
Example #16
0
 public void CreateMovie(Movie movie)
 {
     movieRepository.AddMovie(movie);
 }
        public async Task <ActionResult> PostMovie(Movie movie)
        {
            await _repository.AddMovie(movie.Title);

            return(CreatedAtAction(nameof(GetMovie), new { Title = movie.Title }, movie));
        }