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 void button8_Click(object sender, EventArgs e) { DBConnect helper = new DBConnect(); Console.Out.WriteLine(helper.SelectMovieByGenre("History").Count); }
private void button8_Click(object sender, EventArgs e) { DBConnect helper = new DBConnect(); Console.Out.WriteLine(helper.SelectMovieByGenre("History").Count); }
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; }