private void btnXacNhanThuePhong_Click(object sender, EventArgs e) { string diaChiThuongTru = txtDiaChiThuongTru.Text; string gioiTinh = txtGioiTinh.SelectedItem.ToString(); string maKhach = txtMaKhach.Text; DateTime ngaySinh = txtNgaySinh.Value.Date; string soCMND = txtsoCMND.Text; string soDienThoai = txtsoDienThoai.Text; string tenKhach = txtTenKhach.Text; string maPhong = lblPhong.Text; KHACHTRO khachThuePhong = new KHACHTRO(maKhach, tenKhach, maPhong, ngaySinh, gioiTinh, soDienThoai, diaChiThuongTru, soCMND); HOADON hoaDonThue = new HOADON(lblMaHoaDon.Text, maKhach, nhanVienDangDangNhap.MANHANVIEN, lblPhong.Text, DateTime.Now.Date, double.Parse(lblTongTienHD.Text)); bus_hoaDon.themHoaDon(hoaDonThue); bus_khachTro.themKhach(khachThuePhong); PHONGTRO phong = new PHONGTRO(maPhong, "Đang Ở", float.Parse(lblTienPhong.Text), Int32.Parse(txtSoNguoiO.Text)); bus_phongTro.capNhatPhong(phong); for (int i = 0; i < gridChiTietHoaDon2.RowCount; i++) { CHITIETHOADON chiTietHoaDon = new CHITIETHOADON(gridChiTietHoaDon2.Rows[i].Cells[0].Value.ToString(), gridChiTietHoaDon2.Rows[i].Cells[1].Value.ToString(), 0, Int32.Parse(gridChiTietHoaDon2.Rows[i].Cells[3].Value.ToString()), float.Parse(gridChiTietHoaDon2.Rows[i].Cells[4].Value.ToString())); bus_chiTietHoaDon.themChiTietHoaDon(chiTietHoaDon); } MetroMessageBox.Show(Owner, "Thue Thanh cong", "Thong bao", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); int soTang = Int32.Parse(cbbTrang.SelectedIndex.ToString()); List <PHONGTRO> danhSachPhongTheoTang = bus_phongTro.layPhongTheoTang(soTang * 15, 15); resetTrangThai(); hienThiPhong(danhSachPhongTheoTang); txtDiaChiThuongTru.Text = ""; txtMaKhach.Text = ""; txtTenKhach.Text = ""; txtsoDienThoai.Text = ""; txtSoNguoiO.Text = ""; txtsoCMND.Text = ""; lblTienPhong.Text = ""; lblTongTienDichVu.Text = ""; lblTongTienHD.Text = ""; pnlXuLyThuePhong.Visible = false; }
public void hienThiTrangThaiPhong(PHONGTRO phong, MetroFramework.Controls.MetroTile nutPhong) { if (phong != null) { nutPhong.Text = phong.MAPHONG; switch (phong.TRANGTHAI) { case "Trống": nutPhong.BackColor = Color.Gray; break; case "Đang Ở": DateTime ngayHienTai = DateTime.Now.Date; KHACHTRO khachTro = bus_khachTro.layKhachTheoMaPhong(phong.MAPHONG); if (khachTro != null) { HOADON hoaDon = bus_hoaDon.layHoaDonTheoMaKhach(khachTro.MAKHACH); if (hoaDon != null) { DateTime ngayCuaHoaDon = hoaDon.NGAYLAP.Date; TimeSpan ketQua = ngayHienTai - ngayCuaHoaDon; if (ketQua.Days >= 30) { nutPhong.BackColor = Color.Red; } else if (ketQua.Days < 30 && ketQua.Days >= 25) { nutPhong.BackColor = Color.Gold; } else if (ketQua.Days < 25) { nutPhong.BackColor = Color.YellowGreen; } } } break; } nutPhong.Enabled = true; } }
public bool capNhatKhachTro(KHACHTRO khach) { return(dal_khachTro.capNhatKhachTro(khach)); }
public bool themKhach(KHACHTRO khach) { return(dal_khachTro.themKhach(khach)); }
public void xuLyChonPhong(MetroFramework.Controls.MetroTile nut) { if (nut.BackColor == Color.YellowGreen) { gridChiTietHoaDon2.DataSource = null; if (gridChiTietHoaDon2.RowCount > 0) { gridChiTietHoaDon2.Rows.Clear(); gridChiTietHoaDon2.Columns.Clear(); } txtDien.Visible = false; txtNuoc.Visible = false; label12.Visible = false; label17.Visible = false; ckcCap.Enabled = false; ckcRac.Enabled = false; ckcXe.Enabled = false; ckcInternet.Enabled = false; lblPhong.Text = nut.Text; KHACHTRO khach = bus_khachTro.layKhachTheoMaPhong(nut.Text); if (khach != null) { HOADON hoaDon = bus_hoaDon.layHoaDonTheoMaKhach(khach.MAKHACH); lblMaHoaDon.Text = hoaDon.MAHOADON; txtDiaChiThuongTru.Text = khach.DIACHITHUONGTRU; txtGioiTinh.Text = khach.GIOITINH; txtMaKhach.Text = khach.MAKHACH; txtNgaySinh.Text = khach.NGAYSINH.ToString(); txtsoCMND.Text = khach.SOCMND; txtsoDienThoai.Text = khach.SODIENTHOAI; txtTenKhach.Text = khach.TENKHACH; PHONGTRO phong = bus_phongTro.layDoiTuongPhongTheoMaPhong(lblPhong.Text); if (phong != null) { txtSoNguoiO.Text = phong.SONGUOIO.ToString(); } gridChiTietHoaDon2.DataSource = bus_chiTietHoaDon.layChiTietHoaDonTheoMaHoaDon(hoaDon.MAHOADON); gridChiTietHoaDon2.Columns[0].HeaderText = "Mã Hóa Đơn"; gridChiTietHoaDon2.Columns[1].HeaderText = "Tên Dịch Vụ"; gridChiTietHoaDon2.Columns[2].HeaderText = "Số Cũ"; gridChiTietHoaDon2.Columns[3].HeaderText = "Số Lượng"; gridChiTietHoaDon2.Columns[4].HeaderText = "Thành Tiền"; double tongTienDichvu = 0; for (int i = 0; i < gridChiTietHoaDon2.RowCount; i++) { tongTienDichvu += double.Parse(gridChiTietHoaDon2.Rows[i].Cells[4].Value.ToString()); } lblTongTienDichVu.Text = string.Format("{0:n}", double.Parse(tongTienDichvu.ToString())); PHONGTRO phongTam = bus_phongTro.layDoiTuongPhongTheoMaPhong(nut.Text); if (phongTam != null) { lblTienPhong.Text = string.Format("{0:n}", double.Parse(phongTam.TIENPHONG.ToString())); } lblTongTienHD.Text = string.Format("{0:n}", double.Parse(hoaDon.TONGTIEN.ToString())); } btnTraPhong.Enabled = true; btnThanhToan.Enabled = false; btnXacNhanThuePhong.Enabled = false; pnlXuLyThuePhong.Visible = true; } else if (nut.BackColor == Color.Gray) { gridChiTietHoaDon2.DataSource = null; if (gridChiTietHoaDon2.RowCount > 0) { gridChiTietHoaDon2.Rows.Clear(); gridChiTietHoaDon2.Columns.Clear(); } txtDien.Visible = false; txtNuoc.Visible = false; label12.Visible = false; label17.Visible = false; lblPhong.Text = nut.Text; lblMaHoaDon.Text = tuSinhMaHoaDon(bus_hoaDon.dem()); btnThanhToan.Enabled = false; btnTraPhong.Enabled = false; btnXacNhanThuePhong.Enabled = true; pnlXuLyThuePhong.Visible = true; ckcCap.Enabled = true; ckcRac.Enabled = true; ckcXe.Enabled = true; ckcInternet.Enabled = true; PHONGTRO phong = bus_phongTro.layDoiTuongPhongTheoMaPhong(lblPhong.Text); lblTienPhong.Text = phong.TIENPHONG.ToString(); gridChiTietHoaDon2.Columns.Add("0 ", "Mã hóa đơn"); gridChiTietHoaDon2.Columns.Add("1", "Tên dịch vụ"); gridChiTietHoaDon2.Columns.Add("2", "Số cũ"); gridChiTietHoaDon2.Columns.Add("3", "Số lượng"); gridChiTietHoaDon2.Columns.Add("4", "Thành tiền"); gridChiTietHoaDon2.Rows.Add(6); dichVu = bus_dichVu.layDoiTuongDichVuBangTenDichVu("Điện"); gridChiTietHoaDon2.Rows[0].Cells[0].Value = lblMaHoaDon.Text; gridChiTietHoaDon2.Rows[0].Cells[1].Value = "Điện"; gridChiTietHoaDon2.Rows[0].Cells[2].Value = 0; gridChiTietHoaDon2.Rows[0].Cells[3].Value = 0; gridChiTietHoaDon2.Rows[0].Cells[4].Value = 0; dichVu2 = bus_dichVu.layDoiTuongDichVuBangTenDichVu("Nước"); gridChiTietHoaDon2.Rows[1].Cells[0].Value = lblMaHoaDon.Text; gridChiTietHoaDon2.Rows[1].Cells[1].Value = "Nước"; gridChiTietHoaDon2.Rows[1].Cells[2].Value = 0; gridChiTietHoaDon2.Rows[1].Cells[3].Value = 0; gridChiTietHoaDon2.Rows[1].Cells[4].Value = 0; dichVu3 = bus_dichVu.layDoiTuongDichVuBangTenDichVu("Rác"); gridChiTietHoaDon2.Rows[2].Cells[0].Value = lblMaHoaDon.Text; gridChiTietHoaDon2.Rows[2].Cells[1].Value = "Rác"; gridChiTietHoaDon2.Rows[2].Cells[2].Value = ""; gridChiTietHoaDon2.Rows[2].Cells[3].Value = 1; gridChiTietHoaDon2.Rows[2].Cells[4].Value = dichVu3.DONGIA * float.Parse(gridChiTietHoaDon2.Rows[2].Cells[3].Value.ToString()); dichVu4 = bus_dichVu.layDoiTuongDichVuBangTenDichVu("Xe"); gridChiTietHoaDon2.Rows[3].Cells[0].Value = lblMaHoaDon.Text; gridChiTietHoaDon2.Rows[3].Cells[1].Value = "Xe"; gridChiTietHoaDon2.Rows[3].Cells[2].Value = ""; gridChiTietHoaDon2.Rows[3].Cells[3].Value = 1; gridChiTietHoaDon2.Rows[3].Cells[4].Value = dichVu4.DONGIA * float.Parse(gridChiTietHoaDon2.Rows[3].Cells[3].Value.ToString()); dichVu5 = bus_dichVu.layDoiTuongDichVuBangTenDichVu("Internet"); gridChiTietHoaDon2.Rows[4].Cells[0].Value = lblMaHoaDon.Text; gridChiTietHoaDon2.Rows[4].Cells[1].Value = "Internet"; gridChiTietHoaDon2.Rows[4].Cells[2].Value = ""; gridChiTietHoaDon2.Rows[4].Cells[3].Value = 1; gridChiTietHoaDon2.Rows[4].Cells[4].Value = dichVu5.DONGIA * float.Parse(gridChiTietHoaDon2.Rows[4].Cells[3].Value.ToString()); dichVu6 = bus_dichVu.layDoiTuongDichVuBangTenDichVu("Cáp"); gridChiTietHoaDon2.Rows[5].Cells[0].Value = lblMaHoaDon.Text; gridChiTietHoaDon2.Rows[5].Cells[1].Value = "Cáp"; gridChiTietHoaDon2.Rows[5].Cells[2].Value = ""; gridChiTietHoaDon2.Rows[5].Cells[3].Value = 1; gridChiTietHoaDon2.Rows[5].Cells[4].Value = dichVu6.DONGIA * float.Parse(gridChiTietHoaDon2.Rows[5].Cells[3].Value.ToString()); double tongTienDichvu = 0; for (int i = 0; i < gridChiTietHoaDon2.RowCount; i++) { tongTienDichvu += double.Parse(gridChiTietHoaDon2.Rows[i].Cells[4].Value.ToString()); } lblTongTienDichVu.Text = string.Format("{0:n}", double.Parse(tongTienDichvu + "")); lblTongTienHD.Text = string.Format("{0:n}", double.Parse((tongTienDichvu + double.Parse(lblTienPhong.Text)).ToString())); } else if (nut.BackColor == Color.Gold || nut.BackColor == Color.Red) { ckcCap.Enabled = false; ckcRac.Enabled = false; ckcXe.Enabled = false; ckcInternet.Enabled = false; txtDien.Visible = true; txtNuoc.Visible = true; label12.Visible = true; label17.Visible = true; lblPhong.Text = nut.Text; KHACHTRO khach = bus_khachTro.layKhachTheoMaPhong(nut.Text); if (khach != null) { HOADON hoaDon = bus_hoaDon.layHoaDonTheoMaKhach(khach.MAKHACH); lblMaHoaDon.Text = hoaDon.MAHOADON; txtDiaChiThuongTru.Text = khach.DIACHITHUONGTRU; txtGioiTinh.Text = khach.GIOITINH; txtMaKhach.Text = khach.MAKHACH; txtNgaySinh.Text = khach.NGAYSINH.ToString(); txtsoCMND.Text = khach.SOCMND; txtsoDienThoai.Text = khach.SODIENTHOAI; txtTenKhach.Text = khach.TENKHACH; PHONGTRO phong = bus_phongTro.layDoiTuongPhongTheoMaPhong(lblPhong.Text); if (phong != null) { txtSoNguoiO.Text = phong.SONGUOIO.ToString(); } gridChiTietHoaDon2.DataSource = null; if (gridChiTietHoaDon2.RowCount > 0) { gridChiTietHoaDon2.Rows.Clear(); gridChiTietHoaDon2.Columns.Clear(); } gridChiTietHoaDon2.DataSource = bus_chiTietHoaDon.layChiTietHoaDonTheoMaHoaDon(hoaDon.MAHOADON); gridChiTietHoaDon2.Columns[0].HeaderText = "Mã Hóa Đơn"; gridChiTietHoaDon2.Columns[1].HeaderText = "Tên Dịch Vụ"; gridChiTietHoaDon2.Columns[2].HeaderText = "Số Cũ"; gridChiTietHoaDon2.Columns[3].HeaderText = "Số Lượng"; gridChiTietHoaDon2.Columns[4].HeaderText = "Thành Tiền"; double tongTienDichvu = 0; for (int i = 0; i < gridChiTietHoaDon2.RowCount; i++) { tongTienDichvu += double.Parse(gridChiTietHoaDon2.Rows[i].Cells[4].Value.ToString()); } lblTongTienDichVu.Text = string.Format("{0:n}", double.Parse(tongTienDichvu.ToString())); PHONGTRO phongTam = bus_phongTro.layDoiTuongPhongTheoMaPhong(nut.Text); if (phongTam != null) { lblTienPhong.Text = string.Format("{0:n}", double.Parse(phongTam.TIENPHONG.ToString())); } lblTongTienHD.Text = string.Format("{0:n}", double.Parse(hoaDon.TONGTIEN.ToString())); } btnTraPhong.Enabled = false; btnXacNhanThuePhong.Enabled = false; btnThanhToan.Enabled = true; pnlXuLyThuePhong.Visible = true; } }