public override global::System.Data.DataSet Clone()
{
MovieDB cln = ((MovieDB)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public ActionResult DeleteConfirmed(int id)
{
MovieDB moviedb = db.Movies.Find(id);
db.Movies.Remove(moviedb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Favorites(string imdbID)
{
MovieDB movie = MovieDAL.GetMovie(imdbID);
db.Favorite.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Title,Director,Date")] MovieDB movieDB)
{
if (ModelState.IsValid)
{
db.Entry(movieDB).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movieDB));
}
public IActionResult AddMovieMB(Movie film)
{
if (ModelState.IsValid)
{
MovieDB.Add(film);
ViewData["Success"] = "Movie has been added!";
}
return(View());
}
public ActionResult Edit(MovieDB moviedb)
{
if (ModelState.IsValid)
{
db.Entry(moviedb).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(moviedb));
}
//
// GET: /Movie/Delete/5
public ActionResult Delete(int id = 0)
{
MovieDB moviedb = db.MovieDBs.Find(id);
if (moviedb == null)
{
return(HttpNotFound());
}
return(View(moviedb));
}
/// <summary>
/// 详情页面
/// </summary>
/// <returns></returns>
public ActionResult MovieDetail(int id = 0)
{
//去数据库数据，把id传进去
MovieDB db = new MovieDB();
MovieDetailModel m = db.GetDetail(id);
ViewBag.movieModel = m;
return(View());
}
public ActionResult Edit([Bind(Include = "ID,Title,Year,Poster,Genre,Metascore,Plot")] MovieDB movieDB)
{
if (ModelState.IsValid)
{
db.Entry(movieDB).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movieDB));
}
protected void Page_Load(object sender, EventArgs e)
{
//prevents a user from landing on the page without selecting a movie from the ddl/comingsoon.aspx/default.aspx
if (Session["SelectedMovie"] == null)
{
Response.Redirect("Default.aspx", true);
}
//MovieCategory seperates currently showing movies from movies that havent released(and lack the data fields that a regular movie has)
string movieType = (string)Session["MovieCategory"];
//format the page if the movie type is comingsoon
if (movieType == "ComingSoon")
{
//grabs the movie from the db class
selected = MovieDB.GetComingSoonMovie((string)Session["SelectedMovie"]);
odsSingleMovie.SelectMethod = "GetComingSoonMovie";
//hide irrelevant fields from the details view
dvMovieInfo.Rows[5].Visible = false;
dvMovieInfo.Rows[4].Visible = false;
dvMovieInfo.Rows[3].Visible = false;
pnlShowtimes.Visible = false;
//also hide showtimes
lblDate.Enabled = false;
gvTimes.Enabled = false;
}
else//movie is currently playing
{
selected = MovieDB.GetMovie((string)Session["SelectedMovie"]);
if (Session["SelectedDate"] != null)
{
date = (DateTime)Session["SelectedDate"];
}
else
{
date = DateTime.Now;
Session["SelectedDate"] = date;
}
//formats the selected day, as grammatically correct as possible
lblDate.Text = string.Format("{0:dddd} the {0:dd}{1} of {0:MMMM yyyy}", date, ((date.Day % 10 == 1 && date.Day != 11) ? "st"
: (date.Day % 10 == 2 && date.Day != 12) ? "nd"
: (date.Day % 10 == 3 && date.Day != 13) ? "rd"
: "th"));
}
lblMovieTitle.Text = selected.Name;
//converts the binary array storing the poster to a jpg encoded string
ImgPoster.ImageUrl = "data:image/jpg;base64," + Convert.ToBase64String(selected.Poster);
//set the trailer url depending on which movie is currently selected
ifrmTrailerEmbed.Attributes.Add("src", "https://www.youtube.com/embed/" + selected.TrailerURL);
}
public ActionResult Create(MovieDB moviedb)
{
if (ModelState.IsValid)
{
db.MovieDBs.Add(moviedb);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(moviedb));
}
private void GetMoviesByGenre(int genreID)
{
try
{
Movies = MovieDB.GetMoviesByGenre(genreID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Create([Bind(Include = "ID,Title,Director,Date")] MovieDB movieDB)
{
if (ModelState.IsValid)
{
db.MovieDBs.Add(movieDB);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movieDB));
}
internal Movie Map(MovieDB dbMovie)
{
if (dbMovie == null)
{
return(null);
}
return(new Movie()
{
Id = dbMovie.Id, Title = dbMovie.Title, ReleaseYear = dbMovie.ReleaseYear
});
}
public ActionResult Create([Bind(Include = "ID,Title,Year,Poster,Genre,Metascore,Plot")] MovieDB movieDB)
{
if (ModelState.IsValid)
{
db.Favorite.Add(movieDB);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(movieDB));
}
public ActionResult PlayMovie(string id)
{
MovieDB db = new MovieDB();
MovieViewModel MovieItem = new MovieViewModel();
if (db.ListMovies.Find(id, this.CurrentUserId()) != null)
{
MovieItem.AvailableToWatch = true;
MovieItem.MoviePath = MovieConfiguration.Path + id;
}
return(View(MovieItem));
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
MovieDB ds = new MovieDB();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
private void tbDirectors_TextChanged(object sender, EventArgs e)
{
IsLoadedDirectors = false;
string text = tbDirectors.Text;
lvDirectors.Clear();
ColumnHeader header = new ColumnHeader();
header.Text = "";
header.Name = "col1";
lvDirectors.Columns.Add(header);
lvDirectors.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
lvDirectors.HeaderStyle = ColumnHeaderStyle.None;
try
{
using (MovieDB context = new MovieDB())
{
lvDirectors.CheckBoxes = true;
List <director> directors = null;
if (text.Equals(""))
{
directors = (from c in context.directors
where c.member_of_cast_and_crew.active == 1
orderby c.member_of_cast_and_crew.first_name
select c).ToList();
}
else
{
directors = (from c in context.directors
where (c.member_of_cast_and_crew.first_name.ToLower().Contains(text.ToLower()) ||
c.member_of_cast_and_crew.last_name.ToLower().Contains(text.ToLower())) &&
c.member_of_cast_and_crew.active == 1
orderby c.member_of_cast_and_crew.first_name
select c).ToList();
}
foreach (var director in directors)
{
var item = new ListViewItem(director.member_of_cast_and_crew.first_name + " " + director.member_of_cast_and_crew.last_name);
item.Tag = director;
lvDirectors.Items.Add(item);
if (MovieDirectors.Contains(director))
{
item.Checked = true;
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
IsLoadedDirectors = true;
}
public RentalForm()
{
InitializeComponent();
Movies = MovieDB.GetMovies();
//FormBorderStyle = FormBorderStyle.None;
//WindowState = FormWindowState.Maximized;
initPictureBoxes();
pbLeftArrow.Enabled = false;
pbLeftArrow.Visible = false;
}
public RentalForm(Member member)
{
InitializeComponent();
Movies = MovieDB.GetMovies();
this.member = member;
//FormBorderStyle = FormBorderStyle.None;
//WindowState = FormWindowState.Maximized;
initPictureBoxes();
PopulateGenreCB();
pbLeftArrow.Enabled = false;
pbLeftArrow.Visible = false;
}
private void btnBrowse_Click(object sender, EventArgs e)
{
try
{
List <Movie> myMovieList = new List <Movie>();
myMovieList = MovieDB.GetMovies();
dataGridView1.DataSource = myMovieList;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "MeramecNetFlix", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
// GET: Movies/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MovieDB movieDB = db.MovieDBs.Find(id);
if (movieDB == null)
{
return(HttpNotFound());
}
return(View(movieDB));
}
public ActionResult AddFilm(MovieList movie)
{
if (ModelState.IsValid)
{
using (MovieDB db = new MovieDB())
{
db.MovieList.Add(movie);
db.SaveChanges();
}
ModelState.Clear();
ViewBag.Message = "Movie successfully added";
}
return(View());
}
private void tbMinMovies_TextChanged(object sender, EventArgs e)
{
try
{
int minMovies = -1;
if (!tbMinMovies.Text.Equals(""))
{
minMovies = int.Parse(tbMinMovies.Text);
}
using (MovieDB context = new MovieDB())
{
List <director> directors = null;
if (minMovies == -1)
{
directors = (from c in context.directors
where
c.member_of_cast_and_crew.active == 1
orderby c.member_of_cast_and_crew.first_name
select c).ToList();
}
else
{
directors = (from c in context.directors
where c.movies.Count >= minMovies &&
c.member_of_cast_and_crew.active == 1
orderby c.member_of_cast_and_crew.first_name
select c).ToList();
}
directorsByMinMovies = directors;
List <director> filteredDirectors = DirectorsIntersect();
dgvDirectors.Rows.Clear();
foreach (var director in filteredDirectors)
{
DataGridViewRow row = new DataGridViewRow()
{
Tag = director
};
row.CreateCells(dgvDirectors);
row.SetValues(director.member_of_cast_and_crew.first_name, director.member_of_cast_and_crew.last_name,
director.member_of_cast_and_crew.born, director.member_of_cast_and_crew.birthplace,
director.member_of_cast_and_crew.died);
dgvDirectors.Rows.Add(row);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public void ShouldReturnMovie()
{
var movieId = 11;
var movieDb = new MovieDB();
var movie = new Movie();
_mockMovieRepository.Setup(r => r.Get(movieId)).Returns(movieDb);
_mockMovieConverter.Setup(c => c.ConvertToMovie(movieDb)).Returns(movie);
var movieService = new MovieService(_mockMovieRepository.Object, _mockMovieConverter.Object);
var result = movieService.Get(movieId);
Assert.Equal(movie, result);
}
public ActionResult GetOneMovie(string imdbID)
{
MovieDB movie = MovieDAL.GetMovie(imdbID);
ViewBag.Title = movie.Title;
ViewBag.Meta = movie.Metascore;
ViewBag.Plot = movie.Plot;
ViewBag.Poster = movie.Poster;
ViewBag.Year = movie.Year;
ViewBag.Genre = movie.Genre;
ViewBag.IMDB = movie.ImdbID;
return(View("OneMovie"));
}
public void ShouldConvertMovie()
{
var movieId = 11;
var movieDb = new MovieDB();
var movie = new Movie();
_mockMovieRepository.Setup(r => r.Get(movieId)).Returns(movieDb);
_mockMovieConverter.Setup(c => c.ConvertToMovie(movieDb)).Returns(movie);
var movieService = new MovieService(_mockMovieRepository.Object, _mockMovieConverter.Object);
movieService.Get(movieId);
_mockMovieConverter.Verify(c => c.ConvertToMovie(movieDb), Times.Once);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//Validate the UI
if (string.IsNullOrEmpty(txtMovieNumber.Text.Trim()))
{
MessageBox.Show("Please enter a movie id.");
txtMovieNumber.Focus();
return;
}
if (string.IsNullOrEmpty(txtMovieTitle.Text.Trim()))
{
MessageBox.Show("Please enter a movie name.");
txtMovieNumber.Focus();
return;
}
Movie objMovie = new Movie();
objMovie.movie_number = txtMovieNumber.Text.Trim();
objMovie.movie_title = txtMovieTitle.Text.Trim();
objMovie.description = txtDescription.Text.Trim();
objMovie.movie_year_made = txtMovieYearMade.Text.Trim();
//Genre genre = GenreDB.GetGenreByName(cbGenre.SelectedItem.ToString()); objMovie.genre_id = genre.ID;
objMovie.genre_id = ((Genre)cbGenre.SelectedItem).ID.ToString();//MessageBox.Show(cbGenre.SelectedIndex.ToString());
objMovie.movie_rating = cbRating.Text.Trim();
objMovie.media_type = cbMediaType.Text.Trim();
objMovie.movie_retail_cost = Math.Round(Convert.ToDecimal(txtRetailCost.Text.Trim()), 2);
objMovie.copies_on_hand = txtCopiesOnHand.Text.Trim();
objMovie.image = txtImageFilename.Text.Trim();
objMovie.trailer = txtTrailerLink.Text.Trim();
try
{
bool status = MovieDB.UpdateMovie(objMovie);
if (status) //You can use this syntax as well..if (status ==true)
{
MessageBox.Show("Movie has been updated.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Movie was not updated in database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnBrowse_Click(object sender, EventArgs e)
{
//Call the MovieDB static class to fill the data grid
try
{
List <Movie> movieList = new List <Movie>();
movieList = MovieDB.GetMovies();
dataGridView1.DataSource = movieList;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
Movie movie = MovieDB.GetMovie(txtTitle.Text.Trim());
if (movie != null)
{
Thread viewMovie = new Thread(() => new ViewMovie(movie, member.number).ShowDialog());
viewMovie.SetApartmentState(ApartmentState.STA);
viewMovie.Start();
}
else
{
MessageBox.Show(txtTitle.Text.Trim() + " not found.", "Uh oh", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
async public void SaveToParse ()
{
ParseObject movie;
if (this.ParseId == null || this.ParseId == "") {
movie = new ParseObject ("Pelicula");
} else {
ParseQuery<ParseObject> query = ParseObject.GetQuery ("Pelicula");
movie = await query.GetAsync (this.ParseId);
}
movie ["Nombre"] = this.Title;
movie ["Nombre_Original"] = this.Title;
movie ["Anio"] = int.Parse (this.Year);
movie ["Director"] = this.Director;
movie ["ID_TMDB"] = this.ApiId;
movie ["Descripcion"] = this.Overview;
await movie.SaveAsync ().ContinueWith (t => {
this.ParseId = movie.ObjectId;
Console.WriteLine ("Saved Movie in Parse: " + this.ParseId);
MovieDB movieDB = new MovieDB ();
movieDB.Update (this);
});
}
