public ActionResult DeleteConfirmed(int id)
{
FilmPersonRole filmPersonRole = db.FilmPersonRoles.Find(id);
db.FilmPersonRoles.Remove(filmPersonRole);
db.SaveChanges();
return(RedirectToAction("Index", "Films"));
}
public ActionResult Edit([Bind(Include = "RoleId,PersonId,FilmId,IsActor,IsDirector")] FilmPersonRole filmPersonRole)
{
if (ModelState.IsValid)
{
db.Entry(filmPersonRole).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(filmPersonRole));
}
// GET: FilmPersonRoles/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FilmPersonRole filmPersonRole = db.FilmPersonRoles.Find(id);
if (filmPersonRole == null)
{
return(HttpNotFound());
}
return(View(filmPersonRole));
}
// GET: FilmPersonRoles/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FilmPersonRole filmPersonRole = db.FilmPersonRoles.Find(id);
if (filmPersonRole == null)
{
return(HttpNotFound());
}
//code to generate dropdowns
//FILMS ---------------------------------------------------------------------------------------------
//from the Films model DbSet
//select all columns from the database
//orderby the film title
var filmQuery = from m in db.Films
orderby m.Title
select m;
//construct full films dropdown list preselected with the foreign key
//do so from the query results and display the Film Title
//store in FilmId in the ViewBag
ViewBag.FilmId = new SelectList(filmQuery, "FilmId", "Title", filmPersonRole.FilmId);
//PERSONS --------------------------------------------------------------------------------------------
//from the Persons model DbSet
//select the firstname and lastname as a new field called Name
//and the person id - order by the lastname
var personsQuery = from p in db.Persons
orderby p.LastName
select new
{
Name = p.FirstName + " " + p.LastName,
p.PersonId
};
//construct full films dropdown list preselected with the foreign key
//do so from the query results and display the Name (combined above)
//store in FilmId in the ViewBag
ViewBag.PersonId = new SelectList(personsQuery, "PersonId", "Name", filmPersonRole.PersonId);
return(View(filmPersonRole));
}
// GET: FilmPersonRoles/Create
public ActionResult Create(int?FilmId, int?PersonId, bool isActor)
{
FilmPersonRoleViewModel filmPersonRoleViewModel = new FilmPersonRoleViewModel();
FilmPersonRole filmPersonRole = new FilmPersonRole();
Film film = new Film();
FilmImage filmImage = new FilmImage();
Person person = new Person();
PersonImage personImage = new PersonImage();
if (isActor == true)
{
filmPersonRole.IsActor = true;
filmPersonRole.IsDirector = false;
}
else
{
filmPersonRole.IsActor = false;
filmPersonRole.IsDirector = true;
}
//db.FilmImages.Where(x => x.ImageId == role.FilmId).Single();
if (FilmId == null && PersonId == null)
{
//Return to home page as user is manipulating the url
return(View("~/Views/Home/Index.cshtml"));
}
else if (FilmId == null || FilmId == 0)
{
filmPersonRole.PersonId = PersonId;
person = db.Persons.Where(x => x.PersonId == PersonId).Single();
personImage = db.PersonImages.Where(x => x.ImageId == person.ImageId).Single();
//If FilmId is null then link the existing person to a film choice
//Get film collection for drop down box
var filmQuery = from m in db.Films
orderby m.Title
select m;
ViewBag.Films = new SelectList(filmQuery, "FilmId", "Title", null);
}
else if (PersonId == null || PersonId == 0)
{
filmPersonRole.FilmId = FilmId;
film = db.Films.Where(x => x.FilmId == FilmId).Single();
filmImage = db.FilmImages.Where(x => x.ImageId == film.ImageId).Single();
//If PersonId is null then link the existing film to a person choice
if (isActor)
{
//Get Actors collection for drop down box
var personQuery = from p in db.Persons
where p.IsActor == true
orderby p.LastName
select new
{
FullName = p.FirstName + " " + p.LastName,
p.PersonId
};
ViewBag.Persons = new SelectList(personQuery, "PersonId", "FullName", null);
}
else
{
//Get Directors collection for drop down box
var personQuery = from p in db.Persons
where p.IsDirector == true
orderby p.LastName
select new
{
FullName = p.FirstName + " " + p.LastName,
p.PersonId
};
ViewBag.Persons = new SelectList(personQuery, "PersonId", "FullName", null);
}
}
filmPersonRoleViewModel.ThisFilm = film;
filmPersonRoleViewModel.ThisFilmImage = filmImage;
filmPersonRoleViewModel.ThisFilmPersonRole = filmPersonRole;
filmPersonRoleViewModel.ThisPerson = person;
filmPersonRoleViewModel.ThisPersonImage = personImage;
//generate the view
return(View(filmPersonRoleViewModel));
}
