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 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); }
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 btnActionFilm_Click(object sender, EventArgs e) { string originalTitle = ""; editFilm = Convert.ToBoolean(Session["EditFilm"]); if (editFilm) { originalTitle = Session["Title"].ToString(); } string newTitle = txtFilmTitle.Text; string tempImdbId = txtImdbId.Text; Int32 imdbId = 0; bool imdbIdOk = false; clsFilm aFilm = new clsFilm(); var filmTitleCheck = aFilm.Valid(newTitle); if (filmTitleCheck.Count != 0) { foreach (string error in filmTitleCheck) { Label lblError = new Label(); lblError.Text = "- " + error; pnlActionFilmErrorBody.Controls.Add(lblError); pnlActionFilmErrorBody.Controls.Add(new LiteralControl("<br />")); } } clsLinkCollection AllLinks = new clsLinkCollection(); var imdbIdCheck = AllLinks.ThisLink.Valid(tempImdbId); if (imdbIdCheck.Count != 0) { foreach (string error in imdbIdCheck) { Label lblError = new Label(); lblError.Text = "- " + error; pnlActionFilmErrorBody.Controls.Add(lblError); pnlActionFilmErrorBody.Controls.Add(new LiteralControl("<br />")); imdbIdOk = false; } pnlActionFilmError.Visible = true; } else { imdbId = Convert.ToInt32(tempImdbId); bool ImdbIdAlreadyExists = AllLinks.ImdbIdAlreadyExistsCheck(imdbId); if (ImdbIdAlreadyExists) { //if (!editFilm) //adding a new film //{ Label lblError = new Label(); lblError.Text = "- IMDBId already assigned to another film"; pnlActionFilmErrorBody.Controls.Add(lblError); pnlActionFilmErrorBody.Controls.Add(new LiteralControl("<br />")); pnlActionFilmError.Visible = true; imdbIdOk = false; //} Int32 originalImdbId = Convert.ToInt32(Session["originalIMDBId"]); if (originalImdbId == imdbId) { imdbIdOk = true; } else { imdbIdOk = false; } //else //if we're editing a film //{ // Int32 originalImdbId = Convert.ToInt32(Session["originalIMDBId"]); // if (originalImdbId != imdbId) // { // Label lblError = new Label(); // lblError.Text = "- IMDBId already assigned to another film"; // pnlActionFilmErrorBody.Controls.Add(lblError); // pnlActionFilmErrorBody.Controls.Add(new LiteralControl("<br />")); // imdbIdOk = false; // } // else // { // imdbIdOk = true; // } //} } else { imdbIdOk = true; } } newTitle = newTitle.TrimEnd(); string yearReleased = " " + "(" + ddlYear.SelectedValue + ")"; string titleAndYearReleased = newTitle + yearReleased; bool filmAlreadyExists = false; clsFilmCollection AllFilms = new clsFilmCollection(); if (AllFilms.FilmAlreadyExistsCheck(titleAndYearReleased)) { if (!editFilm) { Label lblError = new Label(); lblError.Text = "Film already exists"; pnlActionFilmErrorBody.Controls.Add(lblError); filmAlreadyExists = true; } else //if we ARE editing a film { if (newTitle != originalTitle) { Label lblError = new Label(); lblError.Text = "Film already exists"; pnlActionFilmErrorBody.Controls.Add(lblError); filmAlreadyExists = true; } else { filmAlreadyExists = false; } } } else { filmAlreadyExists = false; } if (!editFilm && !filmAlreadyExists && imdbIdOk) { AllFilms = new clsFilmCollection(); AllFilms.ThisFilm.Title = titleAndYearReleased; Int32 filmId = AllFilms.Add(); AllLinks.ThisLink.FilmId = filmId; AllLinks.ThisLink.ImdbId = imdbId; AllLinks.Add(); clsFilmGenreCollection AllFilmGenres = new clsFilmGenreCollection(); foreach (ListItem item in chkbxlstGenres.Items) { if (item.Selected) { AllFilmGenres.ThisFilmGenre.FilmId = filmId; AllFilmGenres.ThisFilmGenre.GenreId = Convert.ToInt32(item.Value); AllFilmGenres.Add(); AllFilmGenres = new clsFilmGenreCollection(); } } LoadData(); pnlActionFilm.Visible = false; } if (editFilm) { AllFilms = new clsFilmCollection(); AllFilms.ThisFilm.FilmId = Convert.ToInt32(Session["FilmId"]); newTitle = titleAndYearReleased; if (newTitle == originalTitle) { AllFilms.ThisFilm.Title = originalTitle; } else { AllFilms.ThisFilm.Title = newTitle; } AllFilms.Update(); clsFilmGenreCollection AllFilmGenres = new clsFilmGenreCollection(); AllFilmGenres.ThisFilmGenre.FilmId = filmId; AllFilmGenres.DeleteByFilmId(); foreach (ListItem item in chkbxlstGenres.Items) { if (item.Selected) { AllFilmGenres.ThisFilmGenre.FilmId = filmId; AllFilmGenres.ThisFilmGenre.GenreId = Convert.ToInt32(item.Value); AllFilmGenres.Add(); AllFilmGenres = new clsFilmGenreCollection(); } } LoadData(); pnlActionFilm.Visible = false; } }