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 (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(MovieExtendStringsSql.GetByTitle(title, userID)); } foreach (DataRow ms in dt.Rows) { movieModel = MovieExtendModel.ToObject(ms); } return(movieModel); }
public IActionResult UpdateMovie(string id, MovieExtendModel movieModel) { try { if (movieModel == null) { return(BadRequest("Data is null.")); } //if (!ModelState.IsValid) //{ // Errors errors = ErrorsHelper.GetErrors(ModelState); // return BadRequest(errors); //} var uid = User.Identity.Name; movieModel.userID = uid; movieModel.imdbID = id; MovieExtendModel updatedMovie = moviesExtendRepository.UpdateMovie(movieModel); return(Ok(updatedMovie)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(StatusCode(StatusCodes.Status500InternalServerError, errors)); } }
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 (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(MovieExtendStringsSql.GetByWord(word, userID)); } foreach (DataRow ms in dt.Rows) { arrMovie.Add(MovieExtendModel.ToObject(ms)); } return(arrMovie); }
public static MovieExtendModel ToObject(DataRow reader) { MovieExtendModel movieExtendModel = new MovieExtendModel(); movieExtendModel.imdbID = reader[0].ToString(); movieExtendModel.title = reader[1].ToString(); movieExtendModel.poster = reader[2].ToString(); movieExtendModel.userID = reader[3].ToString(); movieExtendModel.year = int.Parse(reader[4].ToString()); movieExtendModel.plot = reader[5].ToString(); movieExtendModel.website = reader[6].ToString(); movieExtendModel.rated = reader[7].ToString(); movieExtendModel.imdbRating = float.Parse(reader[8].ToString()); try { movieExtendModel.seen = int.Parse(reader[9].ToString()) > 0; } catch (Exception ex) { Debug.WriteLine("trying to parse mysql seen: " + ex.Message); } try { movieExtendModel.seen = bool.Parse(reader[9].ToString()); } catch (Exception ex) { Debug.WriteLine("trying to parse mssql seen: " + ex.Message); } Debug.WriteLine("MovieExtendModel:" + movieExtendModel.ToString()); return(movieExtendModel); }
static public SqlCommand UpdateMovie(MovieExtendModel movieModel) { if (GlobalVariable.queryType == 0) { return(CreateSqlCommand(movieModel, queryMoviesExtendUpdate)); } else { return(CreateSqlCommand(movieModel, procedureMoviesExtendUpdate)); } }
public IActionResult GetByTitle(string movieTitle) { try { var userID = User.Identity.Name; MovieExtendModel oneMovie = moviesExtendRepository.GetByTitle(movieTitle, userID); return(Ok(oneMovie)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(StatusCode(StatusCodes.Status500InternalServerError, errors)); } }
public MovieExtendModel AddMovie(MovieExtendModel movieModel) { //if (GlobalVariable.queryType == 0) //{ MOVy movie = new MOVy { userID = movieModel.userID, movieImdbID = movieModel.imdbID, movieTitle = movieModel.title, moviePoster = movieModel.poster, movieYear = movieModel.year }; MOVIEEXTEND movieExtend = new MOVIEEXTEND { movieImdbID = movieModel.imdbID, moviePlot = movieModel.plot, movieUrl = movieModel.website, movieRated = movieModel.rated, movieImdbRating = movieModel.imdbRating, movieSeen = movieModel.seen, userID = movieModel.userID }; //movieExtend.MOVy = movie; imdbFavoritesEntities.MOVIES.Add(movie); imdbFavoritesEntities.MOVIEEXTENDS.Add(movieExtend); imdbFavoritesEntities.SaveChanges(); return(GetById(movie.movieImdbID, movie.userID)); //} //else //{ // return imdbFavoritesEntities.AddExtendedMovie(movieModel.imdbID, movieModel.title, movieModel.poster, movieModel.year, movieModel.userId, movieModel.plot, movieModel.website, movieModel.rated, movieModel.imdbRating, movieModel.seen).Select(m => new MovieExtendModel // { // userId = m.userID, // title = m.movieTitle, // poster = m.moviePoster, // year = m.movieYear, // imdbID = m.movieImdbID, // plot = m.moviePlot, // website = m.movieUrl, // rated = m.movieRated, // imdbRating = m.movieImdbRating.Value, // seen = m.movieSeen.Value // }).SingleOrDefault(); //} }
public MovieExtendModel UpdateMovie(MovieExtendModel movieModel) { DataTable dt = new DataTable(); using (SqlCommand command = new SqlCommand()) { dt = GetMultipleQuery(MovieExtendStringsSql.UpdateMovie(movieModel)); } foreach (DataRow ms in dt.Rows) { movieModel = MovieExtendModel.ToObject(ms); } return(movieModel); }
static private SqlCommand CreateSqlCommand(MovieExtendModel movie, string commandText) { SqlCommand command = new SqlCommand(commandText); command.Parameters.AddWithValue("@movieImdbID", movie.imdbID); command.Parameters.AddWithValue("@movieTitle", movie.title); command.Parameters.AddWithValue("@moviePoster", movie.poster); command.Parameters.AddWithValue("@movieYear", movie.year); command.Parameters.AddWithValue("@userID", movie.userID); command.Parameters.AddWithValue("@moviePlot", movie.plot); command.Parameters.AddWithValue("@movieUrl", movie.website); command.Parameters.AddWithValue("@movieRated", movie.rated); command.Parameters.AddWithValue("@movieImdbRating", movie.imdbRating); command.Parameters.AddWithValue("@movieSeen", movie.seen); return(command); }
public MovieExtendModel UpdateMovie(MovieExtendModel movieModel) { //if (GlobalVariable.queryType == 0) //{ MOVy movie = imdbFavoritesEntities.MOVIES.Where(m => m.movieImdbID.Equals(movieModel.imdbID)).SingleOrDefault(); MOVIEEXTEND movieExtend = imdbFavoritesEntities.MOVIEEXTENDS.Where(m => m.movieImdbID.Equals(movieModel.imdbID)).SingleOrDefault(); if (movie == null) { return(null); } movie.userID = movieModel.userID; movie.movieImdbID = movieModel.imdbID; movie.movieTitle = movieModel.title; movie.moviePoster = movieModel.poster; movie.movieYear = movieModel.year; movieExtend.movieImdbID = movieModel.imdbID; movieExtend.moviePlot = movieModel.plot; movieExtend.movieUrl = movieModel.website; movieExtend.movieRated = movieModel.rated; movieExtend.movieImdbRating = movieModel.imdbRating; movieExtend.movieSeen = movieModel.seen; movieExtend.userID = movieModel.userID; imdbFavoritesEntities.SaveChanges(); return(GetById(movie.movieImdbID, movie.userID)); //} //else //{ // return imdbFavoritesEntities.UpdateExtendedMovie(movieModel.imdbID, movieModel.title, movieModel.poster, movieModel.year, movieModel.userId, movieModel.plot, movieModel.website, movieModel.rated, movieModel.imdbRating, movieModel.seen).Select(m => new MovieExtendModel // { // userId = m.userID, // title = m.movieTitle, // poster = m.moviePoster, // year = m.movieYear, // imdbID = m.movieImdbID, // plot = m.moviePlot, // website = m.movieUrl, // rated = m.movieRated, // imdbRating = m.movieImdbRating.Value, // seen = m.movieSeen.Value // }).SingleOrDefault(); //} }
public MovieExtendModel UpdateMovie(MovieExtendModel movieModel) { _movies.ReplaceOne(movie => movie.imdbID.Equals(movieModel.imdbID) && movie.userID.Equals(movieModel.userID), movieModel); return(_movies.Find <MovieExtendModel>(movie => movie.imdbID.Equals(movieModel.imdbID) && movie.userID.Equals(movieModel.userID)).Project(m => new MovieExtendModel { userID = m.userID, imdbID = m.imdbID, title = m.title, poster = m.poster, year = m.year, plot = m.plot, website = m.website, rated = m.rated, imdbRating = m.imdbRating, seen = m.seen }).FirstOrDefault()); }
public async Task <IActionResult> GetImdbById(string movieId) { //http://localhost:49270/api/imdbMovies/byId/tt3896198/ var id = User.Identity.Name; try { UserModel userModel = userRepository.GetOneUserById(id); MovieExtendModel oneMovie = await imdbRepository.GetImdbById(userModel.userImdbPass, movieId, id); return(Ok(oneMovie)); } catch (Exception ex) { Errors errors = ErrorsHelper.GetErrors(ex); return(StatusCode(StatusCodes.Status500InternalServerError, errors)); } }
public async Task <MovieExtendModel> GetImdbByTitle(string userPass, string movieTitle, string userId, string type = "", int year = 0, string r = "json", string plot = "short") { //type = movie, series, episode //y = 1981 //r=json, xml //plot = short, full MovieExtendModel movieModel = new MovieExtendModel(); string movie = ""; JObject jmovie = new JObject(); string url = "http://www.omdbapi.com/?" + "apikey=" + userPass + "&t=" + movieTitle; using (HttpClient client = new HttpClient()) { movie = await client.GetStringAsync(url); jmovie = JObject.Parse(movie); } return(createMovieExtendModel(jmovie, userPass, userId)); }
private MovieExtendModel createMovieExtendModel(JObject jmovie, string userPass, string userID) { MovieExtendModel movieModel = new MovieExtendModel(); try { movieModel.imdbID = jmovie.GetValue("imdbID").ToString(); } catch (Exception ex) { movieModel.imdbID = ""; Debug.WriteLine("imdbID:" + ex.Message); } try { movieModel.title = jmovie.GetValue("Title").ToString(); } catch (Exception ex) { movieModel.title = ""; Debug.WriteLine("title:" + ex.Message); } try { movieModel.plot = jmovie.GetValue("Plot").ToString(); } catch (Exception ex) { movieModel.plot = ""; Debug.WriteLine("plot:" + ex.Message); } try { movieModel.website = jmovie.GetValue("Website").ToString(); } catch (Exception ex) { movieModel.website = ""; Debug.WriteLine("website:" + ex.Message); } try { movieModel.rated = jmovie.GetValue("Rated").ToString(); } catch (Exception ex) { movieModel.rated = ""; Debug.WriteLine("rated:" + ex.Message); } movieModel.seen = false; try { movieModel.poster = jmovie.GetValue("Poster").ToString(); } catch (Exception ex) { movieModel.poster = ""; Debug.WriteLine("poster:" + ex.Message); } try { movieModel.userID = userID; } catch (Exception ex) { movieModel.userID = ""; Debug.WriteLine("userId:" + ex.Message); } try { movieModel.year = int.Parse(jmovie.GetValue("Year").ToString()); } catch (Exception ex) { movieModel.year = 0; Debug.WriteLine("year:" + ex.Message); } try { movieModel.imdbRating = float.Parse(jmovie.GetValue("imdbRating").ToString()); } catch (Exception ex) { movieModel.imdbRating = 0; Debug.WriteLine("imdbRating:" + ex.Message); } return(movieModel); }