public ActionResult EditMovie(int id)
{
var repository = new MovieCatalogEntities();
var movie = repository.Movies.FirstOrDefault(m => m.MovieId == id);
// if movie doesn't exist go home
if (movie == null)
{
return(RedirectToAction("Index"));
}
EditMovieViewModel model = new EditMovieViewModel();
model.MovieId = movie.MovieId;
model.Title = movie.Title;
model.SelectedGenreId = movie.GenreId;
model.SelectedRatingId = movie.RatingId;
model.Genres = from g in repository.Genres
select new SelectListItem {
Text = g.GenreType, Value = g.GenreId.ToString()
};
model.Ratings = from r in repository.Ratings
select new SelectListItem {
Text = r.RatingName, Value = r.RatingId.ToString()
};
return(View(model));
}
public ActionResult Index(int id = 1)
{
/*
* Movie result;
* using (var conn = new SqlConnection())
* {
* conn.ConnectionString = ConfigurationManager
* .ConnectionStrings["MovieCatalog"]
* .ConnectionString;
*
* var parameters = new DynamicParameters();
* parameters.Add("@MovieId", id);
*
* result = conn.Query<Movie>(
* "MovieSelectById",
* parameters,
* commandType: CommandType.StoredProcedure).FirstOrDefault();
* }
* ViewBag.Movie = result;
*/
var repository = new MovieCatalogEntities();
ViewBag.Movie = (from movie in repository.Movies
where movie.MovieId == id
select new MovieListView
{
MovieId = movie.MovieId,
Title = movie.Title,
GenreType = movie.Genre.GenreType,
RatingName = movie.Rating.RatingName
}).FirstOrDefault();
return(View());
}
public ActionResult AddMovie(AddMovieViewModel model)
{
var repository = new MovieCatalogEntities();
if (ModelState.IsValid)
{
Movie movie = new Movie();
movie.Title = model.Title;
movie.RatingId = model.SelectedRatingId;
movie.GenreId = model.SelectedGenreId;
repository.Movies.Add(movie);
repository.SaveChanges();
return(RedirectToAction("EditMovie", new { id = movie.MovieId }));
}
// validation failed, return them to the view
model.Genres = from g in repository.Genres
select new SelectListItem {
Text = g.GenreType, Value = g.GenreId.ToString()
};
model.Ratings = from r in repository.Ratings
select new SelectListItem {
Text = r.RatingName, Value = r.RatingId.ToString()
};
return(View(model));
}
public ActionResult DeleteMovie(int id)
{
var repository = new MovieCatalogEntities();
var movie = repository.Movies.FirstOrDefault(m => m.MovieId == id);
// movie exists?
if (movie != null)
{
repository.Movies.Remove(movie);
repository.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Home
public ActionResult Index()
{
var repository = new MovieCatalogEntities();
var model = from movie in repository.Movies
select new MovieListView
{
MovieId = movie.MovieId,
Title = movie.Title,
GenreType = movie.Genre.GenreType,
RatingName = movie.Rating.RatingName
};
return(View(model));
}
public ActionResult AddMovie(AddMovieViewModel model)
{
var movie = new EntityFrameworkIntro.Models.Movie();
movie.Title = model.Title;
movie.GenreId = model.GenreId;
movie.RatingId = model.RatingsId;
var repository = new MovieCatalogEntities();
repository.Movies.Add(movie);
repository.SaveChanges();
return(RedirectToAction("Index", new { id = movie.MovieId }));
}
public ActionResult AddMovie()
{
var repository = new MovieCatalogEntities();
AddMovieViewModel model = new AddMovieViewModel();
model.Genres = from g in repository.Genres
select new SelectListItem {
Text = g.GenreType, Value = g.GenreId.ToString()
};
model.Ratings = from r in repository.Ratings
select new SelectListItem {
Text = r.RatingName, Value = r.RatingId.ToString()
};
return(View(model));
}
protected override void Seed(MovieCatalogEntities context)
{
context.Genres.AddOrUpdate(
g => g.GenreType,
new Genre {
GenreType = "Sci-Fi"
},
new Genre {
GenreType = "Adventure"
},
new Genre {
GenreType = "Mystery"
},
new Genre {
GenreType = "Horror"
}
);
context.Ratings.AddOrUpdate(
r => r.RatingName,
new Rating {
RatingName = "G"
},
new Rating {
RatingName = "PG"
},
new Rating {
RatingName = "PG-13"
},
new Rating {
RatingName = "R"
}
);
context.SaveChanges();
context.Movies.AddOrUpdate(
m => m.Title,
new Movie
{
Title = "Star Wars",
GenreId = context.Genres.First(g => g.GenreType == "Sci-Fi").GenreId,
RatingId = context.Ratings.First(r => r.RatingName == "PG").RatingId
}
);
}
