public static int Xoa(int chiTietBanHangId, Transit mTransit)
{
CHITIETBANHANG item = (from x in mTransit.KaraokeEntities.CHITIETBANHANGs where x.ChiTietBanHangID == chiTietBanHangId select x).First();
mTransit.KaraokeEntities.DeleteObject(item);
mTransit.KaraokeEntities.SaveChanges();
return(item.ChiTietBanHangID);
}
public BOChiTietBanHang(CHITIETBANHANG chiTiet, Transit transit)
{
_ListKhuyenMai = new List <BOChiTietBanHang>();
ChiTietBanHang = chiTiet;
MenuKichThuocMon = ChiTietBanHang.MENUKICHTHUOCMON;
MenuMon = ChiTietBanHang.MENUKICHTHUOCMON.MENUMON;
mTransit = transit;
SoLuongBanTam = (int)ChiTietBanHang.SoLuongBan;
}
public static int CapNhat(CHITIETBANHANG item, Transit mTransit)
{
CHITIETBANHANG m = (from x in mTransit.KaraokeEntities.CHITIETBANHANGs where x.ChiTietBanHangID == item.ChiTietBanHangID select x).First();
m.BanHangID = item.BanHangID;
m.SoLuongBan = item.SoLuongBan;
m.GiaBan = item.GiaBan;
m.ThanhTien = item.ThanhTien;
m.KichThuocMonID = item.KichThuocMonID;
m.NhanVienID = item.NhanVienID;
mTransit.KaraokeEntities.SaveChanges();
return(item.ChiTietBanHangID);
}
public static IQueryable <BOChiTietBanHang> QueryKhuyenMai(CHITIETBANHANG chitietbh, KaraokeEntities kara)
{
var iQuery =
//from chitiet in banhang.CHITIETBANHANGs.Where(o=>o.ChiTietBanHangID_Ref==null)
from chitiet in kara.CHITIETBANHANGs.Where(o => o.ChiTietBanHangID_Ref == chitietbh.ChiTietBanHangID)
join kichthuoc in kara.MENUKICHTHUOCMONs on chitiet.KichThuocMonID equals kichthuoc.KichThuocMonID
join menu in kara.MENUMONs on kichthuoc.MonID equals menu.MonID
select new BOChiTietBanHang
{
MenuKichThuocMon = kichthuoc,
ChiTietBanHang = chitiet,
MenuMon = menu
};
return(iQuery);
}
