public DiscussionPanel(DataSet.FilmsRow film, DataSet.PostsRow lastpost, int postcount, string url)
{
Film = film;
LastPost = lastpost;
PostCount = postcount;
URL = url;
}
protected List <String> ListOfFilmSmallImages(long filmid)
{
string SmallImagesDB;
List <String> SmallImagesSplitted = new List <string>();
//Retrieves the film's info
DataSetTableAdapters.FilmsTableAdapter filmTA = new DataSetTableAdapters.FilmsTableAdapter();
DataSet.FilmsDataTable dataFilms = filmTA.GetFilmById(filmid);
if (dataFilms != null && dataFilms.Count == 1)
{
DataSet.FilmsRow film = dataFilms[0];
SmallImagesDB = film.ImgSmall;
SmallImagesSplitted = SmallImagesDB.Split(',').ToList();
}
return(SmallImagesSplitted);
}
protected void Page_Load(object sender, EventArgs e)
{
long retrievedFilmId = 1; //** need to be dynamic -- pulled as a request variable **//
//retrievedFilmId = long.Parse(Request["FilmId"].ToString());
//Retrieves the film's info
DataSetTableAdapters.FilmsTableAdapter filmTA = new DataSetTableAdapters.FilmsTableAdapter();
DataSet.FilmsDataTable dataFilms = filmTA.GetFilmById(retrievedFilmId);
//Retrieves the classification of the film
DataSetTableAdapters.ClassificationsTableAdapter classificationTA = new DataSetTableAdapters.ClassificationsTableAdapter();
DataSet.ClassificationsDataTable dataClassification = classificationTA.GetClassificationByFilmId(retrievedFilmId, true);
//Retreives a contributor's info
DataSetTableAdapters.ContributorsTableAdapter contributorTA = new DataSetTableAdapters.ContributorsTableAdapter();
DataSet.ContributorsDataTable dataContributors;
//Retreives actors for the film
DataSetTableAdapters.FilmsContributorsTableAdapter filmcontributorActorsTA = new DataSetTableAdapters.FilmsContributorsTableAdapter();
DataSet.FilmsContributorsDataTable dataActors = filmcontributorActorsTA.GetActorsByFilmId(retrievedFilmId, true);
//Retreives directors for the film
DataSetTableAdapters.FilmsContributorsTableAdapter filmcontributorTA = new DataSetTableAdapters.FilmsContributorsTableAdapter();
DataSet.FilmsContributorsDataTable dataDirectors = filmcontributorTA.GetDirectorsByFilmId(1, true);
if (dataFilms != null && dataFilms.Count == 1)
{
DataSet.FilmsRow film = dataFilms[0];
DataSet.ClassificationsRow classificationFilm = dataClassification[0];
imagelargedata.InnerHtml = "<img src='" + film.ImgLarge + "' class='img-thumbnail' title='" + film.Title + "large' style='max-height:100%;max-width:100%'/>";
classificationdata.InnerHtml = "<img src='" + classificationFilm.ImgSmall + "' class='img-thumbnail' title='" + classificationFilm.Title + "Classification' />";
titledata.InnerHtml = "<h3>" + film.Title + "</h3>";
descriptiondata.InnerHtml = "<p>" + film.Description + "</p>";
moviespecificinformation.InnerHtml += "<dl>";
moviespecificinformation.InnerHtml += "<dt>Release Date</dt>";
moviespecificinformation.InnerHtml += "<dd>" + film.ReleaseDate.ToLongDateString() + "</dd>";
moviespecificinformation.InnerHtml += "<dt>Running Time</dt>";
moviespecificinformation.InnerHtml += "<dd>" + film.Duration.ToString() + " mins</dd>";
if (dataActors.Count == 0 && dataDirectors.Count == 0) //no rows of actors or directors for that film
{
moviespecificinformation.InnerHtml += "<dt>No actors or directors to be displayed. Please consult site administrator</dt>";
}
else
{
moviespecificinformation.InnerHtml += "<dt>Director</dt>";
//getting each director in the film
foreach (DataSet.FilmsContributorsRow row in dataDirectors)
{
dataContributors = contributorTA.GetContributorByContributorId(row.ContributorId, true);
DataSet.ContributorsRow contributorinfo = dataContributors[0];
moviespecificinformation.InnerHtml += "<dd>" + contributorinfo.FirstName + " " + contributorinfo.LastName + "</dd>";
}
moviespecificinformation.InnerHtml += "<dt>Cast</dt>";
//getting each actor in the film
foreach (DataSet.FilmsContributorsRow row in dataActors)
{
dataContributors = contributorTA.GetContributorByContributorId(row.ContributorId, true);
DataSet.ContributorsRow contributorinfo = dataContributors[0];
moviespecificinformation.InnerHtml += "<dd>" + contributorinfo.FirstName + " " + contributorinfo.LastName + "</dd>";
}
}
moviespecificinformation.InnerHtml += "</dl>";
}
}
