//ctor(order)
        public EventsData(Event _Event, bool OrderExist)
        {
            if (_Event != null)
            {
                try
                {
                    //first get the full implement
                    evnt = _Event;
                    cartID = evnt.cartID;

                    // get the movieShowTime via Event.MovieShowTimeID
                    movieShowTime = db.MovieShowTimes.Find(Event.MovieShowTimeID);

                    movie = MovieShowTime.Movie;

                    // get the theatres item
                    theaters = (from theat in db.Theaters
                                where theat.MovieTheatersID ==
                                (from rw in db.Rows
                                 where rw.RowsID ==
                                 (from hc in db.HallChairs
                                  where hc.HallChairsID ==
                                  (from co in db.ChairsOrderd
                                   where co.EventID == Event.EventID
                                   select co).FirstOrDefault().HallChairID
                                  select hc).FirstOrDefault().RowID
                                 select rw).FirstOrDefault().TheatersID
                                select theat).SingleOrDefault();

                    // get the TimeScreening item
                    timeScreening = (from ts in db.TimeScreening
                                     where _Event.MovieShowTimeID == ts.MovieShowTimeID && ts.MovieTheatersID == theaters.MovieTheatersID
                                     select ts).SingleOrDefault();

                    ChairsNumber = new List<string>();
                    int[] ChairOrderID = Event.ChairsOrderds.Where(x=>x.EventID== Event.EventID).Select(x=>x.ChairsOrderdiD).ToArray();

                    ChairsNumber.AddRange(EcomLogic.GetChairNumbers(ChairOrderID,Event.ChairsOrderds));
                    getTotalChairsOrdered();

                    OrderDate = DateTime.Now;

                    // if there is a order all fine.. if no , go to catch and make one.
                    try
                    {
                        if (OrderExist == true)
                        {
                            order = (from odr in db.Orders
                                     where odr.EventID == evnt.EventID && odr.CartId == cartID
                                     select odr).SingleOrDefault();
                        }

                    }
                    catch (Exception)
                    {

                        ifEror = "Error by adding the Order.";
                    }

                    ifEror = null;
                }
                catch (Exception ex)
                {
                    ifEror = "There is an error while adding detial's."+ex.Message;
                }
            }
        }
        public ActionResult Create(string movieList, List<DateTime> ShowTime, [Bind(Include = "MovieShowTimeID,MovieID,ShowTime")] MovieShowTime movieshowtime)
        {
            if (ShowTime.Count != 0)
            {
                // create list of Movie Show Time
                List<MovieShowTime> MovieShowTimeList = new List<MovieShowTime>();

                foreach (var item in ShowTime)
                {
                    if (item.Date != Convert.ToDateTime("01/01/0001 00:00:00"))
                    {

                        MovieShowTime ShowTimeItem = new MovieShowTime();
                        // add Detials
                        ShowTimeItem.MovieID = Convert.ToInt32(movieList);
                        ShowTimeItem.ShowTime = item;

                        // add Show Time Item's for the List
                        MovieShowTimeList.Add(ShowTimeItem);
                    }
                }

                //Add all the Item's to DB .
                if (ModelState.IsValid)
                {
                    foreach (var item in MovieShowTimeList)
                    {
                        db.MovieShowTimes.Add(item);
                        db.SaveChanges();
                    }
                    return RedirectToAction("Index", "Movie");
                }
                else
                {
                    ViewBag.ErrorMessage = "Unable to add all the Time's";
                    return RedirectToAction("Create", "Movie");
                }
            }
            else
            {
                ViewBag.ErrorMessage = "Unable to add Movie Show Time";
            }

            return View(movieshowtime);
        }