protected void Page_Load(object sender, EventArgs e) { //Then use the cinema id and film id retrieved to display that info too Session["ShowingID"] = Request["sID"]; //Session["SeatPrice"] = string.Format("{0:C}", Convert.ToDecimal(Request["price"])); Session["SeatPrice"] = Request["price"]; DataSetTableAdapters.ShowingsTableAdapter showingsAdapter = new DataSetTableAdapters.ShowingsTableAdapter(); //DataSet.ShowingsDataTable showingsData = showingsAdapter.GetShowingsByCinemaId(Session["ShowingID"].ToString()); //Test********************************************* DataSet.ShowingsDataTable showingsData = showingsAdapter.GetShowingByShowingId(Convert.ToInt64(Session["ShowingID"].ToString())); DataSetTableAdapters.ScreensTableAdapter screenAdapter = new DataSetTableAdapters.ScreensTableAdapter(); DataSet.ScreensDataTable screenData = screenAdapter.GetScreenByScreenId(showingsData[0].ScreenId, true); DataSetTableAdapters.FilmsTableAdapter taFilms = new DataSetTableAdapters.FilmsTableAdapter(); DataSet.FilmsDataTable fData = taFilms.GetFilmById(Convert.ToInt64(Session["SelectedMovieID"])); DataSet.ScreensRow row1 = showingsData[0].ScreensRow; if (screenData[0].Deluxe == false) { Session["ScreenType"] = "Standard"; } else { Session["ScreenType"] = "Deluxe"; } Session["ShowingDateTime"] = showingsData[0].StartTime; lblFilmStuff.Text = "Booking for the " + showingsData[0].StartTime.ToString("H:mm") + " showing of " + fData[0].Title + " in a " + Session["ScreenType"] + " screen on " + showingsData[0].StartTime.ToString("yyyy'-'MM'-'dd"); lblFilmStuff.Text += " " + Session["SeatPrice"]; }
private void getFilmShowings() { DataSetTableAdapters.ShowingsTableAdapter taShowings = new DataSetTableAdapters.ShowingsTableAdapter(); DataSet.ShowingsDataTable sData = taShowings.GetShowingsByCinemaIdFilmId(Convert.ToInt64(dlstMovie.SelectedValue.ToString()), true, Convert.ToInt64(dlstCinema.SelectedValue.ToString())); foreach (DataSet.ShowingsRow r in sData) { d1.InnerHtml += "<a href='SelectSeats.aspx?sID=" + r.Id + "&price=" + r.CostPerSeat + "'>" + r.StartTime + "</a>"; } }
private void getFilmShowingsWithScreenType() { DataSetTableAdapters.ShowingsTableAdapter taShowings = new DataSetTableAdapters.ShowingsTableAdapter(); DataSet.ShowingsDataTable sData = taShowings.GetShowingsByCinemaIdFilmIdDeluxe(Convert.ToInt64(dlstMovie.SelectedValue.ToString()), true, Convert.ToInt64(dlstCinema.SelectedValue.ToString()), Convert.ToBoolean(Session["ScreenType"].ToString())); foreach (DataSet.ShowingsRow r in sData) { d1.InnerHtml += "<a href='SelectSeats.aspx?sID=" + r.Id + "'>" + r.StartTime + "</a>"; } }