private void btnDatPhong_Click(object sender, EventArgs e)
{
string[] column_name = { "TenKH", "GioiTinh", "SoCMND", "LoaiKHID", "SoDienThoai", "Email", "DiemThuong" };
int maKH = QLKhachHang.insert("KHACHHANG", column_name, txtKhachHang.Text, (cboGioiTinh.SelectedItem == "Nam" ? 1 : 0), txtSoCMT.Text, (cboLoaiKH.SelectedItem == "Nội Địa" ? 1 : 2), txtSoDT.Text, null, 0);
txtMaKH.Text = maKH.ToString();
int maPhieuThue = RentAdd();
int maHD = AddOrder(maPhieuThue);
txtSoBill.Text = maHD.ToString();
if (maHD != -1)
{
MessageBox.Show("Hóa Đơn Đã được thêm!");
DataTable dttb = DTService.getAll();
DataColumn[] keys = new DataColumn[1];
keys[0] = dttb.Columns[0];
dttb.PrimaryKey = keys;
gridDSDichVu.DataSource = dttb;
dtDVSD = DTBillDetail.getAllWhere("CHITIETHOADON", "MAHD = " + txtSoBill.Text + " AND Phong = " + txtSoPhong.Tag.ToString());
DataColumn[] keysDVSD = new DataColumn[1];
keysDVSD[0] = dtDVSD.Columns[0];
dtDVSD.PrimaryKey = keysDVSD;
gridControlDVSuDung.DataSource = dtDVSD;
Phong.update("PHONG", "TinhTrangPhong = 1", "MaPhong = " + txtSoPhong.Tag.ToString());
loadGalleryPhong();
}
else
{
MessageBox.Show("Lỗi khi thêm hóa đơn!");
}
}
private void galleryControl1_Gallery_ItemClick(object sender, GalleryItemClickEventArgs e)
{
//clear dữ liệu
txtKhachHang.Text = "";
txtSoCMT.Text = "";
txtSoDT.Text = "";
txtSoNguoi.Text = "";
dtNgayTra.Text = "";
dtNgayThue.DateTime = DateTime.Now;
txtSoBill.Text = "";
txtTienThuePhong.Text = "";
txtTongTien.Text = "";
txtPhuThu.Text = "";
txtPhiDichVu.Text = "";
cboLoaiKH.Text = "";
string GhiChu = e.Item.Description;
maPhongClick = e.Item.Caption;
txtSoPhong.Text = e.Item.Caption;
string maPhong_TrangThai = e.Item.Tag.ToString();
txtSoPhongBill.Text = e.Item.Caption;
//cboLoaiPhong.DataSource = LoaiKH.getAll("LOAIKHACHHANG");
// add maphong vao txtSoPhong.Tag de su dung khi dat phong, ko phai lay lai ma phong
txtSoPhong.Tag = maPhong_TrangThai.Split('_')[0];
string trangThaiP = maPhong_TrangThai.Split('_')[1];
if (trangThaiP == "0" || trangThaiP == "1")
{
btnDatPhong.Enabled = false;
btnChuyenPhong.Enabled = true;
btnThayDoiThongTin.Enabled = true;
btnInPhieuThuePhong.Enabled = true;
btnThemKH.Enabled = true;
btnXoaKH.Enabled = true;
btnSuaKH.Enabled = true;
showBill(maPhongClick);
// load thong tin người trong phòng
try
{
DataTable dtPhieuThuePhong = DTRent.getAllWhere("PHIEUTHUE", "MaPhong = " + txtSoPhong.Tag.ToString() + " AND TinhTrangPhieuThue = 1");
string maPhieuThue = dtPhieuThuePhong.Rows[0]["MaPhieuThue"].ToString();
txtMaPhieuThue.Text = maPhieuThue;
dtKH = KhachHang.getAllWhere("KHACHHANG", "MaKH = " + dtPhieuThuePhong.Rows[0]["MaKH"].ToString());
txtKhachHang.Text = dtKH.Rows[0]["TenKH"].ToString();
txtSoCMT.Text = dtKH.Rows[0]["SoCMND"].ToString();
cboGioiTinh.SelectedItem = dtKH.Rows[0]["GioiTinh"].ToString() == "1" ? "Nam" : "Nữ";
txtSoDT.Text = dtKH.Rows[0]["SoDienThoai"].ToString();
cboLoaiKH.SelectedItem = dtKH.Rows[0]["LoaiKHID"].ToString() == "1" ? "Nội Địa" : "Quốc Tế";
txtSoNguoi.Text = "1";
dtNgayThue.Text = dtPhieuThuePhong.Rows[0]["NgayBatDau"].ToString();
dtNgayTra.Text = dtPhieuThuePhong.Rows[0]["NgayKetThuc"].ToString();
//HD
loadHoaDon();
//dsdv hien co
DataTable dttb = DTService.getAll();
DataColumn[] keys = new DataColumn[1];
keys[0] = dttb.Columns[0];
dttb.PrimaryKey = keys;
gridDSDichVu.DataSource = dttb;
//ds dich vu da su dung
DataTable dtCTHD = DTBillDetail.getAllWhere("CHITIETHOADON", "MAHD = " + txtSoBill.Text + " AND Phong = " + txtSoPhong.Tag.ToString());
if (dtCTHD.Rows.Count != 0)
{
string[] arrayDV = new string[dtCTHD.Rows.Count];
for (int i = 0; i < dtCTHD.Rows.Count; i++)
{
arrayDV[i] = dtCTHD.Rows[i]["MaDichVu"].ToString();
}
dtDVSD = DTService.getAllWhere("DICHVU", "MaDichVu in (" + String.Join(",", arrayDV) + ")");
DataColumn[] keysDVSD = new DataColumn[1];
keysDVSD[0] = dtDVSD.Columns[0];
dtDVSD.PrimaryKey = keysDVSD;
gridControlDVSuDung.DataSource = dtDVSD;
}
else
{
dtDVSD = new DataTable();
gridControlDVSuDung.DataSource = dtDVSD;
}
}
catch (Exception)
{
return;
throw;
}
}
else
{
btnDatPhong.Enabled = true;
btnChuyenPhong.Enabled = false;
btnThayDoiThongTin.Enabled = false;
btnInPhieuThuePhong.Enabled = false;
gridKhachHang.DataSource = null;
btnThemKH.Enabled = false;
btnXoaKH.Enabled = false;
btnSuaKH.Enabled = false;
}
}
public static DataTable getAll()
{
return(DTService.getAll());
}
