/*
     *  GetAdditionalServices function use to get all additional services
     */
    private void BindGrid()
    {
        StoreFront ObjStoreFront = new StoreFront();
        DataSet    ds            = new DataSet();
        DataTable  dt            = new DataTable();
        DataView   dv            = new DataView();

        ds = ObjStoreFront.GetAdditionalServices(Request.QueryString["SearchFor"].ToString(), Request.QueryString["SearchText"].ToString());
        ddlSearch.SelectedValue = Request.QueryString["SearchFor"].ToString();
        txtSearch.Text          = Request.QueryString["SearchText"].ToString();
        if (ds.Tables[0].Rows.Count > 0)
        {
            gdvAdditionalServices.Visible = true;
            btnDelete.Visible             = true;
            btnStatus.Visible             = true;
            //lblNorec.Visible = false;

            dt = ds.Tables[0];
            dv = dt.DefaultView;
            if ((SortExpression != string.Empty) && (SortDirection != string.Empty))
            {
                dv.Sort = SortExpression + " " + SortDirection;
            }

            gdvAdditionalServices.DataSource = dv;
            gdvAdditionalServices.DataBind();
            CheckAll();
            check();
            Utility.Setserial(gdvAdditionalServices, "srno");
            divsearch.Visible = true;
            btnExport.Visible = true;
            btnImport.Visible = true;
        }
        else
        {
            //lblNorec.Visible = true;
            btnDelete.Visible             = false;
            btnNew.Visible                = true;
            btnStatus.Visible             = false;
            gdvAdditionalServices.Visible = false;
            divsearch.Visible             = false;
            ErrMessage("Sorry, No records found.");
            if ((Convert.ToInt32(ddlSearch.SelectedIndex) > 0) && (txtSearch.Text != ""))
            {
                txtSearch.Text          = "";
                ddlSearch.SelectedIndex = 0;
                lnkNorec.Visible        = true;
                btnNew.Visible          = false;
                // btnAdd.Visible = false;
                btnExport.Visible = false;
                btnImport.Visible = false;
                //lblMsg.Visible = true;
                ErrMessage("Sorry, No records found.");
            }
        }
    }