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); }