//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));
}
