public void OnAddMovieCliked(object sender, RoutedEventArgs e) { _movie.StreamingId = (int)comboboxStreamingtjenester.SelectedValue; _movie.StreamingService = db.StreamingServices.Find(_movie.StreamingId); _movie.Tilgaengelig_Fra = date_fra.SelectedDate.Value; _movie.Tilgaengelig_Til = date_til.SelectedDate.Value; foreach (Genre g_listbox in listboxGenreFilm.SelectedItems) { foreach (Genre g_db in db.GetallGenre()) { if (g_listbox.Name == g_db.Name) { g_db.Movies.Add(_movie); _movie.Genres.Add(g_db); } } } db.SaveChanges(); db.Movies.Add(_movie); MessageBox.Show(_movie.Titel + "er tilføjet"); service.fill_ListviewFilm(listviewFilm); }
public void addGenres() { using (var db = new StreamingContext()) { db.SaveChanges(); if (db.GetallGenre().Count <= 0) { Genre genre1 = new Genre { Name = "Drama" }; Genre genre2 = new Genre { Name = "Action" }; Genre genre3 = new Genre { Name = "Science fiction" }; Genre genre4 = new Genre { Name = "Documentar" }; Genre genre5 = new Genre { Name = "Komodie" }; db.AddGenre(genre1); db.AddGenre(genre2); db.AddGenre(genre3); db.AddGenre(genre4); db.AddGenre(genre5); db.SaveChanges(); } if (db.GetallGenre().Count > 5) { db.Genres.RemoveRange(db.Genres.Where(a => a.Name == a.Name)); db.SaveChanges(); } } }
public void fillGenre(ListBox comboboxGenreFilm, ListBox comboBoxGenreSerie) { using (var db = new StreamingContext()) { List <Genre> items = new List <Genre>(); foreach (Genre el in db.GetallGenre()) { items.Add(el); } comboBoxGenreSerie.ItemsSource = items; comboboxGenreFilm.ItemsSource = items; comboboxGenreFilm.SelectedIndex = 1; comboBoxGenreSerie.SelectedIndex = 1; } }