private void btnTraPhong_Click(object sender, EventArgs e)
{
string maphong = lbPhong.Text;
ThongTinThuePhongBUS ttt = new ThongTinThuePhongBUS();
//Id
int id = new ThongTinThuePhongBUS().newID_traphong();
DateTime ngaythue, ngaytra;
string makhach = lbMaKhach.Text;
ngaythue = dtNgayThue.Value;
ngaytra = dtNgayTraPhong.Value;
string str_tdc = string.Format("{0:#,##0}", tiendatcoc);
//Them vao bang TraPhong
ThongTinThuePhongBUS tttTraphong = new ThongTinThuePhongBUS();
MRDTO.TraPhong tp = new MRDTO.TraPhong(id, makhach, maphong, ngaythue, ngaytra);
if (MessageBox.Show("Ngày thuê: " + dtNgayThue.Text.ToString() + "\nTiền đặt cọc: " + str_tdc + " vnd", "Xác nhận trả phòng: " + maphong, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string sqlinsert = "INSERT INTO TraPhong(Id,MaPhong,MaKhachTro,NgayThue,NgayTraPhong) VALUES(@id,@maphong,@makhach,@ngaythue,@ngaytra)";
int insert = tttTraphong.Insert_Tra_phong(sqlinsert, tp);
//Xoa ben ThongTinThue
var sqlttt = ttt.Delete("DELETE FROM ThongTinThuePhong WHERE MaPhong=@maphong", maphong);
//Xoa khach thuoc phong vua tra
var xoakhachthue = ttt.Delete("DELETE FROM ThongTinKhach WHERE MaPhong=@maphong", maphong);
//Sua trang thai
var update = ttt.Update_TraPhong("UPDATE Phong SET TrangThai=@trangthai WHERE MaPhong='" + maphong + "'");
MessageBox.Show("Đã trả phòng");
//Refresh
Load_listPhong();
ClearAll();
lvKhach.Items.Clear();
}
}
