public IEnumerable <Event> VisibleEvents(IEventAreaService eas)
{
var r = from x in GetAll()
join a in eas.GetAll() on x.Id equals a.EventId
where a.Price != 0
select x;
return(r.ToList());
}
public bool Delete(int id, IEventSeatService es, IEventAreaService ea)
{
var eaAll = ea.GetAll();
var esAll = es.GetAll();
var r = from eventArea in eaAll
join eventSeat in esAll on eventArea.Id equals eventSeat.EventAreaId
where eventSeat.State != 0 &&
eventArea.LayoutId == id
select eventArea;
if (r.Any())
{
throw new Exception("Try to delete layout for locked seat");
}
return(Repository.Delete(id));
}
public bool Delete(int id, IEventSeatService ess, IEventAreaService eas, ILayoutService ls)
{
var all = GetAll();
var esAll = ess.GetAll();
var eaAll = eas.GetAll();
var lsAll = ls.GetAll();
if ((from venue in all
join layout in lsAll on venue.Id equals layout.VenueId
join eventArea in eaAll on layout.Id equals eventArea.LayoutId
join eventSeat in esAll on eventArea.Id equals eventSeat.EventAreaId
where eventSeat.State != 0
select venue
).Any())
{
throw new Exception("Try to delete venue with locked seats");
}
return(Repository.Delete(id));
}
