private Movie MapMovie(SqlDataReader reader)
{
var movieDbModel = new MovieDbModel()
{
MovieId = (int)reader["Movie_ID"],
Title = (string)reader["Title"],
ReleaseDate = (DateTime)reader["ReleaseDate"],
Description = (string)reader["Description"],
GenreId = (int)reader["Genre_ID"],
DirectorId = (int)reader["Director_ID"],
LanguageId = (int)reader["Language_ID"]
};
var movie = movieDbModel.GetMovieCore();
MapGenres(movie, movieDbModel);
MapDirectors(movie, movieDbModel);
MapLanguages(movie, movieDbModel);
return(movie);
}
protected override void Seed(HW_AJAX_MVC.Data.MoviesDbContext context)
{
if (context.Movies.Count() > 0)
{
return;
}
var godfather = new MovieDbModel
{
Title = "The Godfather",
Director = "Francis Ford Coppola",
Year = 1972,
LeadingMaleRole = "Marlon Brando",
LeadingMaleRoleAge = 48,
LeadingFemaleRole = "Diane Keaton",
LeadingFemaleRoleAge = 26,
Studio = "Paramount Pictures",
StudioAddress = "Holywood"
};
context.Movies.Add(godfather);
var taxi = new MovieDbModel
{
Title = "Taxi",
Director = "Gerard Pires",
Year = 1998,
LeadingMaleRole = "Samy Naceri",
LeadingMaleRoleAge = 37,
LeadingFemaleRole = "Marion Cotillard",
LeadingFemaleRoleAge = 23,
Studio = "Canal+",
StudioAddress = "Marselie, France"
};
context.Movies.Add(taxi);
context.SaveChanges();
}
private void MapLanguages(Movie movie, MovieDbModel movieDbModel)
{
var language = _languagesRepository2.Get(movieDbModel.LanguageId);
movie.Language = language;
}
private void MapDirectors(Movie movie, MovieDbModel movieDbModel)
{
var director = _directorsRepository2.Get(movieDbModel.DirectorId);
movie.Director = director;
}
private void MapGenres(Movie movie, MovieDbModel movieDbModel)
{
var genre = _genresRepository2.Get(movieDbModel.GenreId);
movie.Genre = genre;
}
