public void GetAllFilmsByGenre(int genreId)
{
clsDataConnection DB = new clsDataConnection();
DB.AddParameter("@GenreId", genreId);
DB.Execute("sproc_tblFilmGenre_FilterByGenreId");
Int32 recordCount = DB.Count;
Int32 index = 0;
while (index < recordCount)
{
clsFilmGenre aFilm = new clsFilmGenre();
aFilm.FilmId = Convert.ToInt32(DB.DataTable.Rows[index]["FilmId"]);
mAllFilmsByGenre.Add(aFilm);
index++;
}
}
public clsFilmGenreCollection()
{
clsDataConnection DB = new clsDataConnection();
DB.Execute("sproc_tblFilmGenre_SelectAll");
Int32 recordCount = DB.Count;
Int32 index = 0;
while (index < recordCount)
{
clsFilmGenre aFilmGenre = new clsFilmGenre();
aFilmGenre.FilmId = Convert.ToInt32(DB.DataTable.Rows[index]["FilmId"]);
aFilmGenre.GenreId = Convert.ToInt32(DB.DataTable.Rows[index]["GenreId"]);
mAllFilmGenres.Add(aFilmGenre);
index++;
}
}