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);
}
