protected void btnCreateAudit_Click(object sender, EventArgs e)
 {
     Btn_ShowAuditNo2.Enabled = false;
     lblValidation.Visible    = false;
     try
     {
         btnPrint.Disabled = false;
         Btn_Excel.Enabled = true;
         string    ShowName         = ddl_Play.SelectedValue;
         string    ShowLocation     = ddl_Location.SelectedValue;
         string    ShowDate         = dateofshow.Text.Length > 0 ? dateofshow.Text : "0";
         string    ShowTime         = ddl_ShowTimes.SelectedValue;
         string    ShowTime1        = ddl_ShowTimes.SelectedItem.Text;
         string    ShowDate1        = Convert.ToDateTime(dateofshow.Text.ToString()).ToString("dd/MM/yyyy");
         DataTable dtauditno2report = TransactionBOL.AuditNumber2Report(ShowTime1, ShowDate1, ShowName, ShowLocation);
         if (dtauditno2report != null && dtauditno2report.Rows.Count > 0)
         {
             gv_Report.DataSource = dtauditno2report;
             gv_Report.DataBind();
         }
         else
         {
             btnPrint.Disabled = true;
             Btn_Excel.Enabled = false;
             lblMess.Text      = "No Records Found!";
         }
     }
     catch (Exception ex)
     {
         Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(ex.Message);
     }
 }