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); }
}
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;
}
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;
}
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 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();
}
