private void searchHocVien(string textSearch) { DataTable tbHocVien = new DataTable(); //1. Lastname if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 1) { //tbHocVien = boHv.searchHocVienByLastName(textSearch); tbHocVien = boHv.searchHocVienByFullName(textSearch); } //2. Firstname if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 2) { tbHocVien = boHv.searchHocVienByFirstName(textSearch); } //3.Ngay sinh if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 3) { tbHocVien = boHv.searchHocVienByBirthday(textSearch); } //4. Noi sinh if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 4) { tbHocVien = boHv.searchHocVienByNoiSinh(textSearch); } //Dien thoai if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 5) { tbHocVien = boHv.searchHocVienByDienThoai(textSearch); } gridTrainee.DataSource = tbHocVien; }
private void sResultSearchByFirstName() { boHv = new BO_HOCVIEN(); string fullName = string.Empty; if (txtFirstName.Text != "") { fullName = txtFirstName.Text + " " + txtLastName.Text; hvTable = boHv.searchHocVienByFullName(fullName); gridStudents.DataSource = hvTable; } else { return; } }
private bool vCheckHocVienTonTai(string vString) { DataTable tbl = new DataTable(); boHocVien = new BO_HOCVIEN(); tbl = boHocVien.searchHocVienByFullName(vString); if (tbl.Rows.Count > 0) { gridStudents.DataSource = tbl.DefaultView; btnDangKiHvMoi.Enabled = false; flagExitse = true; } else { gridStudents.DataSource = null; btnDangKiHvMoi.Enabled = true; flagExitse = false; } return(flagExitse); }
private void searchHocVien(string textSearch) { DataTable tbHocVien = new DataTable(); //1. Full name if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 1) { tbHocVien = boHv.searchHocVienByFullName(textSearch); } //2. Last name else if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 2) { tbHocVien = boHv.searchHocVienByLastName(textSearch); } //3. Firstname else if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 3) { tbHocVien = boHv.searchHocVienByFirstName(textSearch); } //4.Ngay sinh else if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 4) { tbHocVien = boHv.searchHocVienByBirthday(textSearch); } //5. Noi sinh else if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 5) { tbHocVien = boHv.searchHocVienByNoiSinh(textSearch); } //6. Dien thoai else if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 6) { tbHocVien = boHv.searchHocVienByDienThoai(textSearch); } //7.Theo số chứng chỉ else if (int.Parse(lookSearchBy.GetColumnValue("ID").ToString()) == 7) { tbHocVien = boHv.searchHocVienBySoCC(textSearch + " GTVT"); } gridStudentsList.DataSource = tbHocVien; }