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