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 <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 void sua(KHU a)
{
KHU x = tim(a.makhu);
if (x != null)
{
x.tenkhu = a.tenkhu;
x.soluongtoida = a.soluongtoida;
tc.capnhat();
}
}
private void CommandBinding_Executed_themKhu(object sender, ExecutedRoutedEventArgs e)
{
KHU a = new KHU();
a.makhu = txtMakhu.Text;
a.tenkhu = txtTenkhu.Text;
a.soluongtoida = int.Parse(txtSoluongtoida.Text);
xl.them(a);
dgKhu.ItemsSource = xl.getDSKhu();;
}
private void dgKhu_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
KHU k = (KHU)dgKhu.SelectedItem;
if (k == null)
{
return;
}
txtMakhu.Text = k.makhu;
txtTenkhu.Text = k.tenkhu;
txtSoluongtoida.Text = k.soluongtoida.ToString();
}
private void CommandBinding_Executed_xoaKhu(object sender, ExecutedRoutedEventArgs e)
{
KHU a = (KHU)dgKhu.SelectedItem;
xl.xoa(a);
txtMakhu.Text = "";
txtTenkhu.Text = "";
txtSoluongtoida.Text = "";
dgKhu.ItemsSource = xl.getDSKhu();
}
private void CommandBinding_Executed_timkiemKhu(object sender, ExecutedRoutedEventArgs e)
{
KHU a = xl.tim(txtMakhu.Text);
if (a == null)
{
MessageBox.Show("Không tìm thấy!");
}
else
{
//MessageBox.Show("Mã khu: " + a.makhu + "\nTên khu: " + a.tenkhu + "\nSố lượng tối đa: " + a.soluongtoida);
dgKhu.ItemsSource = xl.getDSKhu().Where(x => x.makhu == a.makhu);
}
}
public IQueryable <BAN> GetAllTableNotInOrderPerArea(KHU khu)
{
return(Data.BOBan.GetAllTableNotInOrderPerArea(khu, mTransit));
}
public void xoa(KHU k)
{
dskhu.DeleteOnSubmit(k);
tc.capnhat();
}
public void them(KHU k)
{
k.makhu = k.makhu.ToUpper();
dskhu.InsertOnSubmit(k);
tc.capnhat();
}
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));
}
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);
}