private void mnuStripGenerate_Click(object sender, EventArgs e) { try { if (this.dgvMovie.DataSource.Rows.Count > 0) { if (saveScript.ShowDialog() == DialogResult.OK) { DataTable dt = new DataTable(); dt = Movie_SP.RequestMovieCopyGetList(); InsertManager im = new InsertManager(false, false); string file = saveScript.FileName; bool a = im.GenerateCopyRequestScript(dt, file); if (a == true) { MessageBox.Show(Messages.ScriptGeneratedSuccessfuly, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(Messages.ScriptGenerationFailed, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { throw new Exception(Messages.NoMovieToCopyScript); } } catch (Exception ex) { MessageBox.Show(ex.Message, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void mnuStripLoad_Click(object sender, EventArgs e) { try { if (openScript.ShowDialog() == DialogResult.OK) { if (File.Exists(openScript.FileName) == true) { long failed = 0; long notFound = 0; string file = openScript.FileName; DataTable dt = new DataTable(); InsertManager im = new InsertManager(false, false); dt = im.LoadCopyRequestScript(file, out failed, out notFound); if (dt.Rows.Count > 0) { dgvMovie.DataSource = dt; this.dataSource = dt; } else if (dt.Rows.Count == 0 && notFound == 0) { throw new Exception(Messages.NoMovieToLoadScript); } if (notFound > 0) { MessageBox.Show(Messages.SomeMoviesNotLoadInScript.Replace("@NUM@", notFound.ToString()).Replace(@"\n", Environment.NewLine), Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { throw new Exception(Messages.SelectFilePath); } } } catch (Exception ex) { MessageBox.Show(ex.Message, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnCopy_Click(object sender, EventArgs e) { try { string destination = txtCopy.Text; if (Directory.Exists(destination) == true) { DataTable dtMovies = Movie_SP.RequestMovieCopyGetList(); if (dtMovies.Rows.Count > 0) { btnCopy.Enabled = false; btnClear.Enabled = false; InsertManager im = new InsertManager(false, false); List <string> notFounded = new List <string>(); try { float size = im.CalculateSize(dtMovies, iMovieBase.MovieRootPath); if (MessageBox.Show("Size to copy is about: " + SizeUtils.GetSizeString(size, SizeModeEnum.HumanReadable) + Environment.NewLine + "Start copying?", "iMovie", MessageBoxButtons.OKCancel) == DialogResult.OK) { notFounded = im.CopyMovies(destination, dtMovies, iMovieBase.MovieRootPath); } } catch (Exception ex) { throw ex; } finally { this.dataSource = Movie_SP.RequestMovieCopyGetList(); dgvMovie.DataSource = dataSource; } if (notFounded.Count > 0) { MessageBox.Show(Messages.RemainingMoviesNotFound, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } btnCopy.Enabled = true; btnClear.Enabled = true; } else { throw new Exception(Messages.NoMovieToCopy); } } else { throw new Exception(Messages.SelectDestinationPath); } } catch (Exception ex) { btnCopy.Enabled = true; btnClear.Enabled = true; MessageBox.Show(ex.Message, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnView_Click(object sender, EventArgs e) { try { enFilterType languageFilter = enFilterType.Any; if (radExactLanguage.Checked == true) { languageFilter = enFilterType.Exact; } enFilterType genreFilter = enFilterType.Any; if (radExactGenre.Checked == true) { genreFilter = enFilterType.Exact; } enFilterType directorFilter = enFilterType.Any; if (radExactDirector.Checked == true) { directorFilter = enFilterType.Exact; } enFilterType actorFilter = enFilterType.Any; if (radExactActor.Checked == true) { actorFilter = enFilterType.Exact; } int count = Convert.ToInt32(txtCount.Value); bool?isSeen = null; if (chkSeen.Checked == true && chkNotSeen.Checked == false) { isSeen = true; } else if (chkSeen.Checked == false && chkNotSeen.Checked == true) { isSeen = false; } bool?isFavorite = null; if (chkFavorite.Checked == true) { isFavorite = true; } double imdbLow = Convert.ToDouble(dropRateLow.SelectedItem); double imdbUp = Convert.ToDouble(dropRateUp.SelectedItem); int productLow = 1900; int productUp = DateTime.Now.Year; if (Movie.IsProductYear(txtProductLow.Text) == true) { productLow = Convert.ToInt32(txtProductLow.Text); } if (Movie.IsProductYear(txtProductUp.Text) == true) { productUp = Convert.ToInt32(txtProductUp.Text); } string durationLow = "00:00:00"; string durationUp = "20:00:00"; if (Movie.IsDuration(txtDurationLow.Text) == true) { durationLow = txtDurationLow.Text; } if (Movie.IsDuration(txtDurationUp.Text) == true) { durationUp = txtDurationUp.Text; } string movieName = txtMovieName.Text; string[] quality = chkQuality.SelectedID; if (quality.Length == 0 || chkQuality.SelectAll == true) { quality = null; } string[] language = chkLanguage.SelectedID; if (language.Length == 0 || chkLanguage.SelectAll == true) { language = null; } string[] genre = dgvGenre.SelectedID; if (genre.Length == 0 || dgvGenre.SelectAll == true) { genre = null; } string[] director = dgvDirector.SelectedID; if (director.Length == 0 || dgvDirector.SelectAll == true) { director = null; } string[] actor = dgvActor.SelectedID; if (actor.Length == 0 || dgvActor.SelectAll == true) { actor = null; } InsertManager insertManager = new InsertManager(false, false); List <Movie> excludedMovies = new List <Movie>(); foreach (PathSource pathSource in pathListBox.DataSource) { excludedMovies.AddRange(insertManager.GetMovieListFromPath(pathSource.PathString)); } List <Movie> duplicateMovies = new List <Movie>(); duplicateMovies = Movie_SP.GetDuplicateMoviesInSource(excludedMovies); DataTable dtMovies = Movie_SP.SuggestRandom(count, movieName, productLow, productUp, imdbLow, imdbUp, durationLow, durationUp, isSeen, isFavorite, director, directorFilter, actor, actorFilter, genre, genreFilter, language, languageFilter, quality, duplicateMovies); Movie[] suggestedMovies = new Movie[0]; suggestedMovies = Movie.FetchAllMovie(dtMovies); if (suggestedMovies.Length == 1) { if (FormManager.IsFormOpen(enForms.frmMovie, suggestedMovies[0].MovieID) == false) { frmMovie movieTemp = new frmMovie(suggestedMovies[0].MovieID); movieTemp.Show(); } } else if (suggestedMovies.Length > 1) { if (FormManager.IsFormOpen(enForms.frmMovieSuggestList, suggestedMovies) == false) { frmMovieSuggestList suggestList = new frmMovieSuggestList(suggestedMovies); suggestList.Show(); } } else { MessageBox.Show(Messages.NoMovieFound, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBox.Show(ex.Message, Messages.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public SqlQuery ToQuery() { var manager = new InsertManager <TableType>(); return(manager.ToQuery(instances)); }