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