public static IQueryable<BAN> GetAllTableNotInOrderPerArea(KHU khu, Transit transit)
{
var listIn = GetAllTableInOrderPerArea(khu, transit);
return from a in GetVisual(transit)
where !listIn.Contains(a) && a.KhuID == khu.KhuID
select a;
}
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 IQueryable<BAN> GetAllTableNotInOrderPerArea(KHU khu)
{
return Data.BOBan.GetAllTableNotInOrderPerArea(khu,mTransit);
}
/// <summary>
/// Deprecated Method for adding a new object to the KHUs EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToKHUs(KHU kHU)
{
base.AddObject("KHUs", kHU);
}
/// <summary>
/// Create a new KHU object.
/// </summary>
/// <param name="khuID">Initial value of the KhuID property.</param>
/// <param name="macDinhSoDoBan">Initial value of the MacDinhSoDoBan 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 KHU CreateKHU(global::System.Int32 khuID, global::System.Boolean macDinhSoDoBan, global::System.Boolean visual, global::System.Boolean deleted, global::System.Boolean edit)
{
KHU kHU = new KHU();
kHU.KhuID = khuID;
kHU.MacDinhSoDoBan = macDinhSoDoBan;
kHU.Visual = visual;
kHU.Deleted = deleted;
kHU.Edit = edit;
return kHU;
}
public IQueryable<BAN> GetVisualTablePerArea(KHU khu)
{
return Data.BOBan.GetVisualTablePerArea(khu, mTransit);
}
public IQueryable<BAN> GetAllTableInOrderPerArea(KHU khu,int banID)
{
return from a in Data.BOBan.GetAllTableInOrderPerArea(khu,mTransit)
where a.BanID!=banID || banID==0
select a;
}
public static IQueryable<BAN> GetVisualTablePerArea(KHU khu, Transit transit)
{
return from a in GetVisual(transit)
where a.KhuID == khu.KhuID
select a;
}
public IQueryable<BAN> GetVisualTablePerArea(KHU khu)
{
frBan.Refresh();
return GetVisualTablePerArea(khu, mTransit);
}
public IQueryable<BAN> GetAllTablePerArea(KHU khu)
{
frBan.Refresh();
return frBan.Query().Where(o => o.KhuID == khu.KhuID && o.Deleted == false);
}
