private Table GetFreeTable(DateTime orderDate)
{
var allReservations = UnitOfWork.All <ReservationOrder>();
var table =
UnitOfWork.GetActual <Table>(
x =>
x.IsNewest && !x.IsDeleted &&
!allReservations
.Any(
r =>
r.Status != ReservationOrderStatus.Cancelled && r.Table == x && DbFunctions.DiffMinutes(r.ReservationTime, orderDate) < 30));
return(table);
}
void ILoad <Items> .Init()
{
if (purchaseRequests == null)
{
frmItems.ItemsGridControl.DataSource = new BindingList <Items>(new UnitOfWork().ItemsRepo.Get());
frmItems.cboCategory.Properties.DataSource =
new EntityServerModeSource()
{
QueryableSource = new UnitOfWork().CategoriesRepo.Fetch()
};
frmItems.cboSearch.Properties.DataSource = new EntityServerModeSource()
{
QueryableSource = new UnitOfWork().ItemsRepo.Fetch()
};
return;
}
var itemsSelected = new UnitOfWork().PRDetailsRepo.Get(m => m.PRId == purchaseRequests.Id).Select(x => x.ItemId);
frmItems.ItemsGridControl.DataSource = new BindingList <Items>(new UnitOfWork().ItemsRepo.Get(x => itemsSelected.All(m => m != x.Id)));
frmItems.cboCategory.Properties.DataSource = new UnitOfWork().ItemsRepo.Fetch(x => x.Category != null || x.Category != "").GroupBy(x => x.Category).ToList().Select(x => new Items()
{
Category = x.Key
});
frmItems.cboSearch.Properties.DataSource = new UnitOfWork().ItemsRepo.Fetch().Select(x => new { x.Item }).ToList().Select(x => new Items()
{
Item = x.Item
});
}
public void Search(string search)
{
if (purchaseRequests == null)
{
frmItems.ItemsGridControl.DataSource = new BindingList <Items>(new UnitOfWork().ItemsRepo.Get(x => (x.Item.StartsWith(search) || x.Category.Contains(search))));
return;
}
var itemsSelected = new UnitOfWork().PRDetailsRepo.Get(m => m.PRId == purchaseRequests.Id).Select(x => x.ItemId);
frmItems.ItemsGridControl.DataSource = new BindingList <Items>(new UnitOfWork().ItemsRepo.Get(x => itemsSelected.All(m => m != x.Id) && (x.Item.StartsWith(search) || x.Category.Contains(search))));
}