protected void Page_Load(object sender, EventArgs e) { //use data item to retrieve all the cinemas and populate dlstCinema. Then use the default cinema (select main one or //the one nearest to user if location data is turned on?) to select all the available screens and populate //dlstScreens using them. //Also display images for the default cinema / screen so the image area isn't empty. //imgScreenView.ImageUrl = //imgSeatLayout.ImageUrl = if (!IsPostBack) { DataSetTableAdapters.CinemasTableAdapter cinematableadapter = new DataSetTableAdapters.CinemasTableAdapter(); DataSet.CinemasDataTable data = cinematableadapter.GetData(); foreach (DataSet.CinemasRow row in data) { dlstCinema.Items.Add(new ListItem(row.Name.ToString(), row.Id.ToString())); } DataSetTableAdapters.ScreensTableAdapter screenTableadApter = new DataSetTableAdapters.ScreensTableAdapter(); DataSet.ScreensDataTable screenData = screenTableadApter.GetScreensByCinemaId(1, true); dlstScreen.Items.Clear(); foreach (DataSet.ScreensRow row in screenData) { dlstScreen.Items.Add(new ListItem(row.Name.ToString(), row.Id.ToString())); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataSetTableAdapters.CinemasTableAdapter cinematableadapter = new DataSetTableAdapters.CinemasTableAdapter(); DataSet.CinemasDataTable data = cinematableadapter.GetData(); foreach (DataSet.CinemasRow row in data) { dlstCinema.Items.Add(new ListItem(row.Name.ToString(), row.Id.ToString())); } Session["SelectedCinemaID"] = dlstCinema.SelectedValue; dlstMovie.Items.Add(new ListItem("<Select>", "0")); DataSetTableAdapters.FilmsTableAdapter taFilms = new DataSetTableAdapters.FilmsTableAdapter(); DataSet.FilmsDataTable fData = taFilms.GetData(); foreach (DataSet.FilmsRow row in fData) { dlstMovie.Items.Add(new ListItem(row.Title.ToString(), row.Id.ToString())); } dlstScreenType.Items.Add(new ListItem("Any", "0")); dlstScreenType.Items.Add(new ListItem("Standard", "false")); dlstScreenType.Items.Add(new ListItem("Delux", "true")); Session["ScreenType"] = dlstScreenType.SelectedValue; } }
protected void Page_Load(object sender, EventArgs e) { var address = new DataSetTableAdapters.AddressesTableAdapter(); var cinima = new DataSetTableAdapters.CinemasTableAdapter(); int cinemaId = 1; DataSetTableAdapters.CinemasTableAdapter cinemas = new DataSetTableAdapters.CinemasTableAdapter(); if (!IsPostBack) { DataSet.CinemasDataTable listCinemas = cinima.GetData(); DDLCinimas.DataSource = listCinemas; DDLCinimas.DataBind(); } if (Request["cinema"] != null) { cinemaId = Int32.Parse(Request["cinema"].ToString()); } cinemaId = Int32.Parse(DDLCinimas.SelectedValue); DataSet.AddressesDataTable addressData = address.GetAddressByCinemaId(cinemaId, true); if (addressData != null && addressData.Count == 1) { //cords for google maps lat = Convert.ToDecimal(addressData[0].CoordY); lon = Convert.ToDecimal(addressData[0].CoordX); //address details line1 = addressData[0].Line1; line2 = addressData[0].Line2; city = addressData[0].City; region = addressData[0].Region; country = addressData[0].Country; postcode = addressData[0].Postcode; } DataSet.CinemasDataTable cinemaData = cinima.GetCinemaByCinemaId(cinemaId, true); if (cinemaData != null && cinemaData.Count == 1) { name = cinemaData[0].Name; cinemaImg = cinemaData[0].ImgLarge; parkingImg = cinemaData[0].ImgParking; Description = cinemaData[0].Description; } }
protected void Page_Load(object sender, EventArgs e) { //Session["Username"] = "******"; // get name? user id? adddress? Session["Cinema"] = "Salford"; Session["Movie"] = "Logan"; Session["ShowingDateTime"] = "2007-05-08 12:35:29.123"; Session["BookingID"] = "3"; //Session["PriceTotal"] = ; // costs? int year = Int32.Parse(Session["ShowingDateTime"].ToString().Substring(2, 2)); int month = Int32.Parse(Session["ShowingDateTime"].ToString().Substring(5, 2)); int day = Int32.Parse(Session["ShowingDateTime"].ToString().Substring(8, 2)); //Response.Write("Year is " + year); //Response.Write("<br/>"); //Response.Write("Month is " + month); //Response.Write("<br/>"); //Response.Write("Day is " + day); //Response.Write(Session["Cinema"].ToString().Substring(0, 2) + Session ["Movie"].ToString().Substring(0, 2)); //"NoSeats" - int //Number of seats selected for the current booking // "ShowingID" - int // ID of the showing for the current booking // "SelectedCinemaID" - int // ID of the cinema for the current booking // "SelectedMovieID" - int // ID of the film for the current booking // QUERIES DataSetTableAdapters.CinemasTableAdapter cinematableadapter = new DataSetTableAdapters.CinemasTableAdapter(); DataSet.CinemasDataTable cinemaData = cinematableadapter.GetCinemaByCinemaId(Convert.ToInt64(Session["SelectedCinemaID"]), true); DataSetTableAdapters.FilmsTableAdapter movietableadapter = new DataSetTableAdapters.FilmsTableAdapter(); DataSet.FilmsDataTable movieData = movietableadapter.GetFilmById(Convert.ToInt64(Session["SelectedMovieID"])); //TextArea1.Value = "\nShowing of: " + Session["Movie"] + " at " + Session["Cinema"] + TextArea1.Value = "\nShowing of: " + movieData[0].Title + " at " + cinemaData[0].Name + " Cinema \n \n" + "on " + day + "/" + month + "/" + year + " at: " + Session["ShowingDateTime"].ToString().Substring(11, 5) + "\n \nYour seats are \nseat1 \nseat2 \nseat3" + "\n \nYour confirmation ID is :" + cinemaData[0].Name.ToString().Substring(0, 2).ToUpper() + Session["ShowingDateTime"].ToString().Substring(2, 2) + movieData[0].Title.ToString().Substring(0, 2).ToUpper() + Session["BookingID"] + " \n \nYour total is: "; }