public void loadCreateddate()
 {
     objshow = new MasterData();
     objrpt = new ReportData();
     DataTable dt = new DataTable();
     Nullable<int> venueid = null;
     venueid = (ddlVenue.SelectedIndex > 0) ? Convert.ToInt32(ddlVenue.SelectedItem.Value) : venueid;
     dt = objrpt.GetEngtReportParameters("D", Convert.ToInt32(ddlShow.SelectedItem.Value), Convert.ToInt32(ddlCity.SelectedItem.Value), venueid);
     objcf.FillDropDownList(ddlCreateddate, dt, "ENGTSTARTDATE", "ENGAGEMENTID");
     if (dt.Rows.Count == 1)
     {
         ddlCreateddate.SelectedIndex = 1;
         LoadEnddate();
     }
 }
 public void LoadEnddate()
 {
     lblEngtEndDate.Text = string.Empty;
     objshow = new MasterData();
     objrpt = new ReportData();
     DataTable dt = new DataTable();
     Nullable<int> venueid = null;
     venueid = (ddlVenue.SelectedIndex > 0) ? Convert.ToInt32(ddlVenue.SelectedItem.Value) : venueid;
     dt = objrpt.GetEngtReportParameters("E", Convert.ToInt32(ddlCreateddate.SelectedItem.Value), venueid, venueid);
     if (dt.Rows.Count > 0)
     {
         lblEngtEndDate.Text = dt.Rows[0]["ENGTENDDATE"].ToString();
     }
 }