public void GetById_SeedFilm()
{
var film2 = _filmRepositorySUT.GetById(Seed.GreaseFilm.Id);
var film = FilmMapper.MapToDetailModel(Seed.GreaseFilm);
Assert.Equal(film, film2, FilmDetailModel.FilmDetailModelComparer);
Assert.Equal(film.Reviews, film2.Reviews, ReviewListModel.ReviewListModelComparer);
Assert.Equal(film.Actors, film2.Actors, ActedInFilmDetailModel.ActedInFilmDetailModelComparer);
Assert.Equal(film.Directors, film2.Directors, DirectedFilmDetailModel.DirectedFilmDetailModelComparer);
}
public ActionResult Index(string gekozenGenre)
{
if (gekozenGenre == "Alles")
{
return(RedirectToAction("Index"));
}
TicketAuthenticator auth = new TicketAuthenticator();
Account acc = _accountRepository.GetAccountById(auth.Decrypt());
acc.Films = _filmRepository.GetBoughtFilms(acc.Id);
acc.Winkelmand = new Winkelmand
{
Films = _winkelmandRepository.GetFilmsInWinkelmand(_winkelmandRepository.GetWinkelmandId(acc.Id))
};
FilmIndexViewmodel viewmodel = new FilmIndexViewmodel
{
ListGenres = _genreRepository.GetAllGenres(),
ListFilm = new List <Film>(),
Account = acc,
AllFilmsCount = _filmRepository.GetAllFilms().Count
};
List <int> filmIds = _genreRepository.GetFilmsWithGenre(gekozenGenre);
foreach (int id in filmIds)
{
viewmodel.ListFilm.Add(_filmRepository.GetById(id));
}
return(View(viewmodel));
}
public Voorstelling GetById(int id)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
FilmRepository FRep = new FilmRepository(new MssqlFilmContext());
ZaalRepository ZRep = new ZaalRepository(new MssqlZaalContext());
conn.Open();
string query = "SELECT * FROM dbo.voorstelling WHERE ID = @id";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("ID", id);
SqlDataReader reader = cmd.ExecuteReader();
Voorstelling voor = new Voorstelling();
while (reader.Read())
{
voor.Id = reader.GetInt32(reader.GetOrdinal("ID"));
voor.Starttijd = reader.GetDateTime(reader.GetOrdinal("begintijd"));
voor.Eindtijd = reader.GetDateTime(reader.GetOrdinal("eindtijd"));
voor.Zl = ZRep.GetById(reader.GetInt32(reader.GetOrdinal("Zaal_ID")));
voor.Fl = FRep.GetById(reader.GetInt32(reader.GetOrdinal("Film_ID")));
}
conn.Close();
return(voor);
}
}
public Film GetByIdFilmService(int id)
{
return(filmRepository.GetById(id));
}
