private static scheddtlstandard _single(Int32 _id)
{
try
{
using (_ge = new generation_entities())
{ return((from a in _ge.scheddtlstandards.Include(p => p.slotinfo) where a.standardID == _id select a).FirstOrDefault()); }
}
catch (Exception ex)
{ return(null); }
}
private static scheddtlvenue _single(Int32 _id)
{
try
{
using (_ge = new generation_entities())
{ return((from a in _ge.scheddtlvenues.Include(p => p.venue) where a.dtlvenueID == _id select a).FirstOrDefault()); }
}
catch (Exception ex)
{ return(null); }
}
private static List <slotinfo> _list()
{
try
{
using (_ge = new generation_entities())
{ return((from a in _ge.slotinfoes where a.isactive == true select a).ToList()); }
}
catch (Exception ex)
{ return(null); }
}
private static List <venue> _list()
{
try
{
using (_ge = new generation_entities())
{ return((from a in _ge.venues orderby a.venuename select a).ToList()); }
}
catch (Exception ex)
{ return(null); }
}
private static talkspeaker _single(Int32 _id)
{
try
{
using (_ge = new generation_entities())
{ return((from a in _ge.talkspeakers.Include(p => p.participant.participantprofile) where a.talkID == _id select a).FirstOrDefault()); }
}
catch (Exception ex)
{ return(null); }
}
private static List <talk> _list(Int32 _id)
{
try
{
using (_ge = new generation_entities())
{ return((from a in _ge.talks where a.talkprograms.Any(b => b.programID == _id) select a).ToList()); }
}
catch (Exception ex)
{ return(null); }
}
public static scheddtlcustom _single(Int32 _id)
{
try
{
using (_ge = new generation_entities())
{
return((from a in _ge.scheddtlcustoms where a.customID == _id select a).FirstOrDefault());
}
}
catch (Exception ex)
{ return(null); }
}
private static List <scheduleheader> _list(Int32?_id)
{
using (_ge = new generation_entities())
{
program _p = (from a in _ge.programs where a.programID == 773 select a).FirstOrDefault();
if (_id != null)
{
List <scheduleheader> _tlist = new List <scheduleheader>();
_tlist = (from a in _ge.scheduleheaders
.Include(p => p.scheduledetails)
.Include(p => p.scheduledetails.Select(x => x.scheddtlcustoms))
.Include(p => p.scheduledetails.Select(x => x.scheddtlstandards))
.Include(p => p.scheduledetails.Select(x => x.scheddtltalks))
.Include(p => p.scheduledetails.Select(x => x.scheddtlvenues))
.Include(p => p.scheduledetails.Select(x => x.scheduledtlrecurrences))
where a.programID == _id select a).ToList();
return(_tlist);
}
else
{
return((from a in _ge.scheduleheaders where a.scheduledetails.Any(b => b.start > DateTime.Today.AddDays(-30)) && a.programID == null select a).ToList());
}
}
}
