public bool AddMovieDAL(MovyEntity newMovie) { try { bool isAdded = false; var ObjContext = new CinestarEntitiesDAL(); var objMovie = new Movy(); objMovie.MovieId = newMovie.MovieId; objMovie.MovieName = newMovie.MovieName; objMovie.MovieUrl = newMovie.MovieUrl; objMovie.ReleaseDate = newMovie.ReleaseDate; objMovie.GenreId = newMovie.GenreId; objMovie.LanguageId = newMovie.LanguageId; objMovie.MovieDescription = newMovie.MovieDescription; ObjContext.Movies.Add(objMovie); int NoOfrowsAffected = ObjContext.SaveChanges(); if (NoOfrowsAffected > 0) { isAdded = true; } return(isAdded); } catch (Exception Ex) { return(false); } }
public ActionResult ViewTicket(int id) { TicketEntity createTicket = new TicketEntity(); createTicket = TicketsBL.SearchTicketByIdBL(id); ViewerProfileEntity viewer = ViewrProfilesBL.SearchViewerProfileByIdBL(createTicket.ViewersId); ShowEntity show = ShowsBL.SearchShowByIdBL(createTicket.ShowId); MovyEntity movie = MovieBL.SearchMovieByIdBL(createTicket.MovieId); ScreenEntity screen = ScreenBL.SearchScreenByIdBL(show.ScreenId); ViewBag.ShowDate = show.ShowDate.ToShortDateString(); ViewBag.ShowId = show.ShowId; ViewBag.ViewerId = viewer.ViewersId; ViewBag.MovieName = movie.MovieName; ViewBag.Price = show.Price * createTicket.NoOfTickets; ViewBag.NameOfCustomer = viewer.FirstName + " " + viewer.LastName; ViewBag.ScreenName = screen.ScreenName; ViewBag.noOfTickets = createTicket.NoOfTickets; ViewBag.seatNos = createTicket.Seats; if (createTicket != null) { return(View()); } else { return(Redirect(string.Format("/Movies/ListAllMovies"))); } }
// GET: Tickets/Details/5 public ActionResult CreateTicket() { int nooftickets = int.Parse(Request.QueryString["noofseats"]); int viewerId = int.Parse(Request.QueryString["viewerid"]); int showId = int.Parse(Request.QueryString["showid"]); int movieId = int.Parse(Request.QueryString["movieId"]); string seatnos = Request.QueryString["seatnumbers"]; ViewerProfileEntity viewer = ViewrProfilesBL.SearchViewerProfileByIdBL(viewerId); ShowEntity show = ShowsBL.SearchShowByIdBL(showId); MovyEntity movie = MovieBL.SearchMovieByIdBL(movieId); ScreenEntity screen = ScreenBL.SearchScreenByIdBL(show.ScreenId); ViewBag.ShowDate = show.ShowDate.ToShortDateString(); ViewBag.ShowId = show.ShowId; ViewBag.ViewerId = viewer.ViewersId; ViewBag.MovieName = movie.MovieName; ViewBag.Price = show.Price * nooftickets; ViewBag.NameOfCustomer = viewer.FirstName + " " + viewer.LastName; ViewBag.ScreenName = screen.ScreenName; ViewBag.noOfTickets = nooftickets; ViewBag.seatNos = seatnos; return(View()); }
// GET: Movies/Details/5 public ActionResult DetailsMovie(int id) { MovyEntity movie = MovieBL.SearchMovieByIdBL(id); if (movie == null) { return(HttpNotFound()); } return(View(movie)); }
public static bool UpdateMovieBL(MovyEntity objMovie) { bool isUpdated = false; if (ValidateMovie(objMovie)) { MovieDAL movieOperations = new MovieDAL(); isUpdated = movieOperations.UpdateMovieDAL(objMovie); } return(isUpdated); }
public static bool AddMovieBL(MovyEntity newMovie) { bool movieAdded = false; if (ValidateMovie(newMovie)) { MovieDAL movieOperations = new MovieDAL(); movieAdded = movieOperations.AddMovieDAL(newMovie); } return(movieAdded); }
public ActionResult SearchAuto(MovyEntity movie) { List <SelectListItem> genreList = GenreBL.ViewAllGenreBL().Select(n => new SelectListItem { Value = n.GenreId.ToString(), Text = n.GenreName }).ToList();; var genreTip = new SelectListItem() { Value = null, Text = "-- genre --" }; genreList.Insert(0, genreTip); ViewBag.generList = new SelectList(genreList, "Value", "Text"); List <SelectListItem> languageList = LanguageBL.ViewAllLanguageBL().Select(n => new SelectListItem { Value = n.LanguageId.ToString(), Text = n.LanguageName }).ToList();; var languageTip = new SelectListItem() { Value = null, Text = "-- Language --" }; languageList.Insert(0, languageTip); ViewBag.langList = new SelectList(languageList, "Value", "Text"); ////Note : you can bind same list from database List <MovyEntityNew> ObjList = new List <MovyEntityNew>(); ObjList = MovieBL.GetAllMoviesBL(); ////Searching records from list using LINQ query //var movieList = (from N in ObjList // where N.MovieName.StartsWith(Prefix) || N.MovieName.StartsWith(Prefix.ElementAt(0).ToString().ToUpper()) // select new { N.MovieName }); //return Json(movieList, JsonRequestBehavior.AllowGet); var movieList = (from N in ObjList where N.MovieName.ToLower().Equals(movie.MovieName.ToLower()) select N); MovyEntityNew movieResult = movieList.FirstOrDefault(); if (movieResult != null) { string url = string.Format("/Movies/MovieDetails/" + movieResult.MovieId); return(Redirect(url)); } else { string url = string.Format("/Movies/ListAllMovies"); return(Redirect(url)); } }
//add view here // GET: Movies/Details/5 public ActionResult MovieDetails(int id) { MovyEntity movie = MovieBL.SearchMovieByIdBL(id); ViewBag.language = LanguageBL.SearchLanguageBL(movie.LanguageId).LanguageName; ViewBag.genre = GenreBL.SearchGenreBL(movie.GenreId).GenreName; movie.ReleaseDate = movie.ReleaseDate.Date; if (movie == null) { return(HttpNotFound()); } return(View(movie)); }
// GET: Movies/Delete/5 public ActionResult DeleteMovie(int id) { //if (id == null) //{ // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); //} MovyEntity movie = MovieBL.SearchMovieByIdBL(id); if (movie == null) { return(HttpNotFound()); } return(View(movie)); }
// GET: Movies public ActionResult ListAllMovies(MovyEntityNew movie, MovyEntity movieFilter) { List <SelectListItem> genreList = GenreBL.ViewAllGenreBL().Select(n => new SelectListItem { Value = n.GenreId.ToString(), Text = n.GenreName }).ToList();; var genreTip = new SelectListItem() { Value = null, Text = "-- genre --" }; genreList.Insert(0, genreTip); ViewBag.generList = new SelectList(genreList, "Value", "Text"); List <SelectListItem> languageList = LanguageBL.ViewAllLanguageBL().Select(n => new SelectListItem { Value = n.LanguageId.ToString(), Text = n.LanguageName }).ToList();; var languageTip = new SelectListItem() { Value = null, Text = "-- Language --" }; languageList.Insert(0, languageTip); ViewBag.langList = new SelectList(languageList, "Value", "Text"); string username = Request.QueryString["username"]; string genrename = GenreBL.SearchGenreBL(movieFilter.GenreId).GenreName; string languagename = LanguageBL.SearchLanguageBL(movieFilter.LanguageId).LanguageName; List <MovyEntityNew> listMovies = MovieBL.GetAllMoviesBL(); var query = from item in listMovies where item.Genre.Equals(genrename) || movieFilter.GenreId == 0 where item.Language.Equals(languagename) || movieFilter.LanguageId == 0 select item; if (Session["Username"] != null && Session["ViewerId"] != null) { ViewBag.ViewerId = Session["ViewerId"]; return(View(query)); } else { string url = string.Format("/Users/LogIn"); return(Redirect(url)); } }
public ActionResult EditMovie(MovyEntity movy) { bool isUpdated = false; if (ModelState.IsValid) { isUpdated = MovieBL.UpdateMovieBL(movy); if (isUpdated) { return(RedirectToAction("Index")); } } return(View(movy)); }
private static bool ValidateMovie(MovyEntity movie) { StringBuilder sd = new StringBuilder(); bool validMovie = true; if (movie.MovieName == string.Empty) { validMovie = false; sd.Append(Environment.NewLine + "Movie Name required"); } if (movie.MovieDescription == string.Empty) { validMovie = false; sd.Append(Environment.NewLine + "Movie description required"); } return(validMovie); }
public static MovyEntity SearchMovieByIdDAL(int id) { CinestarEntitiesDAL ObjContext = new CinestarEntitiesDAL(); var movieQuery = from item in ObjContext.Movies where item.MovieId == id select item; Movy movie = ObjContext.Movies.Find(id); MovyEntity entity = new MovyEntity(); entity.GenreId = movie.GenreId; entity.LanguageId = movie.LanguageId; entity.MovieDescription = movie.MovieDescription; entity.MovieId = movie.MovieId; entity.MovieName = movie.MovieName; entity.MovieUrl = movie.MovieUrl; entity.ReleaseDate = movie.ReleaseDate; return(entity); }
public bool UpdateMovieDAL(MovyEntity updateMovie) { bool movieUpdated = false; var ObjContext = new CinestarEntitiesDAL(); var objMovie = ObjContext.Movies.Find(updateMovie.MovieId); if (objMovie != null) { objMovie.MovieId = updateMovie.MovieId; objMovie.MovieName = updateMovie.MovieName; objMovie.MovieUrl = updateMovie.MovieUrl; objMovie.ReleaseDate = updateMovie.ReleaseDate; objMovie.GenreId = updateMovie.GenreId; objMovie.LanguageId = updateMovie.LanguageId; objMovie.MovieDescription = updateMovie.MovieDescription; int NoofRowsAffected = ObjContext.SaveChanges(); movieUpdated = (NoofRowsAffected > 0); } return(movieUpdated); }
public ActionResult AddMovie(MovyEntity movy) { List <SelectListItem> genreList = GenreBL.ViewAllGenreBL().Select(n => new SelectListItem { Value = n.GenreId.ToString(), Text = n.GenreName }).ToList();; var genreTip = new SelectListItem() { Value = null, Text = "--- select genre ---" }; genreList.Insert(0, genreTip); ViewBag.generList = new SelectList(genreList, "Value", "Text"); List <SelectListItem> languageList = LanguageBL.ViewAllLanguageBL().Select(n => new SelectListItem { Value = n.LanguageId.ToString(), Text = n.LanguageName }).ToList();; var languageTip = new SelectListItem() { Value = null, Text = "--- select Language ---" }; languageList.Insert(0, languageTip); ViewBag.langList = new SelectList(languageList, "Value", "Text"); bool isAdded = false; if (ModelState.IsValid) { isAdded = MovieBL.AddMovieBL(movy); if (isAdded) { return(RedirectToAction("Index")); } } return(View(movy)); }
public ActionResult CreateTicket(TicketEntity ticket) { int nooftickets = int.Parse(Request.QueryString["noofseats"]); int viewerId = int.Parse(Request.QueryString["viewerid"]); int showId = int.Parse(Request.QueryString["showid"]); int movieId = int.Parse(Request.QueryString["movieId"]); string seatnos = Request.QueryString["seatnumbers"]; ViewerProfileEntity viewer = ViewrProfilesBL.SearchViewerProfileByIdBL(viewerId); ShowEntity show = ShowsBL.SearchShowByIdBL(showId); MovyEntity movie = MovieBL.SearchMovieByIdBL(movieId); ScreenEntity screen = ScreenBL.SearchScreenByIdBL(show.ScreenId); TicketEntity createTicket = new TicketEntity(); createTicket.NoOfTickets = nooftickets; createTicket.ShowId = showId; ViewBag.MovieName = movie.MovieName; createTicket.Price = show.Price * nooftickets; createTicket.ViewersId = viewer.ViewersId; createTicket.TransactionDate = DateTime.Now.Date; createTicket.MovieId = movie.MovieId; createTicket.Seats = seatnos; if (ModelState.IsValid) { var IsAdded = TicketsBL.CreateTicketBL(createTicket); if (IsAdded) { return(Redirect(string.Format("/Payments/CompletePayment"))); } else { return(Redirect(string.Format("/SeatLayout/SelectSeatsView"))); } } else { return(Redirect(string.Format("/SeatLayout/SelectSeatsView"))); } }
public ActionResult FilterResult(MovyEntity movie) { string username = Request.QueryString["username"]; return(RedirectToAction("ListAllMovies", movie)); //List<MovyEntity> listMovies = MovieBL.GetAllMoviesBL(); //var query = from item in listMovies // where item.GenreId == movie.GenreId || movie.GenreId == 0 || movie.GenreId < 0 // where item.LanguageId == movie.LanguageId || movie.LanguageId == 0 || movie.LanguageId < 0 // select item; //if (Session["Username"] != null && Session["ViewerId"] != null) //{ // ViewBag.ViewerId = Session["ViewerId"]; // return View(query); //} //else //{ // string url = string.Format("/Users/LogIn"); // return Redirect(url); //} }