/// <summary> /// Function to get all movies from the database /// </summary> /// <returns>List of all movies present in the database</returns> public List<Movie> GetAllMovies() { MySqlCommand cmd = new MySqlCommand("GetAllMovies", connection); List<Movie> MovieList = new List<Movie>(); MySqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { Movie movie = new Movie(); movie.Id = reader.GetInt32("Id"); movie.Title = reader.GetString("Title"); movie.Description = reader.GetString("Description"); movie.ReleaseDate = reader.GetDateTime("ReleaseDate"); movie.Genre = reader.GetString("Genre"); movie.Review = reader.GetString("Review"); movie.Image = (byte[])(reader["Image"]); movie.Url = reader.GetString("Url"); MovieList.Add(movie); } } catch (Exception ex) { logger.Error(ex.ToString()); } finally { reader.Close(); } return MovieList; }
/// <summary> /// Function to search movie by ID /// </summary> /// <param name="Mid">ID of the movies to be searched</param> /// <returns>List of movies whose ID matches with user input</returns> public Movie GetMovieById(int Mid) { MySqlCommand cmd = new MySqlCommand("GetMovieId", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Mid", Mid); MySqlDataReader reader = cmd.ExecuteReader(); Movie movie = null; if (reader.Read()) { try { movie = new Movie(); movie.Id = reader.GetInt32("Id"); movie.Title = reader.GetString("Title"); movie.Description = reader.GetString("Description"); movie.ReleaseDate = reader.GetDateTime("ReleaseDate"); movie.Genre = reader.GetString("Genre"); movie.Review = reader.GetString("Review"); movie.Image = (byte[])(reader["Image"]); movie.Url = reader.GetString("Url"); } catch (Exception ex) { logger.Error(ex.ToString()); } } return movie; }
public Movies(Movie movie) { Id = movie.Id; Title = movie.Title; Description = movie.Description; ReleaseDate = movie.ReleaseDate; Genre = movie.Genre; Review = movie.Review; Image = movie.Image; Url = movie.Url; }
public ActionResult DisplayMovieByTitle(String title) { try { movieDAL = movieManager.GetMovieByTitle(title); movie = new Movies(movieDAL); } catch (Exception ex) { logger.Error(ex.ToString()); } return View(movie); }
public ActionResult DisplayView(int id) { try { movieDAL = movieManager.GetMovieById(id); movie = new Movies(movieDAL); } catch (Exception ex) { logger.Error(ex.ToString()); } return View(movie); }