public InsertMovie(MovieObject movie_, string Header, bool _edit = true) { InitializeComponent(); if (movie_ == null) { movie = new MovieObject(); } else { movie = movie_; } edit = _edit; Text = Header; LoadText(); LoadLanguage(); LoadCategories(); this.Height += 30; btn_Modify.Location = new Point(lb_DescFR.Location.X + 350, lb_DescFR.Location.Y + 130); btn_Modify.Visible = true; SetLabelCursor(System.Windows.Forms.Cursors.IBeam); dtp.Format = DateTimePickerFormat.Custom; dtp.CustomFormat = "dd/MM/yyyy"; // Text Hide lb_Category_Value.Hide(); lb_Date.Hide(); }
private void ImportFromIMDB() { string URL = tb_Url.Text; string id; int IndexIDStart; int IndexIDEnd; IndexIDStart = URL.IndexOf("/title/") + 7; if (IndexIDStart == -1) { throw new Exception("IMDB_ID_NOT_FOUND"); } IndexIDEnd = URL.IndexOf("/", IndexIDStart); if (IndexIDEnd == -1 && URL.IndexOf("tt") == 0) { id = URL; } else if (IndexIDEnd != -1) { id = URL.Substring(IndexIDStart, IndexIDEnd - IndexIDStart); } else { throw new Exception("ID_FORMAT_INVALID"); } MovieObject movie = Database_Connector.GetFromIMDB(id); movie.Category = CategoryObject.GetCategoryID(GetSelectedCategory()); Database_Connector.Insert.Movie(movie); }
public static void Movie(MovieObject obj) { string update = "UPDATE movies SET NAME_EN=:nameEN, NAME_FR=:nameFR, DESCRIPTION_EN=:descEN, DESCRIPTION_FR=:descFR, DIRECTORS=:directors, RELEASEDATE=:datevar, RATING=:rated, RUNTIME=:runtime, IMAGE=:image, CATEGORY=:categoryvar WHERE ID=:movieID"; OracleCommand cmd = new OracleCommand(update, GetConnection()); cmd.Parameters.Add(new OracleParameter("nameEN", obj.Nom_en)); cmd.Parameters.Add(new OracleParameter("nameFR", obj.Nom_fr)); cmd.Parameters.Add(new OracleParameter("descEN", obj.Description_en)); cmd.Parameters.Add(new OracleParameter("descFR", obj.Description_fr)); cmd.Parameters.Add(new OracleParameter("directors", obj.Director)); cmd.Parameters.Add(new OracleParameter("datevar", obj.Date)); cmd.Parameters.Add(new OracleParameter("rated", obj.Rated)); cmd.Parameters.Add(new OracleParameter("runtime", obj.Runtime)); // Add Image OracleParameter image = new OracleParameter("image", OracleDbType.Blob); Image pb_Image = obj.Poster; MemoryStream memoryStream = new MemoryStream(); pb_Image.Save(memoryStream, ImageFormat.Jpeg); byte[] imageBt = memoryStream.ToArray(); image.Value = imageBt; cmd.Parameters.Add(image); cmd.Parameters.Add(new OracleParameter("categoryvar", obj.Category)); cmd.Parameters.Add(new OracleParameter("movieID", obj.ID)); cmd.ExecuteNonQuery(); Database.Update.Movies(); }
public InsertMovie(MovieObject movie_, string Header, bool _edit = true) { InitializeComponent(); if (movie_ == null) movie = new MovieObject(); else movie = movie_; edit = _edit; Text = Header; LoadText(); LoadLanguage(); LoadCategories(); this.Height += 30; btn_Modify.Location = new Point(lb_DescFR.Location.X + 350, lb_DescFR.Location.Y + 130); btn_Modify.Visible = true; SetLabelCursor(System.Windows.Forms.Cursors.IBeam); dtp.Format = DateTimePickerFormat.Custom; dtp.CustomFormat = "dd/MM/yyyy"; // Text Hide lb_Category_Value.Hide(); lb_Date.Hide(); }
public static void Movie(MovieObject movie) { string insert = "INSERT INTO movies VALUES (MOVIEID.NEXTVAL, :name_en, :name_fr, :desc_en, :desc_fr, :directors, :releasedate, :rating, :runtime, :image, :category, :deletedate)"; OracleCommand cmd = new OracleCommand(insert, GetConnection()); cmd.Parameters.Add(new OracleParameter("name_en", movie.Nom_en)); cmd.Parameters.Add(new OracleParameter("name_fr", movie.Nom_fr)); cmd.Parameters.Add(new OracleParameter("desc_en", movie.Description_en)); cmd.Parameters.Add(new OracleParameter("desc_fr", movie.Description_fr)); cmd.Parameters.Add(new OracleParameter("directors", movie.Director)); cmd.Parameters.Add(new OracleParameter("releasedate", movie.Date)); cmd.Parameters.Add(new OracleParameter("rating", movie.Rated)); cmd.Parameters.Add(new OracleParameter("runtime", movie.Runtime)); // Add Image OracleParameter image = new OracleParameter("image", OracleDbType.Blob); Image pb_Image = movie.Poster; MemoryStream memoryStream = new MemoryStream(); pb_Image.Save(memoryStream, ImageFormat.Jpeg); byte[] imageBt = memoryStream.ToArray(); image.Value = imageBt; cmd.Parameters.Add(image); cmd.Parameters.Add(new OracleParameter("category", movie.Category)); cmd.Parameters.Add(new OracleParameter("deletedate", DBNull.Value)); cmd.ExecuteNonQuery(); CloseConnection(); Database.Update.Movies(); }
private MovieObject GetMovieFromSelectedRow() { foreach (DataGridViewRow row in dgv_SearchResults.SelectedRows) { MovieObject movie = new MovieObject(); DateTime date = (DateTime)row.Cells[6].Value; movie.ID = int.Parse(row.Cells[0].Value.ToString()); movie.Nom_en = row.Cells[1].Value.ToString(); movie.Nom_fr = row.Cells[2].Value.ToString(); movie.Description_en = row.Cells[3].Value.ToString(); movie.Description_fr = row.Cells[4].Value.ToString(); movie.Director = row.Cells[5].Value.ToString(); movie.Date = date; movie.Rated = row.Cells[7].Value.ToString(); movie.Runtime = int.Parse(row.Cells[8].Value.ToString()); var data = (Byte[])(row.Cells[9].Value); var stream = new MemoryStream(data); movie.Poster = Image.FromStream(stream); movie.Category = CategoryObject.GetCategoryID(row.Cells[11].Value.ToString()); return(movie); } return(new MovieObject()); }
private void SaveFinalMovie() { finalMovie = new MovieObject(); finalMovie.Poster = pictureBox1.Image; finalMovie.Nom_en = lb_TitreEN.Text; finalMovie.Nom_fr = lb_TitreFR.Text; finalMovie.Description_en = lb_DescEN.Text; finalMovie.Description_fr = lb_DescFR.Text; finalMovie.Rated = lb_Rating.Text; finalMovie.Runtime = int.Parse(lb_Time.Text); finalMovie.Director = lb_Director.Text; }
private void btn_Modify_Click(object sender, EventArgs e) { try { MovieObject oMovie = new MovieObject(); oMovie.Category = CategoryObject.GetCategoryID(cb_Categories.Text); oMovie.ID = movie.ID; oMovie.Nom_en = lb_TitreEN.Text.ToString(); oMovie.Nom_fr = lb_TitreFR.Text.ToString(); oMovie.Description_fr = lb_DescFR.Text.ToString(); oMovie.Description_en = lb_DescEN.Text.ToString(); //oMovie.Date = DateTime.ParseExact(date, "dd/MM/yyyy", CultureInfo.InvariantCulture); oMovie.Date = DateTime.ParseExact(dtp.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); oMovie.Rated = lb_Rating.Text.ToString(); oMovie.Runtime = int.Parse(lb_Time.Text.ToString()); oMovie.Director = lb_Director.Text.ToString(); oMovie.Poster = pictureBox1.Image; Database_Connector.Update.Movie(oMovie); MessageBox.Show("Modification fait!"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private MovieObject GetMovieFromSelectedRow() { foreach (DataGridViewRow row in dgv_SearchResults.SelectedRows) { MovieObject movie = new MovieObject(); DateTime date = (DateTime)row.Cells[6].Value; movie.ID = int.Parse(row.Cells[0].Value.ToString()); movie.Nom_en = row.Cells[1].Value.ToString(); movie.Nom_fr = row.Cells[2].Value.ToString(); movie.Description_en = row.Cells[3].Value.ToString(); movie.Description_fr = row.Cells[4].Value.ToString(); movie.Director = row.Cells[5].Value.ToString(); movie.Date = date; movie.Rated = row.Cells[7].Value.ToString(); movie.Runtime = int.Parse(row.Cells[8].Value.ToString()); var data = (Byte[])(row.Cells[9].Value); var stream = new MemoryStream(data); movie.Poster = Image.FromStream(stream); movie.Category = CategoryObject.GetCategoryID(row.Cells[11].Value.ToString()); return movie; } return new MovieObject(); }
public static MovieObject GetFromIMDB(string id) { string url = "http://www.omdbapi.com/?i=" + id + "&plot=full&r=json"; string urlfr = "https://api.themoviedb.org/3/find/" + id + "?external_source=imdb_id&language=fr&api_key=51418c9e34d1e5629a84126ff72fe09a"; string json; string jsonfr; MovieObject movie; using (WebClient wc = new WebClient()) { wc.Encoding = System.Text.Encoding.UTF8; json = wc.DownloadString(url); jsonfr = wc.DownloadString(urlfr); } dynamic data = JObject.Parse(json); dynamic datafr = JObject.Parse(jsonfr); try { movie = new MovieObject(); string runtime = data["Runtime"]; runtime = new String(runtime.TakeWhile(Char.IsDigit).ToArray()); if (runtime.Equals(string.Empty)) { runtime = "0"; } string Year = data["Year"]; Year = new String(Year.TakeWhile(Char.IsDigit).ToArray()); if (Year.Equals(string.Empty)) { Year = "0"; } string date = data["Released"]; // EN movie.Nom_en = data["Title"]; movie.Description_en = data["Plot"]; movie.Rated = data["Rated"]; movie.Runtime = int.Parse(runtime); movie.Year = int.Parse(Year); // Released -> Release date. movie.Date = DateTime.ParseExact(date, "dd MMM yyyy", CultureInfo.InvariantCulture); movie.Director = data["Director"]; // FR movie.Description_fr = datafr["movie_results"][0]["overview"]; movie.Nom_fr = datafr["movie_results"][0]["title"]; string imgurl = data["Poster"]; // Load Image var request = WebRequest.Create(imgurl); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { movie.Poster = Bitmap.FromStream(stream); } } catch (Exception e) { movie = null; } return(movie); }
private void btn_Modify_Click(object sender, EventArgs e) { try { MovieObject oMovie = new MovieObject(); oMovie.Category = CategoryObject.GetCategoryID(cb_Categories.Text); oMovie.ID = movie.ID; oMovie.Nom_en = lb_TitreEN.Text.ToString(); oMovie.Nom_fr = lb_TitreFR.Text.ToString(); oMovie.Description_fr = lb_DescFR.Text.ToString(); oMovie.Description_en = lb_DescEN.Text.ToString(); //oMovie.Date = DateTime.ParseExact(date, "dd/MM/yyyy", CultureInfo.InvariantCulture); oMovie.Date = DateTime.ParseExact(dtp.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); oMovie.Rated = lb_Rating.Text.ToString(); oMovie.Runtime = int.Parse(lb_Time.Text.ToString()); oMovie.Director = lb_Director.Text.ToString(); oMovie.Poster= pictureBox1.Image; Database_Connector.Update.Movie(oMovie); MessageBox.Show("Modification fait!"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static MovieObject GetFromIMDB(string id) { string url = "http://www.omdbapi.com/?i=" + id + "&plot=full&r=json"; string urlfr = "https://api.themoviedb.org/3/find/" + id + "?external_source=imdb_id&language=fr&api_key=51418c9e34d1e5629a84126ff72fe09a"; string json; string jsonfr; MovieObject movie; using (WebClient wc = new WebClient()) { wc.Encoding = System.Text.Encoding.UTF8; json = wc.DownloadString(url); jsonfr = wc.DownloadString(urlfr); } dynamic data = JObject.Parse(json); dynamic datafr = JObject.Parse(jsonfr); try { movie = new MovieObject(); string runtime = data["Runtime"]; runtime = new String(runtime.TakeWhile(Char.IsDigit).ToArray()); if (runtime.Equals(string.Empty)) runtime = "0"; string Year = data["Year"]; Year = new String(Year.TakeWhile(Char.IsDigit).ToArray()); if (Year.Equals(string.Empty)) Year = "0"; string date = data["Released"]; // EN movie.Nom_en = data["Title"]; movie.Description_en = data["Plot"]; movie.Rated = data["Rated"]; movie.Runtime = int.Parse(runtime); movie.Year = int.Parse(Year); // Released -> Release date. movie.Date = DateTime.ParseExact(date, "dd MMM yyyy", CultureInfo.InvariantCulture); movie.Director = data["Director"]; // FR movie.Description_fr = datafr["movie_results"][0]["overview"]; movie.Nom_fr = datafr["movie_results"][0]["title"]; string imgurl = data["Poster"]; // Load Image var request = WebRequest.Create(imgurl); using (var response = request.GetResponse()) using (var stream = response.GetResponseStream()) { movie.Poster = Bitmap.FromStream(stream); } } catch (Exception e) { movie = null; } return movie; }