public ActionResult displaydatabase()
{
MovieDBHandler dbhandle = new MovieDBHandler();
ModelState.Clear();
return(View(dbhandle.GetAllMovie()));
}
public ActionResult DisplayAll()
{
MovieDBHandler dbhandle = new MovieDBHandler();
ModelState.Clear();
return(View(dbhandle.DisplayAllMovies()));
}
//Stored procedure to get a count of the actors born listed by state
public ActionResult JM1()
{
MovieDBHandler dbhandle = new MovieDBHandler();
ModelState.Clear();
return(View(dbhandle.GetActorsStateCount()));
}
public ActionResult AD1()
{
MovieDBHandler dbhandle = new MovieDBHandler();
ModelState.Clear();
return(View(dbhandle.GetActionActorCalifornia()));
}
// GET: All tables
public ActionResult Index1()
{
MovieDBHandler dbhandle = new MovieDBHandler();
ModelState.Clear();
return(View(dbhandle.GetMovie()));
}
public ActionResult Edit(int id, Movie smodel)
{
try
{
MovieDBHandler sdb = new MovieDBHandler();
sdb.UpdateDetails(smodel);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// GET: Movie/Delete/5
public ActionResult Delete(int id)
{
try
{
MovieDBHandler sdb = new MovieDBHandler();
if (sdb.DeleteMovie(id))
{
ViewBag.AlertMsg = "Film Deleted Successfully";
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(Movie smodel)
{
try
{
if (ModelState.IsValid)
{
MovieDBHandler sdb = new MovieDBHandler();
if (sdb.AddMovie(smodel))
{
ViewBag.Message = "Movie Details Added Successfully";
ModelState.Clear();
}
}
return(View());
}
catch
{
return(View());
}
}
public ActionResult CK2(String type, int age = 0)
{
MovieDBHandler sdb = new MovieDBHandler();
return(View(sdb.GetActorsByAge(age, type)));
}
//-----------------------------------------Chris Kingdon---------------------------------------
public ActionResult CK1()
{
MovieDBHandler sdb = new MovieDBHandler();
return(View(sdb.GetActorsMovieCount()));
}
public ActionResult AD2()
{
MovieDBHandler sdb = new MovieDBHandler();
return(View(sdb.GetActorNotUSARatingOver75()));
}
//the filter for JM2All
public ActionResult JM2(int id)
{
MovieDBHandler sdb = new MovieDBHandler();
return(View(sdb.GetActorMovies(id)));
}
//gets list of all actors for each movie with a select to filter just the movies for that actor
public ActionResult JM2All()
{
MovieDBHandler sdb = new MovieDBHandler();
return(View(sdb.GetActors()));
}
// GET: Movie/Edit/5
public ActionResult Edit(int id)
{
MovieDBHandler sdb = new MovieDBHandler();
return(View(sdb.GetMovie().Find(smodel => smodel.FilmID == id)));
}
internal static IMovieDBHandler NewMovieDBHandler()
{
return(MovieDBHandler.NewInstance());
}
