private void frmThuePhong_Load(object sender, EventArgs e)
{
_load = true;
DateTime date = DateTime.Today.AddDays(0);
dtpNgayvao.Value = date;
//load dgvThongTin
DataTable tb = dalPh.ThongTinPhong("");
dgvThongtin.DataSource = tb;
for (int i = 0; i < dgvThongtin.RowCount; i++)
{
dgvThongtin.Rows[i].Cells["STT"].Value = i + 1;
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Tốt")
{
dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.Lime;
}
else
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Đã thuê")
{
dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.LightSkyBlue;
}
else
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Hỏng")
{
dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
}
//load smbKhachhang
tb = cn.GetDataTable("Select distinct MaKH, tenKH from tblKhachHang");
cmbKhachhang.DataSource = tb;
cmbKhachhang.DisplayMember = "tenKH";
txtMaKH.Text = findCode(cmbKhachhang.Text, "TenKH", "MaKH", tb);
////load Phuongthuc
tb = cn.GetDataTable("Select distinct MaPT, TenPT from tblPhuongThucThue");
cmbPhuongthuc.DataSource = tb;
cmbPhuongthuc.DisplayMember = "TenPT";
cmbPhuongthuc.ValueMember = "MaPT";
cmbPhuongthuc.ResetText();
txtMaPT.Text = findCode(cmbPhuongthuc.Text, "TenPT", "MaPT", tb);
//lay dl vao ec
ecHD.NgayVao = dtpNgayvao.Value.Year.ToString() + "-" + dtpNgayvao.Value.Month.ToString() + "-" + dtpNgayvao.Value.Day.ToString();
_load = false;
}
private void btnThue_Click(object sender, EventArgs e)
{
for (int i = 0; i < dgvThongtin.RowCount; i++)
{
if (Convert.ToBoolean(dgvThongtin.Rows[i].Cells["Thue"].Value) == true)
{
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Đã thuê")
{
MessageBox.Show("Phòng " + dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString() + " đã được thuê rồi. Chọn phòng khác!");
dgvThongtin.Rows[i].Cells["Thue"].Value = false;
return;
}
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Hỏng")
{
MessageBox.Show("Phòng " + dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString() + " đang hỏng. Chọn phòng khác!");
dgvThongtin.Rows[i].Cells["Thue"].Value = false;
return;
}
ecPT.MaPh = dgvThongtin.Rows[i].Cells["MaPh"].Value.ToString();
ecPT.MaKH = txtMaKH.Text;
DateTime date = DateTime.Now;
ecPT.MaPhieu = date.Day.ToString() + date.Month.ToString() + date.Hour.ToString() + date.Minute.ToString() + date.Second.ToString() + dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString();
DAL_PhieuThue dalPhieuthue = new DAL_PhieuThue();
dalPhieuthue.ThemThongTin(ecPT);
ecHD.MaHD = ecPT.MaPhieu;
ecHD.MaPhieuThue = ecPT.MaPhieu;
ecHD.ThanhTien = 0;
ecHD.Gia = 200;
ecHD.NgayVao = dtpNgayvao.Value.Year.ToString() + "-" + dtpNgayvao.Value.Month.ToString() + "-" + dtpNgayvao.Value.Day.ToString();
ecHD.NgayRa = dtpNgayra.Value.Year.ToString() + "-" + dtpNgayra.Value.Month.ToString() + "-" + dtpNgayra.Value.Day.ToString();
dalHD.ThemThongTin(ecHD);
EC_Phong ecPh = new EC_Phong();
ecPh.MaPh = dgvThongtin.Rows[i].Cells["MaPh"].Value.ToString();
ecPh.SoPhong = dgvThongtin.Rows[i].Cells["SoPhong"].Value.ToString();
ecPh.TrangThai = "Đã thuê";
dalPh.SuaThongTin(ecPh);
}
}
MessageBox.Show("Thuê OK!");
DataTable tb = dalPh.ThongTinPhong("");
dgvThongtin.DataSource = tb;
for (int i = 0; i < dgvThongtin.RowCount; i++)
{
dgvThongtin.Rows[i].Cells["STT"].Value = i + 1;
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Tốt")
{
dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.Lime;
}
else
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Đã thuê")
{
dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.LightSkyBlue;
}
else
if (dgvThongtin.Rows[i].Cells["TrangThai"].Value.ToString() == "Hỏng")
{
dgvThongtin.Rows[i].DefaultCellStyle.BackColor = Color.Red;
}
}
}
