public AccountController() { loginsDb = LoginsTableConnection.Instance; datesDb = DatesTableConnection.Instance; ordersDb = OrdersTableConnection.Instance; playsDb = PlaysTableConnection.Instance; }
public HomeController() { authorsDb = AuthorsTableConnection.Instance; genresDb = GenresTableConnection.Instance; datesDb = DatesTableConnection.Instance; playsDb = PlaysTableConnection.Instance; }
/// <summary> /// Gets all need information in ViewBag /// </summary> /// <param name="id">Date id</param> private void getViewBagForOrderPage(int id) { ViewBag.DateId = id; IOrderDao orders = OrdersTableConnection.Instance; IDateDao datesDb = DatesTableConnection.Instance; DatePlay currentDate = datesDb.GetDateById(id); IPlayDao playsDb = PlaysTableConnection.Instance; Play play = playsDb.GetPlayById(currentDate.PlayId); ViewBag.Play = play; IGenreDao genresDb = GenresTableConnection.Instance; ViewBag.Genre = genresDb.GetGenreById(play.GenreId); IAuthorDao authorsDb = AuthorsTableConnection.Instance; ViewBag.Author = authorsDb.GetAuthorById(play.AuthorId); ViewBag.Dates = datesDb.GetDatesByIdPlay(play.Id).OrderBy(x => x.Date).ToList(); ViewBag.TotalCountBalconySeats = TheaterInformation.TotalCountBalconySeats; ViewBag.PriceBalconySeats = TheaterInformation.PriceBalcony; ViewBag.FreeBalconySeats = (TheaterInformation.TotalCountBalconySeats - orders.GetCountBusySeetsByDateIdAndCategory(id, 0)); ViewBag.TotalCountParterreSeats = TheaterInformation.TotalCountParterreSeats; ViewBag.PriceParterreSeats = TheaterInformation.PriceParterre; ViewBag.FreeParterreSeats = (TheaterInformation.TotalCountParterreSeats - orders.GetCountBusySeetsByDateIdAndCategory(id, 1)); }
public PlaysController() { loginsDb = LoginsTableConnection.Instance; datesDb = DatesTableConnection.Instance; ordersDb = OrdersTableConnection.Instance; playsDb = PlaysTableConnection.Instance; authorsDb = AuthorsTableConnection.Instance; genresDb = GenresTableConnection.Instance; }
public ActionResult Cart() { IDateDao datesDb = DatesTableConnection.Instance; ViewBag.Dates = datesDb.GetAllDates(); IOrderDao ordersDb = OrdersTableConnection.Instance; List <Order> orders = ordersDb.GetOrdersByIdLogin(CurrentUserService.GetCurrentUser().Id) .OrderBy(x => datesDb.GetDateById(x.DateId).Date).ToList(); IPlayDao playsDb = PlaysTableConnection.Instance; ViewBag.Plays = playsDb.GetAllPlays(); return(View(orders)); }
// GET: Home public ActionResult Index() { IPlayDao playsDb = PlaysTableConnection.Instance; ViewBag.Plays = playsDb.GetAllPlays(); IAuthorDao authorsDb = AuthorsTableConnection.Instance; ViewBag.Authors = authorsDb.GetAllAuthors(); IGenreDao genresDb = GenresTableConnection.Instance; ViewBag.Genres = genresDb.GetAllGenres(); IDateDao datesDb = DatesTableConnection.Instance; ViewBag.Dates = datesDb.GetAllDates().OrderBy(x => x.Date).ToList(); return(View()); }
// GET: Courier/Orders public ActionResult Orders() { IDateDao datesDb = DatesTableConnection.Instance; ViewBag.Dates = datesDb.GetAllDates(); IOrderDao ordersDb = OrdersTableConnection.Instance; List <Order> orders = ordersDb.GetAllOrders().OrderBy(x => datesDb.GetDateById(x.DateId).Date).ToList(); IPlayDao playsDb = PlaysTableConnection.Instance; ViewBag.Plays = playsDb.GetAllPlays(); ILoginDao loginsDb = LoginsTableConnection.Instance; ViewBag.Logins = loginsDb.GetAllLogins(); return(View(orders)); }
// GET: Plays/Description public ActionResult Description(int id) { try { IPlayDao playsDb = PlaysTableConnection.Instance; Play play = playsDb.GetPlayById(id); ViewBag.Play = play; IGenreDao genresDb = GenresTableConnection.Instance; ViewBag.Genre = genresDb.GetGenreById(play.GenreId); IAuthorDao authorsDb = AuthorsTableConnection.Instance; ViewBag.Author = authorsDb.GetAuthorById(play.AuthorId); IDateDao datesDb = DatesTableConnection.Instance; ViewBag.Dates = datesDb.GetDatesByIdPlay(play.Id).OrderBy(x => x.Date).ToList(); } catch (NullReferenceException) { return(RedirectToAction("Index", "Home")); } return(View()); }
public PlayController(IPlayDao dao) { this.dao = dao; }