//gets all jazz events for a given day
/*Because a deleted event or events in three halls at the same day can cause problems with
* filtering in two columns they are not filtered in two columns*/
public List <Jazz> GetJazzActsByDay(DateTime date)
{
IEnumerable <Jazz> Jazzs;
using (HFContext context = new HFContext())
{
Jazzs = context.Jazzs.Where(j => j.Date == date).OrderBy(j => j.StartTime);
return(RemovePassPartout(Jazzs.ToList()));
}
}
//gets all jazz events
public List <Jazz> GetAll()
{
IEnumerable <Jazz> Jazzs;
using (HFContext context = new HFContext())
{
Jazzs = context.Jazzs.AsEnumerable();
return(Jazzs.ToList());
}
}
//Returns the passe-partout for a single day
public Jazz GetPassePartoutDay(DateTime date)
{
IEnumerable <Jazz> Jazzs;
using (HFContext context = new HFContext())
{
Jazzs = context.Jazzs.Where(j => j.Name.Contains("passe-partout"));
Jazz jazz = Jazzs.SingleOrDefault(j => j.Date == date && !j.Name.Contains("Passe-Partout for all Jazz Events"));
return(jazz);
}
}
