private Movies GetMovieExecQuery(string query) { Movies movie = new Movies(); using (connection = DBHelper.OpenConnection()) { MySqlCommand cmd = new MySqlCommand(query, connection); using (reader = cmd.ExecuteReader()) { if (reader.Read()) { movie = Movies_DAL.GetMovie(reader); } } } return(movie); }