// GET: FilmProducer
        public ActionResult Index()
        {
            FilmProducerDBHandler dbhandle = new FilmProducerDBHandler();

            ModelState.Clear();
            return(View(dbhandle.GetFilmProducer()));
        }
 public ActionResult Edit(int id, FilmProducer smodel)
 {
     try
     {
         FilmProducerDBHandler sdb = new FilmProducerDBHandler();
         sdb.UpdateDetails(smodel);
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(View());
     }
 }
 // GET: FilmProducer/Delete/5
 public ActionResult Delete(int id)
 {
     try
     {
         FilmProducerDBHandler sdb = new FilmProducerDBHandler();
         if (sdb.DeleteFilmProducer(id))
         {
             ViewBag.AlertMsg = "Film Deleted Successfully";
         }
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(View());
     }
 }
 public ActionResult Create(FilmProducer smodel)
 {
     try
     {
         if (ModelState.IsValid)
         {
             FilmProducerDBHandler sdb = new FilmProducerDBHandler();
             if (sdb.AddFilmProducer(smodel))
             {
                 ViewBag.Message = "FilmProducer Details Added Successfully";
                 ModelState.Clear();
             }
         }
         return(View());
     }
     catch
     {
         return(View());
     }
 }
        // GET: FilmProducer/Edit/5
        public ActionResult Edit(int id)
        {
            FilmProducerDBHandler sdb = new FilmProducerDBHandler();

            return(View(sdb.GetFilmProducer().Find(smodel => smodel.FilmID == id)));
        }