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();
}