private void btnThanhtoan_Click(object sender, EventArgs e)
{
int sum = 0;
for (int i = 0; i < dgvThongtin.Rows.Count; i++)
{
sum += int.Parse(dgvThongtin.Rows[i].Cells["Gia"].Value.ToString());
}
_Gia = int.Parse(cn.GetValue(@"select DonGiaHT from tblHoaDon where MaHD = '" + cmbMahd.Text + "'"));
sum += getCost(dtpNgayVao.Value, dtpNgayra.Value, _Gia);
MessageBox.Show("Tổng số tiền thanh toán: " + sum.ToString());
//update hoa don
ecHD.ThanhTien = sum.ToString();
ecHD.MaHD = cmbMahd.Text;
dalHD.ThanhToan(ecHD);
//thay doi thong tin phong
EC_Phong ph = new EC_Phong();
ph.MaPh = cn.GetValue(@"select MaPh from tblPhieuThue where MaPhieu = '" + cmbMahd.Text + "'");
ph.TrangThai = "Tốt";
dalPh.TraPhong(ph);
cmbKhachhang.ResetText();
cmbMahd.ResetText();
dgvThongtin.DataSource = null;
}
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;
ecPT.MaPT = txtMaPT.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);
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);
ecHD.MaHD = ecPT.MaPhieu;
ecHD.MaPhieuThue = ecPT.MaPhieu;
ecHD.ThanhTien = "0";
ecHD.Gia = _Gia;
ecHD.NgayRa = dtpNgayra.Value;
dalHD.ThemThongTin(ecHD);
}
}
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;
//}
}
public int UpDate_TrangThaiTrong(EC_Phong et)
{
return(sql.UpDate_TrangThaiTrong(et));
}
public void HuyBan(EC_Phong et)
{
SQL.HuyBan(et);
}
public string MaPhong(EC_Phong et)
{
return(SQL.MaPhong(et));
}
//-------- update data
public void SuaDuLieu(EC_Phong et)
{
SQL.SuaDuLieu(et);
}
//xóa dữ liệu
public void XoaDuLieu(EC_Phong et)
{
cn.ThucThiCauLenhSQL(@"DELETE from Phong where SoPhong=N'" + et.SoPhong + "'");
}
//sửa dữ liệu
public int SuaDuLieu(EC_Phong et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE Phong SET LoaiPhong =N'" + et.LoaiPhong + "', Gia =N'" + et.Gia + "', MaNV =N'" + et.MaNV + "',TrangThai=N'" + et.TrangThai + "' where SoPhong=N'" + et.SoPhong + "'"));
}
public void ThemDuLieu(EC_Phong ec)
{
cn.ThucHienCauLenh("INSERT INTO Phong1 (MaPhong, TenPhong, LoaiPhong, Gia, TinhTrang ) VALUES('" + ec.Maphong + "',N'" + ec.Tenphong + "',N'" + ec.Loaiphong + "',N'" + ec.Gia + "',N'" + ec.Tinhtrang + "')");
}
public void TraPhong(EC_Phong EC_Ph)
{
connect.ThucHienLenh("update tblPhong set TrangThai = N'" + EC_Ph.TrangThai + "' where MaPh = '" + EC_Ph.MaPh + "'");
}
public int XoaTTPhong(EC_Phong EC_Ph)
{
return(connect.ThucHienLenh("delete from tblPhong where MaPh = '" + EC_Ph.MaPh + "'"));
}
public int SuaThongTin(EC_Phong EC_Ph)
{
return(connect.ThucHienLenh("update tblPhong set SoPhong = N'" + EC_Ph.SoPhong + "', TrangThai = N'" + EC_Ph.TrangThai + "' where MaPh = '" + EC_Ph.MaPh + "'"));
}
public int ThemThongTin(EC_Phong EC_Ph)
{
return(connect.ThucHienLenh("insert into tblPhong(MaPh,SoPhong,TrangThai) values(N'" + EC_Ph.MaPh + "', N'" + EC_Ph.SoPhong + "', N'" + EC_Ph.TrangThai + "') "));
}
public string TrangThai(EC_Phong et)
{
return(sql.TrangThai(et));
}
public int UpDate_TrangThaiDangO(EC_Phong et)
{
return(sql.UpDate_TrangThaiDangO(et));
}
public void DangKy(EC_Phong ec)
{
sql.DangKy(ec);
}
//Hàm thêm dữ liệu
public int ThemDuLieu(EC_Phong et)
{
return(cn.ThucThiCauLenhSQL(@"INSERT INTO Phong(LoaiPhong, Gia, MaNV, TrangThai)
VALUES (N'" + et.LoaiPhong + "',N'" + et.Gia + "',N'" + et.MaNV + "',N'" + et.TrangThai + "')"));
}
public int XoaDulieu(EC_Phong ec)
{
return(this.cn.Query("delete from Phong1 where MaPhong = '" + ec.Maphong + "'"));
}
public int UpDate_TrangThaiDangO(EC_Phong et)
{
return(cn.ThucThiCauLenhSQL(@"UPDATE Phong SET TrangThai = N'Đang Ở' where SoPhong=N'" + et.SoPhong + "'"));
}
public void SuaDuLieu(EC_Phong ec)
{
cn.ThucHienCauLenh("UPDATE Phong1 SET TenPhong = '" + ec.Tenphong + "', LoaiPhong = '" + ec.Loaiphong + "', Gia = '" + ec.Gia + "',TinhTrang='" + ec.Tinhtrang + "' WHERE MaPhong = '" + ec.Maphong + "'");
}
public string TrangThai(EC_Phong et)
{
return(cn.GetValue("SELECT TrangThai FROM Phong where SoPhong=N'" + et.SoPhong + "'"));
}
public void DangKy(EC_Phong ec)
{
cn.ThucHienCauLenh("UPDATE Phong1 SET TinhTrang='" + ec.Tinhtrang + "' ,status ='" + ec.Status + "' WHERE MaPhong = '" + ec.Maphong + "'");
}
public void ThemDuLieu(EC_Phong et)
{
SQL.ThemDuLieu(et);
}
public void ThemDuLieu(EC_Phong ec)
{
sql.ThemDuLieu(ec);
}
// delete data
public void XoaDuLieu(EC_Phong et)
{
SQL.XoaDuLieu(et);
}
public int XoaduLieu(EC_Phong ec)
{
return(this.sql.XoaDulieu(ec));
}
public string LoadTrangThai(EC_Phong et)
{
return(SQL.LoadTrangThai(et));
}
public void SuaDuLieu(EC_Phong ec)
{
sql.SuaDuLieu(ec);
}
public void ThanhToanBan(EC_Phong et)
{
SQL.ThanhToanBan(et);
}
//xóa dữ liệu
public void XoaDuLieu(EC_Phong et)
{
sql.XoaDuLieu(et);
}
