private void LoadData() { LoaiTourBUS loaiTourBus = new LoaiTourBUS(); cbo_LoaiTour.DisplayMember = "TenLoaiTour"; cbo_LoaiTour.ValueMember = "MaLoaiTour"; cbo_LoaiTour.DataSource = loaiTourBus.LoadLoaiTourToCombobox(); DiaDiemBUS diaDiemBus = new DiaDiemBUS(); DataTable table = diaDiemBus.LoadDiaDiem(); cbo_NoiDen.DisplayMember = "TenDiaDiem"; cbo_NoiDen.ValueMember = "MaDiaDiem"; cbo_NoiDen.DataSource = table; cbo_NoiDi.DisplayMember = "TenDiaDiem"; cbo_NoiDi.ValueMember = "MaDiaDiem"; cbo_NoiDi.DataSource = diaDiemBus.LoadDiaDiem(); HuongDanVienBUS huongDanVienBus = new HuongDanVienBUS(); cbo_HuongDanVien.ValueMember = "MaHDV"; cbo_HuongDanVien.DisplayMember = "TenHDV"; cbo_HuongDanVien.DataSource = huongDanVienBus.LoadHuongDanVienToCombobox(); KhachSanBUS khachSanBus = new KhachSanBUS(); cbo_KhachSan.DisplayMember = "TenKS"; cbo_KhachSan.ValueMember = "MaKS"; cbo_KhachSan.DataSource = khachSanBus.LoadKhachSan(); TourBUS tourBus = new TourBUS(); gridControl_Tour.DataSource = tourBus.LoadTourToDataGridView(); }
public static LoaiTourBUS getLoaiTourByTour(TourBUS tour) { LoaiTourBUS loaiTour = new LoaiTourBUS(); String query = "select tenLoai,LoaiTour.maLoai from LoaiTour,Tour where Tour.maLoai=LoaiTour.maLoai and maTour=@maTour"; Connection connection = new Connection(); using (SqlCommand command = new SqlCommand(query, connection.getConnection())) { connection.open(); command.Parameters.AddWithValue("@maTour", tour.MaTour); var reader = command.ExecuteReader(); while (reader.Read()) { loaiTour.MaLoai = reader["maLoai"].ToString(); loaiTour.TenLoai = reader["tenLoai"].ToString(); } reader.Close(); connection.close(); } return(loaiTour); }
public static List <LoaiTourBUS> getAll() { List <LoaiTourBUS> dsLoaiTour = new List <LoaiTourBUS>(); String query = "select * from LoaiTour"; Connection connection = new Connection(); using (SqlCommand command = new SqlCommand(query, connection.getConnection())) { connection.open(); var reader = command.ExecuteReader(); while (reader.Read()) { LoaiTourBUS loaiTour = new LoaiTourBUS(); loaiTour.MaLoai = reader["maLoai"].ToString(); loaiTour.TenLoai = reader["tenLoai"].ToString(); dsLoaiTour.Add(loaiTour); } reader.Close(); connection.close(); } return(dsLoaiTour); }