public static IQueryable <BAN> GetAllTableInOrderPerArea(KHU khu, Transit transit) { return(from a in GetVisual(transit) join b in BOBanHang.GetAllNotCompleted(transit.KaraokeEntities) on a.BanID equals b.BanID where a.KhuID == khu.KhuID select a); }
public static IQueryable <BOTableStatus> GetAll(KaraokeEntities kara) { return(from a in BOBanHang.GetAllNotCompleted(kara) select new BOTableStatus { TableID = (int)a.BanID, Status = (int)a.TrangThaiID }); }