// Új Movie rekord létrehozása
private void CreateFilmRecord()
{
// Dialog megjelenítése az adatok bekéréséhez
List <DirectorsModel> dirlist = context.Directors.ToList();
List <GenreModel> genrelist = context.Genre.ToList();
MoviesDialog moviedlg = new MoviesDialog(dirlist, genrelist, null);
moviedlg.Owner = this;
moviedlg.ShowDialog();
bool result = DialogResult.HasValue ? (bool)moviedlg.DialogResult : false;
// Mentés esetén frissítjük az adatokat az adatbázisban
if (result)
{
MovieModel newmovie = new MovieModel();
newmovie.Title = moviedlg.titleTextBox.Text;
if (moviedlg.yearTextBox.Text != "")
{
newmovie.ReleaseYear = int.Parse(moviedlg.yearTextBox.Text);
}
else
{
newmovie.ReleaseYear = null;
}
string genreselect = moviedlg.genreComboBox.SelectedItem != null ? (string)moviedlg.genreComboBox.SelectedItem : null;
string dirselect = moviedlg.dirComboBox.SelectedItem != null ? (string)moviedlg.dirComboBox.SelectedItem : null;
newmovie.GenreId = genreselect != null?context.Genre.Where(g => g.Genre == genreselect).AsNoTracking().FirstOrDefault().Id : (int?)null;
newmovie.DirectorId = dirselect != null?context.Directors.Where(d => d.Director == dirselect).AsNoTracking().FirstOrDefault().Id : (int?)null;
if (moviedlg.durationTextBox.Text != "")
{
newmovie.Duration = int.Parse(moviedlg.durationTextBox.Text);
}
else
{
newmovie.Duration = null;
}
context.Movie.Add(newmovie);
context.SaveChanges();
}
ReloadFilmListViewContent();
}
// Kiválasztott Movie rekord szerkesztése
private void EditFilmRecord()
{
// Dialog megjelenítése az adatok módosításához
List <DirectorsModel> dirlist = context.Directors.ToList();
List <GenreModel> genrelist = context.Genre.ToList();
MovieModel selectedfilm = (MovieModel)FilmListView.SelectedItem;
MoviesDialog moviedlg = new MoviesDialog(dirlist, genrelist, selectedfilm);
moviedlg.Owner = this;
moviedlg.ShowDialog();
// Mentés esetén frissítjük az adatokat az adatbázisban
if ((bool)moviedlg.DialogResult)
{
MovieModel updmovie = context.Movie.FirstOrDefault(m => m.Id == moviedlg.movieid);
updmovie.Title = moviedlg.titleTextBox.Text;
if (moviedlg.yearTextBox.Text != "")
{
updmovie.ReleaseYear = int.Parse(moviedlg.yearTextBox.Text);
}
else
{
updmovie.ReleaseYear = null;
}
string genreselect = moviedlg.genreComboBox.SelectedItem != null ? (string)moviedlg.genreComboBox.SelectedItem : null;
string dirselect = moviedlg.dirComboBox.SelectedItem != null ? (string)moviedlg.dirComboBox.SelectedItem : null;
updmovie.GenreId = genreselect != null?context.Genre.Where(g => g.Genre == genreselect).AsNoTracking().FirstOrDefault().Id : (int?)null;
updmovie.DirectorId = dirselect != null?context.Directors.Where(d => d.Director == dirselect).AsNoTracking().FirstOrDefault().Id : (int?)null;
if (moviedlg.durationTextBox.Text != "")
{
updmovie.Duration = int.Parse(moviedlg.durationTextBox.Text);
}
else
{
updmovie.Duration = null;
}
context.Movie.Update(updmovie);
context.SaveChanges();
}
ReloadFilmListViewContent();
}
