public void LoadGrid()
 {
     try
     {
         //_obj_Smhr_BuIDDetails.OPERATION = operation.Select;
         SMHR_BUSINESSUNITIDDETAILS _obj_Smhr_BuIDDetails = new SMHR_BUSINESSUNITIDDETAILS();
         _obj_Smhr_BuIDDetails.OPERATION       = operation.Check1;
         _obj_Smhr_BuIDDetails.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
         DataTable DT = BLL.get_BusinessUnitIDDetails(_obj_Smhr_BuIDDetails);
         Rg_BUIDDetails.DataSource = DT;
         //Rg_BUIDDetails.DataBind();
         clearControls();
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_BusinessUnitIDDetails", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        try
        {
            _obj_Smhr_BuIDDetails = new SMHR_BUSINESSUNITIDDETAILS();
            _obj_Smhr_BuIDDetails.BUIDDETAILS_NAME        = BLL.ReplaceQuote(rtxt_BUIDDetails_Name.Text.ToUpper());
            _obj_Smhr_BuIDDetails.BUIDDETAILS_DESCRIPTION = BLL.ReplaceQuote(rtxt_BUIDDetails_Desc.Text);
            _obj_Smhr_BuIDDetails.BUIDDETAILS_VALUE       = BLL.ReplaceQuote(rtxt_BUIDDetails_Value.Text);
            _obj_Smhr_BuIDDetails.BUIDDETAILS_BUID        = rcmb_BUCode.SelectedItem.Value;

            _obj_Smhr_BuIDDetails.CREATEDBY   = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_Smhr_BuIDDetails.CREATEDDATE = DateTime.Now;

            _obj_Smhr_BuIDDetails.LASTMDFBY       = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
            _obj_Smhr_BuIDDetails.LASTMDFDATE     = DateTime.Now;
            _obj_Smhr_BuIDDetails.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);

            switch (((Button)sender).ID.ToUpper())
            {
            case "BTN_UPDATE":
                _obj_Smhr_BuIDDetails.BUIDDETAILS_ID = Convert.ToInt32(lbl_BUIDDetails_ID.Text);
                //_obj_Smhr_BuIDDetails.OPERATION = operation.Check;
                _obj_Smhr_BuIDDetails.OPERATION = operation.Validate;
                if (Convert.ToString(BLL.get_BusinessUnitIDDetails(_obj_Smhr_BuIDDetails).Rows[0]["Count"]) != "1")
                {
                    BLL.ShowMessage(this, "Other Information Already Exists.");
                    return;
                }
                _obj_Smhr_BuIDDetails.OPERATION       = operation.Update;
                _obj_Smhr_BuIDDetails.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
                if (BLL.set_BusinessUnitIDDetails(_obj_Smhr_BuIDDetails))
                {
                    BLL.ShowMessage(this, "Information Updated Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

            case "BTN_SAVE":
                //_obj_Smhr_BuIDDetails.OPERATION = operation.Check;
                _obj_Smhr_BuIDDetails.OPERATION = operation.Validate;
                if (Convert.ToString(BLL.get_BusinessUnitIDDetails(_obj_Smhr_BuIDDetails).Rows[0]["Count"]) != "0")
                {
                    BLL.ShowMessage(this, "Other Information Already Exists.");
                    return;
                }
                _obj_Smhr_BuIDDetails.OPERATION       = operation.Insert;
                _obj_Smhr_BuIDDetails.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
                if (BLL.set_BusinessUnitIDDetails(_obj_Smhr_BuIDDetails))
                {
                    BLL.ShowMessage(this, "Information Saved Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

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