private void butThem_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Bạn có chắc muốn thêm khách thuê này?", "Thêm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
object i = dgvKhachChuaCoPhong.SelectedRows[0].Cells[0].Value;
string makhach = i.ToString();
KHACH_THUE k = kt.lay1khach(makhach);
CT_KHACH_THUE ct = new CT_KHACH_THUE
{
MaKhach = k.MaKhach,
NgayVaoPhong = DateTime.Now,
};
if (rbtPhongMoi.Checked)
{
ct.MaPhong = cbbPhongMoi.SelectedItem.ToString();
ql.AddKhachPhongMoi(ct);
DangKyThue_Load(this, e);
}
else if (rbtGhep.Checked)
{
ct.MaPhong = cbbPhongGhep.SelectedItem.ToString();
ql.AddKhachGhep(ct);
DangKyThue_Load(this, e);
}
MessageBox.Show("Thêm Khách Thuê Thành Công!");
}
}
catch (Exception ex)
{
MessageBox.Show("Mời kiểm tra lại thông tin!");
}
}
public void AddKhachGhep(CT_KHACH_THUE ct)
{
ql.CT_KHACH_THUE.Add(ct);
PHONG_TRO pt = ql.PHONG_TRO.Where(x => x.MaPhong == ct.MaPhong).SingleOrDefault();
pt.SoNguoi++;
KHACH_THUE k = ql.KHACH_THUE.Where(x => x.MaKhach == ct.MaKhach).SingleOrDefault();
k.TinhTrang = 1;
ql.SaveChanges();
}
public void Delete(string s)
{
KHACH_THUE k = this.lay1khach(s);
//USER_KHACHTHUE u = ql.USER_KHACHTHUE.Where(x => x.MaKhach == k.MaKhach).SingleOrDefault();
CT_KHACH_THUE ct = ql.CT_KHACH_THUE.Where(x => x.MaKhach == k.MaKhach).SingleOrDefault();
ct.PHONG_TRO.SoNguoi--;
ql.KHACH_THUE.Remove(k);
ql.CT_KHACH_THUE.Remove(ct);
// ql.USER_KHACHTHUE.Remove(u);
ql.SaveChanges();
}
public void ThemKhachVaoPhongMoi(CT_KHACH_THUE kt)
{
ql.CT_KHACH_THUE.Add(kt);
HOP_DONG hd = new HOP_DONG
{
MaPhong = kt.MaPhong,
NgayLap = kt.NgayVaoPhong
};
ql.HOP_DONG.Add(hd);
PHONG_TRO pt = ql.PHONG_TRO.Where(x => x.MaPhong == kt.MaPhong).SingleOrDefault();
KHACH_THUE k = ql.KHACH_THUE.Where(x => x.MaKhach == kt.MaKhach).SingleOrDefault();
k.TinhTrang = 1; // co phong
pt.TrangThai = 1; // co nguoi thue
pt.SoNguoi++;
ql.SaveChanges();
}
public void AddKhachGhep(CT_KHACH_THUE ct)
{
ptdal.AddKhachGhep(ct);
}
public void AddKhachPhongMoi(CT_KHACH_THUE kt)
{
ptdal.ThemKhachVaoPhongMoi(kt);
}
