public MovieExtendModel GetByTitle(string title, string userID)
        {
            if (title.Equals(string.Empty) || title.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            if (userID.Equals(string.Empty) || userID.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }

            DataTable dt = new DataTable();

            MovieExtendModel movieModel = new MovieExtendModel();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(MovieExtendStringsMySql.GetByTitle(title, userID));
            }

            foreach (DataRow ms in dt.Rows)
            {
                movieModel = MovieExtendModel.ToObject(ms);
            }
            return(movieModel);
        }
        public List <MovieExtendModel> GetByWord(string word, string userID)
        {
            if (word.Equals(string.Empty) || word.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }

            if (userID.Equals(string.Empty) || userID.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }

            DataTable dt = new DataTable();
            List <MovieExtendModel> arrMovie = new List <MovieExtendModel>();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(MovieExtendStringsMySql.GetByWord(word, userID));
            }

            foreach (DataRow ms in dt.Rows)
            {
                arrMovie.Add(MovieExtendModel.ToObject(ms));
            }

            return(arrMovie);
        }
        public MovieExtendModel UpdateMovie(MovieExtendModel movieModel)
        {
            DataTable dt = new DataTable();

            using (MySqlCommand command = new MySqlCommand())
            {
                dt = GetMultipleQuery(MovieExtendStringsMySql.UpdateMovie(movieModel));
            }
            foreach (DataRow ms in dt.Rows)
            {
                movieModel = MovieExtendModel.ToObject(ms);
            }

            return(movieModel);
        }
        public int DeleteMovie(string imdbID, string userID)
        {
            if (imdbID.Equals(string.Empty) || imdbID.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }
            if (userID.Equals(string.Empty) || userID.Equals(""))
            {
                throw new ArgumentOutOfRangeException();
            }

            int i = 0;

            using (MySqlCommand command = new MySqlCommand())
            {
                i = ExecuteNonQuery(MovieExtendStringsMySql.DeleteMovie(imdbID, userID));
            }
            return(i);
        }