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