Ejemplo n.º 1
0
        [HttpGet("GetMovieByName/{movieName}/")] //Route: WebAPI/TermProject/GetMovieByName/
        public List <Movies> GetMovieByName(string movieName)
        {
            DataSet          myDS    = new DataSet();
            StoredProcedures stoPros = new StoredProcedures();

            myDS = stoPros.getMovieByName(movieName);

            DBConnect objDB = new DBConnect();

            Movies        movies = new Movies();
            List <Movies> dpts   = new List <Movies>();

            foreach (DataRow dr in myDS.Tables[0].Rows)
            {
                movies                  = new Movies();
                movies.movieID          = int.Parse(dr["Movie_ID"].ToString());
                movies.movieName        = dr["Movie_Name"].ToString();
                movies.movieImage       = dr["Movie_Image"].ToString();
                movies.movieYear        = int.Parse(dr["Movie_Year"].ToString());
                movies.movieDescription = dr["Movie_Description"].ToString();
                movies.movieRuntime     = int.Parse(dr["Movie_RunTime"].ToString());
                movies.movieAgeRating   = dr["Movie_Age_Rating"].ToString();
                movies.movieGenre       = dr["Movie_Genre"].ToString();
                movies.movieBudget      = float.Parse(dr["Movie_Budget"].ToString());
                movies.movieIncome      = float.Parse(dr["Movie_Income"].ToString());
                dpts.Add(movies);
            }
            return(dpts);
        } //end of GetMovies
Ejemplo n.º 2
0
        public List <Movies> FindMovieByAgeRating(string ID, string ageRating)
        {
            DBConnect  objDB      = new DBConnect();
            SqlCommand objCommand = new SqlCommand();

            objCommand.CommandType = CommandType.StoredProcedure;
            objCommand.CommandText = "TP_FindMovieByAgeRating ";

            objCommand.Parameters.AddWithValue("@AgeRating", ageRating);
            DataSet       ds   = objDB.GetDataSetUsingCmdObj(objCommand);
            List <Movies> list = new List <Movies>();
            Movies        movies;

            foreach (DataRow record in ds.Tables[0].Rows)
            {
                movies                  = new Movies();
                movies.movieID          = int.Parse(record["Movie_ID"].ToString());
                movies.movieName        = record["Movie_Name"].ToString();
                movies.movieImage       = record["Movie_Image"].ToString();
                movies.movieYear        = int.Parse(record["Movie_Year"].ToString());
                movies.movieDescription = record["Movie_Description"].ToString();
                movies.movieRuntime     = int.Parse(record["Movie_RunTime"].ToString());
                movies.movieAgeRating   = record["Movie_Age_Rating"].ToString();
                movies.movieGenre       = record["Movie_Genre"].ToString();
                movies.movieBudget      = float.Parse(record["Movie_Budget"].ToString());
                movies.movieIncome      = float.Parse(record["Movie_Income"].ToString());


                list.Add(movies);
            }
            return(list);
        }
Ejemplo n.º 3
0
        public Boolean UpdateMovie([FromBody] Movies movie)
        {
            if (movie != null)
            {
                DBConnect  objDB      = new DBConnect();
                SqlCommand objCommand = new SqlCommand();

                objCommand.CommandType = CommandType.StoredProcedure;
                objCommand.CommandText = "TP_UpdateMovie";
                objCommand.Parameters.AddWithValue("@Member_ID", movie.memberID);

                objCommand.Parameters.AddWithValue("@Movie_ID", movie.movieID);
                objCommand.Parameters.AddWithValue("@Movie_Image", movie.movieImage);
                objCommand.Parameters.AddWithValue("@Movie_Name", movie.movieName);
                objCommand.Parameters.AddWithValue("@Movie_Year", movie.movieYear);
                objCommand.Parameters.AddWithValue("@Movie_Description", movie.movieDescription);
                objCommand.Parameters.AddWithValue("@Movie_Runtime", movie.movieRuntime);
                objCommand.Parameters.AddWithValue("@Movie_Age_Rating", movie.movieAgeRating);
                objCommand.Parameters.AddWithValue("@Movie_Genre", movie.movieGenre);
                objCommand.Parameters.AddWithValue("@Movie_Budget", movie.movieBudget);
                objCommand.Parameters.AddWithValue("@Movie_Income", movie.movieIncome);

                int retVal = objDB.DoUpdateUsingCmdObj(objCommand);

                if (retVal > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            else
            {
                return(false);
            }
        }