//페이지로드
protected void Page_Load(object sender, EventArgs e)
{
SelectedTheater = DropDownList_Theater.SelectedValue.Trim();
LoginedMember = (Member)Session["MEMBER"];
dbManager = (DBManager)Session["DBAdmin"];
//사용자가 아무 영화를 클릭하지 않은 초기화 상태라면
if (DropDownList_MovieName.SelectedValue == "")
{
String Command = "Select * From Movie";
SqlDataReader reader = dbManager.GetDataList(Command, new List <Tuple <string, object> >());
List <Movie> Movies = Movie.SqlDataReaderToMember(reader);
DropDownList_MovieName.DataTextField = "Moviename";
DropDownList_MovieName.DataValueField = "MovieID";
DropDownList_MovieName.DataSource = Movies;
DropDownList_MovieName.DataBind();
}
//영화를 선택하였으니 해당 영화에 맞는 시간을 보여줌.
else
{
SelectedMovieID = DropDownList_MovieName.SelectedValue.Trim();
String Command = "Select * From Movieschedule Where MovieID = @MovieID";
List <Tuple <string, object> > Params = new List <Tuple <string, object> >();
Params.Add(new Tuple <string, object>("@MovieID", SelectedMovieID));
SqlDataReader reader = dbManager.GetDataList(Command, Params);
List <Movieschedule> PlayTimes = Movieschedule.SqlDataReaderToMember(reader);
DropDownList_PlayDate.DataTextField = "Playtime";
DropDownList_PlayDate.DataValueField = "Playtime";
DropDownList_PlayDate.DataSource = PlayTimes;
DropDownList_PlayDate.DataBind();
Params.Clear();
//상영관을 선택하지 않았음.
if (DropDownList_PlayDate.SelectedValue == "")
{
;
}
//상영관을 선택하였으면 관이랑 남은 좌석수 표시
else
{
SelectedPlayDate = DropDownList_PlayDate.SelectedValue.Trim();
DropDownList_Theater.DataTextField = "RemaindSeatMent";
DropDownList_Theater.DataValueField = "TheaterID";
DropDownList_Theater.DataSource = PlayTimes;
DropDownList_Theater.DataBind();
Params.Clear();
if (TextBox_TicketCount.Text != "")
{
remainTicket = Convert.ToInt32(TextBox_TicketCount.Text);
}
if (remainTicket != 0)
{
if (SelectedMovieID == "" || SelectedPlayDate == "" || SelectedTheater == "")
{
return;
}
SetTable();
}
}
}
}
//페이지로드
protected void Page_Load(object sender, EventArgs e)
{
//세션 로드
LoginedMember = (Member)Session["MEMBER"];
dbManager = (DBManager)Session["DBAdmin"];
//preSelectedValue input
SelectedMovieID = DropDownList_MovieName.SelectedValue.Trim();
SelectedPlayDate = DropDownList_PlayDate.SelectedValue.Trim();
SelectedTheater = DropDownList_Theater.SelectedValue.Trim();
//사용자가 아무 영화를 클릭하지 않은 초기화 상태라면
if (DropDownList_MovieName.SelectedValue == "" || DropDownList_MovieName.SelectedValue == NotSelected)
{
String Command = "Select * From Movie";
SqlDataReader reader = dbManager.GetDataList(Command, new List <Tuple <string, object> >());
List <Movie> Movies = Movie.SqlDataReaderToMember(reader);
Movie notSelectValue = new Movie();
notSelectValue.Moviename = NotSelected;
notSelectValue.MovieID = NotSelected;
Movies.Add(notSelectValue);
DropDownList_MovieName.DataTextField = "Moviename";
DropDownList_MovieName.DataValueField = "MovieID";
DropDownList_MovieName.DataSource = Movies;
DropDownList_MovieName.DataBind();
DropDownList_MovieName.SelectedValue = NotSelected;
}
//영화를 선택하였으니 해당 영화에 맞는 시간을 보여줌.
else
{
SelectedMovieID = DropDownList_MovieName.SelectedValue.Trim();
string Command = "Select * From Movieschedule Where MovieID = @MovieID";
List <Tuple <string, object> > Params = new List <Tuple <string, object> >();
Params.Add(new Tuple <string, object>("@MovieID", SelectedMovieID));
SqlDataReader reader = dbManager.GetDataList(Command, Params);
List <Movieschedule> PlayTimes = Movieschedule.SqlDataReaderToMember(reader);
Movieschedule notSelectValue = new Movieschedule();
notSelectValue.Playtime = NotSelected;
PlayTimes.Add(notSelectValue);
//상영날짜 선택하지 않았음.
if (SelectedPlayDate == "" || SelectedPlayDate == NotSelected)
{
DropDownList_PlayDate.DataTextField = "Playtime";
DropDownList_PlayDate.DataValueField = "Playtime";
DropDownList_PlayDate.DataSource = PlayTimes;
DropDownList_PlayDate.DataBind();
DropDownList_PlayDate.SelectedValue = NotSelected;
Params.Clear();
}
//상영날짜를 선택하였으면 관이랑 남은 좌석수 표시
else
{
//날짜별 영화관중에서 선택한 날짜의 영화관만 도시한다.
List <Movieschedule> PlayTheaters = new List <Movieschedule>();
foreach (Movieschedule playTime in PlayTimes)
{
if (playTime.Playtime == SelectedPlayDate)
{
PlayTheaters.Add(playTime);
}
}
DropDownList_Theater.DataTextField = "RemaindSeatMent";
DropDownList_Theater.DataValueField = "TheaterID";
if (PlayTheaters.Count == 0)
{
;
}
else
{
DropDownList_Theater.DataSource = PlayTheaters;
}
DropDownList_Theater.DataBind();
Params.Clear();
//예약인원이 정해져있는 상태이면서 예약내용이 모두 null값이 아닐경우 좌석배치표를 생성한다.
if (TextBox_TicketCount.Text != "")
{
remainTicket = Convert.ToInt32(TextBox_TicketCount.Text);
}
if (remainTicket != 0)
{
if (SelectedMovieID == "" || SelectedPlayDate == "" || SelectedTheater == "" ||
SelectedMovieID == NotSelected || SelectedPlayDate == NotSelected || SelectedTheater == NotSelected)
{
return;
}
SetTable();
}
}
}
}
