protected void GvNationalityBin_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GvNationalityBin.PageIndex = e.NewPageIndex;

        DataTable dt = (DataTable)Session["dtBinFilter"];

        GvNationalityBin.DataSource = dt;
        GvNationalityBin.DataBind();
        AllPageCode();
        string temp = string.Empty;


        for (int i = 0; i < GvNationalityBin.Rows.Count; i++)
        {
            Label    lblconid = (Label)GvNationalityBin.Rows[i].FindControl("lblNationalityId");
            string[] split    = lblSelectedRecord.Text.Split(',');

            for (int j = 0; j < lblSelectedRecord.Text.Split(',').Length; j++)
            {
                if (lblSelectedRecord.Text.Split(',')[j] != "")
                {
                    if (lblconid.Text.Trim().ToString() == lblSelectedRecord.Text.Split(',')[j].Trim().ToString())
                    {
                        ((CheckBox)GvNationalityBin.Rows[i].FindControl("chkgvSelect")).Checked = true;
                    }
                }
            }
        }
    }
    protected void GvNationalityBin_OnSorting(object sender, GridViewSortEventArgs e)
    {
        HDFSortbin.Value = HDFSortbin.Value == "ASC" ? "DESC" : "ASC";
        DataTable dt = new DataTable();

        dt = objDesg.GetNationalityMasterInactive(Session["CompId"].ToString().ToString());
        DataView dv    = new DataView(dt);
        string   Query = "" + e.SortExpression + " " + HDFSortbin.Value + "";

        dv.Sort = Query;
        dt      = dv.ToTable();
        Session["dtBinFilter"]      = dt;
        GvNationalityBin.DataSource = dt;
        GvNationalityBin.DataBind();
        AllPageCode();
        lblSelectedRecord.Text = "";
    }
    protected void ImgbtnSelectAll_Click(object sender, ImageClickEventArgs e)
    {
        DataTable dtNationality = (DataTable)Session["dtbinFilter"];

        if (ViewState["Select"] == null)
        {
            ViewState["Select"] = 1;
            foreach (DataRow dr in dtNationality.Rows)
            {
                if (!lblSelectedRecord.Text.Split(',').Contains(dr["Nationality_ID"]))
                {
                    lblSelectedRecord.Text += dr["Nationality_ID"] + ",";
                }
            }
            for (int i = 0; i < GvNationalityBin.Rows.Count; i++)
            {
                string[] split    = lblSelectedRecord.Text.Split(',');
                Label    lblconid = (Label)GvNationalityBin.Rows[i].FindControl("lblNationalityId");
                for (int j = 0; j < lblSelectedRecord.Text.Split(',').Length; j++)
                {
                    if (lblSelectedRecord.Text.Split(',')[j] != "")
                    {
                        if (lblconid.Text.Trim().ToString() == lblSelectedRecord.Text.Split(',')[j].Trim().ToString())
                        {
                            ((CheckBox)GvNationalityBin.Rows[i].FindControl("chkgvSelect")).Checked = true;
                        }
                    }
                }
            }
        }
        else
        {
            lblSelectedRecord.Text = "";
            DataTable dtNationality1 = (DataTable)Session["dtBinFilter"];
            GvNationalityBin.DataSource = dtNationality1;
            GvNationalityBin.DataBind();
            ViewState["Select"] = null;
        }
    }
    protected void btnbindBin_Click(object sender, EventArgs e)
    {
        string condition = string.Empty;

        if (ddlOptionBin.SelectedIndex != 0)
        {
            if (ddlOptionBin.SelectedIndex == 1)
            {
                condition = "convert(" + ddlFieldNameBin.SelectedValue + ",System.String)='" + txtValueBin.Text + "'";
            }
            else if (ddlOptionBin.SelectedIndex == 2)
            {
                condition = "convert(" + ddlFieldNameBin.SelectedValue + ",System.String) like '%" + txtValueBin.Text + "%'";
            }
            else
            {
                condition = "convert(" + ddlFieldNameBin.SelectedValue + ",System.String) Like '" + txtValueBin.Text + "%'";
            }

            DataTable dtCust = (DataTable)Session["dtBinNationality"];
            DataView  view   = new DataView(dtCust, condition, "", DataViewRowState.CurrentRows);
            Session["dtBinFilter"]      = view.ToTable();
            lblTotalRecordsBin.Text     = Resources.Attendance.Total_Records + " : " + view.ToTable().Rows.Count.ToString() + "";
            GvNationalityBin.DataSource = view.ToTable();
            GvNationalityBin.DataBind();

            lblSelectedRecord.Text = "";
            if (view.ToTable().Rows.Count == 0)
            {
                imgBtnRestore.Visible   = false;
                ImgbtnSelectAll.Visible = false;
            }
            else
            {
                AllPageCode();
            }
            System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(txtValueBin);
        }
    }
    public void FillGridBin()
    {
        DataTable dt = new DataTable();

        dt = objDesg.GetNationalityMasterInactive(Session["CompId"].ToString().ToString());
        GvNationalityBin.DataSource = dt;
        GvNationalityBin.DataBind();
        Session["dtBinNationality"] = dt;
        Session["dtBinFilter"]      = dt;
        lblTotalRecordsBin.Text     = Resources.Attendance.Total_Records + ": " + dt.Rows.Count.ToString() + "";

        lblSelectedRecord.Text = "";
        if (dt.Rows.Count == 0)
        {
            imgBtnRestore.Visible   = false;
            ImgbtnSelectAll.Visible = false;
        }
        else
        {
            AllPageCode();
        }
    }