//sorting movies public ActionResult Index99(int from, int to, bool Decrease = false, bool Increase = false) { MovieDal mdb = new MovieDal(); List <Movie> lm = new List <Movie>(); string[] formats = { "DD/MM/yyyy" }; //price range foreach (Movie x in mdb.Movies.ToList <Movie>().Where(m => m.Sale == null && m.Price > from && m.Price < to)) { ViewBag.range = "from " + from.ToString() + " to " + to.ToString(); //both catefory and date if (Request.Form["Select Category"] != null && Request.Form["Select Category"].ToString() != "All" && DateTime.TryParse(Request.Form["date1"], out DateTime date1) == true) { ViewBag.category = Request.Form["Select Category"].ToString(); ViewBag.date5 = date1.ToString(); if (x.Category == Request.Form["Select Category"].ToString() && x.Date.Year == date1.Year && x.Date.Month == date1.Month && x.Date.Day == date1.Day) { lm.Add(x); } } //sort by category alone else if (Request.Form["Select Category"] != null && Request.Form["Select Category"].ToString() != "All") { ViewBag.category = Request.Form["Select Category"].ToString(); if (Request.Form["Select Category"].ToString() != "All") { if (x.Category == Request.Form["Select Category"].ToString()) { lm.Add(x); } } } //sort date alone else if (DateTime.TryParse(Request.Form["date1"], out DateTime date11) == true) { if (x.Date.Year == date11.Year && x.Date.Month == date11.Month && x.Date.Day == date11.Day) { ViewBag.date5 = date11.ToString(); lm.Add(x); } } else { lm.Add(x); } } //price decrease .. increase if (Decrease) { lm = lm.OrderBy(q => q.Price).Reverse().ToList(); } if (Increase) { lm = lm.OrderBy(q => q.Price).ToList(); } return(View("Home", lm)); }
//delete movie public ActionResult Delete(int id) { using (MovieDal mdb = new MovieDal()) { return(View(mdb.Movies.Where(x => x.mid == id).FirstOrDefault())); } }
public ActionResult EnterCategory() { ViewBag.Flag = 4; MovieDal dal = new MovieDal(); MovieGallery gallery = new MovieGallery(); gallery.Movies = new List <Movie>(); string CategoryValue = Request.Form["txtCategory"]; if (CategoryValue != null) { List <Movie> temp = (from m in dal.Movies select m).ToList <Movie>(); foreach (Movie movie in temp) { if (movie.Category == CategoryValue) { gallery.Movies.Add(movie); } } if (gallery.Movies.Count == 0) { ViewBag.ErrorMsg = "No Movies found for category entered"; } } return(View("Index", gallery)); }
public void Initialize() { _context = new MvcMovieDbContext("MvcMovieTest"); _dal = new MovieDal(_context); _service = new MovieService(_dal); _controller = new MoviesController(_service); _movieToCreate = new Movie { Title = "The Departed", ReleaseDate = DateTime.Parse("2006-01-01"), Genre = "Suspense Thriller", Price = 19.99M, Rating = "R" }; var otherMovie = new Movie { Title = "Star Wars: Episode IV - A New Hope", ReleaseDate = DateTime.Parse("1976-01-01"), Genre = "Action", Price = 19.99M, Rating = "PG" }; _existingMovies = new List <Movie> { _movieToCreate, otherMovie }; }
public ActionResult MoviesJson() { MovieDal c = new MovieDal(); List <Movie> obj = c.Movies.ToList <Movie>(); return(Json(obj, JsonRequestBehavior.AllowGet)); }
public ActionResult MovieGallery() { TicketDal temp = new TicketDal(); MovieViewModel y = new MovieViewModel(); List <Ticket> tickets = (from x in temp.Tickets where x.email.Equals("1") select x).ToList <Ticket>(); if (tickets.Count == 0) { Ticket obj = new Ticket() { date = "None", time = "None", email = "1", HallId = "None", seat = "None" }; temp.Tickets.Add(obj); temp.SaveChanges(); } List <string> emails = (from x in temp.Tickets select x.email).ToList <string>(); string key = MaxKey(emails); if (Session["email"] == null) { Session["email"] = key; } MovieDal dal = new MovieDal(); MovieViewModel cvm = new MovieViewModel(); List <Movie> movies = dal.Movies.ToList <Movie>(); cvm.movie = new Movie(); cvm.movies = movies; return(View(cvm)); }
public ActionResult Submit() { MovieViewModel mvm = new MovieViewModel(); Movie MyMovie = new Movie() { ID = int.Parse(Request.Form["Movie.ID"]).ToString(), mName = Request.Form["Movie.mName"], mDate = //DateTime.ParseExact(Request.Form["Movie.mDate"], @"MM/dd/yyyy hh:mm:ss", CultureInfo.InvariantCulture), DateTime.Parse(Request.Form["Movie.mDate"]), Price = int.Parse(Request.Form["Movie.Price"]), HallName = Request.Form["Movie.HallName"], Age = int.Parse(Request.Form["Movie.Age"]), Category = Request.Form["Movie.Category"], }; MovieDal dal = new MovieDal(); if (ModelState.IsValid) { dal.Movies.Add(MyMovie); dal.SaveChanges(); mvm.Movie = new Movie(); } else { mvm.Movie = MyMovie; } mvm.Movies = dal.Movies.ToList <Movie>(); return(View("EnterMovie", mvm)); }
// GET: Ticket public ActionResult seats(int id) { using (MovieDal m = new MovieDal()) { return(View(m.Movies.ToList <Movie>().Where(x => x.mid == id).FirstOrDefault())); } }
public ActionResult UploadFiles(Movie MyMovie, HttpPostedFileBase moviePicture) { if (ModelState.IsValid) { if (ModelState.IsValid) { MovieDal dal = new MovieDal(); MyMovie.moviePicture = moviePicture.FileName; dal.MOVIES.Add(MyMovie); dal.SaveChanges(); } try { //Method 2 Get file details from HttpPostedFileBase class if (moviePicture != null) { string path = Path.Combine(Server.MapPath("~/Images"), Path.GetFileName(moviePicture.FileName)); moviePicture.SaveAs(path); } ViewBag.FileStatus = "File uploaded successfully."; } catch (Exception) { ViewBag.FileStatus = "Error while file uploading.";; } } return(RedirectToAction("NewMovie")); }
public ActionResult RemoveMovie() { MovieDal movies = new MovieDal(); movies.GetAllMovies(); return(View(movies)); }
public ActionResult BookTicket(string idSeat) { /*TicketsDal dal = new TicketsDal(); * MovieDal movieDal = new MovieDal(); * TicketsViewModel mvm = new TicketsViewModel(); * var item = movieDal.MOVIES.Where(a => a.ID == id).FirstOrDefault(); ; * List<Tickets> tickets = dal.TicketsList.ToList(); * mvm.Tickets = new Tickets(); * mvm.TicketsList = tickets; * return View(mvm);*/ Tickets mvm = new Tickets(); ItemCart itemCart = new ItemCart(); MovieDal dal = new MovieDal(); SeatDal seatDal = new SeatDal(); var itemSeat2 = seatDal.Seats.Where(a => a.IdSeat == idSeat).FirstOrDefault(); var itemsMovie3 = dal.MOVIES.Where(a => a.SALLE == itemSeat2.Hall && a.showtime == itemSeat2.date).FirstOrDefault(); //var item = dal.MOVIES.Where(a => a.ID == itemsMovie3.ID).FirstOrDefault(); //var itemSeat = seatDal.Seats.Where(a => a.IdSeat == id).FirstOrDefault(); mvm.MOVIENAME = itemsMovie3.name; mvm.SHOWTIME = itemsMovie3.showtime; mvm.COST = itemsMovie3.price; mvm.SEAT = itemSeat2.Number; return(View(mvm)); }
public ActionResult SubRemoveMovie(Movie obj) { MovieDal dal = new MovieDal(); TicketDal tdal = new TicketDal(); string name = obj.MovieName.ToString(); string date = obj.date.ToString(); string time = obj.time.ToString(); List <Movie> exist = (from x in dal.Movies where x.MovieName.Equals(name) && x.date.Equals(date) && x.time.Equals(time) select x).ToList <Movie>(); if (exist.Count == 0) { TempData["msg"] = "Movie doesn't exist !!!"; TempData["color"] = "red"; return(View("RemoveMovie", obj)); } string hid = exist[0].HallId; List <Ticket> Texist = (from x in tdal.Tickets where x.MovieName.Equals(name) && x.date.Equals(date) && x.time.Equals(time) && x.HallId.Equals(hid) select x).ToList <Ticket>(); if (Texist.Count != 0) { TempData["msg"] = "You can't remove this movie , someone buy it!!!"; TempData["color"] = "red"; return(View("RemoveMovie", obj)); } dal.Movies.Remove(exist[0]); dal.SaveChanges(); TempData["msg"] = "Movie Removed Successfully !!!"; TempData["color"] = "blue"; return(View("RemoveMovie")); }
public ActionResult EnterDate() { ViewBag.Flag = 1; MovieDal dal = new MovieDal(); MovieGallery gallery = new MovieGallery(); gallery.Movies = new List <Movie>(); string dateValue = Request.Form["txtDate"]; if (dateValue != null) { DateTime convertedDate = DateTime.Parse(dateValue); List <Movie> temp = (from m in dal.Movies select m).ToList <Movie>(); foreach (Movie movie in temp) { if (movie.mDate.Date == convertedDate.Date) { gallery.Movies.Add(movie); } } if (gallery.Movies.Count == 0) { ViewBag.ErrorMsg = "No Movies found for date entered"; } } return(View("Index", gallery)); }
public ActionResult SubOrder() { MovieDal dal = new MovieDal(); MovieViewModel cvm = new MovieViewModel(); List <Movie> movies; switch ((string)Request.Form["states"]) { case "Price increase": movies = dal.Movies.OrderBy(c => c.price.Length).ThenBy(c => c.price).ToList <Movie>(); break; case "Price decrease": movies = dal.Movies.OrderByDescending(x => x.price.Length).ThenByDescending(c => c.price).ToList <Movie>(); break; case "Most popular": movies = SortByPopular(dal.Movies.ToList <Movie>()); break; default: movies = dal.Movies.OrderBy(x => x.category).ToList <Movie>(); break; } cvm.movie = new Movie(); cvm.movies = movies; return(View("MovieGallery", cvm)); }
public ActionResult ChangePrice() { MovieViewModel mvm = new MovieViewModel(); mvm.Movie = new Movie(); MovieDal dal = new MovieDal(); string nameValue = Request.Form["txtMovieName"]; int price = 0; if (Request.Form["MoviePrice"] != null) { price = int.Parse(Request.Form["MoviePrice"]); } if (MovieExist(nameValue)) { Movie addMovie = dal.Movies.First(a => a.mName == nameValue); addMovie.Price = price; dal.SaveChanges(); mvm.Movies = dal.Movies.ToList <Movie>(); return(View(mvm)); } mvm.Movies = dal.Movies.ToList <Movie>(); return(View(mvm)); }
public ActionResult EditMoviePage(Movie m1) {//take us to the edit movie page view - in the edit action we need to chack only if ModelState.IsValid if (ModelState.IsValid) { //connect to db MovieDal dal = new MovieDal(); //get the max value of OrderNum Movie m2 = (from m in dal.movies where m.MovieName == m1.MovieName select m).FirstOrDefault(); //edit movie in db m2.MovieName = m1.MovieName; m2.Type = m1.Type; m2.Description = m1.Description; m2.Link = m1.Link; m2.ImageLink = m1.ImageLink; dal.SaveChanges(); return(RedirectToAction("MovieListPage")); } return(View(m1)); }
public ActionResult PriceRange() { ViewBag.Flag = 3; MovieDal dal = new MovieDal(); MovieGallery gallery = new MovieGallery(); gallery.Movies = new List <Movie>(); string str = Request.Form["price1"]; if (str != null) { int PriceValue1 = int.Parse(Request.Form["price1"]); int PriceValue2 = int.Parse(Request.Form["price2"]); List <Movie> temp = (from m in dal.Movies select m).ToList <Movie>(); foreach (Movie movie in temp) { if (movie.Price >= PriceValue1 && movie.Price <= PriceValue2) { gallery.Movies.Add(movie); } } } return(View("Index", gallery)); }
public ActionResult Save(string id) { using (MovieDal dc = new MovieDal()) { var v = dc.MOVIES.Where(a => a.ID == id).FirstOrDefault(); return(View(v)); } }
public ActionResult GetList() { using (MovieDal db = new MovieDal()) { List <Movie> empList = db.MOVIES.ToList <Movie>(); return(Json(new { data = empList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult SortByCategory() { MovieDal dal = new MovieDal(); MovieGallery gallery = new MovieGallery(); gallery.Movies = dal.Movies.OrderBy(m => m.Category).ToList <Movie>(); return(View("Index", gallery)); }
public ActionResult SortByMaxPrice() { MovieDal dal = new MovieDal(); MovieGallery gallery = new MovieGallery(); gallery.Movies = dal.Movies.OrderByDescending(m => m.Price).ToList <Movie>(); return(View("Index", gallery)); }
public ActionResult SubFillter() { MovieDal dal = new MovieDal(); MovieViewModel cvm = new MovieViewModel(); List <Movie> movies = (from x in dal.Movies where x.preprice != null select x).ToList <Movie>(); cvm.movie = new Movie(); cvm.movies = movies; return(View("MovieGallery", cvm)); }
// GET: Movie public ActionResult Index() { MovieDal dal = new MovieDal(); MovieGallery gallery = new MovieGallery(); List <Movie> Movies = dal.Movies.ToList <Movie>(); gallery.Movies = Movies; return(View(gallery)); }
public ActionResult EnterMovie() { MovieDal dal = new MovieDal(); MovieViewModel mvm = new MovieViewModel(); List <Movie> Movies = dal.Movies.ToList <Movie>(); mvm.Movie = new Movie(); mvm.Movies = Movies; return(View(mvm)); }
public ActionResult MovieGallery(MovieViewModel model) { MovieDal dal = new MovieDal(); MovieViewModel mvm = new MovieViewModel(); List <Movie> movies = dal.MOVIES.ToList(); mvm.Movie = new Movie(); mvm.Movies = movies; return(View(mvm)); }
public List <Movie> MoviesByTypeValue(string TypeValue) {//get the list of Movies that have type the same as the TypeValue if exist in our users db //connect to db MovieDal dal = new MovieDal(); List <Movie> movies = (from m in dal.movies where m.Type == TypeValue select m).ToList <Movie>(); return(movies); }
public Movie GetMovie(string MovieName) {//get the Movie by name //connect to db MovieDal dal = new MovieDal(); Movie movie = (from m in dal.movies where m.MovieName == MovieName select m).FirstOrDefault(); return(movie); }
public bool checkMovieName(string MovieName) {//check if the movie name exist in our users db //connect to db MovieDal dal = new MovieDal(); bool check = (from m in dal.movies where m.MovieName == MovieName select m).Any(); return(check); }
public ActionResult Edit(int id) { TicketsDal dal = new TicketsDal(); var item = dal.TicketsList.Where(a => a.ID == id).FirstOrDefault(); MovieDal dal2 = new MovieDal(); var item2 = dal2.MOVIES.Where(a => a.name == item.MOVIENAME && a.showtime == item.SHOWTIME).FirstOrDefault(); dal.TicketsList.Remove(item); dal.SaveChanges(); return(RedirectToAction("~/Home/SeatGalleryUser", new { id = item2.ID })); }
public ActionResult MovieListPage() {//take us to the movie list page view //connect to db movies MovieDal dal = new MovieDal(); MovieList list = new MovieList(); list.movies = (from m in dal.movies select m).ToList <Movie>(); return(View(list)); }