public ActionResult SubmitHall()
{
HallViewModel vm = new HallViewModel();
Hall MyHall = new Hall()
{
ID = Request.Form["Hall.ID"],
HallName = Request.Form["Hall.HallName"],
SeatsNumber = int.Parse(Request.Form["Hall.SeatsNumber"])
};
HallDal dal = new HallDal();
if (ModelState.IsValid)
{
dal.Halls.Add(MyHall);
dal.SaveChanges();
vm.Hall = new Hall();
}
else
{
vm.Hall = MyHall;
}
vm.Halls = dal.Halls.ToList <Hall>();
return(View("AddHall", vm));
}
public ActionResult ChangeSeatsNumber()
{
HallViewModel vm = new HallViewModel();
vm.Hall = new Hall();
HallDal dal = new HallDal();
string HallNameValue = Request.Form["txtHallName"];
int _SeatsNumber = 0;
if (Request.Form["HallSeatsNumber"] != null)
{
_SeatsNumber = int.Parse(Request.Form["HallSeatsNumber"]);
}
if (HallNameValue != null)
{
Hall addHall = dal.Halls.First(h => h.HallName == HallNameValue);
addHall.SeatsNumber = _SeatsNumber;
dal.SaveChanges();
vm.Halls = dal.Halls.ToList <Hall>();
return(View(vm));
}
vm.Halls = dal.Halls.ToList <Hall>();
return(View(vm));
}
public ActionResult Delete(int id)
{
using (HallDal mdb = new HallDal())
{
return(View(mdb.Halls.Where(x => x.Hid == id).FirstOrDefault()));
}
}
public ActionResult Save(Hall emp)
{
bool status = false;
if (ModelState.IsValid)
{
using (HallDal dc = new HallDal())
{
if (emp.IDHall != null)
{
//Edit
var v = dc.Halls.Where(a => a.IDHall == emp.IDHall).FirstOrDefault();
if (v != null)
{
v.NumberOfseat = emp.NumberOfseat;
}
}
else
{
//Save
dc.Halls.Add(emp);
}
dc.SaveChanges();
status = true;
return(View("HallGallery"));
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Halls()
{
using (HallDal mdb = new HallDal())
{
return(View(mdb.Halls.ToList <Hall>()));
}
}
public ActionResult SubManagingSeats(Hall obj)
{
HallDal dal = new HallDal();
List <Hall> HallExist = (from x in dal.Halls where x.HallId.Equals(obj.HallId) select x).ToList <Hall>();
if (HallExist.Count == 0)
{
TempData["msg"] = "Hall not exist !!!";
TempData["color"] = "red";
return(View("ManagingSeats", obj));
}
TicketDal Tickdal = new TicketDal();
List <Ticket> exist = (from x in Tickdal.Tickets where x.HallId.Equals(obj.HallId) select x).ToList <Ticket>();
if (exist.Count != 0)
{
TempData["msg"] = "You cant change number of hall's seats , Someone buy ticket in this hall !!!";
TempData["color"] = "red";
return(View("ManagingSeats", obj));
}
HallExist[0].NumSeats = obj.NumSeats;
dal.SaveChanges();
TempData["msg"] = "Number of hall's seats updated successfully !!!";
TempData["color"] = "blue";
return(View("ManagingSeats"));
}
public ActionResult GetList()
{
using (HallDal db = new HallDal())
{
List <Hall> empList = db.Halls.ToList <Hall>();
return(Json(new { data = empList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(string id)
{
using (HallDal dc = new HallDal())
{
var v = dc.Halls.Where(a => a.IDHall == id).FirstOrDefault();
return(View(v));
}
}
public ActionResult HallGallery(MovieViewModel model)
{
HallDal Halldal = new HallDal();
HallViewModel mvm = new HallViewModel();
List <Hall> HALLS = Halldal.Halls.ToList();
mvm.Hall = new Hall();
mvm.Halls = HALLS;
return(View(mvm));
}
public ActionResult AddHall()
{
HallDal dal = new HallDal();
HallViewModel vm = new HallViewModel();
List <Hall> Halls = dal.Halls.ToList <Hall>();
vm.Hall = new Hall();
vm.Halls = Halls;
return(View(vm));
}
public bool MovieExist(string search)
{
HallDal dal = new HallDal();
List <Hall> Halls = (from x in dal.Halls where x.HallName.Contains(search) select x).ToList <Hall>();
if (Halls.Count >= 1)
{
return(true);
}
return(false);
}
public ActionResult DeleteMovie(string id)
{
using (HallDal dc = new HallDal())
{
var v = dc.Halls.Where(a => a.IDHall == id).FirstOrDefault();
if (v != null)
{
dc.Halls.Remove(v);
dc.SaveChanges();
return(View("HallGallery"));
}
}
return(View("HallGallery"));
}
public ActionResult ManageHall(Hall obj)
{
if (ModelState.IsValid)
{
HallDal Haldal = new HallDal();
Haldal.Halls.Add(obj);
Haldal.SaveChanges();
return(RedirectToAction("HallGallery"));
}
return(View());
}
public ActionResult HallGallery()
{
HallDal dal = new HallDal();
if (ModelState.IsValid)
{
var data = dal.Halls.ToList();
return(View());
}
else
{
return(View("Admin/HallGallery"));
}
}
public ActionResult Delete(string id)
{
using (HallDal dc = new HallDal())
{
var v = dc.Halls.Where(a => a.IDHall == id).FirstOrDefault();
if (v != null)
{
return(View(v));
}
else
{
return(HttpNotFound());
}
}
}
public ActionResult Create(Hall c)
{
try
{
using (HallDal mdb = new HallDal())
{
mdb.Halls.Add(c);
mdb.SaveChanges();
}
return(RedirectToAction("Halls"));
}
catch
{
return(View());
}
}
public ActionResult Edit(int id, Hall c)
{
try
{
using (HallDal mdb = new HallDal())
{
mdb.Entry(c).State = EntityState.Modified;
mdb.SaveChanges();
}
return(RedirectToAction("Halls"));
}
catch
{
return(View());
}
}
public ActionResult Delete(int id, Hall c)
{
try
{
using (HallDal mdb = new HallDal())
{
Hall m = mdb.Halls.Where(x => x.Hid == id).FirstOrDefault();
mdb.Halls.Remove(m);
mdb.SaveChanges();
return(RedirectToAction("Halls"));
}
}
catch
{
return(View());
}
}
public ActionResult AddShow(string msg)
{
if (msg != null)
{
ViewData["msg"] = msg;
}
MovieDal movies = new MovieDal();
movies.GetAllMovies();
HallDal halls = new HallDal();
halls.GetAllHalls();
MoviesAndHallsDal data = new MoviesAndHallsDal();
data.Halls = halls;
data.Movies = movies;
return(View(data));
}
public ActionResult SubAddHall(Hall obj)
{
HallDal dal = new HallDal();
string key = obj.HallId.ToString();
List <Hall> exist = (from x in dal.Halls where x.HallId.Equals(key) select x).ToList <Hall>();
if (exist.Count != 0)
{
TempData["testmsg"] = "This hall is allready exist !!!";
TempData["color"] = "red";
return(View("AddHall", obj));
}
dal.Halls.Add(obj);
dal.SaveChanges();
TempData["testmsg"] = "Hall Added Successfully !!!";
TempData["color"] = "blue";
return(View("AddHall"));
}
public ActionResult ManageSeat(Seat obj)
{
if (ModelState.IsValid)
{
SeatDal dal = new SeatDal();
HallDal Haldal = new HallDal();
if (Haldal.Halls.Where(s => s.IDHall.Equals(obj.Hall)).Count() > 0)
{
dal.Seats.Add(obj);
dal.SaveChanges();
return(View("SlideMenu"));
}
else
{
return(RedirectToAction("ManageSeat"));
}
}
return(View("SlideMenu"));
}
public ActionResult SubAddMovie(Movie obj, MovieImage temp)
{
MovieDal dal = new MovieDal();
string Hallid = obj.HallId.ToString();
string date = obj.date.ToString();
string time = obj.time.ToString();
List <Movie> exist = (from x in dal.Movies where x.HallId.Equals(Hallid) && x.date.Equals(date) && x.time.Equals(time) select x).ToList <Movie>();
if (exist.Count != 0)
{
TempData["msg"] = "There is a movie at the same time and the same hall !!!";
TempData["color"] = "red";
return(View("AddMovie", obj));
}
HallDal halls = new HallDal();
List <Hall> HallExist = (from x in halls.Halls where x.HallId.Equals(obj.HallId) select x).ToList <Hall>();
if (HallExist.Count == 0)
{
TempData["msg"] = "Hall not exist !!!";
TempData["color"] = "red";
return(View("AddMovie", obj));
}
string filename = Path.GetFileNameWithoutExtension(temp.ImageBytes.FileName);
string extension = Path.GetExtension(temp.ImageBytes.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
obj.poster = "~/Images/" + filename;
filename = Path.Combine(Server.MapPath("~/Images/"), filename);
temp.ImageBytes.SaveAs(filename);
dal.Movies.Add(obj);
dal.SaveChanges();
TempData["msg"] = "Movie Added Successfully !!!";
TempData["color"] = "blue";
return(View("AddMovie"));
}
public HallViewModel GetSeats(int MovieId)
{
MovieDal temp = new MovieDal();
Movie movie = (from x in temp.Movies where x.id.Equals(MovieId) select x).ToList <Movie>()[0];
HallDal halldal = new HallDal();
string num = (from x in halldal.Halls where x.HallId.Equals(movie.HallId) select x.NumSeats).ToList <string>()[0];
TicketDal dal = new TicketDal();
HallViewModel cvm = new HallViewModel();
List <string> halls = (from x in dal.Tickets
where x.HallId.Equals(movie.HallId) && x.date.Equals(movie.date) && x.time.Equals(movie.time)
select x.seat).ToList <string>();
cvm.halls = halls;
Session["MovieName"] = movie.MovieName;
TempData["date"] = movie.date;
TempData["time"] = movie.time;
TempData["HallId"] = movie.HallId;
TempData["price"] = movie.price;
TempData["MovieId"] = movie.id;
TempData["NumSeats"] = num;
return(cvm);
}
public ActionResult seats(int id, Movie m, int seat = -1)
{
MovieDal mdb = new MovieDal();
Movie m1 = mdb.Movies.ToList <Movie>().Where(x => x.mid == id).FirstOrDefault();
//out of range seats
HallDal hd = new HallDal();
Hall h = hd.Halls.ToList <Hall>().Where(x => x.HallNumber == m1.Hall).FirstOrDefault();
if (h.number_of_seats < seat || seat < 1)
{
ViewBag.check = "Out of range seat! , please choose a seat from 1 to " + h.number_of_seats.ToString();
return(View(m1));
}
//check if the seat is in occupied
TicketDal tdb = new TicketDal();
List <Ticket> t = tdb.Tickets.ToList <Ticket>();
int count = 0;
foreach (Ticket t1 in t)
{
if (t1.Seat == seat && t1.Hall == m1.Hall && t1.Date.Equals(m1.Date))
{
count++;
}
}
//create ticket
if (count == 0)
{
Ticket tt = new Ticket();
tt.Hall = m1.Hall;
if (m1.Sale == null)
{
tt.Price = m1.Price;
}
else
{
tt.Price = (int)m1.Sale;
}
tt.Id = m1.mid;
tt.Movietitle = m1.Title;
tt.Date = m1.Date;
tt.Seat = seat;
tt.Userid = (int)Session["idUser"];
tdb.Tickets.Add(tt);
tdb.SaveChanges();
ViewBag.check = "added to cart succefully !";
//add rating to most popular
MostDal ms = new MostDal();
Most most = ms.Mosts.ToList <Most>().Where(x => x.Title == m1.Title).FirstOrDefault();
most.rate += 1;
ms.Entry(most).State = EntityState.Modified;
ms.SaveChanges();
}
else
{
ViewBag.check = "this seat in occupied !";
}
return(View(m1));
}
public ActionResult SubManagingHalls(Movie obj)
{
TicketDal dal = new TicketDal();
MovieDal Mdal = new MovieDal();
string name = obj.MovieName.ToString();
string date = obj.date.ToString();
string time = obj.time.ToString();
string New_hall = obj.HallId.ToString();
List <Movie> Mexist = (from x in Mdal.Movies where x.MovieName.Equals(name) && x.date.Equals(date) && x.time.Equals(time) select x).ToList <Movie>();
if (Mexist.Count == 0)
{
TempData["msg"] = "Movie doesn't exist !!!";
TempData["color"] = "red";
return(View("ManagingHalls", obj));
}
string Old_hall = Mexist[0].HallId;
List <Ticket> exist = (from x in dal.Tickets where x.MovieName.Equals(name) && x.date.Equals(date) && x.time.Equals(time) && x.HallId.Equals(Old_hall) select x).ToList <Ticket>();
if (exist.Count != 0)
{
TempData["msg"] = "You cant change movie hall , Someone buy ticket for this movie !!!";
TempData["color"] = "red";
return(View("ManagingHalls", obj));
}
HallDal halls = new HallDal();
List <Hall> HallExist = (from x in halls.Halls where x.HallId.Equals(New_hall) select x).ToList <Hall>();
if (HallExist.Count == 0)
{
TempData["msg"] = "Hall not exist !!!";
TempData["color"] = "red";
return(View("ManagingHalls", obj));
}
List <Movie> NewExist = (from x in Mdal.Movies where x.date.Equals(date) && x.time.Equals(time) && x.HallId.Equals(New_hall) select x).ToList <Movie>();
if (NewExist.Count != 0)
{
TempData["msg"] = "There is a movie at the same time and the same hall !!!";
TempData["color"] = "red";
return(View("ManagingHalls", obj));
}
Mdal.Movies.Remove(Mexist[0]);
obj.poster = Mexist[0].poster;
obj.age = Mexist[0].age;
obj.price = Mexist[0].price;
obj.preprice = Mexist[0].preprice;
obj.category = Mexist[0].category;
Mdal.Movies.Add(obj);
Mdal.SaveChanges();
List <Movie> ms = (from x in Mdal.Movies where x.MovieName.Equals(name) && x.date.Equals(date) && x.time.Equals(time) && x.HallId.Equals(New_hall) select x).ToList <Movie>();
foreach (Ticket t in exist)
{
t.MovieId = ms[0].id;
}
dal.SaveChanges();
TempData["msg"] = "Movie hall updated successfully !!!";
TempData["color"] = "blue";
return(View("ManagingHalls"));
}
