public clsFilmCollection()
{
clsDataConnection DB = new clsDataConnection();
DB.Execute("sproc_tblFilm_SelectAll");
Int32 recordCount = DB.Count;
Int32 index = 0;
while (index < recordCount)
{
clsFilm aFilm = new clsFilm();
aFilm.FilmId = Convert.ToInt32(DB.DataTable.Rows[index]["FilmId"]);
aFilm.Title = DB.DataTable.Rows[index]["Title"].ToString();
mAllFilms.Add(aFilm);
index++;
}
}
public List <clsFilm> SearchForFilm(string searchText)
{
List <clsFilm> SearchResults = new List <clsFilm>();
clsFilm aFilm = new clsFilm();
clsDataConnection DB = new clsDataConnection();
DB.AddParameter("@Title", searchText);
DB.Execute("sproc_tblFilm_FilterBySimilarTitle");
Int32 recordCount = DB.Count;
Int32 index = 0;
while (index < recordCount)
{
aFilm = new clsFilm();
aFilm.FilmId = Convert.ToInt32(DB.DataTable.Rows[index]["FilmId"]);
aFilm.Title = DB.DataTable.Rows[index]["Title"].ToString();
SearchResults.Add(aFilm);
index++;
}
return(SearchResults);
}