public ThongTinDatPhong GetKHByMaBill(int id)
{
string query = "SELECT kh.tenKH,p.tenPhong,dp.soNguoi,kh.CMND,kh.guestPhoneNumber FROM dbo.Bill AS b,dbo.DatPhong AS dp, dbo.KhachHang AS kh ,dbo.Phong AS p WHERE b.maPhong=p.maPhong AND b.maBill=dp.maBill AND dp.maKH=kh.maKH AND b.maBill=" + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
ThongTinDatPhong dp = new ThongTinDatPhong(item);
return(dp);
}
return(null);
}
private void btn_Click(object sender, EventArgs e)
{
txbInfoOrder.Clear();
Room room = (sender as Button).Tag as Room;
int roomID = room.MaPhong;
Bill b = BillDAO.Instance.GetBillByRoom(room.MaPhong);
int price = 0;
int tongSoNgay = 0;
try
{
DateTime ngaymuon = Convert.ToDateTime(b.NgayVao);
DateTime ngaytra = DateTime.Now;
TimeSpan time = ngaytra - ngaymuon;
tongSoNgay = time.Days;
if (tongSoNgay == 0)
{
tongSoNgay = 1;
}
price = room.GiaPhong * tongSoNgay;
}
catch (Exception)
{
}
lsvBill.Tag = room;
ShowBill(roomID, price, tongSoNgay);
try
{
ThongTinDatPhong dp = KhachHangDAO.Instance.GetKHByMaBill(b.MaBill);
Staff staff = StaffDAO.Instance.GetStaffByBillID(b.MaBill);
txbInfoOrder.Text = "Tên khách hàng: " + dp.TenKH + Environment.NewLine + "Tên phòng: " + dp.TenPhong + Environment.NewLine + "Số người: " + dp.SoNguoi + Environment.NewLine + "CMND: " + dp.Cmnd + Environment.NewLine + "Số điện thoại: " + dp.Phone + Environment.NewLine + "Tên nhân viên: " + staff.TenNV;
}
catch (Exception)
{
}
}
