public void AddMovie(OmdbMovie omdbMovie, string rating) { string sImdbRating = omdbMovie.imdbRating.Replace(",", "."); string sRating = rating.Replace(",", "."); string sWriters = omdbMovie.Plot.Replace("'", "`"); sWriters = sWriters.Replace(""", ""); string sPlot = omdbMovie.Plot.Replace("'", "`"); sPlot = sPlot.Replace(""", ""); Console.WriteLine(rating); string sSqlConnectionString = "Data Source=193.198.57.183; Initial Catalog = DotNet; User ID = vjezbe; Password = vjezbe"; using (DbConnection oConnection = new SqlConnection(sSqlConnectionString)) using (DbCommand oCommand = oConnection.CreateCommand()) { var query = "INSERT INTO Omdb_Filmovi (Title, Year, Rated, Released, Runtime, Genre, Director, Writer, Actors, Plot, Language, Country, Awards, Poster, Metascore, imdbRating, imdbVotes, imdbID, Type, DVD, BoxOffice, Production, Website, Response, Rating) VALUES ('" + omdbMovie.Title + "', '" + omdbMovie.Year + "', '" + omdbMovie.Rated + "', '" + omdbMovie.Released + "', '" + omdbMovie.Runtime + "', '" + omdbMovie.Genre + "', '" + omdbMovie.Director + "', '" + sWriters + "', '" + omdbMovie.Actors + "', '" + sPlot + "', '" + omdbMovie.Language + "', '" + omdbMovie.Country + "', '" + omdbMovie.Awards + "', '" + omdbMovie.Poster + "', '" + omdbMovie.Metascore + "', '" + sImdbRating + "', '" + omdbMovie.imdbVotes + "', '" + omdbMovie.imdbID + "', '" + omdbMovie.Type + "', '" + omdbMovie.DVD + "', '" + omdbMovie.BoxOffice + "', '" + omdbMovie.Production + "', '" + omdbMovie.Website + "', '" + omdbMovie.Response + "', '" + sRating + "')"; //Console.WriteLine(query); oCommand.CommandText = query; oConnection.Open(); using (DbDataReader reader = oCommand.ExecuteReader()) { reader.Read(); } } }
//vraca listu objekata klase omdb public OmdbMovie SearchOmdbMovie(string searchMovie, string searchYear) { string url = KreiranjeUrl(searchMovie, searchYear); string json = CallRestMethod(url); OmdbMovie _omdbMovie = JsonConvert.DeserializeObject <OmdbMovie>(json); /* * JObject jsonObject = JObject.Parse(json); * var title = jsonObject["Title"]; */ //foreach (JObject item in jsonObject) //{ new OmdbMovie { Title = (string)_omdbMovie.Title, Year = (int)_omdbMovie.Year, Rated = (string)_omdbMovie.Rated, Released = (string)_omdbMovie.Released, Runtime = (string)_omdbMovie.Runtime, Genre = (string)_omdbMovie.Genre, Director = (string)_omdbMovie.Director, Writer = (string)_omdbMovie.Writer, Actors = (string)_omdbMovie.Actors, Plot = (string)_omdbMovie.Plot, Language = (string)_omdbMovie.Language, Country = (string)_omdbMovie.Country, Awards = (string)_omdbMovie.Awards, Poster = (string)_omdbMovie.Poster, Metascore = (int)_omdbMovie.Metascore, imdbRating = (string)_omdbMovie.imdbRating, imdbVotes = (float)_omdbMovie.imdbVotes, imdbID = (string)_omdbMovie.imdbID, Type = (string)_omdbMovie.Type, DVD = (string)_omdbMovie.DVD, BoxOffice = (string)_omdbMovie.BoxOffice, Production = (string)_omdbMovie.Production, Website = (string)_omdbMovie.Website, Response = (string)_omdbMovie.Response }; //} return(_omdbMovie); }