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 List <Object> TienPhong(string maphong)
{
PHONG_TRO phong = ql.PHONG_TRO.Where(x => x.MaPhong == maphong).SingleOrDefault();
var kq = ql.GIA_THUE.Where(e => e.SoNguoi == phong.SoNguoi).Select(q => new
{
phong.MaPhong, GiaTien = q.GiaTien
}).ToList();
List <Object> f = new List <object>(kq);
return(f);
}
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();
}
