protected void ddl_Date_SelectedIndexChanged(object sender, EventArgs e)
{
ddl_Quantity.Items.Clear();
ddl_ShowTime.Items.Clear();
ddl_ShowTime.Items.Add(new ListItem("Select", "0"));
ddl_Quantity.Items.Add(new ListItem("Select", "0"));
String PlayDate = "";
String filmCode = ddl_Package1.SelectedValue;
if (ddl_Date.SelectedItem.Text != "Select")
{
PlayDate = Convert.ToDateTime(ddl_Date.SelectedItem.Text).ToString("dd/MM/yyyy");
}
//PlayDate = PlayDate.Replace("-", "/"); // for local/dev
String Location = "NMJM";
foreach (DataRow dr in VistaBOL.Select_Play(Location, filmCode, PlayDate).Rows)
{
if (ddl_Package1.SelectedValue == "Rs.1275")
{
ddl_ShowTime.Items.Add(new ListItem("2:30 PM", dr[1].ToString().Trim()));
}
if (ddl_Package1.SelectedValue == "Rs.4999")
{
ddl_ShowTime.Items.Add(new ListItem("7:30 PM", dr[1].ToString().Trim()));
}
}
}
void Load_Play()
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("Start Load Play");
ddl_Play.Items.Clear();
DataTable dtlocation = VistaBOL.Select_Play();
//ddl_Play.Items.Add(new ListItem("Select", "0"));
if (dtlocation != null && dtlocation.Rows.Count > 0)
{
foreach (DataRow dr in dtlocation.Rows)
{
if (dr[0].ToString() == "NEW YEAR")
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
}
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("End Load Play");
String Play = ddl_Play.SelectedValue;
dateofshow.Text = "Select";
ddl_Location.Items.Clear();
ddl_Location.Items.Add(new ListItem("Select", "0"));
DataTable dtAudi = VistaBOL.Select_Audi(Play);
foreach (DataRow dr in dtAudi.Rows)
{
ddl_Location.Items.Add(new ListItem(dr[1].ToString(), dr[0].ToString()));
}
}
/// <summary>
///
/// </summary>
void Load_Play()
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("Start Load Play");
ddl_Play.Items.Clear();
DataTable dtlocation = VistaBOL.Select_Play();
ddl_Play.Items.Add(new ListItem("Select", "0"));
if (Request.QueryString["Valentine"] == "s")
{
ddl_Play.Items.Add(new ListItem("JHUMROO", "JHUMROO"));
}
else if (Request.QueryString["MMTD"] == "s")
{
foreach (DataRow dr in dtlocation.Rows)
{
if (dr[0].ToString() != "MANA")
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
}
else if (Request.QueryString["MMT"] == "MMTUS")
{
foreach (DataRow dr in dtlocation.Rows)
{
if (dr[0].ToString() != "MANA")
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
}
else if (Request.QueryString["MANA"] == "ManaPromo")
{
foreach (DataRow dr in dtlocation.Rows)
{
//if (dr[0].ToString() != "JHUMROO" && dr[0].ToString() != "ZANGOORA")
if (dr[0].ToString() == "MANA")
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
}
else if (dtlocation != null && dtlocation.Rows.Count > 0)
{
foreach (DataRow dr in dtlocation.Rows)
{
if (dr[0].ToString() != "NEW YEAR14")
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
}
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("End Load Play");
}
/// <summary>
///
/// </summary>
void Load_Play()
{
ddl_Play.Items.Clear();
DataTable dtlocation = VistaBOL.Select_Play();
ddl_Play.Items.Add(new ListItem("Select", "0"));
if (dtlocation != null && dtlocation.Rows.Count > 0)
{
foreach (DataRow dr in dtlocation.Rows)
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
}
void Load_Play()
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("Start Load Play");
ddl_Play.Items.Clear();
DataTable dtlocation = VistaBOL.Select_Play();
ddl_Play.Items.Add(new ListItem("Select", "0"));
if (dtlocation != null && dtlocation.Rows.Count > 0)
{
foreach (DataRow dr in dtlocation.Rows)
{
ddl_Play.Items.Add(new ListItem(dr[0].ToString(), dr[0].ToString()));
}
}
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("End Load Play");
}
void Load_Play()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ShowName", typeof(string)));
dt.Columns.Add(new DataColumn("Location", typeof(string)));
dt.Columns.Add(new DataColumn("Show Date", typeof(string)));
dt.Columns.Add(new DataColumn("Show Time", typeof(string)));
dt.Columns.Add(new DataColumn("Show Time Code", typeof(string)));
dt.Columns.Add(new DataColumn("locationcode", typeof(string)));
AuditReport ar = new AuditReport();
DateTime PlayDate = DateTime.Now;
ar.Date = Convert.ToDateTime(PlayDate.ToString());
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write("Start Load Play");
DataTable dtlocation = VistaBOL.Select_Play();
if (dtlocation != null && dtlocation.Rows.Count > 0)
{
foreach (DataRow dr in dtlocation.Rows)
{
ar.ShowName = dr[0].ToString();
DataTable dtAudi = VistaBOL.Select_Audi(ar.ShowName.ToString());
foreach (DataRow dr1 in dtAudi.Rows)
{
ar.LocationText = dr1[1].ToString();
ar.LocationValue = dr1[0].ToString();
DataTable drtime = VistaBOL.Select_PlayTime_Audit(ar.LocationValue, ar.ShowName, ar.Date.ToString("dd/MM/yyyy"));
foreach (DataRow dr2 in drtime.Rows)
{
ar.Timetext = Convert.ToDateTime(dr2[0].ToString());
ar.Timevalue = dr2[1].ToString();
dt.Rows.Add(ar.ShowName, ar.LocationText, ar.Date.ToString("ddd, MMM dd,yyyy"), ar.Timetext.ToShortTimeString(), ar.Timevalue, ar.LocationValue);
}
}
}
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
GridView_ShowDetail.DataSource = ds.Tables[0];
GridView_ShowDetail.DataBind();
}
