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();
}
private void btnThemKS_Click(object sender, EventArgs e)
{
if (txtTenKS.Text == "" || txtSoSao.Text == "" || txtTP.Text == "" || txtQuan.Text == "" ||
txtDuong.Text == "" || txtMoTa.Text == "" || txtGiaTB.Text == "")
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin!", "Thông báo");
return;
}
KhachSanDTO ks = new KhachSanDTO();
ks.TenKS = txtTenKS.Text;
ks.SoSao = txtSoSao.Text;
ks.ThanhPho = txtTP.Text;
ks.Quan = txtQuan.Text;
ks.Duong = txtDuong.Text;
ks.SoNha = txtSoNha.Text;
ks.GiaTB = Convert.ToInt32(txtGiaTB.Text);
ks.MoTa = txtMoTa.Text;
//int x = KhachSanBUS.KiemTraTonTai(ks);
//if (x == 0)
if (KhachSanBUS.ThemKhachSan(ks) == true)
{
// KhachSanDTO p = new KhachSanDTO();
MessageBox.Show("Thêm thành công!", "Thông báo");
this.Hide();
ThemKhachSan ks1 = new ThemKhachSan();
ks1.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Lỗi, vui lòng thử lại! \n ", "Thông báo");
}
/*if (KhachHangBUS.ThemKhachHang(kh) == true)
* {
* MessageBox.Show("Thêm khách hàng thành công", "Thông báo");
* settext1 = txtHoTen.Text;
* this.Hide();
* LoginBook frm = new LoginBook();
* frm.Show(); }
* else
*
* }
* }
*
*
* }
*
*/
}
private void CapNhatDanhSachKhachSanTheoPhanTrang(int iPage, int nItem)
{
KhachSanBUS ksBus = new KhachSanBUS();
KS_DsKhachSan = ksBus.getDanhSachKhachSan(iPage, KS_NumberItemOnAPage);
BindingSource bindData = new BindingSource();
bindData.DataSource = KS_DsKhachSan;
this.labelDSKhachSan.Text = this.KS_CurrentPage.ToString() + "/" + this.KS_NumberOfPage.ToString();
this.dataGridViewKhachSan.DataSource = bindData;
this.dataGridViewKhachSan.Refresh();
this.dataGridViewKhachSan.Parent.Parent.Refresh();
}
//---------------Khach San------------------------
public void MyInitial_KhachSan()
{
KhachSanBUS ksBus = new KhachSanBUS();
//Đếm số lượng record trong bảng khach san
int nR = ksBus.getTongSoRecord();
KS_NumberOfPage = nR / KS_NumberItemOnAPage;
if (nR % KS_NumberItemOnAPage != 0)
{
KS_NumberOfPage++;
}
//Lấy danh sách trang đầu tiên.
CapNhatDanhSachKhachSanTheoPhanTrang(1, KS_NumberItemOnAPage);
}
private void buttonTimKiemKS_Click(object sender, EventArgs e)
{
//Lấy thông tin tìm kiếm.
string TenKS = "";
string TenDDDL = "";
if (this.comboBoxTimKS_TenKS.SelectedIndex != 0)
{
TenKS = this.comboBoxTimKS_TenKS.Text;
if (this.comboBoxTimKS_TenDDDL.Enabled == true && this.comboBoxTimKS_TenDDDL.SelectedIndex > 0)
{
TenDDDL = this.comboBoxTimKS_TenDDDL.Text;
}
//Cập nhật lại danh sách, thông tin tìm kiếm
isTimKiem = true;
ThongTinKiemKS = new ThongTinTimKiemDTO();
ThongTinKiemKS.ResetDataTKKhachSan();
ThongTinKiemKS.TenKS = TenKS;
ThongTinKiemDDDL.TenDDDL = TenDDDL;
this.KS_CurrentPage = 1;
KhachSanBUS ksBus = new KhachSanBUS();
int n = ksBus.getTongSeRecordKetQuaTimKiemKhachSan(ThongTinKiemKS.TenKS, ThongTinKiemKS.TenDDDL);
this.KS_NumberOfPage = (n / KS_NumberItemOnAPage);
if (n % this.KS_NumberItemOnAPage != 0)
{
this.KS_NumberOfPage++;
}
CapNhatDanhSachKhachSanTheoPhanTrang(1, KS_NumberItemOnAPage);
}
else
{
MessageBox.Show("Chưa nhập thông tin tìm kiếm.");
isTimKiem = false;
}
}
