/// <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);
}
