public List <NhomTuChonDTO> SearchListNhomTuChon(string valueToSearch) { List <NhomTuChonDTO> List = new List <NhomTuChonDTO>(); string query = string.Format("SELECT NTChon.ID_NhomTuChon, NTChon.ID_ChuongTrinhDaoTao, CTrinhDTao.MaChuongTrinhDaoTao, NTChon.MaNhomTuChon, NTChon.TenNhomTuChon, NTChon.SoTinChi, NTChon.GhiChu " + "FROM dbo.ChuongTrinhDaoTao CTrinhDTao, dbo.NhomTuChon NTChon " + "WHERE CTrinhDTao.ID_ChuongTrinhDaoTao = NTChon.ID_ChuongTrinhDaoTao AND CONCAT(NTChon.MaNhomTuChon, NTChon.TenNhomTuChon, NTChon.SoTinChi, NTChon.GhiChu) LIKE N'%" + valueToSearch + "%'"); DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { NhomTuChonDTO nhomTuChon = new NhomTuChonDTO(dataRow); List.Add(nhomTuChon); } return(List); }
public List <NhomTuChonDTO> GetListNhomTuChon() { List <NhomTuChonDTO> List = new List <NhomTuChonDTO>(); string query = "SELECT NTChon.ID_NhomTuChon, NTChon.ID_ChuongTrinhDaoTao, CTrinhDTao.MaChuongTrinhDaoTao, NTChon.MaNhomTuChon, NTChon.TenNhomTuChon, NTChon.SoTinChi, NTChon.GhiChu " + "FROM dbo.ChuongTrinhDaoTao CTrinhDTao, dbo.NhomTuChon NTChon " + "WHERE CTrinhDTao.ID_ChuongTrinhDaoTao = NTChon.ID_ChuongTrinhDaoTao"; DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { NhomTuChonDTO nhomTuChon = new NhomTuChonDTO(dataRow); List.Add(nhomTuChon); } return(List); }