private void UpdatingForm_Load(object sender, EventArgs e) { MovieClass Movie = new MovieClass(); double count = 0; int NumberOfUpdates = NumberOfUpdatedItems(); for (int i = 0; i < MovieList.Items.Count; i++) { if (MovieList.GetItemChecked(i) == true) { Movie = new MovieClass(MovieList.Items[i].ToString()); MovieName.Text = "Updating: " + Movie.Movie_Name; count += 100.0 / NumberOfUpdates; progressBar1.Value = (int)(count + .5) <= 100 ? (int)(count + .5) : 100; Thread newThread = new Thread(new ThreadStart(Movie.Update_Movie)); try { newThread.Start(); newThread.Join(); } catch { } } } this.Close(); }
private void Create_Movie_File() { try { MovieClass Movie = new MovieClass(); Movie.Movie_Name = AddBox.Text; Movie.Set_Year(YearBox.Text); Movie.Set_Mark(MarkBox.Text); if (IMDBBox.Text.IndexOf("http") == -1) IMDBBox.Text = "http://" + IMDBBox.Text; Movie.Set_IMDB_Adress(IMDBBox.Text); if (TBDBox.Checked == true) Movie.Set_Date("-1", "-1", "-1"); else if ((NoDBox.Checked == true || DateMonth.Text == "Month" || DateDay.Text == "Day" || DateYear.Text == "Year") && TodayButton.Checked == false) Movie.Set_Date("0", "0", "0"); else if (TodayButton.Checked == true) Movie.Set_Date(DateTime.Now.Day.ToString(), DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString()); else Movie.Set_Date(DateDay.Text, DateMonth.Text, DateYear.Text); Movie.Update_Informations(); } catch { } }
private void Add_MovieToList(string movieName) { try { MovieClass movie = new MovieClass(movieName); ListViewItem item = new ListViewItem(movie.Movie_Name); item.SubItems.Add(movie.Get_Genre(1)); item.SubItems.Add(movie.Get_Mark()); item.SubItems.Add(movie.Get_Year()); item.SubItems.Add(movie.Director); if (movie.Runtime != null) item.SubItems.Add(movie.Runtime.Replace(" min", "")); else item.SubItems.Add("Unknown"); if (movie.Get_Date_Year() == -1) item.SubItems.Add("Not viewed yet"); else if (movie.Get_Date_Year() == 0) item.SubItems.Add("Unknown"); else item.SubItems.Add(movie.Get_Date_Month().ToString() + "/" + movie.Get_Date_Day().ToString() + "/" + movie.Get_Date_Year().ToString()); item.SubItems.Add(movie.Get_Country(0)); item.SubItems.Add(movie.Get_Language(0)); //item.SubItems.Add(Name); MovieList.Items.Add(item); } catch { Error_Message(); } }
public TrailerForm(MovieClass movie) { InitializeComponent(); Movie = movie; this.Text = Movie.Movie_Name + "'s Trailer"; }
public Form6(MovieClass movie,bool Edit) { InitializeComponent(); Movie = movie; ReviewTextBox.Text = Movie.Get_Review().Replace(@"\n",Environment.NewLine); if (!Edit) { menuStrip1.Visible = false; ReviewTextBox.BackColor = Color.White; ReviewTextBox.ReadOnly = true; contextMenuStrip1.Items[0].Enabled = contextMenuStrip1.Items[1].Enabled = contextMenuStrip1.Items[2].Enabled = contextMenuStrip1.Items[3].Enabled = contextMenuStrip1.Items[5].Enabled = false; } }
private void button1_Click(object sender, EventArgs e) { MovieClass movie = new MovieClass(); movie.Movie_Name = Title.Text; movie.Set_IMDB_Adress(link); Form4 form = new Form4(movie); form.ShowDialog(); if (form.DialogResult == DialogResult.Cancel) return; DataBaseManipulation.InsertMovie(movie); movie.Update_Movie(); updated = true; }
private void Addbutton_Click(object sender, EventArgs e) { MovieClass Movie = new MovieClass(); Movie = Movies[ListOfMovies.SelectedIndices[0]]; Movie.Movie_Name = WorkerClass.AvailableFolderName(Movies[ListOfMovies.SelectedIndices[0]].MovieName); Movie.Update_Movie(); WorkerClass.WriteFile("Movies.txt", Movie.Movie_Name, true); Form4 form = new Form4(Movie); if (form.ShowDialog() == DialogResult.Cancel) WorkerClass.DeleteFolder(Movie.Movie_Name); else added = true; }
private void SaveInFile(string fileName, List<string> movies) { StreamWriter f = new StreamWriter(fileName); try { MovieClass[] Movies = new MovieClass[movies.Count]; int i = 0; foreach(string movie in movies) Movies[i++] = new MovieClass(movie); Array.Sort(Movies, new DateComparer()); foreach(MovieClass Movie in Movies) { if (NameBox.Checked == true) f.Write(Movie.Movie_Name + " "); if (YearBox.Checked == true) f.Write("(" + Movie.Get_Year() + ") "); if (MarkBox.Checked == true) f.Write("- " + Movie.Get_Mark()+"/10"); if (DateBox.Checked == true) f.Write(" (" + Movie.Get_Date_Day() + "/" + Movie.Get_Date_Month() + "/" + Movie.Get_Date_Year() + ")"); f.WriteLine(); f.WriteLine(); } } catch { f.Close(); } f.Close(); }
private void SaveInFileXML(string fileName, List<string> movies) { try { MovieClass[] Movies = new MovieClass[movies.Count]; int i = 0; foreach(string movie in movies) Movies[i++] = (new MovieClass(movie)); Array.Sort(Movies,new DateComparer()); XmlTextWriter writer = new XmlTextWriter(fileName, Encoding.UTF8); writer.WriteStartDocument(); writer.WriteStartElement("movielist"); foreach(MovieClass Movie in Movies) { writer.WriteStartElement("movie"); writer.WriteStartElement("name"); writer.WriteString(Movie.Movie_Name); writer.WriteEndElement(); if (YearBox.Checked == true) { writer.WriteStartElement("year"); writer.WriteString(Movie.Get_Year()); writer.WriteEndElement(); } if (MarkBox.Checked == true) { writer.WriteStartElement("mark"); writer.WriteString(Movie.Get_Mark()); writer.WriteEndElement(); } if (DateBox.Checked == true) { writer.WriteStartElement("date"); writer.WriteString(Movie.Get_Date_Day() + "/" + Movie.Get_Date_Month() + "/" + Movie.Get_Date_Year()); writer.WriteEndElement(); } writer.WriteEndElement(); //movie } writer.WriteEndElement(); writer.WriteEndDocument(); writer.Close(); } catch { } }
private void toolStripButton6_Click(object sender, EventArgs e) { try { Form6 form = new Form6(Movie, true); form.Text = Movie.Movie_Name + "'s review edit"; form.ShowDialog(); Movie = new MovieClass(Movie.Movie_Name); ReviewRichTextBox.Text = Movie.Get_Review().Replace(@"\n", Environment.NewLine).Replace(@"\r", Environment.NewLine); } catch { Error_Message(); } }
private void toolStripButton8_Click(object sender, EventArgs e) { JumpForm form = new JumpForm(); if (form.ShowDialog() == DialogResult.OK) { Movie = new MovieClass(form.Result); Update_Movie_Details(Movie); for (int i = 0; i < MovieList.Items.Count; i++) if (form.Result.ToUpper() == MovieList.Items[i].Text.ToUpper()) MovieList.Items[i].Selected = true; } }
private void MovieList_SelectedIndexChanged(object sender, EventArgs e) { if (MovieList.SelectedIndices.Count > 0) { Movie = new MovieClass(MovieList.SelectedItems[0].Text); Update_Movie_Details(Movie); } }
private void reloadToolStripMenuItem_Click(object sender, EventArgs e) { Movie = new MovieClass(MovieList.SelectedItems[0].Text); Update_MovieList(MovieList.SelectedIndices[0]); Update_Movie_Details(Movie); }
private void clearToolStripMenuItem_Click(object sender, EventArgs e) { try { string ClearingMovie = MovieList.SelectedItems[0].Text.ToString(); MovieClass movie = new MovieClass(ClearingMovie); if (Directory.Exists("images\\" + movie.Index.ToString() + " Stars") == true) Directory.Delete("images\\" + movie.Index.ToString() + " Stars", true); if (File.Exists("images\\" + movie.Index.ToString() + ".jpg") == true) File.Delete("images\\" + movie.Index.ToString() + ".jpg"); Movie = new MovieClass(ClearingMovie); MovieClass MovieAux = new MovieClass(); MovieAux.Movie_Name = Movie.Movie_Name; MovieAux.Set_Date(Movie.Get_Date_Day().ToString(), Movie.Get_Date_Month().ToString(), Movie.Get_Date_Year().ToString()); MovieAux.Set_IMDB_Adress(Movie.Get_IMDB_Adress()); MovieAux.Set_Mark(Movie.Get_Mark()); MovieAux.Set_Review(Movie.Get_Review()); if (DataBaseManipulation.DefaultMovie().Movie_Name == MovieAux.Movie_Name) MovieAux.Default = true; DataBaseManipulation.UpdateMovie(MovieAux); Update_Movie_Details(MovieAux); reloadToolStripMenuItem_Click(sender, e); MessageBox.Show("\"" + ClearingMovie + "\" was successfully cleaned!", "Successfully cleaned", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { Error_Message(); } }
private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Are you sure you want to delete \"" + Movie.Movie_Name + "\" movie?", "Delete movie", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { string DeletedMovie = MovieList.SelectedItems[0].Text; MovieClass movie = new MovieClass(DeletedMovie); if (Directory.Exists("images\\" + movie.Index.ToString() + " Stars")) Directory.Delete("images\\" + movie.Index.ToString() + " Stars", true); if (File.Exists("images\\" + movie.Index.ToString() + ".jpg")) File.Delete("images\\" + movie.Index.ToString() + ".jpg"); DataBaseManipulation.DeleteMovieFromDB(DeletedMovie); MovieList.SelectedItems[0].Remove(); if (MovieList.Items.Count > 0) { if (DataBaseManipulation.DefaultMovie().Movie_Name != null) Update_Movie_Details(DataBaseManipulation.DefaultMovie()); else Movie = new MovieClass(MovieList.Items[0].Text); } } } catch { return; } }
public static void UpdateMovie(MovieClass Movie,int LastIndex) { try { if (DBCon.ConnectionString == "") { DBCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Directory.GetCurrentDirectory() + "\\Movies.mdb;User Id=Admin;Password=;"; DBCon.Open(); } string command = "UPDATE Movies SET "; command += "Name = '" + WorkerClass.StringWithoutApostrophe(Movie.Movie_Name) + "',"; command += "[Year] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Year()) + "',"; command += "[Mark] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Mark()) + "',"; command += " IMDb_Adress = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_IMDB_Adress()) + "',"; command += " [Date] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Month().ToString()) + "/" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Day().ToString()) + "/" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Year().ToString()) + "',"; command += " [Review] = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_Review()) + "',"; command += " RunTime = '" + Movie.Runtime + "',"; command += " IMDb_Name = '" + WorkerClass.StringWithoutApostrophe(Movie.Get_IMDB_Name()) + "',"; command += " IMDb_Mark = '" + Movie.Get_IMDB_Mark() + "',"; command += " DirectorName = '" + WorkerClass.StringWithoutApostrophe(Movie.Director) + "',"; command += " DirectorWebLink = '" + Movie.DirectorLink + "',"; command += " [Country] = '" + WorkerClass.StringWithApostrophe(WorkerClass.ListToString(Movie.Get_Country())) + "',"; command += " Stars = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Stars())) + "',"; command += " StarsLink = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_StarsLink())) + "',"; command += " Genres = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Genre())) + "',"; command += " [Language] = '" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Language())) + "',"; command += " Tags = '" + WorkerClass.StringWithApostrophe(WorkerClass.ListToString(Movie.Get_Tags())) + "',"; command += " StoryLine = '" + WorkerClass.StringWithoutApostrophe(Movie.Storyline) + "',"; command += " TrailerMovie = '" + WorkerClass.StringWithoutApostrophe(Movie.MovieTrailer) + "',"; command += " DefaultMovie = " + (Movie.Default ? 1 : 0).ToString() + ","; command += " MPAA = '" + WorkerClass.StringWithoutApostrophe(Movie.MPAA_Rating) + "',"; command += " Prizes = '" + WorkerClass.StringWithoutApostrophe(Movie.Prize) + "'"; command += " WHERE Index = " + LastIndex; OleDbCommand DBCom = new OleDbCommand(command, DBCon); DBCom.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Form4(MovieClass MovieCl) { InitializeComponent(); Movie = MovieCl; }
private void Update_MovieList(int index) { try { MovieClass movie = new MovieClass(MovieList.Items[index].Text); MovieList.Items[index].Text = movie.Movie_Name; MovieList.Items[index].SubItems[1].Text = movie.Get_Genre(0); MovieList.Items[index].SubItems[2].Text = movie.Get_Mark(); MovieList.Items[index].SubItems[3].Text = movie.Get_Year(); MovieList.Items[index].SubItems[4].Text = movie.Director; if (movie.Runtime != null) MovieList.Items[index].SubItems[5].Text = movie.Runtime.Replace(" min", ""); else MovieList.Items[index].SubItems[5].Text = "Unknown"; if (movie.Get_Date_Year() == 0) MovieList.Items[index].SubItems[6].Text = "Unknown"; else MovieList.Items[index].SubItems[6].Text = movie.Get_Date_Month().ToString() + "/" + movie.Get_Date_Day().ToString() + "/" + movie.Get_Date_Year().ToString(); MovieList.Items[index].SubItems[7].Text = movie.Get_Country(0); MovieList.Items[index].SubItems[8].Text = movie.Get_Language(0); } catch { return; } }
private void UpdateList() { try { int index = 0; string DefaultName = DataBaseManipulation.DefaultMovie().Movie_Name; Update_MovieList(); for (index = 0; index < MovieList.Items.Count && MovieList.Items[index].Text != DefaultName; index++) ; if (index >= MovieList.Items.Count) { Movie = new MovieClass(MovieList.Items[0].Text); MovieList.Items[0].Selected = true; Update_Movie_Details(Movie); } else { Movie = new MovieClass(DefaultName); MovieList.Items[index].Selected = true; Update_Movie_Details(Movie); } } catch { } }
private void SetMovieTrailer(MovieClass Movie) { try { if (Movie.MovieTrailer == null || Movie.MovieTrailer == "") { axShockwaveFlash1.Movie = "http://www.youtube.com/v/" + Movies[0].Key; MovieListTrailers.Items[0].Selected = true; } else { bool Exist = false; axShockwaveFlash1.Movie = "http://www.youtube.com/v/" + Movie.MovieTrailer; for (int i = 0; i < Movies.Count; i++) if (Movies[i].Key == Movie.MovieTrailer) { MovieListTrailers.Items[i].Selected = true; Exist = true; } if (!Exist) AddMovieTrailer(Movie.MovieTrailer); } } catch { return; } }
public MovieForm(MovieClass movie) { InitializeComponent(); Movie = movie; }
private void TakeTrailerMovieList(MovieClass Movie) { try { if (Movie.Get_IMDB_Name() != null) Movies = WorkerClass.Movie_Trailer_Link(Movie.Get_IMDB_Name()); else Movies = WorkerClass.Movie_Trailer_Link(Movie.Movie_Name); } catch { return; } }
private void Update_MovieList() { MovieClass movie = new MovieClass(); for (; MovieList.Items.Count > 0; MovieList.Items[0].Remove()) ; List<string> MovieNameList = DataBaseManipulation.MovieDetails("Name"); foreach(string MovieName in MovieNameList) { movie = new MovieClass(MovieName); if (movie.Movie_Name != null) { ListViewItem item = new ListViewItem(movie.Movie_Name); item.SubItems.Add(movie.Get_Genre(0)); item.SubItems.Add(movie.Get_Mark()); item.SubItems.Add(movie.Get_Year()); item.SubItems.Add(movie.Director); if (movie.Runtime != null) item.SubItems.Add(movie.Runtime.Replace(" min", "")); else item.SubItems.Add("Unknown"); if (movie.Get_Date_Year() == -1) item.SubItems.Add("Not yet viewed"); else if (movie.Get_Date_Year() == 0) item.SubItems.Add("Unknown"); else item.SubItems.Add(movie.Get_Date_Month().ToString() + "/" + movie.Get_Date_Day().ToString() + "/" + movie.Get_Date_Year().ToString()); item.SubItems.Add(movie.Get_Country(0)); item.SubItems.Add(movie.Get_Language(0)); //item.SubItems.Add(Name); MovieList.Items.Add(item); } } }
private void propertiesToolStripMenuItem_Click(object sender, EventArgs e) { try { MovieClass Movie = new MovieClass(); Movie = Movies[ListOfMovies.SelectedIndices[0]]; Movie.Update_Movie(); Movie.Movie_Name = Movies[ListOfMovies.SelectedIndices[0]].MovieName; Thread.Sleep(1000); MovieForm form = new MovieForm(Movie); form.ShowDialog(); form.Dispose(); WorkerClass.DeleteFolder(Movie.Movie_Name); } catch { } }
private void Update_Movie_Details(MovieClass Movie) { try { Size tempSize = new Size(252, 20); Update_Stars_Movie_Details(); MoviePoster.ImageLocation = "images\\" + Movie.Index.ToString() + ".jpg"; MovieName.Text = Movie.Movie_Name; try { tempSize.Width = (int)(252 * float.Parse(Movie.Get_Mark()) / 10); TopPicture.Size = tempSize; TopPicture.Visible = true; pictureBox2.Visible = true; } catch { TopPicture.Visible = false; pictureBox2.Visible = false; } try { tempSize.Width = (int)(252 * float.Parse(Movie.Get_IMDB_Mark()) / 10); TopPictureMark.Size = tempSize; TopPictureMark.Visible = true; pictureBox1.Visible = true; } catch { TopPictureMark.Visible = false; pictureBox1.Visible = false; } MarkName.Text = Movie.Get_Mark(); if (Movie.Get_IMDB_Name() != null) IMDBName.Text = "( " + Movie.Get_IMDB_Name() + " )"; else IMDBName.Text = "( " + Movie.Movie_Name + " ) - no Update"; MovieNam.Text = Movie.Movie_Name; if (Movie.Get_IMDB_Mark() == null) IMDBMarkDate.Text = "Unknown"; else IMDBMarkDate.Text = Movie.Get_IMDB_Mark(); if ((Movie.Get_Date_Day() != 0 || Movie.Get_Date_Month() != 0 || Movie.Get_Date_Year() != 0) && Movie.Get_Date_Year() != -1) DateDate.Text = Movie.Get_Date_Month().ToString() + "/" + Movie.Get_Date_Day().ToString() + "/" + Movie.Get_Date_Year().ToString(); else if (Movie.Get_Date_Year() == -1) DateDate.Text = "Not viewed yet"; else DateDate.Text = "Unknown"; ReviewRichTextBox.Text = Movie.Get_Review().Replace(@"\n", Environment.NewLine); DirectorDate.Text = Movie.Director; DescriptionTextBox.Text = Movie.Storyline; try { tempSize = new Size(61, 20); YearDate.Size = tempSize; YearDate.Text = int.Parse(Movie.Get_Year()).ToString(); } catch { tempSize = new Size(100, 20); YearDate.Size = tempSize; YearDate.Text = Movie.Get_Year(); } List<string> Aux = new List<string>(); ComboGenreDate.Items.Clear(); ComboGenreDate.Text = Movie.Get_Genre(0); Aux = Movie.Get_Genre(); foreach(string genre in Aux) ComboGenreDate.Items.Add(genre); RuntimeDate.Text = Movie.Runtime; MPAAtext.Text = Movie.MPAA_Rating; CountryDate.Items.Clear(); CountryDate.Text = Movie.Get_Country(0); Aux = Movie.Get_Country(); foreach(string country in Aux) CountryDate.Items.Add(country); LanguageDate.Items.Clear(); LanguageDate.Text = Movie.Get_Language(0); Aux = Movie.Get_Language(); foreach(string language in Aux) LanguageDate.Items.Add(language); toolTip1.SetToolTip(DirectorWebLink, "Visit " + Movie.Director + "'s page"); Tags.Items.Clear(); if (Movie.Get_Tags().Count > 0) { Tags.Text = Movie.Get_Tag(0); foreach (string tag in Movie.Get_Tags()) Tags.Items.Add(tag); } else Tags.Text = "Unknown"; PrizesBox.Text = Movie.Prize; toolTip2.SetToolTip(OscarButton, "Visit " + Movie.Movie_Name + "'s Gallery of Trophies"); } catch { } }
public static int InsertMovie(MovieClass Movie) { try { if (DBCon.ConnectionString == "") { DBCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Directory.GetCurrentDirectory()+"\\Movies.mdb;User Id=Admin;Password=;"; DBCon.Open(); } new OleDbCommand("INSERT INTO Movies ([Name]) VALUES('Google.txt')", DBCon).ExecuteNonQuery(); OleDbDataReader reader = MovieDBReader("Google.txt"); reader.Read(); UpdateMovie(Movie, int.Parse(reader["Index"].ToString())); /*string command = "INSERT INTO Movies VALUES("; command += (int.Parse(reader["Index"].ToString())+1).ToString(); command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Movie_Name) + "'"; command += ",'" + Movie.Get_Year() + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Get_Mark()) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Get_IMDB_Adress()) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Month().ToString()) + "/" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Day().ToString()) + "/" + WorkerClass.StringWithoutApostrophe(Movie.Get_Date_Year().ToString()) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Get_Review()) + "'"; command += ",'" + Movie.Runtime + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Get_IMDB_Name()) + "'"; command += ",'" + Movie.Get_IMDB_Mark() + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Director) + "'"; command += ",'" + Movie.DirectorLink + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Genre())) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Stars())) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_StarsLink())) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Genre())) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(WorkerClass.ListToString(Movie.Get_Tags())) + "'"; command += ",'" + WorkerClass.ListToString(Movie.Get_Language()) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.Storyline) + "'"; command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.MovieTrailer) + "'"; command += "," + (Movie.Default ? 1 : 0).ToString(); command += ",'" + WorkerClass.StringWithoutApostrophe(Movie.MPAA_Rating) + "')"; OleDbCommand DBCom = new OleDbCommand(command, DBCon); //OleDbDataReader reader = DBCom.ExecuteReader(); DBCom.ExecuteNonQuery(); //MessageBox.Show(Movie.Movie_Name + " Successfully Updated!", "Updated"); //for (; reader.Read(); ) //MessageBox.Show("Command : " + reader["Name"].ToString() + " was executed !!!", "Executed"); return 1;*/ return 1; } catch { return 0; } }