private void populateDropDownsWithFilteredData(string filmID, string directorID, string actorID, string filmYear
, string imdbRating, string rottenRating)
{
mcl.Films films = getFilms();
mbl bl1 = new mbl();
mcl.Films tmp = bl1.GetFilmsSubset(filmID, directorID, actorID, filmYear, imdbRating, rottenRating, films);
List <mcl.Actor> actors = (actorID == null) ? bl1.GetDistinctActorsFromFilms(tmp) : bl1.GetDistinctActor(tmp, actorID);
List <mcl.Director> directors = (directorID == null) ? bl1.GetDistinctDirectorsFromFilms(tmp) : bl1.GetDistinctDirector(tmp, directorID);
List <mcl.SimplisticFilm> sFilms = (filmID == null) ? bl1.GetDistinctSimplisticFilmsFromFilms(tmp) : tmp.GetDistinctSimplisticFilm(filmID);
List <string> filmYears = (filmYear == null) ? bl1.GetDistinctFilmYearFromFilms(tmp) :
tmp.GetDistinctFilmYear(filmYear);
List <string> imdbRatings = (imdbRating == null) ? bl1.GetDistinctImdbRatingFromFilms(tmp) :
tmp.GetDistinctImdbRating(imdbRating);
List <string> rottenRatings = (rottenRating == null) ? bl1.GetDistinctRottenRatingFromFilms(tmp) :
tmp.GetDistinctRottenRating(rottenRating);
populateDropDowns(avSV.DropDownLists.UseBlankItem, sFilms, directors, actors, filmYears, imdbRatings, rottenRatings);
if (isSelectionComplete(sFilms, actors, directors))
{
mcl.Film film = new mcl.Film(tmp.GetDistinctFilm(sFilms[0].FilmID), actors, directors);
selectionComplete(film);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
mbl bl = new mbl();
bl.UpdateCSVandRDB();
Cache[cache.FilmCacheName] = null;
populateDropDownsWithOriginalData();
}
private void populateDropDownsWithOriginalData() // returns the original data selected.
{
using (mbl bl1 = new mbl())
{
mcl.Films films = getFilms();
List <mcl.Director> directors = bl1.GetDistinctDirectorsFromFilms(films);
List <mcl.Actor> actors = bl1.GetDistinctActorsFromFilms(films);
List <mcl.SimplisticFilm> sFilms = bl1.GetDistinctSimplisticFilmsFromFilms(films);
populateDropDowns(ddl.UseBlankItem, sFilms, directors, actors);
}
}
private void populateDropDownsWithFilteredData(string filmID, string directorID, string actorID) //populates the drop down list with the filtered data.
{
mcl.Films films = getFilms();
using (mbl bl1 = new mbl())
{
mcl.Films tmp = bl1.GetFilmsSubset(filmID, directorID, actorID, films);
List <mcl.Actor> actors = (actorID == null) ? bl1.GetDistinctActorsFromFilms(tmp) : bl1.GetDistinctActor(tmp, actorID);
List <mcl.Director> directors = (directorID == null) ? bl1.GetDistinctDirectorsFromFilms(tmp) : bl1.GetDistinctDirector(tmp, directorID);
List <mcl.SimplisticFilm> sFilms = (filmID == null) ? bl1.GetDistinctSimplisticFilmsFromFilms(tmp) : tmp.GetDistinctSimplisticFilm(filmID);
populateDropDowns(ddl.UseBlankItem, sFilms, directors, actors);
}
}
private void populateDropDownsWithOriginalData()
{
mbl bl1 = new mbl();
mcl.Films films = getFilms();
List <mcl.Director> directors = bl1.GetDistinctDirectorsFromFilms(films);
List <mcl.Actor> actors = bl1.GetDistinctActorsFromFilms(films);
List <mcl.SimplisticFilm> sFilms = bl1.GetDistinctSimplisticFilmsFromFilms(films);
List <string> filmYears = bl1.GetDistinctFilmYearFromFilms(films);
List <string> imdbRatings = bl1.GetDistinctImdbRatingFromFilms(films);
List <string> rottenRatings = bl1.GetDistinctRottenRatingFromFilms(films);
populateDropDowns(avSV.DropDownLists.UseBlankItem, sFilms, directors, actors, filmYears, imdbRatings, rottenRatings);
}
protected void btn_CreateUpdate_Click(object sender, EventArgs e)
{
mbl bl1 = new mbl();
List <string> inputData = new List <string>()
{
tb_FilmImdbID.Text,
tb_FilmName.Text,
tb_FilmImdbRating.Text,
tb_DirectorImdbID.Text,
tb_DirectorName.Text,
tb_ActorImdbID.Text,
tb_ActorName.Text,
tb_FilmYear.Text
};
bl1.UpdateFilmInDatabase(inputData);
}
protected void Page_Load(object sender, EventArgs e) // this class loads the page.
{
//var tmp = Page.Request.Params["__EVENTTARGET"];
if (this.IsPostBack && isFilteredPageLoad()) // checks if it is a postback (certain credentials of the page are to be checked against some sources)
{
using (mbl bl1 = new mbl()) // calling the movieBuisness layer.
{
string filmID = (DropDownListFilms.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null : DropDownListFilms.SelectedValue); // asking if the dropdownlist selected value is equal to the default value. if it is null then it will select the selected value. //populate the dropdown with the film selected??
string directorID = (DropDownListDirectors.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null : DropDownListDirectors.SelectedValue);
string actorID = (DropDownListActors.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null : DropDownListActors.SelectedValue);
populateDropDownsWithFilteredData(filmID, directorID, actorID);
}
}
else
{
populateDropDownsWithOriginalData();
}
}
private mcl.Films getFilms()
{
mcl.Films films = new mcl.Films();
if ((cache.UseCache) && (Cache[cache.FilmCacheName] != null))
{
films = Cache[cache.FilmCacheName] as mcl.Films;
}
else
{
mbl bl1 = new mbl();
films = bl1.GetFilms(av.SystemSettings.DataAccessPoint.Current);
if (cache.UseCache)
{
Cache[cache.FilmCacheName] = films;
}
}
return(films);
}
private mcl.Films getFilms() //
{
mcl.Films films = new mcl.Films();
if ((cache.UseCache) && (Cache[cache.FilmCacheName] != null))
{
films = Cache[cache.FilmCacheName] as mcl.Films;
}
else
{
using (mbl bl1 = new mbl())
{
films = bl1.GetFilms(av.CsvPaths.MoviesCSV);
if (cache.UseCache)
{
Cache[cache.FilmCacheName] = films;
}
}
}
return(films);
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.IsPostBack && isFilteredPageLoad())
{
mbl bl1 = new mbl();
string filmID = (DropDownListFilms.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null : DropDownListFilms.SelectedValue);
string directorID = (DropDownListDirectors.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null : DropDownListDirectors.SelectedValue);
string actorID = (DropDownListActors.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null : DropDownListActors.SelectedValue);
string filmYear = (DropDownListFilmYears.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null :
DropDownListFilmYears.SelectedValue);
string imdbRating = (DropDownListImdbRatings.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null :
DropDownListImdbRatings.SelectedValue);
string rottenRating = (DropDownListRottenRatings.SelectedValue == av.SystemValues.DropDownLists.DefaultValue ? null :
DropDownListRottenRatings.SelectedValue);
populateDropDownsWithFilteredData(filmID, directorID, actorID, filmYear, imdbRating, rottenRating);
}
else
{
populateDropDownsWithOriginalData();
}
}
