internal void Initialize()
{
//Phát sinh mã loại phòng
txtMaPhong.Text = BUS.PhongBUS.PhatSinhMaPhong().ToString();
//Lấy tất cả loại phòng vào cmb
listLoaiPhong = LoaiPhongBUS.LayTatCaLoaiPhong_List();
//Nếu không có loại phòng, thông báo cần tạo loại phòng trước
if (listLoaiPhong.Count == 0)
{
XtraMessageBox.Show("Cần phải thêm loại phòng trước!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
actionBack();
}
cmbLoaiPhong.Properties.Items.Clear();
foreach (LoaiPhongDTO loaiPhong in listLoaiPhong)
{
cmbLoaiPhong.Properties.Items.Add(new MyComboBoxItem(loaiPhong.TenLoaiPhong, loaiPhong.MaLoaiPhong));
}
cmbLoaiPhong.SelectedIndex = 0;
//Lấy tất cả các tầng
cmbTang.Properties.Items.Clear();
List <string> listTang = PhongBUS.LayCacTangCoSan();
foreach (string tang in listTang)
{
cmbTang.Properties.Items.Add(tang);
}
cmbTang.SelectedIndex = 0;
txtTenPhong.Text = "";
}
private void RefreshDataBinding()
{
txtPhong_2.Properties.DataSource = dtThuePhong = HoaDonBUS.LayTatCaCacThuePhong_Phong_LoaiPhong_DataTable(hoaDon.MaHoaDon);
txtMaHoaDon_Goc.Text = hoaDon.MaHoaDon.ToString();
txtTienTraTruoc_Goc.EditValue = hoaDon.TienTraTruoc;
txtKhachHang_Goc.Text = KhachHangBUS.LayKhachHang(hoaDon.MaKH).TenKH;
txtGhiChu_Goc.Text = hoaDon.GhiChu;
foreach (DataRow dr in dtThuePhong.Rows)
{
txtPhong_Goc.Text += PhongBUS.LayThongTinPhong((int)dr["MaPhong"]).TenPhong;
txtPhong_Goc.Text += "; ";
}
txtMaHoaDon_1.Text = txtMaHoaDon_Goc.Text;
txtTienTraTruoc_1.EditValue = txtTienTraTruoc_Goc.EditValue;
txtKhachHang_1.Text = txtKhachHang_Goc.Text;
txtGhiChu_1.Text = txtGhiChu_Goc.Text;
txtMaHoaDon_2.Text = HoaDonBUS.PhatSinhMaHoaDon().ToString();
txtKhachHang_2.Text = txtKhachHang_Goc.Text;
txtGhiChu_2.Text = txtGhiChu_Goc.Text;
txtTienTraTruoc_2.Properties.MaxValue = Convert.ToDecimal(hoaDon.TienTraTruoc);
}
private void TruyenDataVao()
{
_ChiTietDTO = _bus.LayThongTinBaoBieu(this._Id);
lblIDBaoBieu.Text = _ChiTietDTO.IdBaoBieu;
lblIDPhong.Text = _ChiTietDTO.IdPhong;
lblThoiGianDatPhong.Text = _ChiTietDTO.ThoiGianBatDau;
lblThoiGianTraPhong.Text = _ChiTietDTO.ThoiGianKetThuc;
lblChiPhi.Text = Global.Instance().ConvertCurrency(_ChiTietDTO.TongTien.ToString()) + " VND";
PhongBUS phongBus = new PhongBUS();
PhongDTO _phong = phongBus.LayThongTinPhong(_ChiTietDTO.IdPhong);
lblIDPhong.Text = _phong.IdPhong;
lblLoaiPhong.Text = _phong.LoaiPhong.ToString();
KhachHangBUS khBus = new KhachHangBUS();
KhachHangDTO _kh = khBus.LayThongTinKhachHang(_ChiTietDTO.IdKhachHang);
lblTenKhach.Text = _kh.HoTen;
lblCMNDKhach.Text = _kh.Cmnd.ToString();
string[] _arrayDV = _ChiTietDTO.DsDichVu.Split(',');
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
dataGridView1.AllowUserToResizeRows = false;
dataGridView1.DataSource = dsDichVu(_arrayDV);
//dataGridView1.Columns[0].Visible = false;
}
private void frmThanhToan_FormClosing(object sender, FormClosingEventArgs e)
{
PhongBUS pbus = new PhongBUS();
home.cleanGiaoDien();
home.TaoGiaoDienPhong(pbus.getallphong(), pbus.gettinhtrangp(false), pbus.gettinhtrangp(true), "Phòng");
}
private void btnThemPhong_Click(object sender, EventArgs e)
{
if (txtPhong.Text == "")
{
MessageBox.Show("Mã phòng không được để trống", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtPhong.Focus();
return;
}
pBUS = new PhongBUS();
pDTO = new PhongDTO();
pDTO.Maphong = txtPhong.Text;
pDTO.Maloai = cmbTenLoaiPhong.SelectedValue.ToString();
if (pBUS.insertPhong(pDTO) == 1)
{
Show_phong();
}
else
{
MessageBox.Show("Phòng đã có!");
txtPhong.SelectAll();
txtPhong.Focus();
return;
}
}
private void frmPhong_Load(object sender, EventArgs e)
{
pBus = new PhongBUS();
listP = new List <ePhong>();
listP = pBus.getallphong();
gclDSP.DataSource = listP;
}
public void LoadData()
{
//trThai = 1;
//TrangThai();
LoaiPhongBUS lp = new LoaiPhongBUS();
cbo_loaiPhong.DataSource = lp.DanhSachLoaiPhong().FindAll(o => o.TINHTRANG == true);
cbo_loaiPhong.ValueMember = "MALOAIPHONG";
cbo_loaiPhong.DisplayMember = "TENLOAIPHONG";
TinhTrangPhongBUS tt = new TinhTrangPhongBUS();
cbo_tinhtrang.DataSource = tt.DSTINHTRANGPHONG();
cbo_tinhtrang.ValueMember = "MATTR";
cbo_tinhtrang.DisplayMember = "TENTTR";
//load datagridviewcomboboxcolum truoc khi load ds .
DataGridViewComboBoxColumn dgvcb_loaiphong = (DataGridViewComboBoxColumn)dgv_phong.Columns["colLOAIPHONG"];
dgvcb_loaiphong.DataSource = lp.DanhSachLoaiPhong().FindAll(o => o.TINHTRANG == true);
dgvcb_loaiphong.ValueMember = "MALOAIPHONG";
dgvcb_loaiphong.DisplayMember = "TENLOAIPHONG";
DataGridViewComboBoxColumn dgvcb_tinhtrang = (DataGridViewComboBoxColumn)dgv_phong.Columns["colTINHTRANG"];
dgvcb_tinhtrang.DataSource = tt.DSTINHTRANGPHONG();
dgvcb_tinhtrang.ValueMember = "MATTR";
dgvcb_tinhtrang.DisplayMember = "TENTTR";
//DataGridViewCheckBoxColumn dgvckb = (DataGridViewCheckBoxColumn)dgv_sanpham.Columns["TinhTrang"];
PhongBUS b = new PhongBUS();
dgv_phong.DataSource = b.DanhSachPhong();
}
public override void SendRFID(string RFID)
{
SetCheDo(CheDo.XEM);
LoadDuLieu();
string IDPhong = PhongBUS.GetIDPhongFromRFID(RFID);
if (IDPhong == String.Empty)
{
MessageBox.Show("Không tìm thấy SV này trong phòng nào", "Thông báo");
}
for (int i = 0; i < dgvPhong.Rows.Count; i++)
{
if (dgvPhong.Rows[i].Cells["Mã phòng"].Value.ToString() == IDPhong)
{
dgvPhong.CurrentCell = this.dgvPhong["Mã phòng", i];
}
}
for (int i = 0; i < dgvSinhVien.Rows.Count; i++)
{
if (dgvSinhVien.Rows[i].Cells["RFID"].Value.ToString() == RFID)
{
dgvSinhVien.CurrentCell = this.dgvSinhVien[0, i];
}
}
}
private void btnIn_Click(object sender, EventArgs e)
{
HoaDon bc = new HoaDon();
List <eKhachHang> listkh = new List <eKhachHang>();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
PhongBUS pbus = new PhongBUS();
for (int i = 0; i < gridViewLuongKhach.RowCount; i++)
{
eKhachHang kh = new eKhachHang();
kh.SoPhong = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[0]).ToString();
kh.TenKH = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[1]).ToString();
kh.SoCMND = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[2]).ToString();
kh.SoDT = gridViewLuongKhach.GetRowCellValue(i, gridViewLuongKhach.Columns[3]).ToString();
string tgian = cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(kh.SoPhong), false).GioVao + " " + cttpbus.getCTTP_By_MaPhong_TrangThai(pbus.maPhong_byTen(kh.SoPhong), false).NgayVao.ToShortDateString();
kh.ThoiGianNhanPhong = tgian;
listkh.Add(kh);
}
bc.thoiGianInHD = DateTime.Now.ToLongTimeString() + " " + DateTime.Now.ToShortDateString();
frmPrint frmInBCDV = new frmPrint();
frmInBCDV.InBaoCaoInLuongKhachTuReport(bc, listkh.ToList());
frmInBCDV.ShowDialog();
this.Close();
}
private void khoiTao()
{
dTPNgayNhanPhong.Format = DateTimePickerFormat.Custom;
dTPNgayNhanPhong.CustomFormat = "dd/MM/yyyy hh:mm:ss";
pageNumber = 1;
totalPage = PhongBUS.DemPhong(-1);
totalPage = Utility.TinhKichThuocTrang(totalPage, pageSize);
txtTotalPage.Text = totalPage.ToString();
indexHienTai = -1;
dictionaryLayout = new Dictionary <int, List <PhongLayout> >();
dictionaryDatTiec = new Dictionary <string, List <PhieuDatTiec> >();
bindingSource.Add(new PhieuDatTiec());
dGVDatTiec.AllowUserToAddRows = false;
dGVDatTiec.DataSource = bindingSource;
bindingSource.RemoveAt(0);
dGVDatTiec.Columns["Phong"].HeaderText = "Phòng";
dGVDatTiec.Columns["TenKH"].HeaderText = "Tên khách hàng";
dGVDatTiec.Columns["SoDienThoai"].HeaderText = "Số điện thoại";
dGVDatTiec.Columns["NgayDat"].HeaderText = "Thời gian đặt";
dGVDatTiec.Columns["NgayNhan"].HeaderText = "Thời gian nhận";
//dGVDatTiec.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dGVDatTiec.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dGVDatTiec.Columns["SoHD"].Visible = false;
hienThiTatCaPhong();
}
private void btnHanhDong_Click(object sender, EventArgs e)
{
PhongDTO phongDTO = new PhongDTO();
phongDTO.IDPhong = txtIDPhong.Text;
phongDTO.KhuNha = txtKhuNha.Text;
phongDTO.SoPhong = txtSoPhong.Text;
phongDTO.TinhTrang = txtTinhTrang.Text;
phongDTO.SoLuongToiDa = (int)numToiDa.Value;
if (CheDoHienTai == CheDo.THEM)
{
if (PhongBUS.ThemPhongDTO(phongDTO))
{
MessageBox.Show("Thêm phòng " + phongDTO.IDPhong + " thành công");
LoadDuLieu();
}
else
{
MessageBox.Show("Thêm phòng " + phongDTO.IDPhong + " thất bại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (CheDoHienTai == CheDo.SUA)
{
if (PhongBUS.SuaPhongDTO(phongDTO))
{
MessageBox.Show("Thêm phòng " + phongDTO.IDPhong + " thành công");
LoadDuLieu();
}
else
{
MessageBox.Show("Thêm phòng " + phongDTO.IDPhong + " thất bại", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void trvPhong_AfterSelect(object sender, TreeViewEventArgs e)
{
lsvPhong.Items.Clear();
string maphong = trvPhong.SelectedNode.Tag.ToString();
pBUS = new PhongBUS();
lpBUS = new LoaiPhongBUS();
ctvtBUS = new ChiTietVatTuBUS();
vtBUS = new VatTuBUS();
PhongDTO p = pBUS.getPhongByID(maphong);
if (p != null)
{
LoaiPhongDTO lp = lpBUS.getLoaiPhongByID(p.Maloai);
IList <ChiTietVatTuDTO> lispctvt = ctvtBUS.getListChiTietVatTuByMaLP(lp.Maloai);
foreach (ChiTietVatTuDTO ctvt in lispctvt)
{
IList <VatTuDTO> listvt = vtBUS.getLikeVatTuByID(ctvt.Mavattu);
foreach (VatTuDTO vt in listvt)
{
int i = lsvPhong.Items.Count;
lsvPhong.Items.Add(p.Maphong);
lsvPhong.Items[i].SubItems.Add(vt.Tenvattu);
lsvPhong.Items[i].SubItems.Add(ctvt.Soluong.ToString());
lsvPhong.Items[i].SubItems.Add(Math.Round(lp.Gia, 0).ToString());
}
}
}
}
private void showTreView()
{
trvPhong.Nodes.Clear();
lpBUS = new LoaiPhongBUS();
pBUS = new PhongBUS();
TreeNode tr = new TreeNode();
IList <LoaiPhongDTO> listlp = lpBUS.getListLoaiPhongAll();
foreach (LoaiPhongDTO lp in listlp)
{
tr = new TreeNode(lp.Maloai);
tr.Tag = lp.Maloai;
IList <PhongDTO> listp = pBUS.getListPhongByLoai(lp.Maloai);
if (listp != null)
{
foreach (PhongDTO p in listp)
{
TreeNode pt = new TreeNode(p.Maphong);
pt.Tag = p.Maphong;
tr.Nodes.Add(pt);
}
}
trvPhong.Nodes.Add(tr);
}
}
public void RefreshDataBinding()
{
dataSet = new DataSet();
dtLoaiPhong = LoaiPhongBUS.LayTatCaLoaiPhong_DataTable();
dtDonGiaPhong = DonGia_LoaiPhongBUS.LayTatCaDonGia_DataTable();
dtPhong = PhongBUS.LayTatCaPhong_TinhTrangPhong_LoaiPhong();
dtPhong.TableName = "phong";
dataSet.Tables.Add(dtLoaiPhong);
dataSet.Tables.Add(dtDonGiaPhong);
dataSet.Tables.Add(dtPhong);
dataSet.Relations.Add("Đơn giá phòng", dataSet.Tables["loaiphong"].Columns["MaLP"], dataSet.Tables["dongia_loaiphong"].Columns["MaLoaiPhong"]);
dataSet.Relations.Add("Thông tin phòng", dataSet.Tables["loaiphong"].Columns["MaLP"], dataSet.Tables["phong"].Columns["MaLoaiPhong"]);
gridControl1.DataSource = dataSet.Tables["loaiphong"];
gridControl1.LevelTree.Nodes.Add("Đơn giá phòng", gridViewDonGiaPhong);
gridControl1.LevelTree.Nodes.Add("Thông tin phòng", gridViewPhong);
if (gridViewLoaiPhong.RowCount == 0)
{
wbntLoaiphong.Buttons[1].Properties.Visible = false;
wbntLoaiphong.Buttons[2].Properties.Visible = false;
}
}
private void btnTraPhong_Click(object sender, EventArgs e)
{
if (txtMaKhachHang.Text == "")
{
MessageBox.Show("Vui lòng chọn phòng để trả");
return;
}
else
{
if (lvPhong.SelectedItems.Count > 0)
{
PhongBUS phongBUS = new PhongBUS();
ListViewItem lv = lvPhong.SelectedItems[0];
Phong p = new Phong();
Phong p2 = new Phong();
p.Maphong = lv.SubItems[1].Text;
ThuePhongBUS thuephongbus = new ThuePhongBUS();
KhachHangBUS khBUS = new KhachHangBUS();
ThuePhong tp = new ThuePhong();
tp = thuephongbus.LayThongTinThuePhong(p.Maphong);
p2 = phongBUS.PhongTheoMa(p.Maphong);
string mathuephong = tp.Mathuephong;
string maphong = p.Maphong;
string tenphong = p2.Tenphong;
decimal giaphong = p2.Giaphong;
string tenkhach = txtTenKhachHang.Text;
DateTime ngaythue = DateTime.Parse(txtNgayThue.Text);
int tiendichvu = int.Parse(txtTongTienDV.Text);
string manhanvien = NhanVien.Instance.Manhanvien;
frmTraPhong frm = new frmTraPhong(mathuephong, tenphong, giaphong, tenkhach, ngaythue, tiendichvu, manhanvien, maphong);
frm.ShowDialog();
LoadDanhSachPhong();
}
}
}
public void lblred_MouseHover(object sender, EventArgs e)
{
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
ThuePhongBUS tpbus = new ThuePhongBUS();
KhachHangBUS khbus = new KhachHangBUS();
Label lbl = sender as Label;
string ttPhong = lbl.Text;
string[] lsPhong = ttPhong.Split('\r');
string mathue = cttpbus.getMaThue_By_MaPhong_TrangThai(pbus.maPhong_byTen(lsPhong[0].Trim()), false);
string ttThuePhong = "";
int stt = 0;
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(mathue, pbus.maPhong_byTen(lsPhong[0].Trim())))
{
stt++;
ttThuePhong += "Khách hàng " + stt + " : " + khbus.getenKH_ByID(item.MaKhach) + "\n";
}
foreach (var item in cttpbus.getChiTietThuePhong_By_MaThue_MaPhong(mathue, pbus.maPhong_byTen(lsPhong[0].Trim())))
{
if (item.NgayRa < DateTime.Now.Date)
{
ttThuePhong += "Ngày ra: " + DateTime.Now.Date.ToShortDateString();
}
else
{
ttThuePhong += "Ngày ra: " + item.NgayRa.ToShortDateString();
}
break;
}
toolTipTTThuePhong.SetToolTip(lbl, ttThuePhong);
}
private void LoadDanhSachPhong()
{
PhongBUS phongBUS = new PhongBUS();
lvPhong.Items.Clear();
lvPhong.LargeImageList = imageList1;
lvPhong.View = View.LargeIcon;
foreach (Phong p in phongBUS.getListPhong())
{
ListViewItem lvItem = new ListViewItem(p.Tenphong);
lvItem.SubItems.Add(p.Maphong);
lvItem.SubItems.Add(p.Maloaiphong);
lvItem.SubItems.Add(p.Giaphong.ToString());
lvItem.SubItems.Add(p.Trangthai.ToString());
//lvItem.SubItems.Add()
if (p.Trangthai == 0)
{
lvItem.ImageIndex = 0;
lvItem.BackColor = Color.Green;
}
else if (p.Trangthai == 1)
{
lvItem.ImageIndex = 1;
lvItem.BackColor = Color.Red;
}
lvPhong.Items.Add(lvItem);
}
lvPhong.SelectedIndexChanged += LvPhong_SelectedIndexChanged;
}
private void btnTheoPhong_ItemClick(object sender, ItemClickEventArgs e)
{
cleanGiaoDien();
PhongBUS pbus = new PhongBUS();
TaoGiaoDienPhong(pbus.getallphong(), pbus.gettinhtrangp(false), pbus.gettinhtrangp(true), "Phòng");
}
private void show_Phong()
{
lsvPhong.Items.Clear();
tienphong = 0;
ptpBUS = new PhieuThuePhongBUS();
PhieuThuePhongDTO ptp = ptpBUS.getPhieuThuePhongByID(cmbMaPT.Text);
pdpBUS = new PhieuDatPhongBUS();
PhieuDatPhongDTO pdp = pdpBUS.getPhieuDatPhongByID(ptp.Maphieudat);
ctdpBUS = new ChiTietDatPhongBUS();
IList <ChiTietDatPhongDTO> list = ctdpBUS.getChiTietDatPhongByID(pdp.Maphieudat);
pBUS = new PhongBUS();
lpBUS = new LoaiPhongBUS();
foreach (ChiTietDatPhongDTO ctdp in list)
{
int i = lsvPhong.Items.Count;
PhongDTO p = pBUS.getPhongByID(ctdp.Maphong);
LoaiPhongDTO lp = lpBUS.getLoaiPhongByID(p.Maloai);
lsvPhong.Items.Add(ctdp.Maphong);
lsvPhong.Items[i].SubItems.Add(lp.Gia.ToString("0,0"));
lsvPhong.Items[i].SubItems.Add(pdp.Ngayden.ToShortDateString());
lsvPhong.Items[i].SubItems.Add(pdp.Ngaydi.ToShortDateString());
TimeSpan sno = pdp.Ngaydi.Date.AddDays(1) - pdp.Ngayden.Date;
lsvPhong.Items[i].SubItems.Add(sno.Days.ToString());
decimal tp = lp.Gia * sno.Days;
lsvPhong.Items[i].SubItems.Add(tp.ToString("0,0"));
tienphong += tp;
}
labTP.Text = tienphong.ToString("0,0");
}
public void frmHome_Load(object sender, EventArgs e)
{
cleanGiaoDien();
PhongBUS pbus = new PhongBUS();
TaoGiaoDienPhong(pbus.getallphong(), pbus.gettinhtrangp(false), pbus.gettinhtrangp(true), "Phòng");
}
private void XuLyTraCuu(int loaiPhong, int tinhTrang)
{
PhongBUS b = new PhongBUS();
List <PhongDTO> lst = b.DanhSachPhong().FindAll(o => o.LOAIPHONG == loaiPhong && o.TINHTRANG == tinhTrang);
dgv_phong.DataSource = lst;
}
private void btn_tracuuPSONGUOI_Click(object sender, EventArgs e)
{
PhongBUS a = new PhongBUS();
List <PhongDTO> b = new List <PhongDTO>();
b = a.DanhSachPhong().FindAll(o => o.SONGUOI >= int.Parse(txt_soNGUOI.Text));
try
{
if (b != null)
{
txt_tenPhong.Text = b[0].TENPHONG;
txt_gia.Text = b[0].GIAPHONG.ToString();
}
else
{
txt_tenPhong.Text = "Không còn phòng";
txt_gia.Text = string.Empty;
}
}
catch
{
txt_tenPhong.Text = "Không tìm thấy";
txt_gia.Text = string.Empty;
}
cbo_loaiPhong.SelectedIndex = -1;
}
public void load_list_dichvu()
{
PhongBUS pbus = new PhongBUS();
ChiTietThuePhongBUS cttpbus = new ChiTietThuePhongBUS();
dgvCTDV.DataSource = DataTable_DSDV(ctdvbus.getctdv(MaThue, cttpbus.getMaKhach_By_MaPhong_TrangThai(pbus.maPhong_byTen(TenPhong), false)));
}
void RefreshDataBindingTienGio()
{
tienGio = new DataTable();
tienGio.Columns.Add(new DataColumn("Ngay"));
tienGio.Columns.Add(new DataColumn("KhoangThoiGian"));
tienGio.Columns.Add(new DataColumn("DonGia"));
tienGio.Columns.Add(new DataColumn("SoLuong"));
tienGio.Columns.Add(new DataColumn("GioBD", typeof(double)));
tienGio.Columns.Add(new DataColumn("Phong"));
tienGio.Columns.Add(new DataColumn("colType"));
TongTienGio = 0;
foreach (DTO.ThongTinThanhToanTheoNgay ngay in ThanhToanBUS.TinhTienThuePhong(thuePhong, txtGioRa.Time).listThongTin)
{
TongTienGio += ngay.TongThanhTien;
foreach (LoaiPhongDTO.DonGiaTheoKhoangThoiGian dongia in ngay.listDonGiaTheoKhoangThoiGian)
{
DataRow dr = tienGio.NewRow();
dr["Ngay"] = ngay.ngay.Thu + " (" + ngay.ngay.date.ToString("dd-MM-yyyy") + ")";
dr["KhoangThoiGian"] = dongia.GioBatDau + " - " + dongia.GioKetThuc;
dr["GioBD"] = dongia.GioBatDau.hour * 3600 + dongia.GioBatDau.minute * 60 + dongia.GioBatDau.second;
dr["DonGia"] = dongia.DonGia;
dr["SoLuong"] = Math.Round(ThongTinThanhToanTheoNgay.Gio.CalcTimeSpan(dongia.GioBatDau, dongia.GioKetThuc).TotalHours, 2);
dr["Phong"] = PhongBUS.LayThongTinPhong(thuePhong.MaPhong).TenPhong;
tienGio.Rows.Add(dr);
}
}
txtTienGio.Properties.DataSource = tienGio;
txtTienGio.Properties.NullText = TongTienGio.ToString("###,###,###,##0 VNĐ");
}
private void btnXoaPhong_Click(object sender, EventArgs e)
{
if (lsvPhong.SelectedItems.Count <= 0)
{
return;
}
else
{
if (MessageBox.Show("Bạn có chắc thực hiện việc này không", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
pBUS = new PhongBUS();
string fe = lsvPhong.SelectedItems[0].SubItems[0].Text;
if (pBUS.deletePhong(fe) == 1)
{
Show_phong();
txtPhong.Clear();
}
else
{
MessageBox.Show("Không thể xóa vì nó đang được tham chiếu!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
else
{
lsvPhong.SelectedItems.Clear();
}
}
}
private void HienthiGiaPhong(int maLoaiGia, int maLoaiPhong)
{
PhongBUS phongBUS = new PhongBUS();
lbGiaPhong.Text = phongBUS.LayGiaPhong(maLoaiGia, maLoaiPhong).ToString();
HienthiTraTruoc();
}
private void ChinhSuaThongTinPhong_Load(object sender, EventArgs e)
{
PhongBUS phongBUS = new PhongBUS();
txtMaPhong.Text = phongBUS.LayThongTinPhongQuaMaPhong(MaPhong).maPhong;
if (phongBUS.LayThongTinPhongQuaMaPhong(MaPhong).loaiPhong == 1)
{
txtLoaiPhong.selectedIndex = 0;
}
else if (phongBUS.LayThongTinPhongQuaMaPhong(MaPhong).loaiPhong == 2)
{
txtLoaiPhong.selectedIndex = 1;
}
else
{
txtLoaiPhong.selectedIndex = 2;
}
if (phongBUS.LayThongTinPhongQuaMaPhong(MaPhong).tinhTrang == 0)
{
txtTinhTrang.selectedIndex = 0;
}
else
{
txtTinhTrang.selectedIndex = 1;
}
}
private void Hienthithongtinthuephong(int maPhieuthue)
{
PhieuThuePhongDTO phieuThuePhongDTO = new PhieuThuePhongDTO();
PhieuThuePhongBUS phieuThuePhongBUS = new PhieuThuePhongBUS();
phieuThuePhongDTO = phieuThuePhongBUS.LayPhieuthuephongTheoma(maPhieuthuephong);
maP = phieuThuePhongDTO.MaPhong;
PhongDTO phongDTO = new PhongDTO();
PhongBUS phongBUS = new PhongBUS();
phongDTO = phongBUS.LayPhongTheoMaSo(phieuThuePhongDTO.MaPhong);
HienthiComboboxLoaiGia();
HienthiKhachhang(phieuThuePhongDTO.MaKhachHang);
lbTenPhong.Text = phongDTO.Ten;
lbTang.Text = phongDTO.Tang.ToString();
dtpkGioBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkGioKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
dtpkNgayBD.Value = phieuThuePhongDTO.ThoiGianNhanPhong;
dtpkNgayKT.Value = phieuThuePhongDTO.ThoiGianTraPhong;
cbmLoaiDangKy.SelectedValue = phieuThuePhongDTO.MaLoaiThuePhong;
lbLoaiPhong.Text = phongBUS.LayLoaiPhong(phongDTO.MaLoaiPhong);
HienthiGiaPhong(int.Parse(cbmLoaiDangKy.SelectedValue.ToString()), phongDTO.MaLoaiPhong);
HienthiThoiGian();
}
private void Tb_tenphong_MouseLeave(object sender, MouseEventArgs e)
{
PhongBUS bus = new PhongBUS();
if (tb_tenphong.Text != "")
{
var data = bus.SearchTheoTenPhongdathue(tb_tenphong.Text);
if (data.Rows.Count != 0)
{
tb_tenphong.Text = data.Rows[0].Field <string>(0);
tb_loaiphong.Text = data.Rows[0].Field <string>(1);
tb_gia.Text = data.Rows[0].Field <double>(2).ToString();
tb_ghichu.Text = data.Rows[0].Field <string>(3).ToString();
}
else
{
tb_tenphong.Text = "";
tb_loaiphong.Text = "";
tb_gia.Text = "";
tb_ghichu.Text = "";
}
}
else
{
tb_tenphong.Text = "";
tb_loaiphong.Text = "";
tb_gia.Text = "";
tb_ghichu.Text = "";
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
if (txtTim.Text == "")
{
MessageBox.Show("Bạn chưa điền mã phòng của phòng cần tìm!!");
return;
}
else
{
PhongBUS phongBUS = new PhongBUS();
Phong phong = new Phong();
phong.maPhong = txtTim.Text;
phong.tinhTrang = -1;
phong.loaiPhong = -1;
if (!phongBUS.KiemTraMaPhong(phong))
{
txtTim.Text = "";
txtTim.Focus();
MessageBox.Show("Phòng cần tìm không tồn tại trong danh sách!! Xin nhập lại");
}
else
{
bunifuCustomDataGrid1.DataSource = phongBUS.TimPhong(phong);
}
}
}
