private void addMovie_Click(object sender, EventArgs e) { var movie = new Movie(releaseDate.Value.Date, (int)id.Value, status.Text, revenue.Value, posterUrl.Text, title.Text, 0); try { _movieDao.InsertMovie(movie); var countriesList = (from object country in selectedCountries.Items select country.ToString().SplitInto2Vars().Item2) .ToList(); var movieId = int.Parse(id.Text); _countriesDao.InsertMovieCountries(movieId, countriesList); var genresList = new List <string>(); genresList.AddRange(from object genre in selectedGenres.Items select genre.ToString()); _genresDao.InsertMovieGenres(genresList.Select(x => { var genreId = int.Parse(x.SplitInto2Vars().Item2); return(new MovieGenre(movieId, genreId)); })); foreach (var crewItem in crewListbox.Items) { var separated = crewItem.ToString().SplitInto3Vars(); var crewPersonId = int.Parse(separated.Item3); var crew = new Crew(crewPersonId, movieId, crewJob.Text); _crewDao.InsertCrew(crew); } foreach (var castItem in castListbox.Items) { var separate = castItem.ToString().SplitInto3Vars(); var castPersonId = int.Parse(separate.Item3); var cast = new Cast(castPersonId, movieId, castCharacter.Text); _castDao.InsertCast(cast); } Close(); } catch (Exception exception) { MessageBox.Show(exception.Message); } }
public void Retrieve(int count) { var departments = _httpRetriever.RetrieveDepartments(); _crewDao.InsertDepartments(departments); var genres = _httpRetriever.RetrieveGenres(); _genresDao.InsertGenres(genres); var logins = InsertMembers(); for (var id = 1; id < count; id++) { Console.WriteLine(id); try { RetrieveAndInsertFilm(id); foreach (var login in logins) { _reviewsDao.AddReview(login, RandomString(100), Random.Next(1, 10), id); } var cast = _httpRetriever.RetrieveCastFromFilm(id); foreach (var c in cast) { var person = RetrievePerson(_httpRetriever, c.PersonId); _personDao.InsertPerson(person); _castDao.InsertCast(c); } var crew = _httpRetriever.RetrieveCrewFromFilm(id); foreach (var c in crew) { var person = RetrievePerson(_httpRetriever, c.PersonId); _personDao.InsertPerson(person); _crewDao.InsertCrew(c); } } catch (KeyNotFoundException) { } } _databaseConnection.Close(); }