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()); } } }