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;
}
}
