public string AddMovie(string MovieName, string ShowDate, string MatineeTime, string EveningTime, string NightTime, string MovieLang, string MovieCost)
        {
            MovieAdminDAL agent = new MovieAdminDAL();

            AddMovie obj = new Models.AddMovie();
            bool result = false;

            obj.MovieName = MovieName;
            obj.ShowDate = Convert.ToDateTime(ShowDate);
            obj.Language = MovieLang;
            obj.Cost = Convert.ToDecimal(MovieCost);

            bool timing1 = Convert.ToBoolean(MatineeTime);
            bool timing2 = Convert.ToBoolean(EveningTime);
            bool timing3 = Convert.ToBoolean(NightTime);

            try
            {
                if (timing1)
                {
                    obj.Show = "Matinee";
                    result = agent.AddMovie(obj);
                    if (!result)
                    {
                        return "ERROR";
                    }
                }

                if (timing2)
                {
                    obj.Show = "Evening";
                    result = agent.AddMovie(obj);
                    if (!result)
                    {
                        return "ERROR";
                    }
                }

                if (timing3)
                {
                    obj.Show = "Night";
                    result = agent.AddMovie(obj);
                    if (!result)
                    {
                        return "ERROR";
                    }
                }

                return "DONE";
            }
            catch (Exception)
            {
                return "ERROR"; ;
            }
        }
        public ActionResult GetNumberOfTicketsSold(string movieID)
        {
            int MovieId = Convert.ToInt32(movieID);

            MovieAdminDAL agent = new MovieAdminDAL();

            int res = agent.ReturnNoOfTickets(MovieId);

            ViewBag.NoOfTickets = res;
            ViewBag.MovieId = MovieId;

            return PartialView("_ConfirmMovieCancel");
        }
        public string RemoveMovieItemConfirmed(int movieId)
        {
            MovieAdminDAL agent = new MovieAdminDAL();
            bool res = agent.RemoveShow(movieId);

            if (res)
            {
                return "DONE";
            }

            else
            {
                return "ERROR";
            }
        }
        public ActionResult RemoveMovie()
        {
            //Authentication
            string type = (string)Session["UserRole"];
            if (type == null)
            {
                return RedirectToAction("Register", "UserAccount");
            }
            else if (type.CompareTo("M") != 0)
            {
                Session["UserID"] = null;
                Session["UserRole"] = null;
                return RedirectToAction("Login", "UserAccount");
            }

            MovieAdminDAL agent = new MovieAdminDAL();
            MovieViewModel list = agent.MovieShows();
            return View(list);
        }