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); } }
private void LoadCustomer() { ctBUS = new CustomerBUS(); int GroupID = 0; GroupID = int.Parse(drlNhomMail.SelectedValue.ToString()); if (getUserLogin().DepartmentId == 1) { // customerBySelect = ctBUS.GetAll(); customerBySelect = ctBUS.GetAll(txtName.Text.Trim(), txtPhone.Text.Trim(), txtEmail.Text.Trim(), GroupID); } else { customerBySelect = ctBUS.GetAllByUserAssignTo(getUserLogin().UserId, GroupID, txtName.Text.Trim(), txtEmail.Text.Trim(), txtPhone.Text.Trim()); } try { dlPager.MaxPages = 1000; dlPager.PageSize = 50; dlPager.DataSource = customerBySelect.DefaultView; dlPager.BindToControl = dtlCustomer; this.dtlCustomer.DataSource = dlPager.DataSourcePaged; this.dtlCustomer.DataBind(); } catch (Exception ex) { logs.Error(userLogin.Username + "-Client - LoadCustomer", ex); } }