/// <summary>
/// Returns true if this object equals the value passed in.
/// </summary>
/// <param name="s">Other object to compare to.</param>
/// <returns>True if this == obj, false otherwise.</returns>
public bool Equals(Showtime s)
{
// Return true if all fields match:
return(MovieTitle.Equals(s.MovieTitle) &&
Theater.Equals(s.Theater) &&
Time.Equals(s.Time));
}
//Button For Delete Movie (This button used for delete movie)
private void DeleteMovie_Click(object sender, EventArgs e)
{
con.Open();// Connection Open
comm = new SqlCommand("delete from Movies where MoviesId = " + MoviesID.Text + " ", con);
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Movie Deleted");
con.Close();// Connection Close
ShowMoviesRecord();
MoviesID.Clear();
MovieTitle.Clear();
MovieRating.Clear();
MovieCopies.Clear();
MovieGenre.Clear();
MoviePlot.Clear();
MovieCost.Clear();
MovieReleaseDate.Clear();
}
catch (Exception x)
{
MessageBox.Show("Movie Not Deleted" + x.Message);
}
finally
{
con.Close();// Connection Close
}
}
public MovieTitleDetailViewModel(MovieTitleViewModel viewModel, BaseMovieTitleStore movieStore, IPageService pageService)
{
if (viewModel == null)
{
throw new ArgumentNullException(nameof(viewModel));
}
this.pageService = pageService;
this.movieTitleStore = movieStore;
this.SaveCommand = new Command(async() => await Save());
MovieTitle = new MovieTitle
{
Id = viewModel.Id,
TitleReleaseDate = viewModel.TitleReleaseDate,
Title = viewModel.Title,
MovieDesc = viewModel.MovieDesc,
ReleaseDate = viewModel.ReleaseDate,
ImdbUrl = viewModel.ImdbUrl,
StorageType = viewModel.StorageType,
DateAdded = viewModel.DateAdded,
DateModified = viewModel.DateModified,
};
}
// Update Movie Button (This button used for Update movie details)
private void UpdateMovie_Click(object sender, EventArgs e)
{
con.Open();// Connection Open
comm = new SqlCommand("update Movies set MoviesId= '" + MoviesID.Text + "', MTitle= '" + MovieTitle.Text + "', MRating='" + MovieRating.Text + "', Mcopies='" + MovieCopies.Text + "', Mgenre='" + MovieGenre.Text + "', Mplot='" + MoviePlot.Text + "', MCost='" + MovieCost.Text + "', MRelaseDate='" + MovieReleaseDate.Text + "' where MoviesId = '" + MoviesID.Text + "'", con);
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Movie Updated");
con.Close();// Connection Close
ShowMoviesRecord();
MoviesID.Clear();
MovieTitle.Clear();
MovieRating.Clear();
MovieCopies.Clear();
MovieGenre.Clear();
MoviePlot.Clear();
MovieCost.Clear();
MovieReleaseDate.Clear();
}
catch (Exception)
{
MessageBox.Show("Movie Not Updated");
}
finally
{
con.Close();// Connection Close
}
}
// Insert Movie Button (This button use for insert movie)
private void InsertMovie_Click(object sender, EventArgs e)
{
con.Open();// Connection Open
comm = new SqlCommand("insert into Movies values('" + MoviesID.Text + "','" + MovieTitle.Text + "','" + MovieRating.Text + "','" + MovieCopies.Text + "','" + MovieGenre.Text + "', '" + MoviePlot.Text + "', '" + MovieCost.Text + "', '" + MovieReleaseDate.Text + "')", con);
try
{
comm.ExecuteNonQuery();
MessageBox.Show("Movie Saved");
con.Close();// Connection Close
ShowMoviesRecord();
MoviesID.Clear();
MovieTitle.Clear();
MovieRating.Clear();
MovieCopies.Clear();
MovieGenre.Clear();
MoviePlot.Clear();
MovieCost.Clear();
MovieReleaseDate.Clear();
}
catch (Exception)
{
MessageBox.Show("Movie Not Saved");
}
finally
{
con.Close();// Connection Close
}
}
// Button events
private void ClearSearch_Click(object sender, EventArgs e)
{
StatusLabel.Text = "";
VideoCode.Clear();
MovieTitle.Clear();
RefreshLookupOutput();
StatusLabel.Text = "Search cleared.";
}
public MovieTitleViewModel(MovieTitle movieTitle)
{
this.Id = movieTitle.Id;
this.titleReleaseDate = movieTitle.TitleReleaseDate;
this.title = movieTitle.Title;
this.movieDesc = movieTitle.MovieDesc;
this.releaseDate = movieTitle.ReleaseDate;
this.imdbUrl = movieTitle.ImdbUrl;
this.storageType = movieTitle.StorageType;
this.dateModified = movieTitle.DateModified;
this.dateAdded = movieTitle.DateAdded;
}
public IActionResult AddToDb(MovieTitle importMovie)
{
if (_sqlMovieData.Find(importMovie.Title) != null)
{
throw new Exception($"\"{importMovie.Title}\" is already in db!");
}
var helper = new OMDBImportService(_mapper);
var theMovie = helper.GetCompleteMovie(importMovie.Title);
_sqlMovieData.Add(theMovie);
return(View("index"));
}
private void submit_Click(object sender, RoutedEventArgs e)
{
Movie submittedMovie = new Movie(MovieTitle.Text, MovieGenre.Text, Convert.ToDouble(MovieReviewScore.Text), MovieDirector.Text, Convert.ToInt32(MovieLegnth.Text), MovieamountOfWoollyBearLikeness.Text, MovieMoviePoster.Text);
MovieList.Add(submittedMovie);
//submittedMovie.Title = MovieTitle.Text;
//submittedMovie.Genre = MovieGenre.Text;
// submittedMovie.ReviewScore = Convert.ToDouble(MovieReviewScore.Text);
//submittedMovie.DisplayInformation();
MovieTitle.Clear();
MovieGenre.Clear();
MovieReviewScore.Clear();
MovieDirector.Clear();
MovieLegnth.Clear();
MovieamountOfWoollyBearLikeness.Clear();
MoviePoster.Clear();
}
public override string ToString()
{
var str = "";
int comma = MovieTitle.IndexOf(',');
if (comma > 0)
{
str += MovieID + "," + "\"" + MovieTitle + "\"" + "," + MovieYear;
}
else
{
str += MovieID + "," + MovieTitle + "," + MovieYear;
}
int numGenres = Genres.Count();
if (numGenres > 0)
{
str += ",";
str += Genres.ToString();
}
return(str);
}
public async Task DeleteMovieTitle(MovieTitle movieTitle)
{
await this.connection.DeleteAsync(movieTitle);
}
public async Task UpdateMovieTitle(MovieTitle movieTitle)
{
await this.connection.UpdateAsync(movieTitle);
}
public async Task AddMovieTitle(MovieTitle movieTitle)
{
await this.connection.InsertAsync(movieTitle);
}
public Parser(MovieTitle MovieTitle)
{
Page = download.FindMovie(MovieTitle);
}
//static string xmlFile = "c:\\temp\\n.xml";
public static List<MovieTitle> parseXMLFeed(string xmlFeed)
{
string movieId = String.Empty;
string movieTitle = string.Empty;
int release_year = 0;
string category = String.Empty;
int runLengthTime = 0;
float average_rating = 0;
string boxArtLink = String.Empty;
int itemCounter = 0;
MovieTitle mt = null;
List<MovieTitle> movieList = new List<MovieTitle>();
XmlReader reader = XmlReader.Create(new StringReader(xmlFeed));
while (reader.Read())
{
if (reader.Name == "catalog_titles")
continue;
if (reader.NodeType == XmlNodeType.Element)
{
switch (reader.Name)
{
case "catalog_title":
itemCounter++;
break;
case "id":
movieId = reader.ReadElementContentAsString();
break;
case "title":
if (true == reader.MoveToFirstAttribute())
if (true == reader.MoveToNextAttribute())
movieTitle = reader.Value;
break;
case "box_art":
if (true == reader.MoveToFirstAttribute())
if (true == reader.MoveToNextAttribute())
if (true == reader.MoveToNextAttribute())
boxArtLink = reader.Value;
break;
case "release_year":
release_year = reader.ReadElementContentAsInt();
break;
case "category":
{
if (true == reader.MoveToFirstAttribute())
if (true == reader.MoveToNextAttribute())
category += reader.Value + ", ";
}
break;
case "runtime":
runLengthTime = reader.ReadElementContentAsInt();
runLengthTime /= 60;
break;
case "averate_rating":
average_rating = reader.ReadElementContentAsFloat();
break;
}
}
else if (reader.NodeType == XmlNodeType.EndElement && reader.Name == "catalog_title")
itemCounter++;
if (itemCounter == 2)
{
category = category.TrimEnd(' ');
category = category.TrimEnd(',');
mt = new MovieTitle(movieId, movieTitle, boxArtLink, category, release_year, runLengthTime, average_rating);
movieList.Add(mt);
itemCounter = 0;
}
}
return movieList;
}
