public void LoadMainGrid()
 {
     try
     {
         _obj_smhr_loc                 = new SMHR_LOCATION();
         _obj_smhr_loc.MODE            = 0;
         _obj_smhr_loc.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
         Rg_Location.DataSource        = BLL.get_Location(_obj_smhr_loc);
         Rm_HDPT_page.SelectedIndex    = 0;
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Location", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }
    protected void lnk_Edit_Command(object sender, CommandEventArgs e)
    {
        try
        {
            _obj_smhr_loc = new SMHR_LOCATION();
            DataTable dt_Values = new DataTable();
            _obj_smhr_loc.MODE   = 1;
            _obj_smhr_loc.LOC_ID = Convert.ToInt32(e.CommandArgument);
            dt_Values            = BLL.get_Location(_obj_smhr_loc);
            lbl_LOCID.Text       = Convert.ToString(dt_Values.Rows[0]["LOCATION_ID"]);
            //rtbCode.Text = Convert.ToString(dt_Values.Rows[0]["DEPARTMENT_CODE"]);
            rtxt_Locname.Text = Convert.ToString(dt_Values.Rows[0]["LOCATION_NAME"]);
            rtxt_Desc.Text    = Convert.ToString(dt_Values.Rows[0]["LOCATION_DESC"]);

            if (dt_Values.Rows[0]["LOCATION_ISACTIVE"] != System.DBNull.Value)
            {
                int Status = Convert.ToInt32(dt_Values.Rows[0]["LOCATION_ISACTIVE"]);
                rcmb_Status.SelectedIndex = rcmb_Status.Items.FindItemIndexByValue(Convert.ToString(Status));
            }
            else
            {
                //chk_Active.Checked = false;
            }
            //code for security
            if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
            {
                btn_Edit.Visible = false;
            }

            else
            {
                btn_Edit.Visible = true;
            }
            //rtbCode.Enabled = false;
            rtxt_Locname.Enabled = false;

            btn_Save.Visible           = false;
            Rm_HDPT_page.SelectedIndex = 1;
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Location", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        try
        {
            _obj_smhr_loc = new SMHR_LOCATION();

            _obj_smhr_loc.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());

            //_obj_smhr_Department.DEPARTMENT_CODE = Convert.ToString(rtbCode.Text);
            _obj_smhr_loc.LOC_NAME = Convert.ToString(rtxt_Locname.Text);
            _obj_smhr_loc.LOC_DESC = Convert.ToString(rtxt_Desc.Text);
            int Status = Convert.ToInt32(rcmb_Status.SelectedItem.Value);
            //   if (chk_Active.Checked)
            _obj_smhr_loc.ISACTIVE = Convert.ToBoolean(Status);
            // else
            //_obj_smhr_Department.DEPARTMENT_ISACTIVE = false;
            _obj_smhr_loc.CREATEDBY   = Convert.ToInt32(Session["USER_ID"]);
            _obj_smhr_loc.CREATEDDATE = DateTime.Now;
            _obj_smhr_loc.LASTMDFBY   = Convert.ToInt32(Session["USER_ID"]);
            _obj_smhr_loc.LASTMDFDATE = DateTime.Now;

            switch (((Button)sender).ID.ToUpper())
            {
            case "BTN_SAVE":
                _obj_smhr_loc.LOC_NAME = Convert.ToString(rtxt_Locname.Text.Replace("'", "''"));

                _obj_smhr_loc.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
                _obj_smhr_loc.MODE            = 2;
                DataTable dt = BLL.get_Location(_obj_smhr_loc);
                if (dt.Rows.Count != 0)
                {
                    BLL.ShowMessage(this, "This Loaction is already created for this Organisation");
                    rtxt_Locname.Text = string.Empty;
                    rtxt_Desc.Text    = string.Empty;
                    return;
                }
                _obj_smhr_loc.OPERATION = operation.Insert;
                if (BLL.set_Location(_obj_smhr_loc))
                {
                    BLL.ShowMessage(this, "Information Saved Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

            case "BTN_EDIT":

                int Exist = 0;
                _obj_smhr_loc.LOC_ID = Convert.ToInt32(lbl_LOCID.Text);

                if (_obj_smhr_loc.ISACTIVE == true)
                {
                    _obj_smhr_loc.MODE = 3;
                    Exist = Convert.ToInt32(BLL.get_Location(_obj_smhr_loc).Rows[0]["COUNT"]);
                    if (Exist == 1)
                    {
                        BLL.ShowMessage(this, "There Are Employee With The Location Name  " + rtxt_Locname.Text + "  So You can not Make this as Inactive!");
                        Rm_HDPT_page.SelectedIndex = 0;
                        LoadMainGrid();
                        Rg_Location.DataBind();
                        return;
                    }
                }
                _obj_smhr_loc.LOC_DESC  = rtxt_Desc.Text;
                _obj_smhr_loc.OPERATION = operation.Update;
                if (BLL.set_Location(_obj_smhr_loc))
                {
                    BLL.ShowMessage(this, "Information Updated Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;
            }
            Rm_HDPT_page.SelectedIndex = 0;
            LoadMainGrid();
            Rg_Location.DataBind();
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Location", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }