public void LoadGrid()
 {
     try
     {
         _obj_Smhr_BusinessUnitBank = new SMHR_BUSINESSUNITBANK();
         if (Convert.ToString(Request.QueryString["ID"]) == null)
         {
             _obj_Smhr_BusinessUnitBank.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
             Rg_BusinessUnitBank.DataSource             = BLL.get_BusinessUnitBank(_obj_Smhr_BusinessUnitBank);
             clearControls();
         }
         else
         {
             _obj_Smhr_BusinessUnitBank           = new SMHR_BUSINESSUNITBANK();
             _obj_Smhr_BusinessUnitBank.OPERATION = operation.Empty;
             _obj_Smhr_BusinessUnitBank.BUSUNTBANK_BUSINESSUNIT_ID = Convert.ToInt32(Convert.ToString(Request.QueryString["ID"]));
             Rg_BusinessUnitBank.DataSource = BLL.get_BusinessUnitBank(_obj_Smhr_BusinessUnitBank);
             clearControls();
         }
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_BusinessUnitBanks", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }
    protected void btn_Save_Click(object sender, EventArgs e)
    {
        try
        {
            _obj_Smhr_BusinessUnitBank = new SMHR_BUSINESSUNITBANK();
            _obj_Smhr_BusinessUnitBank.ORGANISATION_ID            = Convert.ToInt32(Session["ORG_ID"].ToString());
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnits.SelectedItem.Value);
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_NAME            = BLL.ReplaceQuote(rtxt_BusinessUnitBankName.Text);
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_BRANCH          = BLL.ReplaceQuote(rtxt_BusinessUnitBankBranch.Text);
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_ACCOUNTNO       = BLL.ReplaceQuote(rtxt_BusinessUnitBankAccountNo.Text);
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_ADDRESS         = BLL.ReplaceQuote(rtxt_BusinessUnitBankAddress.Text);
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_BSBCODE         = BLL.ReplaceQuote(rtxt_BSBCode.Text);
            //_obj_Smhr_BusinessUnitBank.BUSUNTBANK_ISACTIVE = chk_BusinessUnitBankIsActive.Checked;
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_ISACTIVE  = Convert.ToInt32(rcmb_BusinessUnitBankIsActive.SelectedValue);
            _obj_Smhr_BusinessUnitBank.BUSUNTBANK_ISDEFAULT = chk_BusinessUnitBankIsDefault.Checked;

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

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

            switch (((Button)sender).ID.ToUpper())
            {
            case "BTN_UPDATE":
                _obj_Smhr_BusinessUnitBank.BUSUNTBANK_ID = Convert.ToInt32(lbl_BusinessUnitBankID.Text);
                _obj_Smhr_BusinessUnitBank.BUSUNTBANK_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnits.SelectedItem.Value);

                _obj_Smhr_BusinessUnitBank.OPERATION = operation.Combination;

                if (Convert.ToString(BLL.get_BusinessUnitBank(_obj_Smhr_BusinessUnitBank).Rows[0]["Count"]) != "1")
                {
                    BLL.ShowMessage(this, "This Combination Already Exists");
                    return;
                }
                _obj_Smhr_BusinessUnitBank.OPERATION = operation.Update;

                if (BLL.set_BusinessUnitBank(_obj_Smhr_BusinessUnitBank))
                {
                    BLL.ShowMessage(this, "Information Updated Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }

                break;

            case "BTN_SAVE":
                _obj_Smhr_BusinessUnitBank.OPERATION = operation.Combination;
                _obj_Smhr_BusinessUnitBank.BUSUNTBANK_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnits.SelectedItem.Value);

                if (Convert.ToString(BLL.get_BusinessUnitBank(_obj_Smhr_BusinessUnitBank).Rows[0]["Count"]) != "0")
                {
                    BLL.ShowMessage(this, "This Combination Already Exists");
                    return;
                }
                _obj_Smhr_BusinessUnitBank.OPERATION = operation.Insert;
                if (BLL.set_BusinessUnitBank(_obj_Smhr_BusinessUnitBank))
                {
                    BLL.ShowMessage(this, "Information Saved Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

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