private static List <Movie> MovieListLoader(_4Handin.DataAccessLayer.MovieDBListDataTable movieDBListRows)
{
var movieList = new List <Movie>();
foreach (_4Handin.DataAccessLayer.MovieDBListRow row in movieDBListRows)
{
Movie readmovie = new Movie(row.ID, row.Title, row.Genre, row.Year, row.Viewcount, row.PosterPath);
movieList.Add(readmovie);
}
return(movieList);
}
public Movie(int ID) //constructor via DataSet - essentially the same as searching for movie by id but more sexier
{
_4Handin.DataAccessLayer.MovieDBListDataTable movieDBListRows = MovieTableAdapter.GetDataByID(ID);
this.id = int.Parse(movieDBListRows[0]["ID"].ToString());
this.title = movieDBListRows[0]["Title"].ToString();
this.genre = movieDBListRows[0]["Genre"].ToString();
this.year = int.Parse(movieDBListRows[0]["Year"].ToString());
this.viewcount = int.Parse(movieDBListRows[0]["Viewcount"].ToString());
this.posterpath = movieDBListRows[0]["PosterPath"].ToString(); //default "N/A" value set in dataset rather than having it throw an exception on nulls, as was standard
}
public static List <Movie> ListMoviesTop10()
{
_4Handin.DataAccessLayer.MovieDBListDataTable movieDBListRows = MovieTableAdapter.MoviesTop10();
return(MovieListLoader(movieDBListRows));
}
public static List <Movie> ListMoviesByTitle(string Title)
{
_4Handin.DataAccessLayer.MovieDBListDataTable movieDBListRows = MovieTableAdapter.GetDataByTitle(Title);
return(MovieListLoader(movieDBListRows));
}
public static List <Movie> ListMoviesByNoPoster()
{
_4Handin.DataAccessLayer.MovieDBListDataTable movieDBListRows = MovieTableAdapter.GetDataByNotHavingPosterImageUrl();
return(MovieListLoader(movieDBListRows));
}
