protected void btnFilter_Click(object sender, EventArgs e)
    {
        try
        {
            //  GetExpresion();
            //  createTable();
            customer = new DataTable();
            ctBUS = new CustomerBUS();
            dsgBUS = new DetailGroupBUS();
            int GroupID = 0;
            GroupID = int.Parse(drlSubGroup.SelectedValue.ToString());

            if (getUserLogin().DepartmentId == 1)
            {
                //customer = ctBUS.GetAll();
                customer = ctBUS.GetAllFilterCustomer(txtName.Text.Trim(), txtEmail.Text.Trim(), GroupID,txtPhone.Text.Trim());

            }
            else
                customer = ctBUS.GetAllByUserAssignTo(getUserLogin().UserId, GroupID, txtName.Text.Trim(), txtEmail.Text.Trim(),txtPhone.Text.Trim());

            //row = customer.Select(expresion);
            //foreach (DataRow rowItem in row)
            //{
            //    DataRow rowFilter = result.NewRow();
            //    rowFilter["Id"] = rowItem["Id"];
            //    rowFilter["Name"] = rowItem["Name"];
            //    rowFilter["Gender"] = rowItem["Gender"];
            //    rowFilter["Birthday"] = rowItem["Birthday"];
            //    rowFilter["Email"] = rowItem["Email"];
            //    rowFilter["Phone"] = rowItem["Phone"];
            //    rowFilter["Address"] = rowItem["Address"];
            //    result.Rows.Add(rowFilter);
            //}

            dlPager.MaxPages = 1000;
            dlPager.PageSize = 50;
            dlPager.DataSource = customer.DefaultView;
            dlPager.BindToControl = dtlCustomer;
            this.dtlCustomer.DataSource = dlPager.DataSourcePaged;
            this.dtlCustomer.DataBind();
            pnSuccess.Visible = false;

        }
        catch (Exception ex)
        {

            logs.Error(userLogin.Username + "-Client - btnFilter_Click", ex);
        }
    }