public BOMenuKichThuocMon()
{
MenuKichThuocMon = new MENUKICHTHUOCMON();
MenuMon = new MENUMON();
LoaiBan = new LOAIBAN();
DanhSachKhuyenMai = new List <BOMenuKhuyenMai>();
}
public IQueryable <BOMenuGia> GetAllByKichThuocMon(MENUKICHTHUOCMON ktm)
{
return(from a in frmLoaiGia.Query()
join b in frmMenuGia.Query() on a.LoaiGiaID equals b.LoaiGiaID
where b.KichThuocMonID == ktm.KichThuocMonID
select new BOMenuGia
{
LoaiGia = a,
MenuGia = b
});
}
public static IQueryable <BOMenuKhuyenMai> GetAllByKichThuocMon(KaraokeEntities kara, MENUKICHTHUOCMON ktm)
{
var query = from a in kara.MENUKHUYENMAIs.Where(o => o.KichThuocMonID == ktm.KichThuocMonID && o.Visual == true && o.Deleted == false)
join b in kara.MENUKICHTHUOCMONs on a.KichThuocMonTang equals b.KichThuocMonID
join c in kara.MENUMONs on b.MonID equals c.MonID
select new BOMenuKhuyenMai
{
MenuKhuyenMai = a,
KichThuocMonTang = new BOMenuKichThuocMon
{
MenuKichThuocMon = b,
MenuMon = c
}
};
return(query);
}
public static IQueryable <BOMenuGia> GetAllByKichThuocMonVaLoaiGia(KaraokeEntities kara, MENUKICHTHUOCMON ktm, IQueryable <MENULOAIGIA> loaiGia)
{
return(from a in loaiGia
join b in GetAll(kara) on a.LoaiGiaID equals b.LoaiGiaID
where b.KichThuocMonID == ktm.KichThuocMonID
select new BOMenuGia
{
LoaiGia = a,
MenuGia = b
});
}
