protected void Page_Load(object sender, EventArgs e)
{
if ((bool)Session["AdminStatus"] == true)
{
btnAdminAccess.Visible = true;
}
DataRow[] drMovies = GetMoviesInfo();
DataSetTableAdapters.SchedulesTableAdapter taSchedules
= new DataSetTableAdapters.SchedulesTableAdapter();
taSchedules.Fill(ds.Schedules);
//Pack labels and button for effectiveness
//TODO: Ask Dario how to get all tags instead of this
Image[] images = { img1, img2, img3 };
Label[] movieNames = { lblMovieName0, lblMovieName1, lblMovieName2 };
Label[] summaries = { lblSummary0, lblSummary1, lblSummary2 };
Label[] durations = { lblDuration0, lblDuration1, lblDuration2 };
Label[] releaseDates = { lblReleaseDate0, lblReleaseDate1, lblReleaseDate2 };
Label[] IMDB = { lblIMDB0, lblIMDB1, lblIMDB2 };
Label[] genres = { lblGenres0, lblGenres1, lblGenres2 };
DropDownList[] showtimes = { drdShowtime0, drdShowtime1, drdShowtime2 };
for (int index = 0; index < drMovies.Length; index++)
{
images[index].Attributes.Add("src", "images/" + drMovies[index]["Poster"]); //Load movies' images
movieNames[index].Text = drMovies[index]["MovieTitle"].ToString(); //Load movie name
summaries[index].Text = drMovies[index]["Summary"].ToString(); //Load summary
durations[index].Text = drMovies[index]["Duration"].ToString(); //Load duration
releaseDates[index].Text = drMovies[index]["ReleaseDate"].ToString(); //Load relase date
IMDB[index].Text = drMovies[index]["IMDBRating"].ToString(); //Load IMDB rating
genres[index].Text = drMovies[index]["Genres"].ToString(); //Load genres
DataRow[] drSchedules
= ds.Schedules.Select("MovieID='" + drMovies[index]["MovieID"] + "'");
for (int x = 0; x < 5; x++)
{
ListItem item = new ListItem(drSchedules[x]["Showtime"].ToString());
if (Convert.ToInt32(drSchedules[x]["Quantity"]) == 0)
{
item.Attributes.Add("disabled", "true");
}
showtimes[index].Items.Add(item);
}
}
}
protected void btnShowBill_Click(object sender, EventArgs e)
{
Session["Ammount"] = amount;
Session["Tax"] = tax;
Session["Total"] = total;
Session["DaysUntilTuesday"] = daysUntilTuesday;
Session["GeneralAdmission"] = lblQuantity.Text;
Session["SeniorAdmission"] = lblQuantity1.Text;
Session["TuesdayAdmission"] = lblQuantity2.Text;
DataSet ds1 = new DataSet();
DataSetTableAdapters.SchedulesTableAdapter taSchedules
= new DataSetTableAdapters.SchedulesTableAdapter();
taSchedules.Fill(ds1.Schedules);
DataRow[] drTimeId = ds1.Schedules.Select("TimeID=" + (int)Session["TimeID"]);//Inside is where clause
drTimeId[0]["Quantity"] = GetAvailableQuantity() - GetTotalQuantity();
taSchedules.Update(ds1.Schedules);
Server.Transfer("Bill.aspx");
}
private int GetAvailableQuantity()
{
DataSetTableAdapters.SchedulesTableAdapter taSchedules
= new DataSetTableAdapters.SchedulesTableAdapter();
taSchedules.Fill(ds.Schedules);//Get the lateset and put into ds1.Schedules
DataRow[] drSchedules
= ds.Schedules.Select("MovieID='" + (int)Session["MovieID"] + "'");
int timeIndex = 0;
for (int index = 0; index < drSchedules.Length; index++)
{
if (drSchedules[index]["Showtime"].ToString() == (string)Session["Showtime"])
{
timeIndex = Convert.ToInt32(drSchedules[index]["TimeID"]);
}
}
Session["TimeID"] = timeIndex;
DataRow[] drTimeID = ds.Schedules.Select("TimeID = '" + timeIndex + "'");
int remainQnt = Convert.ToInt32(drTimeID[0]["Quantity"]);
return(remainQnt);
}