public void AddMethodOK()
{
//Create an instance of the class we want to create
clsFilmCollection AllFilms = new clsFilmCollection();
//Create the item of test data
clsFilm TestItem = new clsFilm();
//Variable to store the primary kjey
Int32 PrimaryKey = 0;
//Set its properties
TestItem.Title = "Punch 5: Punch Yet Again Even More Hardererer";
TestItem.Duration = 80;
TestItem.AgeRatingID = 5;
TestItem.GenreID = 5;
//Set ThisFilm to the test data
AllFilms.ThisFilm = TestItem;
//Add the record
PrimaryKey = AllFilms.Add();
//Set the primary key of the test data
TestItem.FilmID = PrimaryKey;
//Find the record
AllFilms.ThisFilm.Find(PrimaryKey);
//Test to see that the two values are the same
Assert.AreEqual(AllFilms.ThisFilm, TestItem);
}
public void UpdateMethodOK()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilm TestFilm = new clsFilm();
Int32 PrimaryKey = 0;
TestFilm.FilmName = "Frazers Film";
TestFilm.FilmDescription = "test description, test description, test description, " +
"test description, test description, ";
TestFilm.FilmCertificate = "12";
TestFilm.FilmReleaseDate = DateTime.Now.Date;
TestFilm.FilmDepartureDate = DateTime.Now.Date.AddYears(1);
AllFilms.ThisFilm = TestFilm;
PrimaryKey = AllFilms.Add();
TestFilm.FilmID = PrimaryKey;
TestFilm.FilmName = "Frazers Film2";
TestFilm.FilmDescription = "test description, test description, test description, " +
"test description, test description2, ";
TestFilm.FilmCertificate = "15";
TestFilm.FilmReleaseDate = DateTime.Now.Date;
TestFilm.FilmDepartureDate = DateTime.Now.Date.AddYears(1);
AllFilms.ThisFilm = TestFilm;
AllFilms.Update();
AllFilms.ThisFilm.Find(PrimaryKey);
Assert.AreEqual(AllFilms.ThisFilm, TestFilm);
}
public void SearchForFilmMethodOk()
{
clsFilmCollection AllFilms = new clsFilmCollection();
string searchText = "Story";
Assert.IsNotNull(AllFilms.SearchForFilm(searchText));
}
public void FilterByTitleTestDataFound()
{
//Create an instance of the filtered data
clsFilmCollection FilteredFilms = new clsFilmCollection();
//Variable to store outcome
Boolean OK = true;
//Apply a Title that doesn exist
FilteredFilms.FilterByTitle("Zzzzzzzz");
//Check that the correct number of records are found
if (FilteredFilms.Count == 2)
{
//Check that the first record is ID 36
if (FilteredFilms.FilmList[0].FilmID != 36)
{
OK = false;
}
//Check that the first record is ID 37
if (FilteredFilms.FilmList[0].FilmID != 37)
{
OK = false;
}
}
else
{
OK = false;
}
//Test to see that there are no records
Assert.IsTrue(OK);
}
protected void btnYes_Click(object sender, EventArgs e)
{
clsFilmCollection FilmCollection = new clsFilmCollection();
FilmCollection.ThisFilm.Find(FilmId);
FilmCollection.Delete();
Response.Redirect("FilmList.aspx");
}
public void ReportByFilmNameMethodOK()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilmCollection FilteredFilms = new clsFilmCollection();
FilteredFilms.ReportByFilmName("");
Assert.AreEqual(AllFilms.Count, FilteredFilms.Count);
}
public void CountPropertyOk()
{
clsFilmCollection AllFilms = new clsFilmCollection();
Int32 count = 9755;
AllFilms.Count = count;
Assert.AreEqual(AllFilms.Count, count);
}
public void InstanceOK()
{
//Create an instance of the class we want to create
clsFilmCollection AllFilms = new clsFilmCollection();
//Test to see that it exists
Assert.IsNotNull(AllFilms);
}
public void FilmAlreadyExistsMethodOk()
{
clsFilmCollection AllFilms = new clsFilmCollection();
Boolean found = false;
string title = "Dune (2021)";
found = AllFilms.FilmAlreadyExistsCheck(title);
Assert.IsTrue(found);
}
protected void grdAllFilms_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Int32 filmId = Convert.ToInt32(((Label)grdAllFilms.Rows[e.RowIndex].FindControl("lblFilmId")).Text);
clsFilmCollection AllFilms = new clsFilmCollection();
AllFilms.ThisFilm.FilmId = filmId;
AllFilms.Delete();
LoadData();
}
public void FIlterByTitleNoneFound()
{
//Create an instance of the filtered data
clsFilmCollection FilteredFilms = new clsFilmCollection();
//Apply a title that doesn't exist
FilteredFilms.FilterByTitle("Zzzzzzzz!");
//Test to see that there are no records
Assert.AreEqual(0, FilteredFilms.Count);
}
public void ThisFilmPropertyOk()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilm testFilm = new clsFilm();
testFilm.FilmId = 1;
testFilm.Title = "Midsommar(2019)";
AllFilms.ThisFilm = testFilm;
Assert.AreEqual(AllFilms.ThisFilm, testFilm);
}
protected void btnApply_Click(object sender, EventArgs e)
{
clsFilmCollection Films = new clsFilmCollection();
Films.ReportByFilmName(txtFilmNameFilter.Text);
lstFilmList.DataSource = Films.FilmList;
lstFilmList.DataValueField = "FilmId";
lstFilmList.DataTextField = "FilmName";
lstFilmList.DataBind();
}
protected void btnClear_Click(object sender, EventArgs e)
{
clsFilmCollection Films = new clsFilmCollection();
Films.ReportByFilmName("");
txtFilmNameFilter.Text = "";
lstFilmList.DataValueField = "FilmId";
lstFilmList.DataTextField = "FilmName";
lstFilmList.DataBind();
}
public void CountPropertyOkay()
{
//create instance of class we want to create
clsFilmCollection AllFilms = new clsFilmCollection();
//create some test data to assign to the property
Int32 SomeCount = 0;
//assign the data to the property
AllFilms.Count = SomeCount;
}
public void CountMatchesList()
{
clsFilmCollection Films = new clsFilmCollection();
List <clsFilm> testList = new List <clsFilm>();
clsFilm testItem = new clsFilm();
testItem.FilmId = 1;
testItem.Title = "King Kong (2005)";
testList.Add(testItem);
Films.AllFilms = testList;
Assert.AreEqual(Films.Count, testList.Count);
}
public void FilterByTitleMethodOK()
{
//Create an instance of the class containing unfiltered results
clsFilmCollection AllFilms = new clsFilmCollection();
//Create an instance of the filtered data
clsFilmCollection FilteredFilms = new clsFilmCollection();
//Apply a blank string (should return all records)
FilteredFilms.FilterByTitle("");
//Test to see that the two values are the same
Assert.AreEqual(AllFilms.Count, FilteredFilms.Count);
}
void DisplayAddress()
{
clsFilmCollection FilmList = new clsFilmCollection();
FilmList.ThisFilm.Find(FilmId);
txtFilmName.Text = FilmList.ThisFilm.FilmName;
txtFilmDesc.Text = FilmList.ThisFilm.FilmDescription;
txtCert.Text = FilmList.ThisFilm.FilmCertificate;
txtRelease.Text = FilmList.ThisFilm.FilmReleaseDate.ToString();
txtDeparture.Text = FilmList.ThisFilm.FilmDepartureDate.ToString();
}
public void AddMethodOk()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilm TestItem = new clsFilm();
Int32 primaryKey = 0;
TestItem.Title = "Top Gun: Maverick (2021)";
AllFilms.ThisFilm = TestItem;
primaryKey = AllFilms.Add();
TestItem.FilmId = primaryKey;
AllFilms.ThisFilm.Find(primaryKey);
Assert.AreEqual(AllFilms.ThisFilm, TestItem);
}
public static List<string> SearchFilms(string prefixTest, int count)
{
clsFilmCollection AllFilms = new clsFilmCollection();
List<string> filmTitles = new List<string>();
foreach (clsFilm aFilm in AllFilms.AllFilms)
{
if (aFilm.Title.Contains(prefixTest))
{
filmTitles.Add(aFilm.Title);
}
}
return filmTitles;
}
protected void grdAllFilms_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
clsFilmCollection AllFilmsInDatabase = new clsFilmCollection();
string title = ((TextBox)grdAllFilms.Rows[e.RowIndex].FindControl("txtTitle")).Text;
Session["Title"] = title;
AllFilmsInDatabase = new clsFilmCollection();
foreach (string error in AllFilmsInDatabase.ThisFilm.Valid(title))
{
Label lblError = new Label();
lblError.Text = error;
pnlActionFilmErrorBody.Controls.Add(lblError);
}
}
public void ThisFilmPropertyOK()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilm TestFilm = new clsFilm();
TestFilm.FilmName = "test film";
TestFilm.FilmDescription = "test description";
TestFilm.FilmCertificate = "u";
TestFilm.FilmReleaseDate = DateTime.Now.Date;
TestFilm.FilmShowing = true;
TestFilm.FilmDepartureDate = DateTime.Now.Date.AddYears(1);
AllFilms.ThisFilm = TestFilm;
Assert.AreEqual(AllFilms.ThisFilm, TestFilm);
}
public void UpdateMethodOk()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilm TestItem = new clsFilm();
Int32 primaryKey = 0;
TestItem.Title = "No Time To Die (2020)";
AllFilms.ThisFilm = TestItem;
primaryKey = AllFilms.Add();
TestItem.FilmId = primaryKey;
TestItem.Title = "No Time To Die (2021)";
AllFilms.ThisFilm = TestItem;
AllFilms.Update();
AllFilms.ThisFilm.Find(primaryKey);
Assert.AreEqual(AllFilms.ThisFilm, TestItem);
}
public void ThisFilmPropertyOK()
{
//Create an instance of the class we want to create
clsFilmCollection AllFilms = new clsFilmCollection();
//Create some test data to assign to the property
clsFilm TestFilm = new clsFilm();
//Set the properties of the test object
TestFilm.Title = "Punch 3: Punch Harderer";
TestFilm.Duration = 75;
TestFilm.AgeRatingID = 4;
TestFilm.GenreID = 1;
//Assign the data to the property
AllFilms.ThisFilm = TestFilm;
//Test to see that the two values are the same
Assert.AreEqual(AllFilms.ThisFilm, TestFilm);
}
public void DeleteByFilmIdMethodOk()
{
bool found;
clsFilmGenreCollection AllFilmGenres = new clsFilmGenreCollection();
clsFilmCollection AllFilms = new clsFilmCollection();
AllFilms.ThisFilm.Title = "test";
Int32 primaryKey = AllFilms.Add();
Int32 genreId = 1;
AllFilmGenres.ThisFilmGenre.FilmId = primaryKey;
AllFilmGenres.ThisFilmGenre.GenreId = genreId;
AllFilmGenres.Add();
AllFilmGenres.DeleteByFilmId();
found = AllFilmGenres.ThisFilmGenre.Find(primaryKey, genreId);
Assert.IsFalse(found);
}
protected void ButtonOK_Click(object sender, EventArgs e)
{
clsFilm AFilm = new clsFilm();
string FilmName = txtFilmName.Text;
string FilmDescription = txtFilmDesc.Text;
string FilmCertificate = txtCert.Text;
string FilmReleaseDate = txtRelease.Text;
string FilmDepartureDate = txtDeparture.Text;
Boolean FilmShowing = showingCheck.Checked;
string Error = "";
Error = AFilm.Valid(FilmName, FilmDescription, FilmCertificate, FilmReleaseDate, FilmDepartureDate);
if (Error == "")
{
AFilm.FilmID = FilmId;
AFilm.FilmName = FilmName;
AFilm.FilmDescription = FilmDescription;
AFilm.FilmCertificate = FilmCertificate;
AFilm.FilmReleaseDate = Convert.ToDateTime(FilmReleaseDate);
AFilm.FilmDepartureDate = Convert.ToDateTime(FilmDepartureDate);
clsFilmCollection FilmList = new clsFilmCollection();
if (FilmId == -1)
{
FilmList.ThisFilm = AFilm;
FilmList.Add();
}
else
{
FilmList.ThisFilm.Find(FilmId);
FilmList.ThisFilm = AFilm;
FilmList.Update();
}
Response.Redirect("FilmViewer.aspx");
//Session["AFilm"] = AFilm;
}
else
{
lblError.Text = Error;
}
}
protected void Page_Load(object sender, EventArgs e)
{
pnlAllSearchResults.Visible = false;
pnlError.Visible = false;
if (!IsPostBack)
{
try
{
string searchText = Request.QueryString["searchText"];
Session["searchText"] = searchText;
CheckIfUserIsLoggedIn();
clsFilmCollection AllFilms = new clsFilmCollection();
clsDataConnection DB = new clsDataConnection();
clsDynamicPanel aDynamicPanel = new clsDynamicPanel();
if (AllFilms.SearchForFilm(searchText).Count != 0)
{
foreach (clsFilm aFilm in AllFilms.SearchForFilm(searchText))
{
DB = new clsDataConnection();
DB.AddParameter("@FilmId", aFilm.FilmId);
DB.Execute("sproc_tblLinksFilterByFilmId");
string imdbId = DB.DataTable.Rows[0]["ImdbId"].ToString();
pnlActualSearchResults.Controls.Add(aDynamicPanel.GenerateSearchResultsPanel(aFilm.Title, imdbId));
}
GenerateMoods();
pnlAllSearchResults.Visible = true;
}
else
{
pnlActualSearchResults.Controls.Clear();
pnlActualSearchResults.Controls.Add(aDynamicPanel.GenerateEmptySearchResultsPanel());
}
}
catch
{
pnlError.Visible = true;
}
}
}
void LoadData()
{
try
{
clsFilmCollection AllFilmsInDatabase = new clsFilmCollection();
AllFilmsInDatabase = new clsFilmCollection();
grdAllFilms.DataSource = AllFilmsInDatabase.AllFilms;
grdAllFilms.DataBind();
if (!string.IsNullOrEmpty(txtFilmSearch.Text.Trim()))
{
grdAllFilms.DataSource = AllFilmsInDatabase.SearchForFilm(txtFilmSearch.Text);
grdAllFilms.DataBind();
}
}
catch
{
pnlError.Visible = true;
}
}
public void ListAndCountOK()
{
clsFilmCollection AllFilms = new clsFilmCollection();
List <clsFilm> TestList = new List <clsFilm>();
clsFilm TestFilm = new clsFilm();
TestFilm.FilmName = "test film";
TestFilm.FilmDescription = "test description";
TestFilm.FilmCertificate = "u";
TestFilm.FilmReleaseDate = DateTime.Now.Date;
TestFilm.FilmShowing = true;
TestFilm.FilmDepartureDate = DateTime.Now.Date.AddYears(1);
TestList.Add(TestFilm);
AllFilms.FilmList = TestList;
Assert.AreEqual(AllFilms.Count, TestList.Count);
}
public void DeleteMethodOK()
{
clsFilmCollection AllFilms = new clsFilmCollection();
clsFilm TestFilm = new clsFilm();
Int32 PrimaryKey = 0;
TestFilm.FilmName = "Frazers Film";
TestFilm.FilmDescription = "test description, test description, test description, " +
"test description, test description, ";
TestFilm.FilmCertificate = "12";
TestFilm.FilmReleaseDate = DateTime.Now.Date;
TestFilm.FilmDepartureDate = DateTime.Now.Date.AddYears(1);
AllFilms.ThisFilm = TestFilm;
PrimaryKey = AllFilms.Add();
TestFilm.FilmID = PrimaryKey;
AllFilms.ThisFilm.Find(PrimaryKey);
AllFilms.Delete();
Boolean Found = AllFilms.ThisFilm.Find(PrimaryKey);
Assert.IsFalse(Found);
}
