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<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
};
}
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;
}
/// <summary>
/// Create a new MENUKICHTHUOCMON object.
/// </summary>
/// <param name="kichThuocMonID">Initial value of the KichThuocMonID property.</param>
/// <param name="giaBanMacDinh">Initial value of the GiaBanMacDinh property.</param>
/// <param name="thoiGia">Initial value of the ThoiGia property.</param>
/// <param name="kichThuocLoaiBan">Initial value of the KichThuocLoaiBan property.</param>
/// <param name="soLuongBanBan">Initial value of the SoLuongBanBan property.</param>
/// <param name="sapXep">Initial value of the SapXep property.</param>
/// <param name="visual">Initial value of the Visual property.</param>
/// <param name="deleted">Initial value of the Deleted property.</param>
/// <param name="edit">Initial value of the Edit property.</param>
public static MENUKICHTHUOCMON CreateMENUKICHTHUOCMON(global::System.Int32 kichThuocMonID, global::System.Decimal giaBanMacDinh, global::System.Boolean thoiGia, global::System.Int32 kichThuocLoaiBan, global::System.Int32 soLuongBanBan, global::System.Int32 sapXep, global::System.Boolean visual, global::System.Boolean deleted, global::System.Boolean edit)
{
MENUKICHTHUOCMON mENUKICHTHUOCMON = new MENUKICHTHUOCMON();
mENUKICHTHUOCMON.KichThuocMonID = kichThuocMonID;
mENUKICHTHUOCMON.GiaBanMacDinh = giaBanMacDinh;
mENUKICHTHUOCMON.ThoiGia = thoiGia;
mENUKICHTHUOCMON.KichThuocLoaiBan = kichThuocLoaiBan;
mENUKICHTHUOCMON.SoLuongBanBan = soLuongBanBan;
mENUKICHTHUOCMON.SapXep = sapXep;
mENUKICHTHUOCMON.Visual = visual;
mENUKICHTHUOCMON.Deleted = deleted;
mENUKICHTHUOCMON.Edit = edit;
return mENUKICHTHUOCMON;
}
/// <summary>
/// Deprecated Method for adding a new object to the MENUKICHTHUOCMONs EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToMENUKICHTHUOCMONs(MENUKICHTHUOCMON mENUKICHTHUOCMON)
{
base.AddObject("MENUKICHTHUOCMONs", mENUKICHTHUOCMON);
}
