// GET: CTHDs
public ActionResult Index(string mahd)
{
using (qlphongtrosvEntities db = new qlphongtrosvEntities())
{
List <KhachHang> khachHang = db.KhachHangs.ToList();
List <HoaDon> hoaDon = db.HoaDons.ToList();
List <CTHD> cthd = db.CTHDs.ToList();
List <DSPhong> dsPhong = db.DSPhongs.ToList();
var hd = db.CTHDs.Where(x => x.MaHD == mahd).SingleOrDefault();
var main = from h in hoaDon
join d in dsPhong on h.MaPhong equals d.MaPhong
where (h.MaHD == mahd)
select new ViewModel
{
hoaDon = h,
dsPhong = d
};
var sub = from c in cthd
join k in khachHang on c.MaKH equals k.MaKH
where (c.MaHD == mahd)
select new ViewModel
{
cthd = c,
khachHang = k,
ThanhTien = Convert.ToDouble(c.HoaDon.DSPhong.GiaTienPhong + c.GiaDien * c.SoDien + c.GiaNuoc * c.SoNuoc)
};
if (hd == null)
{
ViewBag.TinhTranghd = 0;
ViewBag.ID = mahd;
}
ViewBag.Main = main;
ViewBag.Sub = sub;
return(View());
}
}
