protected void rcmb_Bank_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e)
 {
     try
     {
         if (rcmb_Bank.SelectedIndex != 0)
         {
             _obj_Smhr_BankBanch = new SMHR_BANKBRANCH();
             _obj_Smhr_BankBanch.BRANCH_BANK_ID = Convert.ToInt32(rcmb_Bank.SelectedItem.Value);
             _obj_Smhr_BankBanch.OPERATION      = operation.Empty;
             DataTable DT = new DataTable();
             rcmb_Branch.Items.Clear();
             _obj_Smhr_BankBanch.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
             rcmb_Branch.DataSource     = BLL.get_BankBranch(_obj_Smhr_BankBanch);
             rcmb_Branch.DataTextField  = "BRANCH_CODE";
             rcmb_Branch.DataValueField = "BRANCH_ID";
             rcmb_Branch.DataBind();
             rcmb_Branch.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select"));
         }
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmempidentification", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }
    //protected void loadDropdown()
    //{
    //    rcmb_BankCode.Items.Clear();
    //    rcmb_BankCode.SelectedItem = "HDFC";

    //    //rcmb_BankCode.DataSource = BLL.get_Bank(new SMHR_BANKBRANCH());
    //    //rcmb_BankCode.DataTextField = "BANK_CODE";
    //    //rcmb_BankCode.DataValueField = "BANK_ID";
    //    //rcmb_BankCode.DataBind();
    //    //rcmb_BankCode.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0"));
    //}

    public void LoadGrid()
    {
        try
        {
            SMHR_BANKBRANCH _obj_Smhr_BankBanch = new SMHR_BANKBRANCH();
            _obj_Smhr_BankBanch.OPERATION       = operation.Check1;
            _obj_Smhr_BankBanch.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
            //DataTable DT = BLL.get_BankBranch(new SMHR_BANKBRANCH());BHARADWAJ
            DataTable DT = BLL.get_BankBranch(_obj_Smhr_BankBanch);
            Rg_BankBranch.DataSource = DT;
            clearControls();
        }
        catch (Exception ex)
        {
            SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_BankBranch", ex.StackTrace, DateTime.Now);
            Response.Redirect("~/Frm_ErrorPage.aspx");
        }
    }
    protected void lnk_Edit_Command(object sender, CommandEventArgs e)
    {
        try
        {
            //lbl_BranchHeader.Visible = false;
            SMHR_BANKBRANCH _obj_Smhr_BankBanch = new SMHR_BANKBRANCH();
            //loadDropdown();
            clearControls();
            LoadCombos();
            rtxt_BranchCode.Enabled             = false;
            rcmb_BankCode.Enabled               = false;
            _obj_Smhr_BankBanch.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
            _obj_Smhr_BankBanch.BRANCH_ID       = Convert.ToInt32(e.CommandArgument);
            //DataTable dt = BLL.get_BankBranch(new SMHR_BANKBRANCH(Convert.ToInt32(Convert.ToString(e.CommandArgument))));
            DataTable dt = BLL.get_BankBranch(_obj_Smhr_BankBanch);
            if (dt.Rows.Count > 0)
            {
                lbl_BranchId.Text           = Convert.ToString(dt.Rows[0]["BRANCH_ID"]);
                rtxt_BranchCode.Text        = Convert.ToString(dt.Rows[0]["BRANCH_CODE"]);
                rtxt_BranchName.Text        = Convert.ToString(dt.Rows[0]["BRANCH_NAME"]);
                rcmb_BankCode.SelectedIndex = rcmb_BankCode.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["BRANCH_BANK_ID"]));
                //}
                //code for security
                if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
                {
                    btn_Update.Visible = false;
                }

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


            _obj_Smhr_BankBanch.BRANCH_NAME    = BLL.ReplaceQuote(rtxt_BranchName.Text);
            _obj_Smhr_BankBanch.BRANCH_BANK_ID = Convert.ToInt32(rcmb_BankCode.SelectedItem.Value);
            //    _obj_Smhr_Masters.ORGANISATION_ID  = Convert.ToInt32(Session["ORG_ID"]);


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

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

            _obj_Smhr_Masters                 = new SMHR_MASTERS();
            _obj_Smhr_Masters.MASTER_ID       = Convert.ToInt32(rcmb_BankCode.SelectedItem.Value);
            _obj_Smhr_Masters.MASTER_TYPE     = "Bank";
            _obj_Smhr_Masters.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);

            _obj_Smhr_Masters.OPERATION = operation.Select;
            DataTable dtBankCode  = BLL.get_MasterRecords(_obj_Smhr_Masters);
            string    strBankCode = string.Empty;
            if (dtBankCode.Rows.Count > 0)
            {
                strBankCode = Convert.ToString(dtBankCode.Rows[0]["HR_MASTER_CODE"]);
            }
            string strBranchCode = BLL.ReplaceQuote(rtxt_BranchCode.Text.ToUpper());
            //_obj_Smhr_BankBanch.BRANCH_CODE = strBankCode + strBranchCode;
            switch (((Button)sender).ID.ToUpper())
            {
            case "BTN_UPDATE":
                _obj_Smhr_BankBanch.BRANCH_ID = Convert.ToInt32(lbl_BranchId.Text);
                //_obj_Smhr_BankBanch.OPERATION = operation.Check;
                _obj_Smhr_BankBanch.OPERATION = operation.Validate1;
                if (Convert.ToString(BLL.get_BankBranch(_obj_Smhr_BankBanch).Rows[0]["Count"]) != "1")
                {
                    BLL.ShowMessage(this, "Branch with this Code Already Exists");
                    return;
                }
                _obj_Smhr_BankBanch.BRANCH_CODE     = strBranchCode;
                _obj_Smhr_BankBanch.OPERATION       = operation.Update;
                _obj_Smhr_BankBanch.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
                if (BLL.set_BankBranch(_obj_Smhr_BankBanch))
                {
                    BLL.ShowMessage(this, "Information Updated Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

            case "BTN_SAVE":
                //_obj_Smhr_BankBanch.OPERATION = operation.Check;
                //_obj_Smhr_BankBanch.BRANCH_CODE = strBankCode + strBranchCode;
                _obj_Smhr_BankBanch.BRANCH_CODE = strBranchCode;
                _obj_Smhr_BankBanch.OPERATION   = operation.Validate1;
                if (Convert.ToString(BLL.get_BankBranch(_obj_Smhr_BankBanch).Rows[0]["Count"]) != "0")
                {
                    BLL.ShowMessage(this, "Branch with this Code Already Exists");
                    return;
                }
                //  _obj_Smhr_BankBanch.BRANCH_CODE = strBankCode + strBranchCode;
                _obj_Smhr_BankBanch.OPERATION       = operation.Insert;
                _obj_Smhr_BankBanch.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
                if (BLL.set_BankBranch(_obj_Smhr_BankBanch))
                {
                    BLL.ShowMessage(this, "Information Saved Successfully");
                }
                else
                {
                    BLL.ShowMessage(this, "Information Not Saved");
                }
                break;

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