private void btnPhong_Click(object sender, EventArgs e) { Button btn = (Button)sender; txtDVSoPhong.Text = btn.Text; lvDsDichVu.Items.Clear(); BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(txtDVSoPhong.Text); BEL_HoaDonDichVu hddv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(dp.MaKH); if (hddv != null) { DsDVDaCo = BAL_DichVu.Instance.LoadDichVuTheoMaHD(hddv.Mahd.ToString()); if (DsDVDaCo.Count > 0) { foreach (BEL_DichVu dv in DsDVDaCo) { ListViewItem lvitem = new ListViewItem(); lvitem.Text = dv.Tendv; lvitem.SubItems.Add(new ListViewItem.ListViewSubItem() { Text = dv.Gia.ToString() }); lvitem.SubItems.Add(new ListViewItem.ListViewSubItem() { Text = dv.Giamgia.ToString() }); lvDsDichVu.Items.Add(lvitem); } } TinhTongTien(); } }
private void btnDVThanhToan_Click(object sender, EventArgs e) { if (txtDVTong.Text != "0") { if (DsDV.Count > 0 && DsDVDaCo.Count == 0) { BEL_DatPhong DP = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(txtDVSoPhong.Text); BEL_HoaDonDichVu hd = new BEL_HoaDonDichVu(0, DP.MaKH, DateTime.Now, txtDVTong.Text, TK1.Manv.ToString()); BAL_HoaDonDichVu.Instance.AddHoaDonDV(hd); BAL_HoaDonDichVu.Instance.AddChiTiet(DsDV, txtDVSoPhong.Text); lvDsDichVu.Items.Clear(); MessageBox.Show("Thêm dịch vụ thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } if (DsDV.Count > 0 && DsDVDaCo.Count > 0) { BAL_HoaDonDichVu.Instance.AddChiTiet(DsDV, txtDVSoPhong.Text); BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(txtDVSoPhong.Text); BEL_HoaDonDichVu hddv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(dp.MaKH); BAL_HoaDonDichVu.Instance.UpTongTien(hddv.Mahd.ToString(), txtDVTong.Text); lvDsDichVu.Items.Clear(); MessageBox.Show("Thêm dịch vụ thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } if (DsDV.Count == 0) { MessageBox.Show("Chưa có dịch mới được chọn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Hãy chọn chọn dịch vụ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void cbbTPSoPhong_SelectedValueChanged(object sender, EventArgs e) { try { string sophong = cbbTPSoPhong.Text; BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong); BEL_KhachHang kh = BAL_KhachHang.Instance.LoadKhachHangTheoMa(dp.MaKH); BEL_Phong Phong = BAL_Phong.Instance.LoadRoomSoPhong(sophong); BEL_LoaiPhong loaiphong = BAL_LoaiPhong.Instance.LoadLoaiPhongTheoMa(Phong.Maloaiphong); txtTPHoTen.Text = kh.Hotenkh; TimeTPNgaySinh.Value = kh.Ngaysinh; if (kh.Gioitinh == "Nam") { radTPNam.Checked = true; } else { radTPNu.Checked = true; } txtTPSDT.Text = kh.Sdt; txtTPDiaChi.Text = kh.Diachi; txtTPQuocTich.Text = kh.Quoctich; txtTPCMND.Text = kh.Cmnd; TimeTPNgayDat.Value = dp.NgayDatPhong; DateTime dt = TimeTPNgayTra.Value; TimeSpan t = dt.Subtract(dp.NgayDatPhong); double day = t.TotalDays; txtTPThanhTien.Text = (Math.Round(day) * loaiphong.Giaphong).ToString(); } catch { } }
public int AddDatPhong(BEL_DatPhong room) { string sql = "INSERT INTO dbo.DatPhong VALUES( @madp , @makh , @sophong , @ngaydat , @trangthai )"; int result = DataProvider.Instance.ExecuteNonQuery(sql, new object[] { room.MaDatPhong, room.MaKH, room.SoPhong, room.NgayDatPhong, "No" }); return(result); }
public rpHoaDon(string makh, string sophong, BEL_DatPhong dp, BEL_KhachHang kh, BEL_TraPhong tp, BEL_HoaDonThue hd) { InitializeComponent(); this.makh = makh; this.sophong = sophong; this.dp = dp; this.kh = kh; this.tp = tp; this.hd = hd; }
public BEL_DatPhong LoadDatPhongTheoMa(string madp) { DataTable Data = DAL_DatPhong.Instance.LoadDatPhongTheoMa(madp); if (Data.Rows.Count > 0) { BEL_DatPhong item = new BEL_DatPhong(Data.Rows[0]); return(item); } return(null); }
public BEL_DatPhong LoadDatPhongTheoSoPhong(string sophong) { BEL_DatPhong list = null; DataTable Data = DAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong); foreach (DataRow row in Data.Rows) { list = new BEL_DatPhong(row); } return(list); }
public List <BEL_DatPhong> LoadDatPhong() { List <BEL_DatPhong> list = new List <BEL_DatPhong>(); DataTable Data = DAL_DatPhong.Instance.LoadDatPhong(); foreach (DataRow row in Data.Rows) { BEL_DatPhong item = new BEL_DatPhong(row); list.Add(item); } return(list); }
private void btnDPLuu_Click(object sender, EventArgs e) { if (KiemTraTrongDP()) { string GioiTinh; if (radDPNam.Checked == true) { GioiTinh = "Nam"; } else { GioiTinh = "Nu"; } BEL_KhachHang kh = new BEL_KhachHang(txtDPMaKH.Text, txtDPHoTenKH.Text, GioiTinh, txtSDTDP.Text, TimeDPNgaySinh.Value, txtDPDiaChi.Text, txtDPQuocTich.Text, txtDPCMND.Text); BEL_DatPhong dp = new BEL_DatPhong(txtDPMaDP.Text, txtDPMaKH.Text, cbDPSoPhong.Text, TimeDPNgayDat.Value); BEL_HoaDonThue hd = new BEL_HoaDonThue("NULL", Manv, dp.MaDatPhong, "NULL", kh.MaKH, DateTime.Now, float.Parse(txtDPTienCoc.Text), 0, "Yes"); if (BAL_KhachHang.Instance.LoadKhachHangTheoMa(kh.MaKH) == null) { if (BAL_DatPhong.Instance.LoadDatPhongTheoMa(dp.MaDatPhong) == null) { if (BAL_KhachHang.Instance.InsertCustomer(kh)) { if (BAL_DatPhong.Instance.AddDatPhong(dp)) { MessageBox.Show("Đặt phòng thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); BAL_HoaDonThue.Instance.AddHoaDon(hd, kh.MaKH, dp.SoPhong); BAL_Phong.Instance.UpdateRoomTrangThai(cbDPSoPhong.Text, "Yes"); XoaTrongDP(); BAL_HoaDonThue.Instance.AddChiTiet(BAL_HoaDonThue.Instance.LoadHDThueTheoMaDP(dp.MaDatPhong).Mahd, dp.SoPhong); } } else { MessageBox.Show("Đặt phòng thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Mã đặt phòng trùng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Mã khách hàng trùng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Hãy điền đầy đủ thông tin", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnTPXuat_Click(object sender, EventArgs e) { if (cbbTPSoPhong.Text != "" && txtTPMaTP.Text != "") { if (BAL_TraPhong.Instansce.KiemTraTonTai(txtTPMaTP.Text) == false) { string sophong = cbbTPSoPhong.Text; BEL_DatPhong dp = BAL_DatPhong.Instance.LoadDatPhongTheoSoPhong(sophong); BEL_KhachHang kh = BAL_KhachHang.Instance.LoadKhachHangTheoMa(dp.MaKH); BEL_TraPhong tp = new BEL_TraPhong(txtTPMaTP.Text, kh.MaKH, dp.SoPhong, DateTime.Now); BEL_HoaDonThue hd = BAL_HoaDonThue.Instance.LoadHDThueTheoMaDP(dp.MaDatPhong); BEL_HoaDonDichVu dv = BAL_HoaDonDichVu.Instance.LayHoaDonTheoMaKH(kh.MaKH); if (dv != null) { if (txtTPThanhTien.Text == "0") { hd.Tongtien = (float.Parse(txtTPThanhTien.Text)) + float.Parse(dv.Thanhtien); } else { if (float.Parse(txtTPThanhTien.Text) < hd.Tiencoc) { hd.Tongtien = (hd.Tiencoc - float.Parse(txtTPThanhTien.Text)) + float.Parse(dv.Thanhtien); } else { hd.Tongtien = (float.Parse(txtTPThanhTien.Text) - hd.Tiencoc) + float.Parse(dv.Thanhtien); } } } else { if (txtTPThanhTien.Text == "0") { hd.Tongtien = (float.Parse(txtTPThanhTien.Text)); } else { if (float.Parse(txtTPThanhTien.Text) < hd.Tiencoc) { hd.Tongtien = (hd.Tiencoc - float.Parse(txtTPThanhTien.Text)); } else { hd.Tongtien = (float.Parse(txtTPThanhTien.Text) - hd.Tiencoc); } } } hd.Matraphong = txtTPMaTP.Text; rpHoaDon rp = new rpHoaDon(dp.MaKH, sophong, dp, kh, tp, hd); rp.ShowDialog(); } else { MessageBox.Show("Trùng mã đặt phòng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Hãy điền đầy đủ thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public bool AddDatPhong(BEL_DatPhong room) { int result = DAL_DatPhong.Instance.AddDatPhong(room); return(result > 0); }