//
// GET: /Movie/Edit/5
public ActionResult Edit(int id)
{
using (var ctx = new MoviesContext())
{
var movie = ctx.MovieSet.Where(m => m.ID == id).First();
return View(movie);
}
}
public ActionResult Delete(int id)
{
using (var ctx = new MoviesContext())
{
var movie = ctx.MovieSet.Where(m => m.ID == id).First();
ctx.DeleteObject(movie);
ctx.SaveChanges();
}
return RedirectToAction("Index");
}
//
// GET: /Movie/Details/5
public ActionResult Details(int id)
{
using (var ctx = new MoviesContext())
{
var movie = ctx.MovieSet
.Include("Reviews")
.Where(m => m.ID == id)
.First();
return View(movie);
}
}
public ActionResult Edit(int id, FormCollection collection)
{
using (var ctx = new MoviesContext())
{
var movie = ctx.MovieSet.Where(m => m.ID == id).First();
TryUpdateModel(movie, new string[] { "Title", "ReleaseDate" });
if (ModelState.IsValid)
{
ctx.SaveChanges();
return RedirectToAction("Index");
}
return View(movie);
}
}
public ActionResult Create([Bind(Exclude="ID")]
Movie movie)
{
if (ModelState.IsValid)
{
using (var ctx = new MoviesContext())
{
ctx.AddToMovieSet(movie);
ctx.SaveChanges();
return RedirectToAction("Index");
}
}
return View();
}
//
// GET: /Movie/
public ActionResult Index(string q)
{
using (var ctx = new MoviesContext())
{
var movies = ctx.MovieSet
.Where(m => m.Title.StartsWith(q) || q == null)
.OrderByDescending(m => m.Reviews.Average(r => r.Rating))
.Take(10)
.Select(m => new MovieSummary
{
ID = m.ID,
AverageRating = m.Reviews.Average(r => r.Rating),
ReleaseDate = m.ReleaseDate,
Title = m.Title
})
.ToList();
return View(movies);
}
}
