protected void lnk_Delete_Command(object sender, CommandEventArgs e)
    {
        try
        {
            SMHR_SHIFTDEFINITION _obj_Smhr_ShiftDefinition = new SMHR_SHIFTDEFINITION();
            _obj_Smhr_ShiftDefinition.SHIFT_ID  = Convert.ToInt32(Convert.ToString(e.CommandArgument));
            _obj_Smhr_ShiftDefinition.OPERATION = operation.Check;

            if (Convert.ToString(BLL.get_ShiftDefinition(_obj_Smhr_ShiftDefinition).Rows[0]["Count"]) != "0")
            {
                BLL.ShowMessage(this, "This Shift is Already assigned to Employee, so cannot be deleted");
                return;
            }


            _obj_Smhr_ShiftDefinition.OPERATION = operation.Delete;
            if (BLL.set_ShiftDefinition(_obj_Smhr_ShiftDefinition))
            {
                BLL.ShowMessage(this, "Deleted Successfully");
            }

            else
            {
                BLL.ShowMessage(this, "Deletion failed");
            }
            LoadGrid();
            Rg_Shift.DataBind();
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_shiftDefinition", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
 public void LoadGrid()
 {
     try
     {
         SMHR_SHIFTDEFINITION _obj_Smhr_ShiftDefinition = new SMHR_SHIFTDEFINITION();
         _obj_Smhr_ShiftDefinition.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
         DataTable DT = BLL.get_ShiftDefinition(_obj_Smhr_ShiftDefinition);
         Rg_Shift.DataSource = DT;
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_shiftDefinition", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
     //  clearControls();
 }
    protected void lnk_Edit_Command(object sender, CommandEventArgs e)
    {
        try
        {
            clearControls();
            SMHR_SHIFTDEFINITION _obj_Smhr_ShiftDefinition = new SMHR_SHIFTDEFINITION();
            _obj_Smhr_ShiftDefinition.SHIFT_ID        = Convert.ToInt32(Convert.ToString(e.CommandArgument));
            _obj_Smhr_ShiftDefinition.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());

            DataTable dt = BLL.get_ShiftDefinition(_obj_Smhr_ShiftDefinition);

            lbl_ShiftID.Text = Convert.ToString(dt.Rows[0]["SHIFT_ID"]);

            rtxt_ShiftCode.Text             = Convert.ToString(dt.Rows[0]["SHIFT_CODE"]);
            rtxt_ShiftDesc.Text             = Convert.ToString(dt.Rows[0]["SHIFT_DESC"]);
            rtp_ShiftStartTime.SelectedDate = Convert.ToDateTime(dt.Rows[0]["SHIFT_STARTTIME"]);
            rtp_ShiftEndTime.SelectedDate   = Convert.ToDateTime(dt.Rows[0]["SHIFT_ENDTIME"]);

            //code for security
            if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
            {
                btn_Edit.Visible = false;
            }

            else
            {
                btn_Edit.Visible = true;
            }
            Rm_Shift_page.SelectedIndex = 1;
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_shiftDefinition", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        try
        {
            SMHR_SHIFTDEFINITION _obj_Smhr_ShiftDefinition = new SMHR_SHIFTDEFINITION();

            _obj_Smhr_ShiftDefinition.SHIFT_CODE      = Convert.ToString(rtxt_ShiftCode.Text);
            _obj_Smhr_ShiftDefinition.SHIFT_DESC      = Convert.ToString(rtxt_ShiftDesc.Text);
            _obj_Smhr_ShiftDefinition.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
            _obj_Smhr_ShiftDefinition.SHIFT_STARTTIME = Convert.ToString(Convert.ToDateTime(rtp_ShiftStartTime.SelectedDate).TimeOfDay);
            _obj_Smhr_ShiftDefinition.SHIFT_ENDTIME   = Convert.ToString(Convert.ToDateTime(rtp_ShiftEndTime.SelectedDate).TimeOfDay);

            _obj_Smhr_ShiftDefinition.SHIFT_CREATEDBY   = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_Smhr_ShiftDefinition.SHIFT_CREATEDDATE = DateTime.Now;

            _obj_Smhr_ShiftDefinition.SHIFT_LASTMDFBY   = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_Smhr_ShiftDefinition.SHIFT_LASTMDFDATE = DateTime.Now;

            switch (((Button)sender).ID.ToUpper())
            {
            case "BTN_EDIT":
                _obj_Smhr_ShiftDefinition.SHIFT_ID = Convert.ToInt32(lbl_ShiftID.Text);
                //_obj_Smhr_ShiftDefinition.OPERATION = operation.Check;
                //if (Convert.ToString(BLL.get_ShiftDefinition(_obj_Smhr_ShiftDefinition).Rows[0]["Count"]) != "1")
                //{
                //    BLL.ShowMessage(this, "Shift is already defined with this code");
                //    return;
                //}
                _obj_Smhr_ShiftDefinition.OPERATION = operation.Update;
                if (BLL.set_ShiftDefinition(_obj_Smhr_ShiftDefinition))
                {
                    BLL.ShowMessage(this, "Information updated Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }

                break;

            case "BTN_SAVE":
                _obj_Smhr_ShiftDefinition.OPERATION = operation.Check;
                if (Convert.ToString(BLL.get_ShiftDefinition(_obj_Smhr_ShiftDefinition).Rows[0]["Count"]) != "0")
                {
                    BLL.ShowMessage(this, "Shift Definition With this Name Already Exists");
                    return;
                }
                _obj_Smhr_ShiftDefinition.OPERATION = operation.Insert;
                if (BLL.set_ShiftDefinition(_obj_Smhr_ShiftDefinition))
                {
                    BLL.ShowMessage(this, "Information Saved Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

            default:
                break;
            }
            Rm_Shift_page.SelectedIndex = 0;
            LoadGrid();
            Rg_Shift.DataBind();
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_shiftDefinition", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }