private void dgHolidays_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 {
     try
     {
         inspect            = new clsInspections();
         inspect.cAction    = "D";
         inspect.iOrgId     = OrgId;
         inspect.iHolidayId = Convert.ToInt32(e.Item.Cells[0].Text);
         if (inspect.HolidayDetail() == -1)
         {
             Session["lastpage"] = "admin_holidays.aspx";
             Session["error"]    = _functions.ErrorMessage(153);
             Response.Redirect("error.aspx", false);
             return;
         }
         ShowHolidays();
     }
     catch (Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"]     = "admin_holidays.aspx";
         Session["error"]        = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if (inspect != null)
         {
             inspect.Dispose();
         }
     }
 }
 private void dgHolidays_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
 {
     try
     {
         if (((ActiveUp.WebControls.ActiveDateTime)e.Item.FindControl("adtEndDate")).Date >= ((ActiveUp.WebControls.ActiveDateTime)e.Item.FindControl("adtStartDate")).Date)
         {
             inspect                    = new clsInspections();
             inspect.cAction            = "U";
             inspect.iOrgId             = OrgId;
             inspect.iHolidayId         = Convert.ToInt32(e.Item.Cells[0].Text);
             inspect.daHolidayStartDate = ((ActiveUp.WebControls.ActiveDateTime)e.Item.FindControl("adtStartDate")).Date;
             inspect.daHolidayEndDate   = ((ActiveUp.WebControls.ActiveDateTime)e.Item.FindControl("adtEndDate")).Date;
             inspect.sHolidayName       = ((TextBox)e.Item.FindControl("tbHolidayName")).Text;
             inspect.iHolidayPercentOff = Convert.ToInt32(((ListBox)e.Item.FindControl("lbPercentOff")).SelectedValue);
             if (inspect.HolidayDetail() == -1)
             {
                 Session["lastpage"] = "admin_holidays.aspx";
                 Session["error"]    = _functions.ErrorMessage(153);
                 Response.Redirect("error.aspx", false);
                 return;
             }
             dgHolidays.EditItemIndex = -1;
             ShowHolidays();
         }
         else
         {
             Header.ErrorMessage = "Start Date must be less than End Date";
         }
     }
     catch (Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"]     = "admin_holidays.aspx";
         Session["error"]        = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if (inspect != null)
         {
             inspect.Dispose();
         }
     }
 }
 private void btnAddHoliday_Click(object sender, System.EventArgs e)
 {
     try
     {
         if (adtNewEndDate.Date >= adtNewStartDate.Date)
         {
             inspect                    = new clsInspections();
             inspect.cAction            = "U";
             inspect.iOrgId             = OrgId;
             inspect.iHolidayId         = 0;
             inspect.daHolidayStartDate = adtNewStartDate.Date;
             inspect.daHolidayEndDate   = adtNewEndDate.Date;
             inspect.sHolidayName       = tbNewHolidayName.Text;
             inspect.iHolidayPercentOff = Convert.ToInt32(lbNewPercentOff.SelectedValue);
             inspect.HolidayDetail();
             ShowHolidays();
         }
         else
         {
             Header.ErrorMessage = "Start Date must be less than End Date";
         }
     }
     catch (Exception ex)
     {
         _functions.Log(ex, HttpContext.Current.User.Identity.Name, SourcePageName);
         Session["lastpage"]     = "admin_holidays.aspx";
         Session["error"]        = ex.Message;
         Session["error_report"] = ex.ToString();
         Response.Redirect("error.aspx", false);
     }
     finally
     {
         if (inspect != null)
         {
             inspect.Dispose();
         }
     }
 }