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;
}
}