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