public ActionResult Index() { List <MovieActorProducerImageVM> MovieVMlist = new List <MovieActorProducerImageVM>(); // to hold list of Movie,Image details var MovieList = (from m in db.Movies join a in db.Actors on m.MovieID equals a.ActorID join p in db.Producers on m.MovieID equals p.ProducerID join i in db.Images on m.MovieID equals i.ImageID select new { m.Name, m.YearOfRelease, m.Plot, a.ActorID, p.ProducerID, i.Title, i.ImagePath, }).ToList(); //query getting data from database from joining tables and storing data in MovieVMList foreach (var item in MovieList) { MovieActorProducerImageVM objVM = new MovieActorProducerImageVM(); // ViewModel objVM.Name = item.Name; //Getting properties based on values in ViewModel objVM.YearOfRelease = item.YearOfRelease; objVM.Plot = item.Plot; objVM.ActorID = item.ActorID; objVM.ProducerID = item.ProducerID; objVM.Title = item.Title; objVM.ImagePath = item.ImagePath; MovieVMlist.Add(objVM); } //Using foreach loop fill data from MovieVMList to List<MovieActorProducerImageVM>. return(View(MovieVMlist)); }
public ActionResult DeleteConfirmed(int id) { MovieActorProducerImageVM mapiVM = db.MovieActorProducerImageVMs.Find(id); db.MovieActorProducerImageVMs.Remove(mapiVM); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MovieID, Name, YearOfRelease, Plot, Title, ImagePath")] MovieActorProducerImageVM mapiVM) { if (ModelState.IsValid) { db.Entry(mapiVM).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mapiVM)); }
public ActionResult Create([Bind(Include = "Name, YearOfRelease, Plot, Title, ImagePath")] MovieActorProducerImageVM mapiVM) { if (ModelState.IsValid) { db.MovieActorProducerImageVMs.Add(mapiVM); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mapiVM)); }
// GET: Movies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MovieActorProducerImageVM mapiVM = db.MovieActorProducerImageVMs.Find(id); if (mapiVM == null) { return(HttpNotFound()); } return(View(mapiVM)); }