private List <Movie> Search(string title, string director, string year, string genre, string actor)
{
DBConnect helper = new DBConnect();
List <Movie> movies = new List <Movie>();
if (title.Length > 2)
{
List <Movie> fromTitle = helper.SelectMovie("SELECT * FROM Movies WHERE title LIKE '%" + title + "%'");
movies.AddRange(fromTitle);
}
if (director.Length > 2)
{
List <Movie> fromDirector = helper.SelectMovie("SELECT * FROM Movies WHERE director LIKE '%" + director + "%'");
movies.AddRange(fromDirector);
}
if (year.Length > 2)
{
List <Movie> fromYear = helper.SelectMovie("SELECT * FROM Movies WHERE year LIKE '%" + year + "%'");
movies.AddRange(fromYear);
}
if (genre.Length > 2)
{
List <Movie> fromGenre = helper.SelectMovieByGenre(genre);
movies.AddRange(fromGenre);
}
if (actor.Length > 2)
{
List <Movie> fromActor = helper.SelectMovieByActor(actor);
movies.AddRange(fromActor);
}
return(movies);
}
private List<Movie> Search(string title, string director, string year, string genre, string actor)
{
DBConnect helper = new DBConnect();
List<Movie> movies = new List<Movie>();
if (title.Length > 2)
{
List<Movie> fromTitle = helper.SelectMovie("SELECT * FROM Movies WHERE title LIKE '%" + title + "%'");
movies.AddRange(fromTitle);
}
if (director.Length > 2)
{
List<Movie> fromDirector = helper.SelectMovie("SELECT * FROM Movies WHERE director LIKE '%" + director + "%'");
movies.AddRange(fromDirector);
}
if (year.Length > 2)
{
List<Movie> fromYear = helper.SelectMovie("SELECT * FROM Movies WHERE year LIKE '%" + year + "%'");
movies.AddRange(fromYear);
}
if (genre.Length > 2)
{
List<Movie> fromGenre = helper.SelectMovieByGenre(genre);
movies.AddRange(fromGenre);
}
if (actor.Length > 2)
{
List<Movie> fromActor = helper.SelectMovieByActor(actor);
movies.AddRange(fromActor);
}
return movies;
}
