internal static List <EventDisplayObject> GetAllEventsWithDataByClientID(int?filter) { List <EventDisplayObject> retVal = new List <EventDisplayObject>(); int clientID = filter ?? default(int); using (var db = new RFIDDBEntities()) { try { //var query = db.Clients.ToList(); var query = from b in db.EventRecords orderby b.ID descending where b.ClientID == clientID select b; foreach (var item in query) { EventDisplayObject toAdd = new EventDisplayObject(); toAdd.Event = item; toAdd.Client = db.Clients.Find(item.ClientID); var datesQuery = from b in db.EventDates where b.EventRecordsID == item.ID select b; toAdd.EventDates = datesQuery.ToList(); retVal.Add(toAdd); } } catch { } } return(retVal); }
public static EventDisplayObject GetEventWithDataByID(int?eID) { EventDisplayObject retVal = new EventDisplayObject(); if (eID != null) { using (var db = new RFIDDBEntities()) { try { //var query = db.Clients.ToList(); var query = from b in db.EventRecords where b.ID == eID select b; foreach (var item in query) { EventDisplayObject toAdd = new EventDisplayObject(); toAdd.Event = item; toAdd.Client = db.Clients.Find(item.ClientID); var datesQuery = from b in db.EventDates where b.EventRecordsID == item.ID select b; toAdd.EventDates = datesQuery.ToList(); retVal = toAdd; } } catch { } } } return(retVal); }
// GET: Host public ActionResult Index() { int accessEventID = int.Parse(ConfigurationManager.AppSettings["ActiveEvent"]); EventDisplayObject eventDO = new EventDisplayObject(); eventDO.Event = db.EventRecords.Where(o => o.ID == accessEventID).FirstOrDefault(); eventDO.EventDates = db.EventDates.Where(o => o.EventRecordsID == accessEventID).ToList(); eventDO.Client = db.Clients.Where(o => o.ID == eventDO.Event.ClientID).FirstOrDefault(); List <Attendee> attList = db.Attendees.Where(o => o.EventID == accessEventID).ToList(); // Holds links to various event bits return(View(eventDO)); }
// GET: EventRecords/Details/5 public ActionResult Details(int?id, int?filter) { if (filter == null) { return(HttpNotFound()); } ViewBag.FilterID = filter; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //EventRecord eventRecord = db.EventRecords.Find(id); EventDisplayObject eventDO = new EventDisplayObject(); eventDO.Event = db.EventRecords.Where(o => o.ID == id).FirstOrDefault(); eventDO.EventDates = db.EventDates.Where(o => o.EventRecordsID == id).ToList(); eventDO.Client = db.Clients.Where(o => o.ID == eventDO.Event.ClientID).FirstOrDefault(); if (eventDO == null || eventDO.Event == null) { return(HttpNotFound()); } return(View(eventDO)); }